PI61097: DB2 ADMIN TOOL ISSUES WITH LINE COMMAND 'DSN - DISPLAY TABLE SPACE DATA SET NAME(S)' AFTER APPLYING APAR PI46245

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying APAR PI46245, the issues that APAR addressed are
  fix, but the following issues are found:
  - Hitting F3 from panel ADB2MSPC 'DB2 Space Manager' with
    no value in the 'DB2 catalog high level qualifier' field
    returns:
    INVALID DATA SET NAME, '.DSNDBC.DSNDB01.DBD01.I0001.A001'
    ***
    then returns to panel ADB21DSN 'Data Sets for TS ...' with
    message 'Invalid qualifier' and an invlaid data set name
    shown on the panel.
  - Entering an invalid HLQ on panel ADB2MSPC 'DB2 Space Manager'
    leads to a catalog HLQ starting with the invalid HLQ on
    panel ADB21DSN 'Data Sets for TS ...'  data set name field.
    DB2 Admin Tool does not check whether the HLQ is valid.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'DSN - Display table        *
  *                 space data set name(s)' line command.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When issuing the 'DSN - Display         *
  *                      table space data set name(s)' line      *
  *                      command against table spaces of         *
  *                      DB2 catalog DSNDB06 and directory       *
  *                      DSNDB01 on panel ADB21S 'Table          *
  *                      Spaces', the following problems         *
  *                      were observed:                          *
  *                                                              *
  *                      1. If nothing was specified for the     *
  *                      field 'DB2 catalog high level           *
  *                      qualifier', upon pressing the F3        *
  *                      key on panel ADB2MSPC 'DB2              *
  *                      Space Manager', the following           *
  *                      message is seen:                        *
  *                                                              *
  *                      'INVALID DATA SET NAME'                 *
  *                                                              *
  *                      2. If the wrong value was specified     *
  *                      for field 'DB2 catalog high level       *
  *                      qualifier', upon pressing the Enter     *
  *                      key on panel ADB2MSPC, it advances      *
  *                      to panel ADB21DSN 'Data Sets for ..',   *
  *                      and displays the wrong high level       *
  *                      qualifier.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When issuing the 'DSN - Display table space data set name(s)'
  line command against table spaces of DB2 catalog DSNDB06 and
  directory DSNDB01 on panel ADB21S, an 'INVALID DATA SET NAME'
  error may be observed on panel ADB2MSPC, and panel ADB21DSN
  may display the wrong high level qualifier for the data set.
  

Problem conclusion

• When issuing the 'DSN - Display table space data set name(s)'
  line command against table spaces of DB2 catalog DSNDB06
  and directory DSNDB01 on panel ADB21S, the following
  will now occur:
  
  1. If nothing is specified for field 'DB2 catalog high level
  qualifier', upon pressing the F3 key on panel ADB2MSPC,
  it advances to panel ADB21S.
  
  2. If the wrong value is specified for field 'DB2 catalog high
  level qualifier', upon pressing the Enter key on panel ADB2MSPC,
  a new message, ADBZ111E / msgadbz111e, will be displayed:
  
  ADBZ111E:
  The high level qualifier specified for the data set is invalid.
  
  Explanation:
  An invalid high level qualifier was specified for the data set.
  
  System action
  Processing stops.
  
  User response
  Specify a valid high level qualifier.
  

Temporary fix

Comments

APAR Information

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

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

  UI40546 UI40547

Modules/Macros

•    ADBE1DSN ADBZ11   ADB2MSPC ADB21DSN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI40546

     UP16/09/05 P F609

• RB20 PSY UI40547

     UP16/09/05 P F609

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.