Fixes are available
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 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 auto-runstats is running on a table, then the rollback of the runstats or other DDL on the table that occurs while other transactions are in the middle of compilation can result in various -901 SQLCODEs or traps as the table packed descriptor may be removed from memory while being accessed. Example symptoms include Traps with the following stacks: sqlcode -901: "Invalid collation ID" from sqlnq_get_collation "qunp has more columns then base table" from sqlng_build_colRefs_obj Traps: Sig#11 Trap sqlng_build_IndexList_obj 0x00007FCFE0C33B8C sqloEDUCodeTrapHandler + 0x03ac 0x00007FCFDF982D15 _Z25sqlng_build_IndexList_objP9sqlng_blkttP8sqlrg_pdP18sqlrg_dat apartinfoPP14sqlriIndexList + 0x02e5 0x00007FCFDF93F041 _Z20sqlngRecordTableInfoP9sqlng_blktthP9sqlnq_ftbbbP19sqlno_plan _operator + 0x0321 0x00007FCFDFA5455A _Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb + 0x06fa 0x00007FCFDF94A75E _Z26sqlngProcessCdeCseProducerP9sqlng_blkP19sqlno_plan_operator + 0x061e 0x00007FCFDFA541AF _Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb + 0x034f Sig#11 Trap sqlngMemBlockLookup 0x00007F950C8D7B8C sqloEDUCodeTrapHandler + 0x03ac 0x00007F950B70F2D9 _Z19sqlngMemBlockLookupP9sqlng_blkPvmRP15sqlngSectObject + 0x03a9 0x00007F950B70DC70 _Z23sqlngSectSetPtrInternalP9sqlng_blkPvS1_m + 0x0130 0x00007F950B6E31F9 _Z18sqlng_build_TQA_opP9sqlng_blkP19sqlno_plan_operator + 0x0869 0x00007F950B6E1F89 _Z19sqlng_process_tq_opP9sqlng_blkP19sqlno_plan_operator + 0x0739 0x00007F950B6F82E4 _Z24sqlng_process_remote_opsP9sqlng_blkP19sqlno_plan_operatorbb + 0x0484 Sig #11 Trap sqlrlc_find_invalidate 0x00007F421E485B8C sqloEDUCodeTrapHandler + 0x03ac 0x00007F421F5BE64E _Z22sqlrlc_find_invalidateP8sqlrr_cbP10sqlrlc_keyjP8SQLZ_RID + 0x07ce 0x00007F421F5FBFE6 _Z14sqlrlc_end_uowP8sqlrr_cbiP19sqlr_savepoint_info + 0x0246 0x00007F421EAAE020 _Z29sqlrr_cleanup_tran_before_DPSP8sqlrr_cbiiiiiiiPiS1_ + 0x1520 0x00007F421EADDABA _Z17sqlrr_tran_routerP8sqlrr_cb + 0x0eea
Local fix
disable autorunstats (database configuration auto_runstats)
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 3 Fix Pack 3
Temporary fix
Comments
APAR Information
APAR number
IT22447
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
2017-09-19
Closed date
2018-03-19
Last modified date
2018-03-19
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