PM88473: WSL VALIDATION FAILED WHEN ALTER COLUMN OF TABLE WHICH HAS A MQT REFERENCED OR IS A TEMPORAL TABLE WITH VERSIONING ENABLED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS.
  WSL validation failed when alter column of table which has a MQT
  referenced or is a temporal table with VERSIONING enabled
  Error messages:
  1) ALT the LOB column while the table has a MQT referenced to.
  ADB3001E Error processing Table SCOCPG07.TBOCPG07_BLOB in ALTER
  statement: Object does not exist.
  2) ALT the LOB column while the table is temporal table with
  VERSIONING enabled.
  ADB3023E Error processing Table SYSADM.TBOCPG0G in ADD
  VERSIONING statement: The table is the wrong type of table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 DB2 Object Comparison Tool for z/OS who      *
  *                 make changes to a table with a Materialized  *
  *                 Query Table (MQT) or history table and       *
  *                 perform Work Statement list (WSL)            *
  *                 validation through the Change Management     *
  *                 (CM), Object Compare or WSL paths.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS WSL    *
  *                      Validate function and DB2 Object        *
  *                      Comparison Tool for z/OS 'Run           *
  *                      Validate' function could fail           *
  *                      with an error message when making       *
  *                      changes to a table which has a MQT      *
  *                      referenced or a temporal table with     *
  *                      VERSIONING enabled.                     *
  *                                                              *
  *                      (1) Alter LOB column of a table         *
  *                      which has a MQT reference.              *
  *                      Validate may fail with an error         *
  *                      message while processing the            *
  *                      ALTER TABLE >base_table<                *
  *                      ALTER COLUMN >lob_col<                  *
  *                      statement:                              *
  *                                                              *
  *                      ADB3001E Error processing               *
  *                      Table >tbschema<.>tbname< in            *
  *                      ALTER statement: Object does            *
  *                      not exist.                              *
  *                                                              *
  *                      (2) Alter column of a table which is    *
  *                      a temporal table with VERSIONING        *
  *                      enabled. Validate may fail with an      *
  *                      error message while processing the      *
  *                      ALTER TABLE >temporal_tb< ADD           *
  *                      VERSIONING USE HISTORY TABLE            *
  *                      >history_table< statement:              *
  *                                                              *
  *                      ADB3023E Error processing Table         *
  *                      >temporal_tb< in ADD VERSIONING         *
  *                      statement: The table is the wrong       *
  *                      type of table.                          *
  *                                                              *
  *                      (3) Make changes to a table which has   *
  *                      a temporal table with VERSIONING        *
  *                      enabled. The changes lead to            *
  *                      DROP/CREATE of the table spaces of      *
  *                      the temporal table and history table.   *
  *                      Validate may fail with an error         *
  *                      message while processing the CREATE     *
  *                      TABLE >history_table< statement:        *
  *                                                              *
  *                      ADB3000E Error processing Table         *
  *                      >history_table< in CREATE statement:    *
  *                      Object already exists                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Administration Tool for z/OS WSL Validate function and DB2
  Object Comparison Tool for z/OS 'Run Validate' function could
  fail with an error when making changes to a table which has a
  MQT referenced or a temporal table with VERSIONING enabled.
  

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:

  UK95558 UK95571

Modules/Macros

• ADB2DEP  ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK95558

     UP13/07/18 P F307

• RA20 PSY UK95571

     UP13/07/18 P F307

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.