Fixes are available
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 number
IT34723
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
2020-10-29
Closed date
2021-03-31
Last modified date
2021-03-31
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
[{"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:
03 May 2022