PI92262: UCD WORKFLOW UPDATE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• UCD WORKFLOW UPDATE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 who use the z/OS Management Facility         *
  *                 (z/OSMF) interface to run a workflow         *
  *                 and the users who import DDLs using          *
  *                 a mask in change management.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. This APAR provides verification      *
  *                      mask support in CM Batch workflow       *
  *                      for zOSMF. Also, the input parameters   *
  *                      of GEN workflow have been updated.      *
  *                                                              *
  *                      2. Running a WSL with an option         *
  *                      preserve tablespace access state ends   *
  *                      with ABENDED S722.                      *
  *                                                              *
  *                      3. An unformatted DDL is generated      *
  *                      after importing the DDL using mask in   *
  *                      Change Management.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1. This APAR adds support of verification mask feature in
  analyze step, "cmban", of CM Batch workflow. Also, GEN
  workflow is updated to support new parameter RUNSQLID
  and map a variable "newsch" to both NEWSCH and
  NEWSQLID.
  
  2. When option preserve tablespace access state is enabled,
  Batch Restart Program (ADBTEP2) tries to preserve a
  tablespace access state even if the tablespace is dropped.
  The invalid reference of the tablespace access state will
  result in ABEND S722 (infinite loop) as shown in the below
  example.
  
  23.04.24 JOB13378 $HASP165 OCB0M5O7 ENDED AT N1 -
  ABENDED S722 U0000 CN(INTERNAL)
  
  3. When a user imports a DDL with a mask in Change Management,
   the DDL (Create Auxiliary Table) appears in an unformatted
   block, making the DDL difficult to read.
  

Problem conclusion

• New function and other reported issues are 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:

  UI53490 UI53491

Modules/Macros

•    ADBH1DA  ADBH7DA  ADBP7DA  ADBP9000 ADBTEPR
  ADBZPAX  ADB2CRO  ADB2FMT  ADB21DA  ADB21DA0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI53490

     UP18/01/30 P F801

• RC10 PSY UI53491

     UP18/01/30 P F801

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.