IBM Support

PK16683: UTIL LINE COMMAND USED ON AN INDEX DOES NOT PROVIDE THE SAME REPAIR OPTIONS FOUND WHEN USING THE SAME COMMAND ON TABLESPACES.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 Administration Tool does not show the same options when
    using the UTIL line command on an INDEX as when used on a
    TableSpace.  For example, REPAIR Utility on a TableSpace:
     N - Repair nocopypend    NA - Repair nocheckpend   NB - Repair
    NB - Repair norcvrpend    NL - RepairLevelid
    whereas REPAIR Utility on an Index:
     N - Repair
    No REPAIR Utility options presented for Indexes.
    

Local fix

  • Add the options manually
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users  of DB2 Administration Tool,  who      *
    *                 generate a repair job against an index,      *
    *                 may be affected.                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 Administration Tool does not show   *
    *                      the  same options when using the UTIL   *
    *                      line command on an INDEX as when used   *
    *                      on a TableSpace.                        *
    *                      .*                                      *
    *                      When building an ADMIN repair utility   *
    *                      job  against  an index, there is only   *
    *                      one flavor of repair on panel adb2ux.   *
    *                      The  review/change  options  must  be   *
    *                      used  to  select the flavor of repair   *
    *                      desired.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    UTIL  line  command  used  on  an  index  did  not  provide  the
    same  REPAIR  options  found  when  using  the  same  command on
    TABLESPACES.
    

Problem conclusion

  • Panel  ADB2UX  has  been  modified  to list the types of repair
    desired. The user will not be required to use the review/change
    options to make the selection.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK16683

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-12-13

  • Closed date

    2006-05-26

  • Last modified date

    2006-07-06

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

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

Modules/Macros

  •    ADB2UX
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • R710 PSY UK14861

       UP06/06/02 P F606

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

Document Information

Modified date:
06 July 2006