APAR status
Closed as fixed if next.
Error description
You are running an insert from select into a fragmented table. You have PDQ enabled for the session that executes the insert statement. The statement fails with one of the following symptoms: - SQL Error-271 Could not insert new row into the table. No accompanying ISAM code. - SQL Error-271 Could not insert new row into the table. ISAM code -103 ISAM error: illegal key descriptor (too many parts or too long). - Assert Failure which crashes or hangs the engine The stacks printed in the af.* files may vary: afstack afhandler affail_interface mt_ex_throw_sig afsig_handler <signal frame> old_rhpfree relsdbmem doreleasesdb drpcurlist ip_evalexpr runproc udrlm_spl_execute udrlm_exec_routine udr_execute evalfunckey fmbldkey fm_idxinsert fmwrite aud_sqiswrite chkrowcons addone insert_next producer_thread startup afstack afhandler affail_interface mt_ex_throw_sig afsig_handler <signal frame> check_cblist_newfrags qd_initenv ip_evalexpr runproc udrlm_spl_execute udrlm_exec_routine udr_execute evalfunckey fmbldkey fm_idxinsert fmwrite aud_sqiswrite chkrowcons addone insert_next producer_thread startup afstack afhandler affail_interface mt_ex_throw_sig afsig_handler <signal frame> old_rhpfree delcontext udrlm_spl_execute udrlm_exec_routine udr_execute evalfunckey fmbldkey fm_idxinsert fmwrite aud_sqiswrite chkrowcons addone insert_next producer_thread startup afstack afhandler affail_interface mt_ex_throw_sig afsig_handler <signal frame> setvardata udrlm_spl_execute udrlm_exec_routine udr_execute evalfunckey fmbldkey fm_idxinsert fmwrite aud_sqiswrite chkrowcons addone insert_next producer_thread startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * functional indexes where the function (UDR) is an SPL * * routine * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.70.xC9 or earlier PID if available. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT02349
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-06-09
Closed date
2017-06-09
Last modified date
2017-06-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RB70 PSN
UP
RB70 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":"B70","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 June 2017