PI11419: MIG FUNCTION WITH HPU UNLOAD DSNU070I DSNUGDFL - KEYWORD OR OPERAND 'REPLACE' INVALID WITH 'RESUME(YES)'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS MIG function and the High
  Performance Unload generated LOAD syntax options result in the
  target system LOAD job failing:
  DSNU070I DSNUGDFL - KEYWORD OR OPERAND 'REPLACE' INVALID WITH
  'RESUME(YES)
  when the HPU option ULOPTLDT is (REPLACE,LOG(NO),ENFORCE(NO))
  

Local fix

• Do not specify ULOPTLDT = (REPLACE,LOG(NO),ENFORCE(NO))
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Migrate function to         *
  *                 migrate DB2 objects definitions and/or       *
  *                 the data.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Migrate function generates LOAD syntax  *
  *                      with the option RESUME YES which is     *
  *                      mutually exclusive with the REPLACE     *
  *                      option generated by DB2 High            *
  *                      Performance Unload (HPU).  The target   *
  *                      system LOAD job fails with the          *
  *                      following error message:                *
  *                                                              *
  *                      DSNU070I DSNUGDFL - KEYWORD             *
  *                      OR OPERAND 'REPLACE' INVALID            *
  *                      WITH 'RESUME(YES)'                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS Migrate function generates
  LOAD syntax with option RESUME YES which is mutually exclusive
  with the REPLACE option generated by DB2 High Performance
  (HPU). The target system LOAD job fails with the following
  error message:
  
  DSNU070I DSNUGDFL - KEYWORD OR OPERAND
  'REPLACE' INVALID WITH 'RESUME(YES)'
  

Problem conclusion

• An enhancement has been delivered.
  
  Previously, the Migrate function only supported the RESUME
  YES option in the target system LOAD job. The user was not
  able to choose between options REPLACE and RESUME YES.
  This APAR enhances this functionality. The user is now able
  to determine how the data is loaded into the target system
  by customizing the value of the LOAD Utility options RESUME
  and REPLACE using the UO command and setting the option
  'Use customized utility options' to YES on panel ADB28M
  'Migrate Parameters'.
  
  The following rules determines which option is used:
  
  1. Migrate will attempt to use the customized REPLACE
  and RESUME LOAD Utility options if specified by the user.
  
  2. DB2 does not allow using LOAD REPLACE on certain
  types of tables. When LOAD REPLACE is not allowed but
  is specified, the REPLACE option is converted to RESUME
  YES. Warning message ADB7001W will be issued in the
  LOAD statements conversion step with job return code 4.
  
  3. If not all the tables under a multi-table table space are
  selected for migration on the source system, the REPLACE
  option for LOAD utility, if specified, is converted to
  RESUME YES. Warning message ADB7001W will be
  issued in the LOAD statements conversion step with job
  return code 4.
  
  4. If all the tables under a multi-table table space are
  selected for migration on the source system, the REPLACE
  option for LOAD utility, if specified, is used. Any additional
  tables under the table space on the target system remain
  empty after migration. Warning message ADB7002W will be
  issued in the LOAD statements conversion step with job
  return code 4.
  
  5. If customized utility options for RESUME and REPLACE
  are not used, Migrate will use the RESUME/REPLACE
  option in the LOAD control statement generated by the
  DB2 UNLOAD Utility or HPU.
  
  New messages:
  
  ADB7001W  The REPLACE keyword in the LOAD control
  statement for table table_name is converted to RESUME YES.
  Reason reason_code.
  
  Explanation: DB2 restrictions on LOAD REPLACE require
  a change to the LOAD control statement. The reason code
  indicates the source of the error:
  
  01. The table to be loaded is a system-period temporal table
      with data versioning define.
  02. The table to be loaded is an archive-enabled table.
  03. The table is under a multi-table table space and not all
      the tables under the table space are migrated.
  
  System action: Processing continues.
  
  User action: Review the the LOAD control statement for the
  specified table, particularly the REPLACE keyword. Correct
  the statement, if necessary, and try again.
  
  ADB7002W The LOAD REPLACE option is applied to the
  multi-table table space ts_name. Any additional tables in
  the target table space are left empty after migration.
  
  The LOAD REPLACE option is applied to the multi-table
  table space  ts_name. Any additional tables in the target
  table space are left empty after migration.
  
  Explanation: The LOAD REPLACE option is applied to the
  table space as specified in the LOAD Utility options because
  all the tables under the table space are selected for migration
  on the source system. Any additional tables in the table space
  on the target system are left empty after migration because the
  LOAD REPLACE option is used.
  
  System action: Processing continues.
  
  User action: Confirm that it is appropriate to use the LOAD
  REPLACE option before submitting the target jobs.
  
  User's Guide updates:
  
  Updates to the DB2 Administration Tool for z/OS Version 11,
  Release 1 User's Guide and Reference, under Section 'Step 2.
  Generate batch jobs' of Chapter - 'Migrating DB2 objects,
  data, views, and catalog statistics' can be found via
  the following link:
  
  http://www-01.ibm.com/support/docview.wss?uid=swg27041314
  

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

•    ADBH8M   ADB2REG  ADB2UTC  ADB28MC  ADB28MCT
  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI19669

     UP14/07/23 P F407

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.