PH29710: CLEANUP OF THREAD RELATED STORAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• cleanup of thread related storage
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Security Guardium S-TAP for     *
  *                 Db2 on z/OS                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. CQM or STAP cleanup of thread        *
  *                      related storage.                        *
  *                      2. Update SMEM_SIZE default values.     *
  *                      3. Memory overlay of an internal QM     *
  *                      storage management control block as a   *
  *                      result of an over-reaching DISCARDDATA  *
  *                      function during the execution of QM's   *
  *                      memory management routines.             *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. Memory leak when parallel threads are cancelled via the
  Db2 CANCEL THREAD command or when jobs running parallel threads
  are terminated abnormally.
  2. Update SMEM_SIZE default values.
  3. Memory overlay during execution of QM's internal memory
  management functions.
  

Problem conclusion

• 1. Logic is added to detect a cancelled CPU parallelism
  thread if PARALLEL(Y) is specified in the CQM start up
  parameters. Additionally, if a Db2 is stopped and restarted and
  CQM or STAP remain active there is logic now at Db2 Monitoring
  Agent installation to clean up any CQM/STAP thread related
  storage that may remain from the previous time Db2 was active.
  2. Update SMEM_SIZE default values.
  

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:

  UI72674

Modules/Macros

• ADH#BCMZ ADH#COMZ ADH#PARZ ADHMINIZ ADHMSRCZ
  

Fix information

• Fixed component name

  SEC GUAR STAP D

• Fixed component ID

  5655STP00

Applicable component levels

• RA13 PSY UI72674

     UP20/11/26 P F011

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.