PI27522: DB2 ADMINISTRATION TOOL FOR Z/OS WHEN USING VALIDATE WSL YES ISSUES ERROR MESSAGE MSGADB3023E ADB3023E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when using Validate
  WSL YES issues error message msgADB3023E ADB3023E
  Error processing Table <tablename> in ADD VERSIONING statement:
  The table is the wrong type of table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Change Management (CM) to       *
  *                 ANALYZE a change.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When specifying YES for option          *
  *                      'Validate WSL' on panel ADB2C11A        *
  *                      'Generate Analyze Job' to validate      *
  *                      Work Statement List (WSL) that          *
  *                      contains the following statements:      *
  *                                                              *
  *                      ALTER TABLE >temporal_table_owner<.     *
  *                      >temporal_table_name< DROP              *
  *                      VERSIONING;                             *
  *                      ...                                     *
  *                      ALTER TABLE >temporal_table_owner<      *
  *                      .>temporal_table_name< ADD              *
  *                      VERSIONING USE HISTORY TABLE            *
  *                      >history_table_owner<.                  *
  *                      >history_table_name<                    *
  *                                                              *
  *                      DB2 Admin issues error message          *
  *                      ADB3023E / msgadb3023e:                 *
  *                                                              *
  *                      ADB3023E Error processing Table         *
  *                      >tablename< in ADD VERSIONING           *
  *                      statement:                              *
  *                      The table is the wrong type of table.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Error message ADB3023E / msgadb3023e is erroneously issued
  when validating WSL.
  

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:

Modules/Macros

•    ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI22966

     UP14/11/18 P F411

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.