IBM Support

IV08650: SQLJ finalizer early closes cause 'Object Closed' on ResultSets/Statements, hung DB2 routines, WAS IndexOutOfBounds

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An SQLJ application using explicit or default connection
    contexts may be subjected to finalizer driven early closes
    resulting in 'Object Closed' kind of Exceptions on the
    underlying ResultSets or Statements.
    
    Other symptoms may include agent hangs in stored procedures
    running on DB2 for Linux, Unix, and Windows.
    The corresponding agent for the db2fmp process will have an
    associated stack of:
    
    semop + 0xC0
    semop@glue11 + 0x74
    sqloSSemP + 0x22C
    sqlccIPCWaitForReceive__FP21SQLCC_IPC_RESOURCES_TUi + 0x6C
    sqlccIPCWaitForReceive__FP21SQLCC_IPC_RESOURCES_TUi@glue4D6 +
    0x74
    sqlriInvokeInvoker__FP10sqlri_ufob + 0x794
    sqlricall__FP8sqlrr_cb + 0x100
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x6C8
    sqlrr_process_execute_request__FP8sqlrr_cbi - 0x258
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x240
    sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x968
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface - 0x48
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124
    @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1D8
    @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
    @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
    sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xD8
    RunEDU__8sqeAgentFv + 0x11C
    EDUDriver__9sqzEDUObjFv + 0x78
    sqloEDUEntry + 0x57C
    
    Websphere applications may encounter an
    IndexOutOfBoundsException similar to the following:
    
    java.lang.IndexOutOfBoundsException: Index: 5, Size: 5
        at java.util.ArrayList.get(ArrayList.java:352)
        at
    com.ibm.ws.rsadapter.jdbc.WSJdbcObject.closeChildWrappers(WSJdbc
    Object.java:292)
        at
    com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:2
    38)
        at
    com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:1
    93)
    
    
    Applications written to close their connection context at the
    end of a method will not be affected by early closes.
    

Local fix

  • Close contexts at the end of the method to avoid having the
    finalizer close the context.
    

Problem summary

  • First fixed in JDBC/SQLJ driver from DB2 9.7 Fix Pack 5 (JCC
    driver version 3.63.75)
    

Problem conclusion

  • Upgrade to JDBC/SQLJ driver from DB2 9.7 Fix Pack 5 (JCC
    driver version 3.63.75) or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV08650

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2011-10-04

  • Closed date

    2017-05-19

  • Last modified date

    2017-05-19

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

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

    IC79151

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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:
19 May 2017