APAR status
Closed as program error.
Error description
When you run an ALTER TABLE like alter table tab1 add constraint primary key(c1) constraint pk_tab1; to add a primary key constraint to a table or alter table tab1 next size 10000; to change the next extent size of a table you will notice that the COMPRESSED keyword is missing from a table that was created with it. This does not immediately impact the eventually existing compression and the compression dictionary, but when for example using dbexport/dbimport it will lead to a table which is no longer compressed.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of compressed tables. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC8 * ****************************************************************
Problem conclusion
Problem Fixed In IBM Informix Server 12.10.xC8
Temporary fix
Comments
APAR Information
APAR number
IT15342
Reported component name
IFMX ULT WHSE E
Reported component ID
IM0019BOS
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-05-18
Closed date
2016-12-09
Last modified date
2016-12-09
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
IFMX ULT WHSE E
Fixed component ID
IM0019BOS
Applicable component levels
RB70 PSN
UP
RB70 PSY
UP
RC10 PSN
UP
RC10 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBJS3","label":"Informix Ultimate Warehouse Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2016