PI92498: QUERY MONITOR REORG RECOMMENDATION EXCEPTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This enhancement adds the ability to leverage advice from IBM
  DB2 Query Monitor via a new exception/symptom called REORG
  AVOIDANCE.  A new entity called a Performance Window will
  provide start/end timestamps for CQM to monitor SQL that runs
  within that performance window against any object contained in
  the HAA object profile being processed.  Over time, CQM can
  detect performance degradation in the SQL being recorded.
  Should HAA exceptions recommend a REORG, the REORG can be
  avoided when:
  .
   1) the REORG AVOIDANCE exception is selected
   2) the SQL that CQM has recorded shows little indication of
      performance degradation.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Automation Tool z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: This enhancement adds the ability to    *
  *                      leverage advice from IBM DB2 Query      *
  *                      Monitor via a new exception/symptom     *
  *                      called REORG AVOIDANCE.  A new entity   *
  *                      called a Performance Window will        *
  *                      provide start/end timestamps for CQM    *
  *                      to monitor SQL that runs within that    *
  *                      performance window against any object   *
  *                      contained in the HAA object profile     *
  *                      being processed.  Over time, CQM can    *
  *                      detect performance degradation in the   *
  *                      SQL being recorded. Should HAA          *
  *                      exceptions recommend a REORG, the       *
  *                      REORG can be avoided when:              *
  *                       1. the REORG AVOIDANCE exception is    *
  *                        selected                              *
  *                       2. the SQL that CQM has recorded       *
  *                        shows little indication of            *
  *                        performance degradation.              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UI55599

Modules/Macros

•    HAA$ABKP HAA$ACES HAA$ACTR HAA$ADMD HAA$ADMN
  HAA$ADMS HAA$ADMU HAA$ADMW HAA$ADM1 HAA$ADM2 HAA$ADM4 HAA$ADM5
  HAA$ADM6 HAA$ADM7 HAA$ADRV HAA$ADSD HAA$ALLC HAA$ALRG HAA$ALRO
  HAA$ALRP HAA$ALRT HAA$AOIM HAA$AOSP HAA$APAR HAA$APFT HAA$APRD
  HAA$ARST HAA$ASIM HAA$ASMU HAA$ASTK HAA$ATRH HAA$BCHJ HAA$BCPY
  HAA$BDSN HAA$BGDG HAA$BJBC HAA$BJBN HAA$BMSD HAA$BMSG HAA$BPRD
  HAA$BRST HAA$BSAU HAA$BSHU HAA$BSUU HAA$BULD HAA$BULJ HAA$BUTA
  HAA$BUTB HAA$BUTC HAA$BUTD HAA$BUTE HAA$BUTG HAA$BUTH HAA$BUTI
  HAA$BUTJ HAA$BUTK HAA$BUTL HAA$BUTM HAA$BUTP HAA$BUTQ HAA$BUTR
  HAA$BUTS HAA$BUTT HAA$BUTU HAA$BUTV HAA$BUTX HAA$BUTZ HAA$BUT2
  HAAXZA1A HAAXZA1C HAAXZA1D HAAXZA1E HAAXZA1F HAAXZA10 HAAXZA11
  HAAXZA12 HAAXZA13 HAAXZA14 HAAXZA15 HAAXZA16 HAAXZA17 HAAXZA18
  HAAXZA19 HAAXZA20 HAAXZA21 HAAXZA22 HAAXZA23 HAAXZA24 HAAXZCLE
  HAAXZCLL HAAXZCMD HAAXZCM4 HAAXZDAP HAAXZDCB HAAXZDLC HAAXZDOB
  HAAXZDT@ HAAXZERT HAAXZEXT HAAXZGBT HAAXZGMN HAAXZGRS HAAXZJDD
  HAAXZJDS HAAXZJPG HAAXZJST HAAXZLD  HAAXZQDT HAAXZSCV HAAXZSH1
  HAAXZSTK HAAXZSUB HAAXZTM  HAAXZTOK HAAXZVTP HAAXZWT  HAAXZWTO
  HAAXZWTR HAAXZXDC H25H430J
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI55599

     UP18/05/09 P F805

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.