IT34723: TRAP/PANIC DURING SQLU_REGISTER_TABLE_UNLOAD ON CDE TEMPORAL TABLE

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• CDE temporal tables are only supported starting db2_v111m3fp3.
  
  Please note that the problem is dereferncing
  unallocated/uninitialized memory block - so symptoms include
  TRAP *and* Panic, including all sorts of memory related errors
  (corruption/free block/etc)
  
  Common callstack:
  17       sqluRegisterUnloadStart
  18       sqlu_register_table_unload
  19       sqluvtun_route_in
  
  Repro:
  CREATE TABLE t1(
                    "POLICY_ID" CHAR(4 OCTETS) NOT NULL ,
                    "COVERAGE" INTEGER NOT NULL ,
                    "SYS_START" TIMESTAMP(12) NOT NULL ,
                    "SYS_END" TIMESTAMP(12) NOT NULL ,
                   PERIOD SYSTEM_TIME ("SYS_START","SYS_END")
  MAINTAINED BY USER )
                   ORGANIZE BY COLUMN;
  
  
  CREATE TABLE t1_hist(
                    "POLICY_ID" CHAR(4 OCTETS) NOT NULL ,
                    "COVERAGE" INTEGER NOT NULL ,
                    "SYS_START" TIMESTAMP(12) NOT NULL ,
                    "SYS_END" TIMESTAMP(12) NOT NULL )
                   ORGANIZE BY column;
  
  
  ALTER TABLE t1 ADD USER VERSIONING USE HISTORY TABLE t1_hist;
  
  And then run HPU INIT API:
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 LUW Users                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1.4.6 or higher                            *
  ****************************************************************
  

Problem conclusion

• Upgrade to Db2 11.1.4.6 or higher
  

Temporary fix

• NA
  

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 PSY

     UP