IC97429: SQLEXEC THREADS HANG ON CPU VP CONSUMING HIGH CPU TIME PREVENTING OTHER THREADS FROM RUNNING

APAR status

• Closed as program error.

Error description

• Sqlexec threads can get stuck in an infinite for loop in
  need_usr_write_ticket()
  
  Stack trace for the hung threads:
  
  cmprstr()
  need_usr_write_ticket()
  get_sysdbprocids()
  ddopen()
  dbopen()
  find_db()
  sqopendb()
  dodatabase()
  chkarg4()
  sqmain()
  listen_verify()
  spawn_thread()
  th_init_initgls()
  startup()
  
  or
  
  need_usr_write_ticket()
  get_sysdbprocids()
  ddopen()
  dbopen()
  find_db()
  sqopendb()
  excommand()
  sq_execute()
  sqmain()
  listen_verify()
  spawn_thread()
  th_init_initgls()
  startup()
  
  
  The loop is in need_usr_write_ticket().  To hit this code a
  sysdbopen() procedure must be defined.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Those using sysdbopen / sysdbclose                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC8                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RB70 PSN

     UP

• RB70 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP