IZ52703: REPEATED DB2DIAG.LOG ENTRIES FROM FUNCTION SQLRIRIDC DURING CURSOR FETCH.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The following is an example of the db2diag.log message that
    might occur when fetching from a cursor:
    
    2009-05-20-15.35.48.189860-240 E3374737A678       LEVEL: Severe
    PID     : 397498               TID  : 123743      PROC : db2sysc
    0
    INSTANCE: db2inst              NODE : 000         DB   : DBNAME
    APPHDL  : 0-57200              APPID:
    10.2.200.74.47548.090519132144
    AUTHID  : USERID
    EDUID   : 123743               EDUNAME: db2agent (DBNAME) 0
    FUNCTION: DB2 UDB, runtime interpreter, sqlriridc, probe:4409
    MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : String, 35 bytes
    sqlriridc failed on probe and node:
    DATA #2 : unsigned integer, 8 bytes
    0
    DATA #3 : unsigned integer, 2 bytes
    0
    DATA #4 : unsigned integer, 2 bytes
    0
    
    The problem is that DB2 should not be logging this into the
    db2diag.log.  There are normal sqlcode's that can be encountered
    and DB2 does not log normal sql codes into the db2diag.log.
    
    This APAR will prevent this db2diag.log probe from showing and
    up filling up the log.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * n/a                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The following is an example of the db2diag.log message that  *
    *                                                              *
    * might occur when fetching from a cursor:                     *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2009-05-20-15.35.48.189860-240 E3374737A678       LEVEL:     *
    * Severe                                                       *
    * PID     : 397498               TID  : 123743      PROC :     *
    * db2sysc                                                      *
    * 0                                                            *
    *                                                              *
    * INSTANCE: db2inst              NODE : 000         DB   :     *
    * DBNAME                                                       *
    * APPHDL  : 0-57200              APPID:                        *
    *                                                              *
    * 10.2.200.74.47548.090519132144                               *
    *                                                              *
    * AUTHID  : USERID                                             *
    *                                                              *
    * EDUID   : 123743               EDUNAME: db2agent (DBNAME) 0  *
    *                                                              *
    * FUNCTION: DB2 UDB, runtime interpreter, sqlriridc,           *
    * probe:4409                                                   *
    * MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT           *
    *                                                              *
    * "SQLCA has already been built"                               *
    *                                                              *
    * DATA #1 : String, 35 bytes                                   *
    *                                                              *
    * sqlriridc failed on probe and node:                          *
    *                                                              *
    * DATA #2 : unsigned integer, 8 bytes                          *
    *                                                              *
    * 0                                                            *
    *                                                              *
    * DATA #3 : unsigned integer, 2 bytes                          *
    *                                                              *
    * 0                                                            *
    *                                                              *
    * DATA #4 : unsigned integer, 2 bytes                          *
    *                                                              *
    * 0                                                            *
    *                                                              *
    *                                                              *
    *                                                              *
    * The problem is that DB2 should not be logging this into the  *
    *                                                              *
    * db2diag.log.  There are normal sqlcode's that can be         *
    * encountered                                                  *
    * and DB2 does not log normal sql codes into the db2diag.log.  *
    *                                                              *
    *                                                              *
    *                                                              *
    * This APAR will prevent this db2diag.log probe from showing   *
    * and                                                          *
    * up filling up the log.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.5 FixPak 5                          *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.5 FixPak 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ52703

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-05

  • Closed date

    2010-02-24

  • Last modified date

    2010-02-24

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

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

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R950 PSY

       UP

  • R950 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

950

Reference #:

IZ52703

Modified date:

2010-02-24

Translate my page

Machine Translation

Content navigation