PM53289: ABEND0C4 RC11 IN CQM#LCSX, ABENDSB78-18

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses a race condition that can occur when
  multiple CQM or ASC (Audit SQL Collector) address spaces
  are started within seconds of each other, causing incorrect
  storage to be freed or reused and possible ABEND0C4-11
  or ABENDSB78-18 in CQM/ASC to also occur.
  
  NOTE: The DB2 Query Monitor Collector started task shares
  code with the DB2 Audit Management Expert Collector and the
  InfoSphere Guardium S-TAP Collector started tasks. Customers
  running the Collector with either (or both) DB2 Query Monitor
  and DB2 Audit Management Expert or InfoSphere Guardium S-TAP
  may experience this problem.
  

Local fix

• Stop the CQM/ASC collectors and the master address space,
  then start the CQM/ASC collectors one at a time (note:
  please do not start the second collector until the first
  one has fully initialized).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses a race condition    *
  *                      that can occur when multiple CQM or     *
  *                      ASC (Audit SQL Collector) address       *
  *                      spaces are started within seconds of    *
  *                      each other, causing incorrect storage   *
  *                      to be freed or reused and possible      *
  *                      ABEND0C4-11 or ABENDSB78-18 in CQM/ASC  *
  *                      to also occur. NOTE: The DB2 Query      *
  *                      Monitor Collector started task shares   *
  *                      code with the DB2 Audit Management      *
  *                      Expert Collector and the InfoSphere     *
  *                      Guardium S-TAP Collector started tasks. *
  *                      Customers running the Collector with    *
  *                      either (or both) DB2 Query Monitor      *
  *                      and DB2 Audit Management Expert or      *
  *                      InfoSphere Guardium S-TAP may           *
  *                      experience this problem.                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PM53288

• APAR is sysrouted TO one or more of the following:

  UK75136

Modules/Macros

•    CQM#INIX CQM#LCSX CQM#PCIQ CQM#PCIX CQMMINIX
  CQMOINIX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK75136

     UP12/01/05 P F201

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.