PH37183: 3Q 2021 ENHANCEMENTS APAR

5.4.0-TIV-KD5-FP0027.zip
5.4.0-TIV-KD5-FP0027.tar.gz
5.4.0-TIV-KD5-FP0027.README
5.4.0-TIV-KD5-LP0021.zip
5.4.0-TIV-KD5-LP0021.tar
5.4.0-TIV-KD5-FP0026.zip
5.4.0-TIV-KD5-FP0026.tar.gz
5.4.0-TIV-KD5-FP0026.README
5.4.0-TIV-KD5-FP0025.zip
5.4.0-TIV-KD5-FP0025.tar.gz
5.4.0-TIV-KD5-FP0025.README

APAR status

• Closed as new function.

Error description

• 3Q 2021 Enhancements APAR
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: - Enhanced 3270 User Interface users         *
  *                 - Performance Expert Client users            *
  *                 - Classic Interface users                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: a) The Thread History collection        *
  *                         options and data set status is added *
  *                         in the E3270UI display.              *
  *                      b) Six new new ZPARM fields are added   *
  *                         to the System Parameters pages in    *
  *                         the PE Client.                       *
  *                      c) ABORT and COMMIT fields are added to *
  *                         the thread detail workspace in the   *
  *                         E3270UI.                             *
  *                      d) New Db2 12 ZPARM fields are added to *
  *                         E3270UI and Classic interface        *
  *                      e) Fast Traversal Block (FTB) and Index *
  *                         Algorithm 2 (IAG2) statistics fields *
  *                         are missing in the E3270UI           *
  *                      f) FTB fields and I/O interrupt CPU     *
  *                         Times are added to the PE Client.    *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  a) E3270UI Thread History configuration options and VSAM data
     set information are not externalized.
  b) New zParms are not available in Performance Expert Client.
  c) No thread commit and abort displayed from E3270UI thread
     information detail.
  d) New Db2 12 ZPARMs are not available from E3270UI and classic.
  e) Missing FTB and IAG2 support from data manager statistics
     from E3270UI.
  f) Missing support for FTB fields and I/O interrupt CPU Time
     in PE Client.
  

Problem conclusion

• a) Added COPT and data set displays to E3270UI Thread History.
  b) Six new fields added to System Parameters in PE Client:
       Block utilities from updating replicated tables(DSNTIP6)
       Allow update/delete/insert with isolation UR(DSN6SPRM)
       Disallow SSAR authorization(DSN6SPRM)
       Offload: Use only new accelerator type(DSNTIP82,DSNTIP8A)
       Use integrated sort acceleration for DFSORT(DSNTIP63)
       Memory limit for selected indexes(DSNTIP71)
  c) Added commit and abort count fields to thread detail work-
     spaces in E3270UI.
  d) New Db2 12 ZPARMs are added to both E3270UI and Classic
     interfaces:
       QWP4MFAT   (MFA_AUTHCACHE_UNUSED_TIME)
       QWP4LIRO   (LOAD_RO_OBJECTS)
       QWP4UBCDC  (UTILS_BLOCK_FOR_CDC)
       QWP4AUDIWU (ALLOW_UPD_DEL_INS_WITH_UR)
       QWP4QAONAT  USE ONLY NEW ACCEL_TYPE
       QWP4UZS    (UTILS_USE_ZSORT)
       QWP4IXMCS  Index Memory Control(Select IX)
       QWP4DSSAR  (DISALLOW_SSARAUTH)
       QWP4FTBUO  (FTB_NON_UNIQUE_INDEX)
       QWP4RINSU  (REORG_INDEX_NOSYSUT1)
       QWP4RICLD  (REORG_IC_LIMIT_DASD)
       QWP4RICLT  (REORG_IC_LIMIT_TAPE)
  e) Added the following fields to new E3270UI KDPPSQLG and
     KDPSLQF workspaces to show FTB and IAG2 Data Manager
     Statistics.
       QISTTRAVMIN
       QISTFTBCANT
       QISTFTBCAN
       QISTFTBSIZE
       QISTFTBNUMP
       QISTFTBNUMC
       QISTINPR
       QISTINPE
  f) Added six new counters for FTB statistic details:
       Minimum index traversals
       FTB index count
       Qualified indexes
       Memory allocation (in MB)
       Previous FTB indexes
       Current FTB indexes
     Added two new IAG2 counters:
       PIPE re-enable Attempted
       PIPE re-enable Succeeded
     Added I/O interrupt time fields under CPU Times page in PE
     Client:
       System Services I/O interrupt processing time
       Database Services I/O interrupt processing time
       IRLM I/O interrupt processing time
       DDF I/O interrupt processing time
  
  Search Keywords
  
  KDPHCOPT KDPHDSET KDPTPN2 QWACCOMM QWACABRT
  

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:

  UI77534

Modules/Macros

• DGOFSIST DGOMZF00 DGOMZF03 DGONFWP1 DGONFWP9 DGONFWPA DGOSCREC
  DGOVCRDB DGOVFTAB DGOVFTIN DGOVMIDI DGOVMSTR DGOVRA   DGOVSCLO
  DGOVSCNI DGOVSCNT DGOVSCS1 DGOVSFLR DGOVSGFT DGOVSLOC DGOVSORT
  DGOVSQFM DGOVSSP1 DGOVSSP2 DGOVSTQL DGOVUDAT DGOVUFTL DGOW1FIL
  DGOWF106 DGOWF107 FPEUIFC2 FPEUIFCI FPEUNIDT FPEVFTM  FPEVSFLR
  FPEVZMAI KD5AGENT KDPATR   KDPBAR   KDPCAT   KDPDOC   KDPH0057
  KDPHCOPT KDPHDSET KDPHFTAB KDPJSTMS KDPJSTPS KDPJSTPW KDPMAP
  KDPMSMAN KDPPLEX  KDPPSQL3 KDPPSQL4 KDPPSQL5 KDPPSQLF KDPPSQLG
  KDPPSQT1 KDPPZCTL KDPPZDSN KDPPZOTH KDPPZPF  KDPPZUTL KDPSQL4
  KDPSQL5  KDPSQL7  KDPSQLF  KDPSQLT1 KDPTPN2  KDPVRTMS KDPZCTL
  KDPZDSN  KDPZOTH  KDPZPERF KDPZUTIL KO25SXST KO25ZPRM KO2APC42
  KO2APC4K KO2APC4S KO2CCAFB KO2OQAL2 KO2OQALK KO2OQALS KO2PCTLH
  KO2PDSNH KO2POTHH KO2PPFMH KO2PUTLH KO2TZCTL KO2TZDSN KO2TZOTH
  KO2TZPFM KO2TZUTL
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI77534

     UP21/10/14 P F110

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.