IBM Support

PM10378: Provide sample statement in setup job to create the EXPLAIN database

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When customers want to use the OMPE EXPLAIN functionality they
    must submit jobs that create the required database objects.
    These jobs do not create the database where these objects should
    reside. In order to prevent misunderstandings, a job that
    creates the required database should also be provided to the
    customers.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   ICAT                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: The EXPLAIN database is currently       *
    *                      created by a generic CREATE DATABASE    *
    *                      statement. This may not fit to          *
    *                      customers requirements.                 *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    *                                                              *
    ****************************************************************
    PROBLEM SUMMARY:
    The CREATE DATABASE statement was removed.
    
    PROBLEM CONCLUSION:
    The CREATE DATABASE statement was removed.
    

Problem conclusion

  • The CREATE DATABASE statement was removed.
    
    KEYWORDS : EXPLAIN DATABASE
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM10378

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2010-03-19

  • Closed date

    2011-02-22

  • Last modified date

    2017-02-04

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

    PM04904

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

    UK65001 UK65014

Modules/Macros

  •    KD261SEX
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R410 PSY UK65001

       UP11/02/24 P F102 Ø

  • R420 PSY UK65014

       UP11/02/24 P F102 Ø

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 February 2017