PH53421: IDAA ENHANCEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New fields being added to DB2 tables and DB2 Accelerator
  tables. An existing field is being renamed in a DB2 Accelerator
  table. A_DB2_IDAA_ST_A_I to be partitioned by growth by
  default and replicated by a new view.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM Z Decision Support Version  *
  *                 1.9.0 and IBM Z Performance and Capacity     *
  *                 Analytics Version 3.1.0 who use the          *
  *                 DB2 component or the Analytics - DB2         *
  *                 component.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Fields relevant to IBM Db2 Analytics *
  *                      Accelerator (IDAA) statements and       *
  *                      connection details are not present      *
  *                      in related tables.                      *
  *                      2. A_DB2_IDAA_ST_A_I abends on install  *
  *                      with an SQLCODE = -205 followed by an   *
  *                      SQLCODE = -660 when partitioned by      *
  *                      range.                                  *
  *                      3. Column name ACT_INACT_DBATS in       *
  *                      table A_DB2_DB_SYS_I does not comply    *
  *                      with naming standards.                  *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  1. Fields relevant to IDAA statements and connection details
  are not present in related tables.
  2. A_DB2_IDAA_ST_A_I abends on install when partitioned by
  range. This is due to the absence of an MVS_SYSTEM_ID field.
  3. Column name ACT_INACT_DBATS in table A_DB2_DB_SYS_I does
  not comply with the naming standard for maximum values.
  

Problem conclusion

Temporary fix

Comments

• 1. Fields relevant to IDAA statements and connection details
  have been added to the related tables.
  2. A_DB2_IDAA_ST_A_I now defaults to growth partitioning on
  install.
  3. Column name ACT_INACT_DBATS in table A_DB2_DB_SYS_I has
  been changed to ACT_INAC_DBATS_MAX to meet naming standards.
  

APAR Information

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

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

  UI91967 UI91968 UI91969

Modules/Macros

• DRLIADB2 DRLJMTVK DRLSA2D4 DRLTA2D2 DRLTA2D4 DRLTD2BA DRLTD2T
  DRLTD2UT DRLUA2D2 DRLUA2D4 DRLVA2D4
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R9A0 PSY UI91967

     UP23/06/23 P F306  

• RC01 PSY UI91968

     UP23/06/23 P F306  

• RCA0 PSY UI91969

     UP23/06/23 P F306  

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.