APAR status
Closed as program error.
Error description
A session running an update on an updatable SDS node can hang on a proxySess condition with the following symptoms: From an onstat -g ath: 55 112a98b80 1115d24e0 1 cond wait proxySess 1cpu sqlexec The stack for the sqlexec thread: Stack for thread: 55 sqlexec base: 0x0000000112d22000 len: 69632 pc: 0x0000000101ce8644 tos: 0x0000000112d30551 state: cond wait vp: 1 yield_processor_mvp () mt_wait () proxyWriteQXfer () proxyWritePostHotRow () proxyWriteDetectHotRow () gettupl () scan_next () dodelupd () aud_dodelupd () excommand () sq_execute () sqmain () listen_verify () spawn_thread () startup () The proxy thread on the primary side is idle with the following stack: Stack for thread: 82527 proxyTh base: 0x0000000113990000 len: 69632 pc: 0x0000000101ce8644 tos: 0x00000001139a0131 state: sleeping vp: 1 yield_processor_mvp () mt_yield () proxyWriteThread () startup ()
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users on updatable secondary server * **************************************************************** * PROBLEM DESCRIPTION: * * A session on an updatable secondary server with multiple CPU * * VP's can hang when there is a high degree of concurrency. * **************************************************************** * RECOMMENDATION: * * Please upgrade to 11.50.xC8 when available. * ****************************************************************
Problem conclusion
Problem is first fixed in 11.50.xC8.
Temporary fix
Comments
APAR Information
APAR number
IC70027
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-07-19
Closed date
2011-09-27
Last modified date
2011-09-27
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:
27 September 2011