IBM Support

PH46022: MOVETB LINE COMMAND GENERATES INCORRECT REORG UTILITY CONTROL STATEMENT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ISPF Panel navigation for MOVETB line command allows Db2 Utility
    option combination of SHRLEVEL REFERENCE and FASTSWITCH NO or
    SHRLEVEL REFERENCE and FASTSWITCH NO. The panel navigation
    should warn the user about the combination of Db2 Utility
    options because the MOVETB line command change is not
    materialized in the Db2 catalog with those combinations of Db2
    Utility options.
    
    ADDITIONAL SYMPTOMS:
    MOVETB, FASTSWITCH, SHRLEVEL
    

Local fix

  • BYPASS/CIRCUMVENTION:
    NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 who use the ISPF option 1.S MOVETB           *
    *                 line command on table space                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: ....+....1....+....2....+....3....+.... *
    *                      The table space MOVETB function might   *
    *                      use REORG utility options that do not   *
    *                      allow pending definition changes to be  *
    *                      materialized. Db2 Utilities issues      *
    *                      message DSNU1165I when this situation   *
    *                      occurs.                                 *
    ****************************************************************
    The table space MOVETB function is enhanced to use SHRLEVEL
    CHANGE and FASTSWITCH YES when basic settings are used for REORG
    options. When customized settings are in use, if SHRLEVEL NONE
    is specified, SHRLEVEL CHANGE is used instead, and if
    FASTSWITCH NO is specified, FASTSWITCH YES is used instead.
    
    Keywords: TABLESPACE DSNU1165I
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH46022

  • 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

    2022-05-02

  • Closed date

    2022-08-18

  • Last modified date

    2022-09-01

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

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

    UI82007 UI82017

Modules/Macros

  • ADB2MVT2 ADB2USO  ADB2USOP ADB34    ADBH1S
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI82007

       UP22/08/20 P F208

  • RD10 PSY UI82017

       UP22/08/20 P F208

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

Document Information

Modified date:
01 September 2022