IBM Support

IC78490: WHEN THERE ARE APPLICATIONS IN ROLLBACK OR COMMIT STATE, DB2 SNAPSHOT MONITOR MAY RETURN SQL1042C ERROR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • when there are applications in rollback or commit state, 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
    
    Some other utility which relies on the service of monitor
    component could also be affected, e.g db2top. In db2top, using
    'U' option to collect lock information may also cause db2top
    exited with sql1042c error.
    
    The following records could be found in db2diag.log if turning
    on the database manager configuration parameter DIAGLEVEL to 4:
    
    2013-03-12-03.43.12.074851-240 I243248E595           LEVEL: Info
    PID     : 19365                TID : 46913030187328  KTID :
    xxxxxx
    PROC    : db2sysc
    INSTANCE: db2inst1             NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-21                 APPID:
    *LOCAL.db2inst1.130312073953
    AUTHID  : DB2INST1             HOSTNAME: host123
    EDUID   : 41                   EDUNAME: db2agent (instance)
    FUNCTION: DB2 UDB, database monitor, sqm_snap_appl_locks,
    probe:10
    DATA #1 : <preformatted>
    Snapshot cannot obtain lock information for application with app
    handle 13. Application in commit/rollback.
    
    The following records could be found in db2 trace:
    
    | | | | sqm___sqm_write_lock_waits entry [eduid 224497 eduname
    db2agent]
    | | | | sqm___sqm_write_lock_waits exit
    | | | sqm_snap_appl_locks data [probe 10]
    | | | sqm_snap_appl_locks exit [rc = 0x000004D2 = 1234]
    | | sqm___sqm_snap_db_locks exit [rc = 0x000004D2 = 1234]
    | | sqm___sqm_free_dbcb_list entry [eduid 224497 eduname
    db2agent]
    | | sqm___sqm_free_dbcb_list exit
    | sqm___sqlmonssagnt exit [rc = 0x000004D2 = 1234]
    | sqlm_buffer_postprocess entry [eduid 224497 eduname db2agent]
    | sqlm_buffer_postprocess data [probe 1]
    | sqlm_buffer_postprocess data [probe 2]
    | sqlm_buffer_postprocess exit
    | sqm___sqlmfree entry [eduid 224497 eduname db2agent]
    | sqm___sqlmfree exit [rc = 0xFFFFFFFF = -1]
      sqm___sqlmonssbackend exit [rc = 0xFFFFFFFF = -1]
    

Local fix

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

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * when there are applications in rollback or commit state, 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                                               *
    *                                                              *
    *                                                              *
    * Some other utility which relies on the service of monitor    *
    *                                                              *
    * component could also be affected, e.g db2top. In db2top,     *
    * using                                                        *
    * 'U' option to collect lock information may also cause db2top *
    *                                                              *
    * exited with sql1042c error.                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    * The following records could be found in db2 trace:           *
    *                                                              *
    *                                                              *
    *                                                              *
    * | | | | sqm___sqm_write_lock_waits entry [eduid 224497       *
    * eduname                                                      *
    * db2agent]                                                    *
    *                                                              *
    * | | | | sqm___sqm_write_lock_waits exit                      *
    *                                                              *
    * | | | sqm_snap_appl_locks data [probe 10]                    *
    *                                                              *
    * | | | sqm_snap_appl_locks exit [rc = 0x000004D2 = 1234]      *
    *                                                              *
    * | | sqm___sqm_snap_db_locks exit [rc = 0x000004D2 = 1234]    *
    *                                                              *
    * | | sqm___sqm_free_dbcb_list entry [eduid 224497 eduname     *
    *                                                              *
    * db2agent]                                                    *
    *                                                              *
    * | | sqm___sqm_free_dbcb_list exit                            *
    *                                                              *
    * | sqm___sqlmonssagnt exit [rc = 0x000004D2 = 1234]           *
    *                                                              *
    * | sqlm_buffer_postprocess entry [eduid 224497 eduname        *
    * db2agent]                                                    *
    * | sqlm_buffer_postprocess data [probe 1]                     *
    *                                                              *
    * | sqlm_buffer_postprocess data [probe 2]                     *
    *                                                              *
    * | sqlm_buffer_postprocess exit                               *
    *                                                              *
    * | sqm___sqlmfree entry [eduid 224497 eduname db2agent]       *
    *                                                              *
    * | sqm___sqlmfree exit [rc = 0xFFFFFFFF = -1]                 *
    *                                                              *
    * sqm___sqlmonssbackend exit [rc = 0xFFFFFFFF = -1]            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 db2_v97fp6                                    *
    ****************************************************************
    

Problem conclusion

  • The fix will be included in DB2 db2_v97fp6
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    IC78490

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-02

  • Closed date

    2012-06-06

  • Last modified date

    2013-03-13

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

    IC77861

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78490

Modified date: 13 March 2013