PI48187: ENHANCEMENTS TO THE SPREADSHEET INPUT DATA GENERATOR AND THE SYSTEM PARAMETER TABLES IN THE PERFORMANCE DATABASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Enhancements to the Spreadsheet Input Data Generator and the
  System Parameter tables in the Performance Database
  
  Additional Keywords
  DIR_ENTRY_RECLAIM
  DATA_ENTRY_RECLAIM
  XI_DIR_ENTRY_RECLM
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - PDB                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. (Group) Buffer Pool identifiers      *
  *                      are differently represented as small    *
  *                      integers and as character strings       *
  *                      in various Performance Database tables  *
  *                      and field selection lists of the        *
  *                      Spreadsheet Input Data Generator.       *
  *                                                              *
  *                      2. The field QWHSSID (MVS system        *
  *                      identifier) is not supported in         *
  *                      the System Parameter tables of the      *
  *                      Performance Database and in the         *
  *                      related field selection lists of the    *
  *                      Spreadsheet Input Data Generator.       *
  *                                                              *
  *                      3. Some columns in the Performance      *
  *                      Database table DB2PMSYSPAR_230          *
  *                      may hold negative numbers.              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Introduce formatting functions BP2C and GBP2C in the
  Spreadsheet Input Data Generator to transform integer (group)
  buffer pool identifiers to character representations.
  
  2. Add column MVS_ID to the System Parameter tables of the
  Performance Database and to the related field selection lists
  of the Spreadsheet Input Data Generator.
  
  3. Modify data type INTEGER of three columns in the
  DB2PMSYSPAR_230 table to BIGINT.
  
  PROBLEM CONCLUSION:
  1. Introduce formatting functions BP2C and GBP2C in the
  Spreadsheet Input Data Generator to transform integer (group)
  buffer pool identifiers to character representations.
  
  2. Add column MVS_ID to the System Parameter tables of the
  Performance Database and to the related field selection lists
  of the Spreadsheet Input Data Generator.
  
  3. Modify data type INTEGER of three columns in the
  DB2PMSYSPAR_230 table to BIGINT.
  
  KEYWORDS:
  SPREADSHEET MVS_ID QWHSSID DB2PMSYSPAR_230
  

Problem conclusion

• 1. Introduce formatting functions BP2C and GBP2C in the
  Spreadsheet Input Data Generator to transform integer (group)
  buffer pool identifiers to character representations.
  
  2. Add column MVS_ID to the System Parameter tables of the
  Performance Database and to the related field selection lists
  of the Spreadsheet Input Data Generator.
  
  3. Modify data type INTEGER of three columns in the
  DB2PMSYSPAR_230 table to BIGINT.
  

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:

  UI32146

Modules/Macros

• DGOWBSFP DGOWB106 DGOWB201 DGOWB202 DGOWB230 DGOWB256 DGOWCSFP
  DGOWC106 DGOWC201 DGOWC202 DGOWC230 DGOWC256 DGOWDSFP DGOWD106
  DGOWD201 DGOWD202 DGOWD230 DGOWD256 DGOWFILE DGOWLSFP DGOWL106
  DGOWL201 DGOWL202 DGOWL230 DGOWL256 DGOWUPDB DGOW1FIL FPEPCGM
  FPEPPRM  FPEPWSFP FPEPW106 FPEPW201 FPEPW202 FPEPW230 FPEPW256
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R530 PSY UI32146

     UP15/10/20 P F510

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.