PM61935: DB2 10 ENFM9 PANEL ADB21 V VIEWS COMMAND SHOWS NO RESULTS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' V - Views command on panel
  ADB21 shows no objects when running on a DB2 10 subsystem in
  ENFM9 mode.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'V - Views' option or       *
  *                 'J - Triggers' on panel ADB21 'System        *
  *                 Catalog' panel and DB2 10 in any of the      *
  *                 following Enabling-New-Function (ENFM)       *
  *                 modes:                                       *
  *                                                              *
  *                 V10 ENFM8 : Enabling-new-function            *
  *                             mode from Version 8              *
  *                 V10 ENFM8*: Enabling-new-function            *
  *                             mode* from Version 8             *
  *                 V10 ENFM9 : Enabling-new-function            *
  *                             mode from Version 9.1            *
  *                 V10 ENFM9*: Enabling-new-function            *
  *                             mode* from Version 9.1           *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Administration Tool for      *
  *                      z/OS, when using 'V - Views' option     *
  *                      or 'J - Triggers' option on panel       *
  *                      ADB21 and subsystem DB2 10 ENFM mode,   *
  *                      objects are not displayed even if       *
  *                      there are objects stored in the DB2     *
  *                      catalog, and an error message           *
  *                      'No rows returned' is issued on         *
  *                      the panels.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In the DB2 Administration Tool for z/OS, when using 'V -
  Views' option or 'J - Triggers' option on panel ADB21 and
  subsystem DB2 10 ENFM mode, objects are not displayed
  even if there are objects stored in the DB2 catalog, and an
  error message 'No rows returned' is issued on the panels.
  The catalog table SYSVIEWS for view objects and SYSTRIGGERS
  for trigger objects are changed. The column type which is
  used to store the statement is changed from VARCHAR to CLOB
  in DB2 10 ENFM mode.
  

Problem conclusion

• The following panels have been changed to provide support to
  display views or triggers on DB2 10 ENFM:
  
  ADBPCP 'Copy Privileges'
  ADB2AH 'Schema Authorizations'
  ADB2AO 'Procedure/Function Authorizations'
  ADB2AQ 'Sequence Authorizations'
  ADB2ARLO 'Dependent Objects for Role'
  ADB21 'System Catalog'
  ADB21D 'Databases'
  ADB21DS 'Database Structures'
  ADB21H 'Schemas'
  ADB21T 'Tables, Views, and Aliases'
  ADB21VV 'Views'
  

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:

Modules/Macros

•    ADBPCP   ADB2AH   ADB2AO   ADB2AQ   ADB2ARLO
  ADB21    ADB21D   ADB21DS  ADB21H   ADB21K   ADB21T   ADB21VV
  ADB21VV0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK78299

     UP12/04/28 P F204

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.