IBM Support

PI05200: NEW STORED PROCEDURE SYSPROC.ADMIN_EXPLAIN_MAINT

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • New Stored Procedure SYSPROC.ADMIN_EXPLAIN_MAINT
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users who use the        *
    *                 EXPLAIN tables or run the DDL                *
    *                 provided in the sample members DSNTESC       *
    *                 and DSNTESH to create the EXPLAIN tables     *
    ****************************************************************
    * PROBLEM DESCRIPTION: This PTF ships a new DB2-supplied       *
    *                      stored procedure                        *
    *                      SYSPROC.ADMIN_EXPLAIN_MAINT. It also    *
    *                      modifies the DB2 sample DDL members     *
    *                      DSNTESC and DSNTESH to create           *
    *                      partition-by-growth table spaces,       *
    *                      instead of segmented table spaces,      *
    *                      for the EXPLAIN tables.                 *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    The SYSPROC.ADMIN_EXPLAIN_MAINT stored procedure maintains
    EXPLAIN tables under a specified schema. It can be used to:
    - bring all existing EXPLAIN tables to current release format;
    - create missing EXPLAIN tables;
    - create a new set of EXPLAIN tables;
    - create a new set of aliases on the EXPLAIN tables;
    - drop existing EXPLAIN tables; or
    - drop existing EXPLAIN tables and create a new set.
    
    The DB2 sample DDL members DSNTESC and DSNTESH, which are used
    to create EXPLAIN tables, are modified to create
    partition-by-growth table spaces instead of segmented table
    spaces for the EXPLAIN tables.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI05200

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-30

  • Closed date

    2014-04-25

  • Last modified date

    2014-06-03

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

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

    UI17423

Modules/Macros

  • DSN@DMEM DSN@RIN  DSN@RVFY DSN@XAZP DSNADMEM DSNTESC  DSNTESH
    DSNTESR  DSNTIDXA DSNTIDXB DSNTIJRT DSNTINST DSNTINSV DSNTINS1
    DSNTIPRA DSNTIPRL DSNTRIN  DSNTRVFY DSNTXAZP HDBBB10J
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI17423

       UP14/05/13 P F405

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.



Document information

More support for: DB2 for z/OS

Software version: 11.0

Reference #: PI05200

Modified date: 03 June 2014


Translate this page: