IBM Support

PH41681: MOVETB LINE COMMAND GENERATES REORG STATEMENT WITHOUT MAPPING TABLE FOR MULTI-TABLE TABLE SPACES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The MOVETB line command on panel ADB21S ('Table Spaces') does
    not generate the mapping table for the REORG statement, even
    though the mapping table is specified on panel ADB2US01
    ('Specify Utility Options - REORG TABLESPACE').  This affects
    multi-table table spaces.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 and Db2 Object Comparison Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: The MOVETB line command generates a     *
    *                      REORG statement without a mapping table *
    *                      for a multi-table table space.          *
    *                                                              *
    ****************************************************************
    The MOVETB line command on panel ADB21S ('Table Spaces') does
    not generate the mapping table option for the REORG statement
    even though the mapping table is specified on panel
    ADB2USO1.
    Note: The mapping table input fields are visible on panel
    ADB2USO1 when the UO command is specified on panel ADB2MVT2 and
    the SHRLEVEL option is C (Change) on panel ADB2USO. The utility
    control option 'List/Customize DB2 Utility options'
    is required to be YES on panel ADB2US ('Table Space Utilities').
    Panel ADB2US can be displayed by issuing the UT line command
    against a table space.
    
    KEYWORDS: MOVETB MAPTABLE MAPPINGTABLE
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH41681

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-10-29

  • Closed date

    2022-01-20

  • Last modified date

    2022-02-01

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

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

    UI78996

Modules/Macros

  • ADBEMVT3
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI78996

       UP22/01/25 P F201

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]

Document Information

Modified date:
02 February 2022