IBM Support

PM84747: (D)FIELD TABLESPACE TYPE CHANGED FROM LARGE TO <NORMAL> WHEN COM PARING DDL TO DB2 CATALOG FOR OBJECTS DEFINED AS LARGE NUMPARTS

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 issues a message:
    Compare tablespace source(>dbname<.>spacename<) and
    target(>dbname<.>spacename<)
        (D)Field Tablespace TYPE changed from LARGE to <normal>
      Tablespace >dbname<.>spacename< will be dropped
      Tablespace will be recreated
    when no change exists between the DDL and the DB2 Catalog.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
    *                 z/OS who compare a table space and the       *
    *                 table space was created with the LARGE       *
    *                 option.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: When performing a DDL to DB2 Catalog    *
    *                      compare, if a table space is defined    *
    *                      with the LARGE option in the DDL file,  *
    *                      Object Compare detects a difference     *
    *                      in the type of table space when there   *
    *                      should be no change.  The Compare       *
    *                      Report produced the following message:  *
    *                                                              *
    *                      (D)Field Tablespace TYPE changed        *
    *                         from LARGE to >normal<               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The table space is mistaken as a partitioned table space instead
    of a LARGE table space.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM84747

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-13

  • Closed date

    2013-04-15

  • Last modified date

    2013-05-06

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

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

    UK93456 UK93457

Modules/Macros

  •    ADBCDTS
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK93456

       UP13/04/18 P F304

  • RA20 PSY UK93457

       UP13/04/18 P F304

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

Document Information

Modified date:
06 May 2013