PI16384: CM IMPORT ISSUE / CM EXPORT ISSUE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' CM export changes is not
  using --#SET TERMINATOR statements for some types of statements
  and CM import changes is not issuing any error messages when
  processing the effected statements resulting in some statements
  not being imported.
  Change Management EXPORT then IMPORT enqueue issue: IEF861I
  FOLLOWING RESERVED DATA SET NAMES UNAVAILABLE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Change Management (CM)      *
  *                 Import/Export function.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following issues are fixed:         *
  *                                                              *
  *                      - The CM Export Change function is      *
  *                      not generating '--#SET TERMINATOR'      *
  *                      statements for CREATE PROCEDURE         *
  *                      statements.                             *
  *                                                              *
  *                      - The CM Import Change function         *
  *                      which uses the previously exported      *
  *                      Changes (CHG) file as the source        *
  *                      does not register CREATE PROCEDURE      *
  *                      statements, and does not provide        *
  *                      a message to inform the user of         *
  *                      the missing statements.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following issues are fixed:
  
  - The CM Export Change function is not generating '--#SET
  TERMINATOR' statements for CREATE PROCEDURE statements.
  
  - The CM Import Change function which uses the previously
  exported Changes (CHG) file as the source does not register
  CREATE PROCEDURE statements, and does not provide a message
  to inform the user of the missing statements.
  

Problem conclusion

• Problems have been resolved:
  
  - The CM Export Change function has been modified to wrap
  statements such as CREATE PROCEDURE with '--#SET TERMINATOR'
  statements.
  
  - The CM Import Change function has been modified to issue
  a new error message ADB9600E / msgadb9600e when encountering
  CREATE PROCEDURE statements without '-#SET TERMINATOR'
  statements:
  
  ADB9600E        Change Management can not import statements
                  that are in the delta change file. Contact IBM
                  Software Support and provide the delta change
  file.
  Explanation:    The Import program can not process special
                  statements generated by DB2 Admin and Object
                  Comparison tools.
  System action:  Processing stops.
  User response:  This is an internal error. Contact IBM Software
                  Support and provide the delta change file.
  

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:

  UI20545

Modules/Macros

•    ADBCEST  ADBCEXP  ADBCRCH  ADB2CID  ADB2ISQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI20545

     UP14/08/20 P F408

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.