IBM Support

PM38254: CATALOG COPY FUNCTION INCORRECT TABLESPACE NAMES I.E. NOT CCNNKX X AS DOCUMENTED IN THE USER'S GUIDE AND HELP PANEL ADBHCCJ

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Administration Tool for z/OS Catalog Copy function
    does not create its tablespaces as per the User's Guide and
    Reference or help panel ADBHCCJ "HELP: Create Catalog Copy and
    Bind Batch Jobs":
      Table spaces are created of the name CCnnKxx, where nn is the
      page size required and xx is the plan suffix for this catalog
      copy set.
    and issues DROP TABLESPACE commands for CC4Knn,CC8Knn, CC16Knn
    and CC32Knn.
    ADDITIONAL SYMPTOM: SQLCODEN616
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS Version 10 who use Catalog Copy.        *
    ****************************************************************
    * PROBLEM DESCRIPTION: The Catalog Copy table spaces           *
    *                      documented in the help panel ADBHCCJ    *
    *                      and in the DB2 Administration Tool      *
    *                      User's Guide are incorrect.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The DB2 Administration Tool User's Guide and help panel,
    ADBHCCJ were not updated to reflect the changes to the way
    Catalog Copy creates table spaces.
    

Problem conclusion

  • Catalog Copy has changed the way it creates table spaces in DB2
    Administration Tool User's Guide Version 10.  It now creates
    table spaces with the same name as the DB2 catalog, but in the
    database provided on panel ADB2CCJ 'Create Catalog Copy and
    Bind'.  The help pael and the DB2 Administration Tool User's
    Guide will be changed to reflect the new processing.  In
    addition, LOB table spaces will be dropped last and fixed in
    panel ADB2CCD 'Display Catalog Copy Versions' so that a
    processing error does not appear when sorting fields or
    pressing the enter key when in the panel.  The DB2
    Administration Tool User's Guide which describes the table
    space names created by Catalog Copy will be changed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM38254

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-03

  • Closed date

    2011-07-19

  • Last modified date

    2011-08-01

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

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

    UK69922

Modules/Macros

  •    ADBHCCJ  ADB2CCD  ADB2CCM
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK69922

       UP11/07/22 P F107

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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 August 2011