IBM Support

PH31211: COGNOS REPORT IMPROVEMENTS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Historical data is missing from some reports after applying the
    GA PTF.
    Improve the COGNOS sorting to ensure dates are in the
    correct order.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All IBM Z Performance and Capacity           *
    *                 Analytics users of Cognos reports.           *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. Average MIPS values may not be       *
    *                         present for all periods in CPU       *
    *                         reports.                             *
    *                      2. Cognos reports may not display data  *
    *                         in correct chronological order.      *
    *                      3. Duplicates may appear in views after *
    *                      2nd year of collecting data without     *
    *                      running the purge process.              *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    1. Cognos data model does not consistently calculate average
       MIPS.
    2. Cognos is processing date/time incorrectly for sorting.
    3. Views show duplicates when multiple years are collected.
    

Problem conclusion

  • IBM Z Performance and Capacity Analytics:
    1. Cognos data model is updated to consistently calculate the
      MIPS Average for all periods. New column AVG_MIPS_USED_AVG is
      added to the following views to facilitate this change:
         CP_CICS_APPLM_DV
         CP_CICS_APPLM_HV
         CP_CICS_APPLM_WV
         CP_CICS_REGNM_DV
         CP_CICS_REGNM_HV
         CP_CICS_REGNM_WV
         CP_CICS_TRANM_DV
         CP_CICS_TRANM_HV
         CP_CICS_TRANM_WV
         CP_CPU_CEC_DV
         CP_CPU_CEC_HV
         CP_CPU_CEC_MV
         CP_CPU_CEC_WV
         CP_CPU_JOB_DV
         CP_CPU_JOB_HV
         CP_CPU_JOB_MV
         CP_CPU_JOB_WV
         CP_CPU_LPAR_DV
         CP_CPU_LPAR_HV
         CP_CPU_LPAR_MV
         CP_CPU_LPAR_WV
         CP_CPU_WKLD_DV
         CP_CPU_WKLD_HV
         CP_CPU_WKLD_MV
         CP_CPU_WKLD_WV
         CP_CPU_WKLDA_DV
         CP_CPU_WKLDA_HV
         CP_CPU_WKLDA_MV
         CP_CPU_WKLDA_WV
         CP_CPU_WKLDB_DV
         CP_CPU_WKLDB_HV
         CP_CPU_WKLDB_MV
         CP_CPU_WKLDB_WV
    2. Cognos processing of date/time is enhanced to
       consistently sort chronologically.
    3. The above views and the following views, are modified to show
     data for the correct year only.
      CP_CPU_WKLD_TV
      CP_CPU_WKLDA_TV
      CP_CPU_WKLDB_TV
      CP_CPU_LPAR_TV
      CP_CPU_CEC_TV
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH31211

  • 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

    2020-11-03

  • Closed date

    2020-11-20

  • Last modified date

    2020-12-01

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

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

    UI72432 UI72433

Modules/Macros

  • DRLTCPCA DRLTCPCI DRLTCPCR DRLTKZH3 DRLTKZHX DRLWC31M DRLWCPCA
    

Fix information

  • Fixed component name

    TDS FOR Z/OS

  • Fixed component ID

    569510100

Applicable component levels

  • RC01 PSY UI72432

       UP20/11/24 P F011

  • RCA8 PSY UI72433

       UP20/11/24 P F011

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:
02 December 2020