PI98235: DB2 ADMIN TOOL - WHEN 'QUERY TYPE FOR VIEWS' SET TO ENHANCED, SQLCODE -206 IF FILTER OPTION SPECIFIES A SYSVIEWS COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When DB2 Admin parm 'Query type for views' set to Enhanced and
  Column filter field on panel ADB21 'System Catalog' contains a
  column name from SYSVIEWS, option 'V' returns error SQLCODE -206
  / SQLCODEN206
    DSNT408I SQLCODE = -206, ERROR:  T.<viewcolumn> IS NOT VALID
             IN THE  CONTEXT WHERE IT IS USED
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: User of the DB2 Administration Tool          *
  *                 for z/OS who use the enhanced view           *
  *                 query in panel ADB21.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When DB2 Admin parm 'Query type         *
  *                      for views' is set to Enhanced and       *
  *                      Column filter field on panel ADB21      *
  *                      'System Catalog' contains a column      *
  *                      name from SYSVIEWS, option 'V'          *
  *                      returns error SQLCODE -206 /            *
  *                      SQLCODEN206.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Panel ADB21 Column filter field does not use SYSVIEWS
  columns when doing Enhanced view query. The following
  changes have been made when using Enhanced view query:
  
  - The COLUMN filter field will use SYSVIEWS table columns
  to filter if no correlation name is used.
  
  - The COLUMN filter field will allow correlation names to allow
  filtering of both SYSTABLES and SYSVIEWS table columns.
  Use T for correlation name for SYSTABLES columns (e.g.
  T.RELCREATED) and use V for correlation name for SYSVIEWS
  columns (e.g. V.CHECK ).
  
  - Help information is added to describe the use of COLUMN
  filter field in panels ADBH1 and ADBHP2.
  
  - Text is added to pop-up panel ADBVWCF to inform user that
  enhanced view query will allow SYSVIEWS column filtering.
  
  - Command VC will show SYSVIEWS table columns.
  
  - Command VSEL will use SYSVIEWS table columns for select
  prototype.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI58070 UI58071

Modules/Macros

•    ADBHP2   ADBH1    ADB2VWCF ADB21
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58070

     UP18/09/07 P F809

• RC10 PSY UI58071

     UP18/09/07 P F809

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.