IBM Support

PI59053: DB2 ADMINISTRATION TOOL FOR Z/OS CUSTOMIZATION PROCESS DOES NOT PROVIDE BP16K / BP32K SELECTION FOR CM

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Administration Tool for z/OS Customization process
    does not provide customer with method of selecting
    BP16K nor BP32K bufferpool names for Change Management
    objects
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool for         *
    *                 z/OS who use IBM Tools Customizer            *
    *                 for z/OS.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: When customizing DB2 Administration     *
    *                      Tool for z/OS, IBM Tools Customizer     *
    *                      for z/OS does not provide a way to      *
    *                      customize buffer pool names for         *
    *                      creating specific Change Management     *
    *                      table space objects that require the    *
    *                      16KB and 32KB buffer pool size.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When customizing DB2 Administration Tool for z/OS, IBM Tools
    Customizer for z/OS does not provide a way to customize buffer
    pool names for creating specific Change Management table space
    objects that require the 16KB and 32KB buffer pool size, instead
    it uses fixed BP16K0 and BP32K as the buffer pool name in the
    following CREATE TABLESPACE statements of ADBSETUP job:
    
    CREATE TABLESPACE ">cm_tsname_prefix<CROL"
    IN ">cm_dbname<"
    BUFFERPOOL BP16K0
    ... ... ;
    .
    CREATE TABLESPACE ">cm_tsname_prefix<CVLN"
    IN ">cm_dbname<"
    BUFFERPOOL BP32K
    ... ...;
    

Problem conclusion

  • The new fields 'Table space 16KB BUFFERPOOL name' and
    'Table space 32KB BUFFERPOOL name' are added under the
    category of creating Change Management objects on both
    Product Parameters panel CCQPPRD and DB2 Parameters
    panel CCQPDB2 to customize 16KB and 32KB buffer pool
    names for creating specific Change Management table space
    objects that require the 16KB and 32KB buffer pool size.
    If no value is specified in the field 'Table space 16KB
    BUFFERPOOL name', the default BP16K0 will be used to
    create specific table spaces that require the 16KB buffer
    pool size.  If no value is specified in the fild 'Table
    space 32KB BUFFERPOOL name', the default BP32K will be used
    to create specific table spaces that require the 32KB buffer
    pool size.
    Also, the descriptions for some TCz parameters are
    changed/added. Check Tecknotes: "A way to specify
    BP with Tools Customizer for the Change Management,
    Checkpoint & Catalog Copy databases" for more details.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI59053

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-03-14

  • Closed date

    2016-08-09

  • Last modified date

    2016-09-02

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

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

    UI39956 UI39957

Modules/Macros

  •    ADB$$PRM ADBCUST  ADBSETUP ADB2CUST
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB10 PSY UI39956

       UP16/08/16 P F608

  • RB20 PSY UI39957

       UP16/08/16 P F608

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":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 September 2016