IT01128: PDQ QUERY HANGS ON MUTEX FREE_LOCK

APAR status

• Closed as program error.

Error description

• Using IDS 11.70 a query running with PDQ enabled may appear to
  hang. The output of the "onstat -g ses <sid>" command will show
  a number of threads in a state of waiting for the mutex
  free_lock. In addition one thread will show in a running state.
  
  For example:
  
  4405339  sqlexec  7000007afff4a68  S--P---  7584     mutex wait
  free_lock -
  4624280  scan_136 700000859af29e0  -------  2000     running-
  4624281  scan_136 7000007d951ce28  S------  2128     mutex wait
  free_lock -
  4624282  scan_136 7000007ae7b72f8  S------  2128     mutex wait
  free_lock -
  4624283  scan_136 7000007b5c5e448  S------  2128     mutex wait
  free_lock -
  
  The output of the command "onstat -g lmx" will indicate threads
  waiting on the free_lock mutex as shown below:
  
  Locked mutexes:
  mid      addr             name               holder   lkcnt
  waiter   waittime
  105221   7000007a8c74358  free_lock          4624280  0
  4405339  30693
  
  4624282  30693
  
  4624281  30693
  
  4624283  30692
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users running parallel data queries                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC9                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC9
  

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

• RA10 PSN

     UP