DB2 FOR LUW / DB2FORLUW / B10 - DB2

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

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

N/A

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.04.2018
28.11.2018
28.11.2018