A fix is available
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 number
PI11419
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-02-10
Closed date
2014-07-16
Last modified date
2014-08-04
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 August 2014