IBM Support

JR27407: 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

  • If database quiesces and unquiesces, all connections in the
    connection pool will be stale and a -1228 sql error will be
    returned.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9 FixPak 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR27407

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-09-07

  • Closed date

    2008-06-24

  • Last modified date

    2008-06-24

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

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

    JR28802

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSY

       UP

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021