IBM Support

PI66370: DB2 ADMIN TOOL - PBG RECREATED INCORRECTLY, BUILT WITH NUMPARTS INSTEAD OF MAXPARTITIONS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When there are changes in the table that cause the table space
    to be dropped and recreated, upon create the table space is
    being built with NUMPARTS instead of MAXPARTITIONS.
    
    NUMPARTS is generated instead of MAXPARTITIONS because
    SYSTABLESPACE.TYPE is specified in the ignore file. To work
    around the issue for this case, remove SYSTABLESPACE.TYPE
    from the ignore file.
    

Local fix

  • Remove SYSTABLESPACE.TYPE from the ignore file.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool         *
    *                 for z/OS and DB2 Object Comparison           *
    *                 Tool for z/OS who make a change to           *
    *                 partitioned tables/table spaces.             *
    ****************************************************************
    * PROBLEM DESCRIPTION: When there are changes in the table     *
    *                      that cause the PBG table space to       *
    *                      be dropped and recreated, upon          *
    *                      CREATE the table space is being built   *
    *                      with the NUMPARTS keyword instead       *
    *                      of MAXPARTITIONS.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The NUMPARTS keyword is generated instead of MAXPARTITIONS
    because SYSTABLESPACE.TYPE is specified in the ignore file
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI66370

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    B20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-26

  • Closed date

    2016-11-29

  • Last modified date

    2016-12-01

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

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

    UI42969 UI42970

Modules/Macros

  •    ADB2CME  ADB2CMF
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB10 PSY UI42969

       UP16/12/01 P F611

  • RB20 PSY UI42970

       UP16/12/01 P F611

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

Document Information

Modified date:
01 December 2016