APAR status
Closed as program error.
Error description
The server crashes with the following stack trace: mapcolgroupby() process_select() process_view_colltbl_expr() processview() foldviews() sqbind() sq_common_bind() sq_bind() sqmain() listen_verify() spawn_thread() startup() The esql/c app was trying to prepare a cursor with a select statement that used the for update of column_name syntax as an alternative to declaring a update cursor. The test case view is defined as the following: create table jr_basetab (col1 char(20), col2 int); create view jr_view (hld_info, col2) as select jr_func(x0.col1,USER,'hld_info','col1')::char(25),x0.col2 from jr_basetab x0; Then the select that is trying to get prepared in the esql/c app is as follows: select hld_info from jr_view where col2 = ? for update of hld_info
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IDS 9.40 and above * **************************************************************** * PROBLEM DESCRIPTION: * * A query statement with "FOR UPDATE OF <column>" clause * * against a view where the column doesn't map directly to the * * base table column (i.e. casting, UDR, etc) causes server to * * SEGV. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC8 when available. * ****************************************************************
Problem conclusion
The problem is first fixed in IDS 11.50.xC8.
Temporary fix
Comments
APAR Information
APAR number
IC68386
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-05-04
Closed date
2010-10-06
Last modified date
2010-10-06
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 PSY
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:
06 October 2010