APAR status
Closed as program error.
Error description
In an select using remote parts where a predicate with a DECRYPT_CHAR clause is used and this predicate is promoted to the remote server by the optimizer, the server may report an af file with the following stack x00000000008d71aa (/opt/informix/12.10.FC12/bin/oninit) decrypt_const_password 0x000000000091aff3 (/opt/informix/12.10.FC12/bin/oninit) wrtexpr 0x000000000091b181 (/opt/informix/12.10.FC12/bin/oninit) wrtexpr 0x000000000091d0cf (/opt/informix/12.10.FC12/bin/oninit) wrtexpr 0x0000000000917336 (/opt/informix/12.10.FC12/bin/oninit) creatext 0x00000000007c364c (/opt/informix/12.10.FC12/bin/oninit) opbrstmt 0x00000000007c3950 (/opt/informix/12.10.FC12/bin/oninit) opbldremote 0x000000000092625f (/opt/informix/12.10.FC12/bin/oninit) bldremcmds 0x00000000007f3328 (/opt/informix/12.10.FC12/bin/oninit) sqoptim 0x00000000007fbf98 (/opt/informix/12.10.FC12/bin/oninit) opinit 0x00000000007ff1e5 (/opt/informix/12.10.FC12/bin/oninit) op_opinit 0x00000000007f110c (/opt/informix/12.10.FC12/bin/oninit) sqoptim 0x0000000000a2bfb5 (/opt/informix/12.10.FC12/bin/oninit) sqbind 0x0000000000a45fde (/opt/informix/12.10.FC12/bin/oninit) sq_common_bind 0x0000000000b0b011 (/opt/informix/12.10.FC12/bin/oninit) sqmain 0x000000000154ca1b (/opt/informix/12.10.FC12/bin/oninit) spawn_thread 0x0000000001411450 (/opt/informix/12.10.FC12/bin/oninit) th_init_initgls 0x0000000001456d88 (/opt/informix/12.10.FC12/bin/oninit) startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 11.70.xC9W2, 12.10.xC15 * * and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 11.70.xC9W2, 12.10.xC15 (when * * available) or 14.10.xC5. * ****************************************************************
Problem conclusion
Fixed in Informix Server 11.70.xC9W2, 12.10.xC15 and 14.10.xC5.
Temporary fix
Comments
APAR Information
APAR number
IT33046
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
2020-06-02
Closed date
2021-01-05
Last modified date
2021-01-05
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
06 January 2021