PH38004: BATCH STATISTICS/RECTRACE NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Batch STATISTICS/RECTRACE new function
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
  *                 users of components:                         *
  *                 - Batch Statistics PDB                       *
  *                 - Batch Statistics CSV                       *
  *                 - Batch Rectrace report                      *
  *                 - Batch SAVE migration                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:  - Db2 FL509 introduce new statistics   *
  *                      counters.                               *
  *                      - Not able to use Statistics SAVE file  *
  *                      after FL509 support                     *
  *                      - 22 new fields are missing in          *
  *                        Statistics PDB/CSV tables             *
  *                      - 9 new metrics needs to be added into  *
  *                      Batch Recordtrace report                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  - New counters introduced by Db2 FL509 are not supported in
  OMPE Batch Statistics.
  - If Statistics SAVE datasets, created prior applying this
  PTF, are to be used they need to be migrated to latest version.
  - 22 new fields are missing in PDB table
  DB2PM_STAT_GENERAL and in FILE/SAVE datasets.
  - 9 new metrics need to be included into Batch Rectrace report.
  

Problem conclusion

Temporary fix

Comments

• - New counters introduced by Db2 FL509 are externalized in
  Batch Statistics
  -Statistics migration utility updated to migrate SAVE file
  to the latest version.
  - 22 new fields added to Statistics PDB table and included into
  FILE/ SAVE dataset:
  QXSTSRT, QXSTSRTL, QXSTSFN1, QXSTMSRT, QXRWSID1, QXRWSID2,
  QTPCGBP, QTPCUT, QISTCLKF, QISTRLK, QISTINPR, QISTINPE,
  QISTVMIN, QISTCANT, QISTBCAN, QISTSIZE, QISTNUMP, QISTNUMC,
  SSTIOT, DTIOT, SDITIOT, SDDFTIOT
  - 9 fields are added into Batch Rectrace report:
  QWSAIIPT, QISTINPR, QISTINPE, QISTTRAVMIN, QISTFTBCANT,
  QISTFTBCAN, QISTFTBSIZE, QISTFTBNUMP, QISTFTBNUMC
  
  
  Search Keywords:
  QXSTSRT, QXSTSRTL, QXSTSFN1, QXSTMSRT, QXRWSID1, QXRWSID2,
  QTPCGBP, QTPCUT, QISTCLKF, QISTRLK, QISTINPR, QISTINPE,
  QISTVMIN, QISTCANT, QISTBCAN, QISTSIZE, QISTNUMP, QISTNUMC,
  SSTIOT, DTIOT, SDITIOT, SDDFTIOT, QISTTRAVMIN, QISTFTBCANT,
  QISTFTBCAN, QISTFTBSIZE, QISTFTBNUMP, QISTFTBNUMC, QWSAIIPT
  ×**** PE21/12/22 FIX IN ERROR. SEE APAR PH42996  FOR DESCRIPTION
  

APAR Information

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

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

  UI77098

Modules/Macros

• DGOBGENL DGOBSRAL DGOBSRBN DGOBSRCM DGOBSRDD DGOBSRLG DGOBSRLK
  DGOBSRLO DGOBSROC DGOBSRPO DGOBSRQP DGOBSRRI DGOBSRSH DGOBSRSP
  DGOBSRSQ DGOBSRSS DGOBSRTM DGOBSTAL DGOBSTBN DGOBSTCM DGOBSTDD
  DGOBSTLG DGOBSTLK DGOBSTLO DGOBSTOC DGOBSTPO DGOBSTQP DGOBSTRI
  DGOBSTSH DGOBSTSP DGOBSTSQ DGOBSTSS DGOBSTTM DGOER000 DGOFECAL
  DGOFEDAT DGOFFLDS DGOFPDAT DGOFSIST DGOFSWSA DGOFSXST DGOFUCA1
  DGOFUCAL DGOFUFAC DGOFUFDI DGOMSWSA DGONF9ST DGONFISE DGOPMIC1
  DGOPSB10 DGOPSB20 DGOPSC10 DGOPSCNV DGOSACMG DGOSACU2 DGOSACUM
  DGOSAPAW DGOSAPTS DGOSATGS DGOSATXA DGOSBGEN DGOSBLKX DGOSBORD
  DGOSBORE DGOSCGEN DGOSDGEN DGOSFILE DGOSFMTQ DGOSFMTR DGOSFMTS
  DGOSFMTT DGOSGENC DGOSGENS DGOSLGEN DGOSREDC DGOSREPG DGOSREPM
  DGOSRMGS DGOSSAVE DGOSSTDA DGOSSWSR DGOSTRAC DGOSUPDB DGOVSCS1
  FPECMDAT FPEPSGEN FPEUCBPR FPEUIFC2 FPEUIFCI FPEUMSGS FPEUNIDT
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI77098

     UP21/09/15 P F109

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.