PH59206: ADD SUPPORT FOR UTILITY HISTORY TABLES.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Add support for Db2 V13 FL501 and FL504 Utility History tables.
  The support includes:
  1) Store the runtime information for utilities executed during
     the recovery both on the utility and on the object level.
  2) Add a statistics report for active and finished recoveries.
     The report contains information about all executed utilities
     grouped by the utility name.
  3) Update recovery monitoring panels to include information from
     Utility History tables - time elapsed, CPU used, zIIP used.
  

Local fix

• N/A
  

Problem summary

• Add support for Db2 V13 FL501 and FL504 Utility History tables.
  The support includes:
  1) Store the runtime information for utilities executed during
  the recovery both on the utility and on the object level.
  2) Add a statistics report for active and finished recoveries.
  The report contains information about all executed utilities
  grouped by the utility name.
  3) Update recovery monitoring panels to include information from
  Utility History tables - time elapsed, CPU used, zIIP used.
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

  PH59033

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

  UI95233

Modules/Macros

• ARY#BSDU ARY#LSQL ARY#MGRT ARY#PDSN ARY#RIO  ARY#SVOL ARY#YARC
  ARY#YDEL ARY$BOOT ARY$BPRU ARY$BPRV ARY$CG00 ARY$CGSL ARY$CGUP
  ARY$CGXD ARY$FQRY ARY$ICSB ARY$MAIN ARY$PRCL ARY$RESO ARY$SBCV
  ARY$SSID ARY$SSRA ARY$SSVD ARY$SSVV ARY$SYSL ARY$VAL  ARY4COMM
  ARY4MSG  ARY4MVSF ARY4QCLO ARY4QRHC ARY4QRRC ARY4QUTH ARY4SERV
  ARY4SRRD ARY4TYPS ARY@APRN ARY@BACK ARY@BAKS ARY@BHPG ARY@BLDB
  ARY@CGRS ARY@HCHK ARY@IVP  ARY@MAIN ARY@MJCR ARY@OCK9 ARY@OCPE
  ARY@OCPR ARY@ODSD ARY@OFLD ARY@OFLP ARY@OREN ARY@OSMS ARY@PEND
  ARY@REST ARY@RSTO ARY@RVNS ARY@RVSM ARY@RVSR ARY@SCAT ARY@SCKP
  ARY@SCLP ARY@SCMD ARY@SCON ARY@SDFG ARY@SDV2 ARY@SEST ARY@SETC
  ARY@SFLA ARY@SFLD ARY@SFQY ARY@SHRL ARY@SIDC ARY@SIMG ARY@SIMX
  ARY@SLOG ARY@SOFX ARY@SOIC ARY@SPLT ARY@SREC ARY@STSK ARY@STUB
  ARY@SVFY ARYBABAL ARYBABAQ ARYBABCK ARYBABCS ARYBABDT ARYBABOB
  ARYBABOP ARYBABPK ARYBABRL ARYBABRO ARYBABRS ARYBABSC ARYBABSR
  ARYBABTR ARYBABTS ARYBABUT ARYBABVA ARYBACSA ARYBADBV ARYBADCS
  ARYBADMA ARYBADT@ ARYBAICG ARYBAIPM ARYBALA  ARYBAMAN ARYBAMRR
  ARYBAOPT ARYBAPBP ARYBAPPL ARYBARCS ARYBAROM ARYBARPD ARYBARPS
  ARYBASAM ARYBASDM ARYBASEI ARYBASIM ARYBASRC ARYBATRM ARYBAVDM
  ARYBAVIM ARYBAVOM ARYBBCAI ARYBBCFO ARYBBCSL ARYBBDDM ARYBBDES
  ARYBBDFL ARYBBDSL ARYBBDSQ ARYBBERS ARYBBGLO ARYBBGOC ARYBBGOL
  ARYBBGRJ ARYBBIDM ARYBBIEN ARYBBIPS ARYBBOBM ARYBBOBS ARYBBOCN
  ARYBBODM ARYBBOXG ARYBBPDM ARYBBPI  ARYBBPLN ARYBBPLS ARYBBROM
  ARYBBRPA ARYBBRPC ARYBBRSL ARYBBSAM ARYBBSCM ARYBBSGD ARYBBSRC
  ARYBBSYM ARYBBSYS ARYBBTDM ARYBBTIR ARYBBTPM ARYBBTRM ARYBBTRS
  ARYBBTSL ARYBBTUJ ARYBBUCD ARYBBUCO ARYBBUDC ARYBBULD ARYBBUPV
  ARYBBURP ARYBBURV ARYBBUTH ARYBBVDM ARYBBVSL ARYBCAI  ARYBCDCS
  ARYBCICI ARYBCOAS ARYBCRAS ARYBDCLP ARYBDPLS ARYBDTRS ARYBEUSJ
  ARYBGINS ARYBGRDD ARYBGRDG ARYBGRDL ARYBGRGR ARYBGRMD ARYBGRML
  ARYBGRMR ARYBGRMT ARYBGRPL ARYBGRRR ARYBGRSF ARYBGUS  ARYBHDT@
  ARYBHHC  ARYBIDT@ ARYBINV  ARYBIPDS ARYBISCD ARYBISDO ARYBISMR
  ARYBJGBC ARYBJGCS ARYBJGDL ARYBJGID ARYBJGIM ARYBJGRD ARYBJGSB
  ARYBLAQ  ARYBLDRG ARYBLDSQ ARYBLFS  ARYBLMAN ARYBLOPT ARYBLUTL
  ARYBMACA ARYBMATB ARYBMATS ARYBMBMC ARYBMIXM ARYBMOPT ARYBOPLS
  ARYBOROD ARYBOSEP ARYBOSPQ ARYBOVBS ARYBOVSI ARYBOVSR ARYBPDCS
  ARYBPLDS ARYBPLOS ARYBPOCS ARYBPPCS ARYBPRFV ARYBRMAN ARYBRMOS
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R320 PSY UI95233

     UP24/01/18 P F401

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.