PH19446: IZDS: DATA IN THE DB2_US_TRAN_SHAR_H TABLE FOR SEC_CHANGED_PAGEDIS INCORRECT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Data in the DB2_US_TRAN_SHAR_H table for SEC_CHANGED_PAGED is
  incorrect
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: TDSz/IZDS/IZPCA  users of the DB2 Component, *
  *                 6 Data Sharing Statistics subcomponent and   *
  *                 Analytics - DB2 component,  6 Data Sharing   *
  *                 for V181, V182, V190 and V310.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Wrong value on column SEC_CHANGED_PAGES *
  *                      getting value from field QBGA2W of      *
  *                      SMF_101 record which are no longer      *
  *                      supported by DB2 from V8 and up.        *
  ****************************************************************
  * RECOMMENDATION: Aooly the provided PTF.                      *
  ****************************************************************
  The field QBGA2W of SMF_101 record is no longer supported in
  DB2 record V8 and up but is still used on TDSz/IZDS/IZPCA code.
  

Problem conclusion

• The following change are done for this APAR:
  
  1. Change the value for the field SEC_CHANGED_PAGES to set to
     NULL for DB2 V8 and up in tables DB2_US_TRAN_SHAR_H for all
     versions and A_DB2_SHR_TRAN_I for V181, V182, V190 and V310.
  
  2. Update the System Performance Feature Reference Volume I
     to change the comment for the updated fields.
  

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:

  UI69982 UI69983 UI69984 UI69985 UI69986

Modules/Macros

• DRLTA2D6 DRLTD2TS DRLUA2D6
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R80A PSY UI69983

     UP20/06/13 P F006

• R8A0 PSY UI69982

     UP20/06/13 P F006

• R8A9 PSY UI69984

     UP20/06/13 P F006

• R9A0 PSY UI69985

     UP20/06/13 P F006

• RCA0 PSY UI69986

     UP20/06/13 P F006

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.