IZ52919: SQLCODE -901 OR TRAP AFTER COMMIT OF WITH HOLD CURSOR CONTAINING

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • In an SQL procedure that declares a cursor with the WITH HOLD
    attribute, you may observe a -901 error or a trap under the
    following circumstances:
    
    - The cursor declaration references one or more columns of type
    XML;
    - The SQL procedure commits the current unit of work, using a
    COMMIT statement;
    - The SQL procedure subsequently attempts to use the cursor in
    another operation, such as a FETCH, INSERT, DELETE, or CLOSE.
    
    If a -901 error occurs, it will be similar to the following:
    
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason
    "sqlricls_complex :
    Promoted XDA Temp (-572662307 : -572662307) not fou".)
    SQLSTATE=58004
    
    If a trap occurs, the stack trace may reference
    xmlDataDescriptor functions, as seen in the following example:
    
    0x09000000054C4E5C
    sqldcsl_beginInsert__FP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLUiPP13S
    QLDCSL_RSVCB + 0x270
    0x09000000054C5F7C
    xmls_InsertTempCSLRecord__FP11XMLSTORE_CBUiPPcPUsR8XMLS_XID +
    0x594
    0x0900000005C5EF38 flush__17xmlDataDescriptorFP11XMLSTORE_CBb +
    0x490
    0x090000000560E9E4
    copy__17xmlDataDescriptorFP11XMLSTORE_CBP17xmlDataDescriptor +
    0xC3C
    0x09000000053E0038 sqlrxXMLCopy__FP8sqeAgentP10sqlz_valueT2bT4 +
    0x180
    0x0900000005634A80
    performBindout__13pvmXMLManagerFUiP10sqlz_valueT2 + 0x114
    0x090000000563337C
    sqlribnoCbToZValueQueryPsm__FP14db2UCinterface + 0x10D0
    

Local fix

  • If possible, defer your COMMIT until all cursor operations are
    complete and the cursor is closed.
    

Problem summary

  • This issue will be fixed in the next release.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IZ52919

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    910

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-10

  • Closed date

    2009-06-10

  • Last modified date

    2009-06-10

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

    IZ52917

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

Fix information

Applicable component levels

  • R950 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

910

Reference #:

IZ52919

Modified date:

2009-06-10

Translate my page

Machine Translation

Content navigation