PH25777: OBSOLETE REPORTING FIELDS QISECTA/QISEKTA IN DB2 TABLES

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• QISECTA/QISEKTA have been replaced by QISESQCA and QISESQKA
  which are available in newer versions of DB2 V12. The older
  values contain no data. Customers would like to use newer
  fields for reporting, etc. APAR would create new columns. Old
  columns to be kept but only collected by older releases and
  state "they do not contain data as of DB2 Vxx.x" accordingly.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: TDSz/IZDS/IZPCA users of the DB2 Component,  *
  *                 subcomponent 2 Address Space,                *
  *                 and Analytics - DB2 component,               *
  *                 subcomponent 2 Address Space                 *
  *                 for V181, V182, V190 and V310.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 fields QISECTA and QISEKTA are no   *
  *                      longer supported from Db2 V8 and up     *
  *                      and replaced by QISESQCA and QISESQKA.  *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The fields QISECTA and QISEKTA are no longer supported by Db2
  from V8 and up. Db2 introduced two new fields QISESQCA and
  QISESQKA for amount of storage above the bar that was allocated
  for plans and packages respectively.
  

Problem conclusion

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:

  UI70459 UI70460 UI70461 UI70462 UI70463

Modules/Macros

• DRLTA2D2 DRLTD2D  DRLUA2D2
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R80A PSY UI70460

     UP20/07/15 P F007

• R8A0 PSY UI70459

     UP20/07/15 P F007

• R8A9 PSY UI70461

     UP20/07/15 P F007

• R9A0 PSY UI70462

     UP20/07/15 P F007

• RCA0 PSY UI70463

     UP20/07/15 P F007

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.