PH29448: CM BATCH: WSL VALIDATE LOOKS FOR WRONG DSN WHEN PREFIX_FOR_DATA_SETS IS SET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CM Batch: WSL validate looks for wrong dsn when
  PREFIX_FOR_DATA_SETS is set.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 for z/OS and Object Comparison Tool          *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                      Comparing a table with an XML column to *
  *                      a table with a CHAR column results      *
  *                      in the following error:                 *
  *                                                              *
  *                      ADB7350E Module : ADB2CMT detected an   *
  *                      ONCODE condition 8094 in                *
  *                      DETECT_COLMATCH at 26847 (actual line   *
  *                      might change depending on current       *
  *                      maintenance)                            *
  *                                                              *
  *                      Because this conversion is unsupported, *
  *                      the expected result is the following    *
  *                      error message:                          *
  *                                                              *
  *                      ADB7955E (E)Conversion from XML to CHAR *
  *                      not supported                           *
  *                                                              *
  *                                                              *
  *                      Issue 2:                                *
  *                      A job with the VALIDATE_WSL and         *
  *                      PREFIX_FOR_DATA_SETS options fails with *
  *                      RC12                                    *
  *                                                              *
  *                                                              *
  *                      Issue 3:                                *
  *                      A Change Management job fails with an   *
  *                      error (SQLCODE = -669) during an        *
  *                      explicit drop of an archive enabled     *
  *                      table when the archive table is in      *
  *                      a UTS tablespace.                       *
  ****************************************************************
  Issue 1:
  Compare fails with ONCODE 8094 when attempting to convert
  the data type of a column from XML to CHAR.
  
  Issue 2:
  When VALIDATE_WSL is set to 'Y' and PREFIX_FOR_DATA_SETS is
  set to a valid value, the CM Batch job fails with RC12,
  because the work statement list (WSL) validate function is
  looking for the incorrect data set name.
  
  Issue 3:
  This APAR provides fix to support the drop of an
  archive enabled table in a UTS tablespace using Change
  Management.  Change 'RUN' ends successfully.
  

Problem conclusion

• Issue 1:
  The problem has been resolved. Instead
  of an ONCODE 8094, this situation will result in the
  expected unsupported conversion error message
  
  Issue 2 & 3:
  The 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:

  UI71919

Modules/Macros

• ADB2CMF  ADB2CMR  ADB2CMT  ADBCCM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI71919

     UP20/10/07 P F010

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.