IBM Support

PI09605: MSG ADB9717E GENERATED ON PBG TABLESPACE WITH LOCKPART

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 message ADB9717E
    during the Change Management process of Analyzing a comparison
    of a PBG Tablespace with Lockpart specified.
    

Local fix

  • remove lockpart
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS who use Change Management Batch (CM     *
    *                 Batch) to analyze a change and the change    *
    *                 has an ALTER TABLESPACE statement with       *
    *                 LOCKPART clause.                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: When analyzing a change that contains   *
    *                      only one ALTER TABLESPACE statement     *
    *                      with the LOCKPART clause, CM Batch job  *
    *                      failed with a RC =8 / RC8 and error     *
    *                      message ADB9717E / msgadb9717e:         *
    *                                                              *
    *                      ADB9717E A null list was retrieved      *
    *                      from the prerequisite program.          *
    *                      Chgid=changeid, action=PAN              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Since DB2 R810, all partitioned table spaces are treated as if
    they were defined as LOCKPART YES and the user is still able
    to specify the LOCKPART clause in the ALTER TABLESPACE
    statement.  DB2 Admin now provides this support.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI09605

  • 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

    2014-01-14

  • Closed date

    2014-05-14

  • Last modified date

    2014-06-03

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

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

Modules/Macros

  • ADBCDTS
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA20 PSY UI17985

       UP14/05/17 P F405

  • RB10 PSY UI17986

       UP14/05/17 P F405

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:
03 June 2014