PH67645: COMPARE WITH WSL VALIDATE FAILED TO CREATE VIEW WITH MESSAGE ADB3024E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User was doing a compare of an imported change involving 2 views
  and the view with a subselect failed during WSL validation with
  error message ADB3024E:
  ADB3024E ADB2WVL An error occurred while processing the
  VFI0003T_NO_LIFE_BVP object in the statement type of CREATE .The
  number of columns specified for the view does not match the
  number of columns in the corresponding table.
  A manual check of the columns involved in the CREATE VIEW showed
  that the number of columns do match.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use WSL validation on view DDL           *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Compare to import views      *
  *                      with WSL validation on, an error        *
  *                      incorrectly reports that the columns in *
  *                      the view's subselect do not match,      *
  *                      even though they actually do.           *
  ****************************************************************
  The user was running a compare of an imported change involving
  2 views, and the view with a subselect failed during WSL
  validation with error message ADB3024E:
  
  ADB3024E ADB2WVL An error occurred while processing the
  VIEW1 object in the statement type of CREATE .The number of
  columns specified for the view does not match the number of
  columns in the corresponding table.
  
  A manual check of the columns involved in the CREATE VIEW
  showed that the number of columns do match.
  
  Also, minor spacing issues are present in message ADB3024E and
  need to be fixed.
  

Problem conclusion

• The problems have 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:

  UO05826

Modules/Macros

• ADB2WVL  ADB3000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO05826

     UP25/11/19 P F511

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.