APAR status
Closed as program error.
Error description
When the following select is run with statement cache turned on, it will return a -769 error when run for the fourth time and will sometimes cause the server to crash with a segv. The query is quite complex but can be reduced to the following to see the -769 error. case when table2_a.col1 in (select table1_a.col1 from table1 table1_a where table1_a.col2=2009) then 'Value' end from table2 table2_a -769: Internal - iterator execution/phase error UNKNOWN ITERATOR. The assertions show very similar stacks apart from the actual end function which is either clscan_create or sort_create. Stack trace information from the AF files: clscan_create + 0xa0 [oninit] it_create + 0x1d0 [oninit] prepselect + 0x240 [oninit] sort_create + 0xb4 [oninit] it_create + 0x290 [oninit] prepselect + 0x240 [oninit]
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IDS users with statement cache set using subquery inside * * projection list 'case' statement. * **************************************************************** * PROBLEM DESCRIPTION: * * When SSC is set and a projection list subquery is used * * inside a CASE statement, the server gives an iterator * * execution error. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC6 and above. * ****************************************************************
Problem conclusion
Problem first fixed in IDS 11.50.xC6.
Temporary fix
Comments
APAR Information
APAR number
IC62640
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
2009-08-19
Closed date
2009-10-26
Last modified date
2009-10-26
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:
26 October 2009