APAR status
Closed as program error.
Error description
Here is an example: select (select * from table(sp(b))) from (select * from test); where 'sp' is a stored procedure, 'test' is a table, and 'b' is one of the table columns. The stack in the AF file may look like this: afstack mt_ex_throw_sig afsig_handler rdatavalChar valload geval routine_evalargs udr_evalcurs ip_evalprchead ip_open itscan_open prepselect subqprep exsubq ev_cb new_eval evalcols getrow fetchrow exfetch sql_nfetch sq_nfetch sqmain spawn_thread startup Please note, you may see another function instead of 'rdatavalChar', depending on the data type being used in the stored procedure.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users having table function with correlated column reference * * to a Derived table/View * **************************************************************** * PROBLEM DESCRIPTION: * * When user query has table function ( or iterator function) * * with correlated column referring to a derived table, server * * may give crash during subquery execution. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC9. * ****************************************************************
Problem conclusion
Fixed in 11.50.xC9.
Temporary fix
Comments
APAR Information
APAR number
IC71973
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-10-18
Closed date
2011-09-27
Last modified date
2011-09-27
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:
27 September 2011