PH19206: Numerous incorrout fixes in V540 online interfaces

db2pe.client.v5.3.1.0.8605.win64.zip
db2pe.client.v5.3.1.0.8604.win64.zip

APAR status

• Closed as unreproducible in next release.

Error description

• Numerous incorrout fixes in V540 online interfaces
  
  1) CONNTYPE filter not working for near term history
  
  
  
  
  
  Additional keywords
  NTH NTA Accounting connection type filtering
  

Local fix

• Apply PTF when available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
  *                 users of component                           *
  *                 PE server subtask                            *
  *                 Performance Expert Client                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Thread/Statement level HTAP metrics.    *
  *                                                              *
  *                      Db2 V12 FL505 ZPARMs are missing from   *
  *                      the PE Client. ZPARM field is shown as  *
  *                      'N/A' for Db2 V11.                      *
  *                                                              *
  *                      The Java Runtime Environment has not    *
  *                      addressed the latest common             *
  *                      vulnerabilities. The JDBC driver        *
  *                      doesn't support the Db2 Database 11.5.  *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  Enhancement 'Thread/Statement level HTAP metrics':
  
  Thread level and statistic and dynamic statement level HTAP
  metrics that were implemented in the Db2 APAR PH00574 are
  missing from the PE Client.
  
  Enhancement 'FL505 ZPARMs':
  
  Various ZPARM fields that were implemented in the V12R1M505
  release of Db2 are missing from the PE Client. FLASHCOPY_XRCP
  ZPARM is not present for Db2 V11.
  
  The Java Runtime Environment used by PE Client has some
  vulnerabilities and needs to be updated. The JDBC driver used by
  PE Client to check local Db2 installation doesn't support the
  Db2 Database V11.5.
  

Problem conclusion

Temporary fix

Comments

• Enhancement 'Thread/Statement level HTAP metrics':
  
  6 new counters called the HTAP metrics were added under 2 PE
  Client pages: 2 counters for static statement level and 2 for
  dynamic were added to the Statistic Details page and 2 counters
  for thread level to the Thread Details page.
  
  Enhancement 'FL505 ZPARMs':
  
  28 new ZPARMs were added to various panels under the System
  Parameters (ZPARMs) page.
  
  The Java Runtime Environment was updated to address the latest
  common vulnerabilities. The JDBC driver was updated to support
  the Db2 Database V11.5.
  
  Search Keywords:
  HTAP Thread Statement ZPARM FL505
  

APAR Information

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

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

  UI69439

Modules/Macros

• DGOAACUM DGOACREC DGOARCAL DGONF370 DGONF380 DGONF410 DGONF500
  DGONFIL1 DGONFILE DGONTRAC DGORRSQL DGOSI369 DGOSPREQ DGOVCRDB
  DGOVFTAB DGOVFTIN DGOVMSTR DGOVRA   DGOVS700 DGOVSCLO DGOVSCNI
  DGOVSCNT DGOVSCS2 DGOVSCT1 DGOVSDSC DGOVSFLR DGOVSGFT DGOVSLOC
  DGOVSORT DGOVSQFM DGOVSTQL DGOVUDAT DGOVUFTL DGOXF000 DGOXF002
  DGOXR000 DGOXT002 FPEK$INF FPEUFTDS FPEUFTS2 FPEUIFC2 FPEUIFCI
  FPEUNIDT FPEUVTMM FPEVFTM  FPEVSETM FPEVSFLR FPEVZMAI KO2CCAFB
  KO2OQAL2 KO2OQALK KO2OQALS KO2PUTLH
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI69439

     UP20/05/14 P F005

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.