PM63571: PANEL ADB2P2 FIELD 'QUERY TYPE FOR VIEWS' DOES NOT RETAIN CHOICE EVEN WHEN 'RESET TO DEF. AT STARTUP' NO S 12/05/02 PTF PEREMOVE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' panel ADB2P2 'Change DB2
  Admin Defaults' field 'Query type for views' introduced by APAR
  PM60628 does not retain its value even if the same panels field
  'Reset to Def. at Startup' is set to NO.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use panel ADB2P2 'Change DB2        *
  *                 Admin Defaults' to change the 'Query type    *
  *                 for views  . . . . . (E-ENHANCED or          *
  *                 S-SINGULAR)' value.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool 10.1 for    *
  *                      z/OS panel ADB2P2 does not retain the   *
  *                      value of 'Query type for views'         *
  *                      correctly when this field has been      *
  *                      changed.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program is missing the logic to retain the changed value for
  'Query type for views' on panel ADB2P2.
  

Problem conclusion

• Problem has been resolved.
  The DB2 Administration Tool for z/OS version 10.1 provides
  an Enhanced query and Singular query for view navigation
  on panel ADB21 'System Catalog'.  The default query type is
  'E-Enhanced' query, which provides more information for views
  than the 'S-Singular' query.  For performance reasons there are
  two interfaces to change the query type value for views.  One
  interface is from the pop-up panel ADB2VWCF 'VIEW TYPE
  CONFIGURATION' after entering option '1 - DB2 system catalog'
  on panel ADB2 'DB2 Administration Menu', then entering option
  'V - Views' on panel ADB21 'System Catalog'.  The other
  interface is if the current setting of 'Reset to Def. at
  Startup' is YES on panel ADB2P2 before you exit DB2 Admin,
  the query type for views will be changed to 'Enhanced'
  upon re-entering the DB2 Admin Tool.  The ADB2VWCF panel
  will pop up until you choose a query type for views on panel
  ADB2VWCF.  If the current setting of 'Reset to Def. at
  Startup' is NO on panel ADB2P2 before you exit DB2 Admin,
  which indicates you do not want to change the default setting
  for DB2 Admin, ADB2VWCF panel will not pop up upon re-entering
  DB2 Admin. For this situation, if you want to change the
  value of view's query type, you can change the value of
  'Query type for views ' on panel ADB2P2.
  

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:

  UK79672

Modules/Macros

•    ADBHP2   ADBR     ADB2VWCF ADB21
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK79672

     UP12/06/21 P F206

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.