IBM Support

PH10618: DB2 ADMINISTRATION TOOL - SM LINE COMMAND WILL ONLY RUN ON DB2 SYSTEM WHERE WLM IS CONFIGURED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Panel ADB2M1S runs panel ADB2ZPV0 to get the zparms and that
    may not be working as expected (e.g. Db2 waits until it times
    out) when there are no WLMs. Also, it doesn't seem that this
    path honors the PARMS option "Get Db2 zparms" (&GETDB2ZP), so
    user can turn this logic off on a system with no WLMs - and
    avoid to wait for the time out.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Three issues are addressed:             *
    *                                                              *
    *                      Issue 1: Line command SM on panel       *
    *                               ADB21S 'Table Spaces' will     *
    *                               only run on Db2 systems where  *
    *                               WLM is configured.             *
    *                                                              *
    *                      Issue 2: Line command COUNT on          *
    *                               PANEL ADB21T results in        *
    *                               SQLCODE -802 / SQLCODEN802.    *
    *                                                              *
    *                      Issue 3: Altering a table, an ISPF      *
    *                               Dialog Error occurs on panel   *
    *                               ADB27PGA.                      *
    ****************************************************************
    Issue 1:
    When line command SM is entered on
    panel ADB21S 'Table Spaces', it will
    only run on Db2 systems where WLM
    is configured.
    
    Issue 2:
    The COUNT line command on
    PANEL ADB21T results in
    SQLCODE -802 in DBRM:ADBMAIN.
    
    Issue 3:
    When a terminal Emulator is configures with
    Device Model 2 (24 x 80), line command ALT on panel
    ADB21T 'Tables, Views, and Alias' results in the following
    ISPF Dialog Error:
    Panel 'ADB27PGA' error
    Invalid window width value (must be numeric, >= 8, less than
    screen width).
    

Problem conclusion

  • Problems have been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH10618

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    B20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-04-08

  • Closed date

    2019-07-19

  • Last modified date

    2019-08-01

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

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

    UI64317

Modules/Macros

  • ADB21A   ADB21T   ADB21VV  ADB27PGA ADB2M1S
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI64317

       UP19/07/24 P F907

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 August 2019