PK23739: HIGH PRIVATE STORAGE UTILIZATION BY THE DATA COLLECTOR COULD RESULT IN ABEND S0878

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The CQM data collector may utilize a large amount of private
  storage.
  This could cause an ABEND S0878.
  
  OTHER KEYWORDS: ABEND878 878 ABENDS878 S878
                  ABEND80A Possible after an ABEND0C1 or ABEND0C6
  

Local fix

• The following instructions are provided for running a CQM
  diagnostic utility to relieve the storage problem described in
  APAR PK23739.
  
  You can run it multiple times via an automated scheduler or
  watch for high CPU usage and submit it to relieve the excessive
  usage.
  
  The final PTF will correct QM processing to ensure the storage
  cleanup is done promptly and when necessary so this temporary
  solution will no longer be necessary.
  
  
  INDICATIONS:  Run this job when QM excessive memory consumption
                is seen.
  
  
  EXPECTED RESULTS:
  
  * This job will cause CQM to allow the schedule
    of memory cleanup.
  
  * It will not cause additional overhead.
  
  * It will generate 3 or 4 lines of output similar
    to the following.
  
  YDATCMDDUMMY
   IEA630I  OPERATOR CQMDOG5  NOW ACTIVE,   SYSTEM=RS25    ,
  LU=CSPARRA
   CQM9099I RESET_FLAG(SDA,001B,00DF) NEW VALUE=00
   CQM9099I RESET_FLAG(SDA,05AC,007F) NEW VALUE=18
  
  
  CONSIDERATIONS:
  
  * The CQM started task must be running when this
    job is submitted or it will return an RC24.
  
  * This job resets a flag in the SDA memory of
    the CQM STC that schedules the memory cleanup
    process. Resetting the flag will allow the next
    task in CQM to schedule clean up.
  
  * Running this job multiple times will not cause
    a problem whether the flag is set correctly or not.
  
  
  EXAMPLE:
  
  
  //CQM#YDAT JOB <JOB PARAMETERS>
  //**************************************************************
  //*
  //* Licensed Materials - Property of IBM
  //* 5697-I03
  //* (c) Copyright IBM Corp. 1999, 2004 All Rights Reserved.
  //* (c) Copyright Rocket Software, Inc. 1999, 2004 All Rights
  //* US Government Users Restricted Rights - Use, duplication, or
  //* disclosure restricted by GSA ADP Schedule Contract with IBM
  //*
  //* INSTRUCTIONS:
  //*
  //* ISSUE CHANGE COMMANDS:
  //*  C #DBQM# TO A VALID QUERY MONITOR SUBSYSTEM NAME
  //*  C #HLQ1# TO THE HIGH LEVEL QUALIFIER FOR THE OFFLOAD DSN'S
  //*
  //*  CHANGE THE CQM220.SCQMLOAD TO THE NAME OF THE
  //*  QUERY MONITOR SCQMLOAD PDS INSTALLED ON YOUR SYSTEM
  //*
  //*  CHANGE THE FEC130.SFECLOAD TO THE NAME OF THE
  //*  QUERY MONITOR SFECLOAD PDS INSTALLED ON YOUR SYSTEM
  //*  QUERY MONITOR SFECLOAD PDS INSTALLED ON YOUR SYSTEM
  //*
  //**************************************************************
  *
  //IDCAMS  EXEC PGM=IDCAMS
  //SYSPRINT DD SYSOUT=*
  //SYSIN    DD *
     DELETE #HLQ1#.CQMYDATA
     SET MAXCC = 0
  //STEP1   EXEC PGM=CQM#YDAT,REGION=6M
  //STEPLIB  DD DSN=CQM220.SCQMLOAD,DISP=SHR
  //         DD DSN=FEC130.SFECLOAD,DISP=SHR
  //SYSPRINT DD   SYSOUT=*
  //UTPRINT  DD   SYSOUT=*
  //SYSUT1   DD   UNIT=SYSALLDA,SPACE=(CYL,(10,10))
  //SORTOUT  DD   UNIT=SYSALLDA,SPACE=(CYL,(10,10))
  //CQMYDATA DD DSN=#HLQ1#.CQMYDATA,DISP=(,CATLG),
  //  UNIT=SYSALLDA,SPACE=(CYL,(1,1),RLSE),
  //  DCB=(LRECL=32756,BLKSIZE=0,RECFM=VB)
  //CQMLOADP DD *
     CQM_SUBSYSTEM(#DBQM#)
     RESET_FLAG(SDA,1B,20)
     RESET_FLAG(SDA,5AC,80)
  /*
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The CQM data collector may utilize a    *
  *                      large amount of private storage.        *
  *                      This could cause an ABEND S0878.        *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK13996

Modules/Macros

•    CQM#ARCH CQM#DRVR CQM#EXCP CQM#INIT CQMMESQL
  CQMMEXCP CQMMFREE CQMMHSTV CQMMSSQL CQMTTEXT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK13996

     UP06/05/08 P F605 Ž

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.