Fixes are available
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 number
IT24734
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-16
Closed date
2018-11-28
Last modified date
2018-11-28
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022