PM00821: EXCESSIVE AUXILIARY STORAGE USAGE AND SYSTEM WIDE PAGING 09/11/09 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Q uery Monitor can cause excessive Auxiliary Storage usage
  and system wide paging.
  SYSTRACE will show:
  010C 00000000  PGM    011 077C2001 9206019C  00060011 0000024A
                                               25C0E000 02BE 010C
  010C 00000000  PGM    011 077C2001 9206019C  00060011 0000024A
                                               25C0F000 02BE 010C
  010C 00000000  PGM    011 077C2001 9206019C  00060011 0000024A
                                               25C10000 02BE 010C
  010C 00000000  EXT   1005 077C0001 92060496  00001005 02BE 010C
  010C 00000000  PGM    011 077C2001 9206019C  00060011 0000024A
                                               25C11000 02BE 010C
  with the PRIMARY ASID 02BE being QM (CQMMSTR in this case) and
  the SECONDARY ASID 010C being xxxxDBM1 (DBMCDBM1 in this case).
  The PSW address of 9206019C is CQMOREDX+19C (at PK89760 level)
  and can be from offsets X'019C' through +X'05D2'.  In this
  example, CQMOREDX is loaded at 12060000 with an eyecatcher of
      CQMOREDX 230   09/02/0917.24 H238230 OSz1.9 .PK89760
    SM 5697-I03 . ROCKET SOFTWARE, INC. 1999, 2008
  There can be thousands of these entries and the following
  message may be seen:
   ILR012W ALL LOCAL PAGING SPACE IS FULL OR BAD, ASM WAIT03C
  RSN=01
  

Local fix

• Stop the CQM collector started task.  Add the following
  parameters to CQMPARMS before restarting the collector.
  INFLIGHT(N)
  PARALLEL(N)
  DISABLE_COM_HOOK(Y)
  DISABLE_AB_HOOK(Y)
  
  These are undocumented PARMS.
  These are the descriptions of the PARMS
  
  INFLIGHT
  controls an asynchronous task that scans all long running
  threads and attempts to update exception and alert data
  in-flight. Turning off INFLIGHT will prevent both the exception
  and alert processes from detecting thresholds until the end of a
  statement.
  
  PARALLEL
  controls the display of the associated 'child' task information
  from a parent, parallel task. PARALLEL(N) will prevent the
  'child' task from being viewed.
  
  DISABLE_COM_HOOK(Y)
  will prevent some COMMIT statements from being displayed.
  
  DISABLE_ABT_HOOK(Y)
  will prevent some ROLLBACK statements from being displayed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL DB2 Query Monitor Users                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Q uery Monitor can cause excessive  *
  *                      Auxiliary Storage usage  and system     *
  *                      wide paging.                            *
  *                      SYSTRACE will show:                     *
  *                      010C                                    *
  *                      00000000  PGM    011 077C2001 9206019C  *
  *                      00060011 0000024A                       *
  *                      25C0E000 02BE                           *
  *                      010C010C 00000000  PGM    011 077C2001  *
  *                      9206019C  00060011 0000024A             *
  *                                                              *
  *                      25C0F000 02BE 010C010C 00000000  PGM    *
  *                      011 077C2001 9206019C  00060011         *
  *                      0000024A                                *
  *                      25C10000 02BE 010C010C                  *
  *                      00000000  EXT   1005 077C0001 92060496  *
  *                      00001005 02BE 010C010C 00000000  PGM    *
  *                      011 077C2001 9206019C  00060011         *
  *                      0000024A                                *
  *                      25C11000 02BE 010Cwith                  *
  *                      the PRIMARY ASID 02BE being QM (CQMMSTR *
  *                      in this case) and  the SECONDARY ASID   *
  *                      010C being xxxxDBM1 (DBMCDBM1 in this   *
  *                      case). The PSW address of 9206019C is   *
  *                      CQMOREDX+19C (at PK89760 level) and can *
  *                      be from offsets X'019C' through         *
  *                      +X'05D2'.  In this                      *
  *                      example, CQMOREDX is loaded at          *
  *                      12060000 with an eyecatcher of          *
  *                      CQMOREDX 230   09/02/0917.24 H238230    *
  *                      OSz1.9 .PK89760       SM 5697-I03 .     *
  *                      ROCKET SOFTWARE, INC. 1999, 2008        *
  *                      There can be thousands of these         *
  *                      entries and the following    message    *
  *                      may be seen:                            *
  *                      ILR012W ALL LOCAL PAGING                *
  *                      SPACE IS FULL OR BAD, ASM WAIT03C       *
  *                      RSN=01                                  *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A code change has been made to correct this issue
  

Problem conclusion

• APPLY PTF
  

Temporary fix

• *********
  * HIPER *
  *********
  STOP THE CQM COLLECTOR STARTED TASK.  ADD THE FOLLOWING
  PARAMETERS TO CQMPARMS BEFORE RESTARTING THE COLLECTOR.
  INFLIGHT(N)
  PARALLEL(N)
  DISABLE_COM_HOOK(Y)
  DISABLE_AB_HOOK(Y)
  

Comments

APAR Information

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

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

  UK52153

Modules/Macros

•    CQMMESQX CQMOREDX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK52153

     UP09/12/03 P F912 «

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.