PM64396: QBST AND QBGL RETURNS INCORRECT DATA WHEN BUFFER POOLS ARE DEFINED MORE THAN 25. 12/06/19 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• First QBST and QBGL in an overflow IFCID2 returns bufferpool ID
  incremented by 28 when bufferpools are defined more than 25.
  IFCID0002
  *************************************************************
  Additional Symptoms and Keywords:
   IFCID 2 0002 IFCID2 IFCID0002
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 statistics record IFCID2.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following conditions are reported:  *
  *                      1. If more than 25 group or local       *
  *                         bufferpools are in use, fields       *
  *                         QBSTPID and QBGLGN will contain      *
  *                         incorrect values in the first        *
  *                         repeating group of an overflow       *
  *                         IFCID2 record.                       *
  *                      2. The assembler mapping for DSNDQ8ST   *
  *                         is incorrect as field Q8STQUEW is    *
  *                         missing.                             *
  *                      Both issues arise after installing      *
  *                      APAR PM50435/PTF UK76014.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following conditions are reported:
  1. APAR PM50435 did not recompile all necessary parts for
     changes made to DSNDQWS1. This results in incorrect
     processing such that QBSTPID and QBGLGN become increased by
     a value of 28.
  2. APAR PM50435 did not account for DSNDQ8ST field Q8STQUEW.
  
  Additional Keywords:
  IDAAV2R1/K
  

Problem conclusion

• DB2 is changed as follows:
  1. All remaining recompiles have been included such that
     overflow IFCID2 records will have correct values for QBSTPID
     and QBGLGN.
  2. The assembler mapping for DSNDQ8ST has been corrected to
     include field Q8STQUEW.
  

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:

  UK79290

Modules/Macros

• DSNDQ8ST DSNWVZD1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK79290

     UP12/06/19 P F206

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.