IBM Support

IC81074: DB2 SNAPSHOT MONITOR MAY RETURN SQL1042C ERROR WHEN THERE ARE INDOUBT TRANSACTIONS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When there are indoubt transactions, db2 get snapshot for locks
    on <db2_name> may receive sql1042c error.
    
    E.g.
    
    $ db2 get snapshot for locks on sample
    SQL1042C  An unexpected system error occurred.  SQLSTATE=58004
    
    
    The following records could be found in db2 trace:
    
    | | | | | | | | | sqm___sqm_snap_db_locks entry [eduid 80577
    eduname db2agent]
    | | | | | | | | | | sqlpm_write_locks_indoubt_tran entry [eduid
    80577 eduname db2agent]
    | | | | | | | | | | | sqlpm_write_locks entry [eduid 80577
    eduname db2agent]
    | | | | | | | | | | | | pdLogPrintf entry [eduid 80577 eduname
    db2agent]
    | | | | | | | | | | | | | pdIsDiagLevelOk entry [eduid 80577
    eduname db2agent]
    | | | | | | | | | | | | | pdIsDiagLevelOk data [probe 10]
    | | | | | | | | | | | | | pdIsDiagLevelOk data [probe 20]
    | | | | | | | | | | | | | pdIsDiagLevelOk data [probe 500]
    | | | | | | | | | | | | | pdIsDiagLevelOk exit
    | | | | | | | | | | | sqlpm_write_locks data [probe 55]
    | | | | | | | | | | | | pdLogPrintf exit
    | | | | | | | | | | | sqlpm_write_locks exit [rc =0x000004E2 =
    1250]
    
    
    diag.log shows:
    
    2012-01-25-11.22.21.035956-300 E853625A479        LEVEL: Info
    PID     : 2687188              TID  : 89596       PROC : db2sysc
    0
    INSTANCE:              NODE : 000
    APPHDL  : 0-1403               APPID:
    AUTHID  :
    EDUID   : 89596                EDUNAME: db2agent (instance) 0
    FUNCTION: DB2 UDB, lock manager, sqlpm_write_locks, probe:55
    DATA #1 : <preformatted>
    Transaction changed underneath sqlpm_write_locks.
    tidhdl=2, tentryState=7
    
    2012-01-25-11.22.21.036274-300 I854105A798        LEVEL: Info
    PID     : 2687188              TID  : 89596       PROC : db2sysc
    0
    INSTANCE:                      NODE : 000
    APPHDL  : 0-1403               APPID:
    AUTHID  :
    EDUID   : 89596                EDUNAME: db2agent (instance) 0
    FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1042   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQLMSSAG
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000040
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate: 58004
    

Local fix

  • using db2pd -locks -db <db_name> to collect lock information
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 for Linux, UNIX and Windows                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 fixpack 6                                 *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC81074

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-27

  • Closed date

    2012-06-06

  • Last modified date

    2012-06-06

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

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

    IC84336 IC84737

Fix information

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC81074

Modified date: 06 June 2012