APAR status
Closed as program error.
Error description
An AF can occur with a trigger on a table which has a varchar column that is being inserted to. The stack shows: afstack afhandler affail_interface mt_ex_throw_sig afsig_handler <signal frame> rdatavalVchar ev_column new_eval scan_filter rsseqscan_read fmseqscan_read gettupl scan_next dodelupd excommand ip_evalsql runproc udrlm_spl_execute udrlm_exec_routine udr_execute exroutine execproc aud_execproc excommand dotrstmts dotrigs ferafttrig addone insone_next doinsert excommand sq_execute sqmain spawn_thread startup
Local fix
A possible workaround could be to change the varchar type of the table inserted into to a char type.
Problem summary
**************************************************************** * USERS AFFECTED: * * 11.50 * **************************************************************** * PROBLEM DESCRIPTION: * * Server can unexpectedly crash when user is using the * * triggering procedure having the table references. * **************************************************************** * RECOMMENDATION: * * Upgrade to latest 11.50.xCX server. * ****************************************************************
Problem conclusion
The Latest 11.50 server will correct this issue of unexpected crash of the server while running the trigger which has triggerring procedure with table references.
Temporary fix
Comments
APAR Information
APAR number
IC67709
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-04-07
Closed date
2011-01-20
Last modified date
2011-01-20
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:
20 January 2011