IBM Support

JR28802: If database quiesces and unquiesces, all connections in the conn ection pool will be stale and a -1228 sql error will be returned

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If database is started and stopped, such as when a restoredb is
    done, all connections in the connection pool will be stale and
    a -1228 or SQL30081N sqlerror will be returned. The defect fix
    will make it so that only the first connnection in the pool,
    upon returning this error, will be bad All remaiing connection
    objects will be guaranteed to be good.
    If this APAR is not applied, when this situation described
    above occurs, the application will need to create new
    connection objects in order to re-connect to the database.
    SQL30081N error when executing the user application of restore
    db, delete, and insert sequentially in a short time.
    

Local fix

  • Turn connection pooling off using "pooling=false" in the
    connection string. Performance will be slightly slower, but it
    will work correctly.
    

Problem summary

  • After a db stop/start the connections become stale and a -1228
    or SQL30081N error is returned.
    

Problem conclusion

  • First fixed in 9.5 FP1
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR28802

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-03-21

  • Closed date

    2008-05-02

  • Last modified date

    2008-05-02

  • APAR is sysrouted FROM one or more of the following:

    JR27407

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 May 2008