IBM Support

IC90893: CLI EXTENDED DIAGNOSTICS, ARRAYINPUTCHAIN ENABLED AGAINST A BUSY DB2 ZOS SERVER RETURNS SQL0904N-NO REASON CODE, RESOURCE NAME

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When a CLI application with extended diagnostics and
    arrayinputchain enabled runs a SQL query against a DB2 z/OS
    database server when the resource is busy (example: table is
    pending state or out of locks) returns just the SQL0904N error,
    with no REASON CODE AND RESOURCE NAME information.
    or
    When we retrieve the error message from CLI , it may look like
    below text without any reason code or resource name in the
    message.
    SQLGetDiagRec( pszSqlState="57011", pfNativeError=-904,
    pszErrorMsg="[IBM][CLI Driver][DB2] SQL0904N  Unsuccessful
    execution caused by an unavailable resource.  Reason code: "",
    type of resource: "", and resource name: "".  SQLSTATE=57011
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * CLI users when retrieving the error.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7.9                                 *
    ****************************************************************
    

Problem conclusion

  • DB2 v9.7 FP9 contains the fix, with this new fix user will the
    error message with appropriate error tokens and reason.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90893

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-15

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

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

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

    IC91794 IC93688

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC90893

Modified date: 17 December 2013