PI15757: DB2 ADMINISTRATION TOOL FOR Z/OS HELP PANEL ADBH1 DOES NOT EXPLAIN D/L/H FIELD OF PANEL ADB21 IN DETAIL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS Help Panel ADBH1
  does not explain D/L/H field of panel ADB21 in detail
  

Local fix

• We recommend that the user specify the schema name instead of
  the database name in the D/L/H field when diplaying Triggers
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the  'J - Triggers' option      *
  *                 on panel ADB21 'System Catalog' and specify  *
  *                 a database name in the 'In D/L/H' input      *
  *                 field.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When issuing option 'J - Triggers'      *
  *                      on the panel ADB21 with a database      *
  *                      name specified in the 'In D/L/H' input  *
  *                      field, the error message 'No rows       *
  *                      returned' was displayed even if the     *
  *                      trigger exists in the database.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The input field 'In D/L/H' on panel ADB21 allows the user to
  qualify their search for database, collection and schema
  objects by entering a matching pattern. The help panel ADBH1
  'HELP: DB2 System Catalog Facilities' does not clearly describe
  the appropriate information for each type of object when
  specifying the database, collection, or schema name.
  

Problem conclusion

• The description for the input filed 'In D/L/H' on help panel
  ADB 'HELP: DB2 System Catalog Facilities has been improved to
  clarify its usage:
  
  You can qualify your search for database, collection and
  schema objects by entering a matching pattern in the 'IN D/L/H'
  input field.
  
  Specify a database name for the following types of objects:
      S - Table spaces                 X - Indexes
      T - Tables, views, and aliases   C - Columns
      Y - Synonyms                     N - Constraints
      PDC - DB2 pending definition changes
    Specify a schema name for the following types of objects:
      H - Schemas                      O - Stored procedures
      E - User defined data types      J - Triggers
      F - Functions                    Q - Sequences
    Specify a collection ID for the following type of objects:
      K - Packages
  

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:

  UI19170 UI19171

Modules/Macros

•    ADBH1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19170

     UP14/06/28 P F406

• RB10 PSY UI19171

     UP14/06/28 P F406

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.