APAR status
Closed as program error.
Error description
Query with SUBSTR and CONCAT expression can cause the AF: SELECT col1, col[2,3] || '-' || col[4,5] AF: x0000000011424cc0 (oninit)afstack 0x0000000011427e38 (oninit)afhandler 0x00000000114284f8 (oninit)affail_interface 0x0000000011429d44 (oninit)mt_ex_throw_sig 0x00000000113e76d0 (oninit)afsig_handler 0x00003fffb0300478 <>__kernel_sigtramp_rt64 0x00000000000018d5 (*nosymtab*)0x18d5 # Invalid/incorrect 0x0000000010659a48 (oninit)wrtexpr 0x0000000010659aa4 (oninit)wrtexpr 0x000000001065843c (oninit)wrtexpr 0x000000001065f85c (oninit)wrtcollist 0x0000000010656b28 (oninit)creatext 0x00000000104ce0f4 (oninit)opbldremote 0x0000000010665998 (oninit)bldremcmds 0x000000001058e6ec (oninit)dwa_offload 0x000000001058f060 (oninit)dwa_matchQuery 0x00000000104e9df0 (oninit)sqoptim 0x00000000107936dc (oninit)bldstructs 0x00000000107a6a7c (oninit)sqcmd 0x00000000107a7410 (oninit)sq_cmnd 0x00000000107a7560 (oninit)sq_prepare 0x0000000010886fd8 (oninit)sqmain 0x0000000011550e78 (oninit)spawn_thread 0x0000000011401088 (oninit)th_init_initgls 0x000000001140d4c0 (oninit)startup Actual AF should be more like: x0000000011424cc0 (oninit)afstack 0x0000000011427e38 (oninit)afhandler 0x00000000114284f8 (oninit)affail_interface 0x0000000011429d44 (oninit)mt_ex_throw_sig 0x00000000113e76d0 (oninit)afsig_handler 0x00003fffb0300478 <>__kernel_sigtramp_rt64 (oninit)gettypeexpr 0x00000000000018d5 (oninit)typeexpr 0x0000000010659a48 (oninit)wrtexpr 0x0000000010659aa4 (oninit)wrtexpr 0x000000001065843c (oninit)wrtexpr 0x000000001065f85c (oninit)wrtcollist 0x0000000010656b28 (oninit)creatext 0x00000000104ce0f4 (oninit)opbldremote 0x0000000010665998 (oninit)bldremcmds 0x000000001058e6ec (oninit)dwa_offload 0x000000001058f060 (oninit)dwa_matchQuery 0x00000000104e9df0 (oninit)sqoptim 0x00000000107936dc (oninit)bldstructs 0x00000000107a6a7c (oninit)sqcmd 0x00000000107a7410 (oninit)sq_cmnd 0x00000000107a7560 (oninit)sq_prepare 0x0000000010886fd8 (oninit)sqmain 0x0000000011550e78 (oninit)spawn_thread 0x0000000011401088 (oninit)th_init_initgls 0x000000001140d4c0 (oninit)startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * In DWA environment, Assert Failure in gettypeexpr wrtexpr * * called by dwa_offload(). * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Fixed in IDS 12.10.xC13.
Temporary fix
Comments
APAR Information
APAR number
IT26528
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-10-06
Closed date
2019-09-26
Last modified date
2019-09-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
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
26 September 2019