PH52766: INTV SLOW RESPONSE IF MANY DATASETS DELETED FROM CATALOG

APAR status

• Closed as program error.

Error description

• Incorrect process for identifying deleted datasets leads to
  excessive ICF Catalog Requests
  

Local fix

• The problem only occurs if the interval datasets are deleted
  before the interval retention limit is reached. One alternative
  is to update the SMS policy to migrate, not delete, the datasets
  before the intervals roll off until fix is available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
  ****************************************************************
  1. Increasing time delay of INTV command if interval datasets
  have been deleted
  2. Intermittent INCOROUT in INTV command in AVAIL column
  

Problem conclusion

• 1. Dataset catalog processing improved to reduce number of
  catalog requests
  2. Data moved into field had justification improved
  

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:

  UI91889

Modules/Macros

• CQM#INIX CQM#PARM CQM$GPOB CQM$GPOV CQM$INTV CQM$LC27 CQM$PRFG
  CQM$PRGI CQM34    CQM35    CQM359E  CQM36    CQM367E  CQM85
  CQM853E  CQMHGPOB CQMHLC18 CQMHPRGI
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI91889

     UP23/05/24 P F305