IT22447: VARIOUS -901 SQLCODES AND TRAPS DURING COMPILATION RELATING TO ACCESS OF THE TABLE PACKED DESCRIPTOR

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

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 is sysrouted FROM one or more of the following:

  IT22435

• 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