IBM Support

PH41689: PARTITIONING ERRORS ON IMS CAPACITY PLANNING & IMS KEY PERFORMANCE TABLES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On the CP_IMS_* & KPM_IMS_ATF_*  tables you are allowed to
    Partition by Range. It uses the key ORIGIN_IMS, which is
    non-existent for both sets of components. Those tables are only
    suppose to be Partition by growth.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of IBM Z Decision Support who      *
    *                 wish to use the following component and      *
    *                 have IMS range partitioning:                 *
    *                 Key Performance Metrics - IMS                *
    *                                                              *
    *                 All users of IBM Z Performance and Capacity  *
    *                 Analytics who wish to use the following      *
    *                 components and have IMS range partitioning:  *
    *                 Key Performance Metrics - IMS                *
    *                 Capacity Planning - IMS                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Install of components fail when         *
    *                      IMS range partitioning is enabled.      *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF before attempting     *
    *                 install of the affected components.          *
    ****************************************************************
    CP_IMS_REGN% and KPM_IMS_ATF% tables do not contain the column
    ORIGIN_IMS which is required for partitioning. Install fails
    when IMS partition by range is enabled.
    

Problem conclusion

  • CP_IMS_REGN% and KPM_IMS_ATF% table definitions are modified
    so that they now will always be partitioned by growth.
    Indices for these tables are now created as primary clustering
    indices instead of Data Partitioned Secondary Indices (DPSI)
    giving improved performance for queries.
    
    MODIFIED OBJECTS
    +--------------------------------------------------------------+
    The following IBM Z Performance and Capacity Analytics and
    IBM Z Decision Support objects are provided with or modified by
    this APAR:
    
              OBJECT                OBJECT   MEMBER
    COMPONENT NAME                  TYPE     NAME      LIBRARY
    +--------------------------------------------------------------+
    CP_IMS    DRLSCPI6             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPI7             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPI8             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPI9             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPIA             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPIB             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPIC             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPID             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPIE             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPIF             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              DRLSCPIG             TABSPACE  DRLSCPIM &HLQ..SDRLDEFS
              CP_IMS_REGNT_T       TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGNT_H       TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGNT_D       TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGNT_W       TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGNT_M       TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGN_T        TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGN_H        TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGN_D        TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGN_W        TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGN_M        TABLE     DRLTCPIB &HLQ..SDRLDEFS
              CP_IMS_REGN_F        TABLE     DRLTCPIB &HLQ..SDRLDEFS
    KPM_IMS   DRLSITL4(*)          TABSPACE  DRLSITLS &HLQ..SDRLDEFS
              DRLSITL5(*)          TABSPACE  DRLSITLS &HLQ..SDRLDEFS
              KPM_IMS_ATF_T(*)     TABLE     DRLTKIMA &HLQ..SDRLDEFS
              KPM_IMS_ATF_EVT_T(*) TABLE     DRLTKIMA &HLQ..SDRLDEFS
    
    (*) 190 and 310
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH41689

  • Reported component name

    TDS FOR Z/OS

  • Reported component ID

    569510100

  • Reported release

    C01

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-10-29

  • Closed date

    2021-12-12

  • Last modified date

    2022-01-04

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

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

    UI78496 UI78497 UI78498 UI78499 UI78500 UI78501

Modules/Macros

  • DRLSCPIM DRLSITLS DRLTCPIB DRLTKIMA
    

Fix information

  • Fixed component name

    TDS FOR Z/OS

  • Fixed component ID

    569510100

Applicable component levels

  • R901 PSY UI78499

       UP21/12/15 P F112

  • R9A1 PSY UI78500

       UP21/12/15 P F112

  • RC01 PSY UI78496

       UP21/12/15 P F112

  • RCA1 PSY UI78497

       UP21/12/15 P F112

  • RCA8 PSY UI78498

       UP21/12/15 P F112

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.

[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS2DUM","label":"IBM Z Decision Support"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C01"}]

Document Information

Modified date:
05 January 2022