IT24734: INSTANCE MAY PANIC DURING A DROP SEQUENCE

Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• If you are in a SMP or DPF environment, your Db2 instance may
  crash if a DROP SEQUENCE is issued from the same connection that
  has an open cursor that is referencing the sequence
  
  The following can be seen in the db2diag.log file :
  
  XXXXXXXXXXXXXXXXXXXXXXXXXXXXX         LEVEL: Severe
  PID     : 4064004              TID : 185107         PROC :
  db2sysc 0
  INSTANCE: xxxxx              NODE : 000           DB   : xxxxxxx
  APPHDL  : 0-21884              APPID: xxx.xx.xx.xx.xxxxx.xxxxxxx
  AUTHID  : xxxxxx               HOSTNAME: xxxx
  EDUID   : 185107               EDUNAME: db2agnts (xxxxxxx) 0
  FUNCTION: DB2 UDB, data management, sqldSeqFetch, probe:2043
  MESSAGE : ZRC=0x8704007A=-2029780870=SQLD_REC_DELETED "DELETED
  RECORD ID"
  DATA #1 : String, 25 bytes
  seqCache - sequence cache
  DATA #2 : Hexdump, 280 bytes
  0x0A000376A8FF3820 : 0000 0261 0000 0000 0000 0000 0000 0125
  ...a...........%
  0x0A000376A8FF3830 : 0000 0001 0000 0000 0000 0014 0000 0000
  ................
  0x0A000376A8FF3840 : 0000 0000 0000 0026 0000 0000 0011 54B1
  .......&......T.
  0x0A000376A8FF3850 : 2018 0221 0937 4626 2161 0000 0000 0000
  ..!.7F&!a......
  0x0A000376A8FF3860 : 0002 1F00 0002 0000 0A00 0376 A8FF 38C0
  ...........v..8.
  0x0A000376A8FF3870 : 0000 0000 0000 0000 0002 1F00 0002 0000
  ................
  0x0A000376A8FF3880 : 0A00 0376 A8FF 38D0 0000 0000 0000 0000
  ...v..8.........
  0x0A000376A8FF3890 : 0002 1F00 0002 0000 0A00 0376 A8FF 38E0
  ...........v..8.
  0x0A000376A8FF38A0 : 0000 0000 0000 0000 0002 1F00 0002 0000
  ................
  0x0A000376A8FF38B0 : 0A00 0376 A8FF 38F0 0000 0000 0000 0000
  ...v..8.........
  0x0A000376A8FF38C0 : 0000 0000 0000 0000 0000 0000 0000 001C
  ................
  0x0A000376A8FF38D0 : 0000 0000 0000 0000 0000 0214 7483 647C
  ............t.d|
  0x0A000376A8FF38E0 : 0000 0000 0000 0000 0000 0000 0000 001C
  ................
  0x0A000376A8FF38F0 : 0000 0000 0000 0000 0000 0000 0128 060C
  .............(..
  0x0A000376A8FF3900 : 0000 0000 0000 0000 0000 0000 0000 001C
  ................
  0x0A000376A8FF3910 : 00BF 2000 0001 0000 002E FF4D 0000 0000
  .. ........M....
  0x0A000376A8FF3920 : 0000 0000 0000 0000 0000 0000 0000 0000
  ................
  0x0A000376A8FF3930 : 0000 0000 0000 0000
  ........
  
  
  
  XXXXXXXXXXXXXXXXXXXXXXXXXXXXX         LEVEL: Info
  PID     : 4064004              TID : 185107         PROC :
  db2sysc 0
  INSTANCE: xxxxx              NODE : 000           DB   : xxxxxxx
  APPHDL  : 0-21884              APPID: xxx.xx.xx.xx.xxxxx.xxxxxxx
  AUTHID  : xxxxxx               HOSTNAME: xxxxxx
  EDUID   : 185107               EDUNAME: db2agnts (xxxxxx) 0
  FUNCTION: DB2 UDB, base sys utilities,
  sqeLocalDatabase::ForceDBShutdown, probe:16870
  MESSAGE : Regular agent EDU doing ForceDBShutdown.  Force DB
  shutdown agent ID
            is:
  DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes
  0-21884
  DATA #2 : sqeApplication_acbInfo,
  PD_TYPE_sqeApplication_acbInfo, 4 bytes
  x0
  CALLSTCK: (Static functions may not be resolved correctly, as
  they are resolved to the nearest symbol)
    [0] 0x090000000818BAAC ForceDBShutdown__16sqeLocalDatabaseFi +
  0xC0C
    [1] 0x0900000008781978
  sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x1978
    [2] 0x09000000087846A8
  sqldEndDumpBadPage__FP8sqeAgentP11SQLB_FIX_CBUliN34 + 0x168
    [3] 0x0900000008784990
  sqldDumpBadPage__FP8sqeAgentP8SQLD_TCBP13SQLD_PAGESLOTP11SQLB_FI
  X_CBUliT6 + 0xF0
    [4] 0x090000000CC980A0
  IPRA.$sqldSeqFetch__FP8sqeAgentP8SQLD_SEQP13SQLD_DFM_WORKPiP14SQ
  LP_LOCK_INFO + 0xAC0
    [5] 0x090000000CC96AEC
  IPRA.$sqldSeqFetchUpdateGen__FP8sqeAgentPP8SQLD_SEQP8SQLD_SEQ +
  0x8C
    [6] 0x090000000CC95670
  IPRA.$sqldSeqLoadGen__FP8sqeAgentPP8SQLD_SEQP8SQLD_SEQ + 0x290
    [7] 0x090000000CC95248 sqldSeqGenerate__FP8sqeAgentP8SQLD_SEQ
  + 0x568
    [8] 0x090000000E1263C4 sqlriSeqNextval__FP8sqlrr_cb + 0x1C4
    [9] 0x0900000009A669F8
  sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5F8
    [10] 0x09000000093B9E28 sqlrr_smp_router__FP8sqlrr_cb + 0x188
    [11] 0x09000000093B62D0
  sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xFD0
    [12] 0x090000000939B39C
  IPRA.$sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x7FC
    [13] 0x09000000093953B4 sqleProcessSubRequest__FP8sqeAgent +
  0x2C74
    [14] 0x0900000007C83C2C RunEDU__8sqeAgentFv + 0x9EC
    [15] 0x0900000007C668A0 EDUDriver__9sqzEDUObjFv + 0x2E0
    [16] 0x0900000007B56814 sqloEDUEntry + 0x374
    [17] 0x0900000000528E10 _pthread_body + 0xF0
    [18] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Mod 4 Fixpack 4
  

Temporary fix

Comments

APAR Information

• 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 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP