DB2 - Problem description
Problem IT34723 | Status: Closed |
TRAP/PANIC DURING SQLU_REGISTER_TABLE_UNLOAD ON CDE TEMPORAL TABLE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem 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: | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.6 or higher * **************************************************************** | |
Local Fix: | |
NA | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.6 or higher * **************************************************************** | |
Comment | |
Upgrade to Db2 11.1.4.6 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.10.2020 31.03.2021 31.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |