APAR status
Closed as program error.
Error description
IDS might terminate unexpectedly in deferred constraint checking during rollback of global transaction when the dictionary cache is too small. The statement executed in the transaction looks like this: INSERT INTO MYTAB(CID2, CDATE, CID3) SELECT FIRST 1 2222, TODAY , CID3 FROM MYTAB2; The table has several constraints defined and a trigger which raises an exception. Call Stack for thread #50 - sqlexec 0x00000001403526E8 (oninit)col2expr 0x000000014035499D (oninit)dotted2expr 0x0000000140358755 (oninit)expr2expr 0x0000000140354D9E (oninit)op_bind_rtn 0x000000014035575C (oninit)buildexpr 0x0000000140358B30 (oninit)expr2expr 0x0000000140354D9E (oninit)op_bind_rtn 0x000000014035575C (oninit)buildexpr 0x0000000140358B30 (oninit)expr2expr 0x00000001400C0887 (oninit)readchkcon 0x00000001400D89EE (oninit)ddrallcons 0x00000001400DEAC2 (oninit)readcats 0x00000001400E48A9 (oninit)readtab 0x00000001400E56B9 (oninit)ddgettable_hierarchy 0x00000001400E73D3 (oninit)ddgettable 0x000000014042AC13 (oninit)getdictab 0x000000014021A1DB (oninit)setdeflist 0x000000014021C59F (oninit)ifx_common_xrollback 0x000000014021CCFD (oninit)sq_xrollback 0x0000000140061228 (oninit)sqmain 0x0000000140BD0D20 (oninit)listen_verify 0x0000000140BD220E (oninit)spawn_thread 0x0000000140B8616A (oninit)startup onstat -g dic shows that the dictionary cache is full: > onstat -g dic IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line -- Up 1 days 12:12:49 -- 80320 Kbytes Dictionary Cache: Number of lists: 31, Maximum list size: 10 ... Total number of dictionary entries: 310
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Win64 customers running rollback in global transaction with * * deferred constraint checking * **************************************************************** * PROBLEM DESCRIPTION: * * Server abends * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC7 or higher * ****************************************************************
Problem conclusion
Problem already fixed in 11.50.xC7
Temporary fix
Comments
APAR Information
APAR number
IC65379
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-01-04
Closed date
2010-10-15
Last modified date
2010-10-15
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
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2010