IBM Support

PI87863: ENTERING 'GA' COMMAND FROM PANEL ADB2Z MAY RESULT IN ERROR: TABLE IS NOT OPEN

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When two users both enter the 'GA' command ('Alter group buffer
    pools') from panel ADB2Z ('System Administration'), the second
    user may receive the error 'Table is not open'.  The same error
    may occur if the same user tries to enter the 'GA' command from
    another DB2 member of the same Data Sharing Group on a
    different LPAR.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool         *
    *                 for z/OS.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Entering the command 'GA'               *
    *                      ('Alter GroupBuffer Pool') on the       *
    *                      System Administration panel ADB2Z       *
    *                      may result in the error message         *
    *                      'Table is not open'.                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When two Admin Tool users both enter command
    'GA' to alter group buffer pool from System Administration
    panel ADB2Z, the second user will receive "Table is not
    open". The problem remains until the first user exits from ISPF.
    The problem can also occur when the same user tries to
    enter the 'GA' command from another DB2 member in the
    same Data Sharing Group on a different LPAR.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI87863

  • 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

    2017-09-25

  • Closed date

    2017-11-15

  • Last modified date

    2017-12-02

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

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

    UI51939 UI51940

Modules/Macros

  •    ADBEZGA
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB20 PSY UI51939

       UP17/11/18 P F711

  • RC10 PSY UI51940

       UP17/11/18 P F711

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

Document Information

Modified date:
02 December 2017