IC70027: SESSION CAN HANG ON PROXYSESS CONDITION WHEN EXECUTING AN UPDATE ON AN UPDATEABLE SDS NODE

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 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