search cancel

Invalid combination of keywords generated for a load statement

book

Article ID: 201230

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS RC/Migrator for DB2 for z/OS RC/Update for DB2 for z/OS

Issue/Introduction

The Analysis of an RC/Compare strategy is generating an invalid combination of load statements.

LOAD DATA                             
INDDN PTILOAD                      
RESUME YES                         
REPLACE                            
LOG NO                             
ENFORCE CONSTRAINTS                
DISCARDS 1                         
DISCARDDN TDISC                    
ERRDDN TERRD                       
MAPDDN TMAPD                       
WORKDDN (TSYUTD,TSOUTD)            
STATISTICS INDEX(ALL) UPDATE ALL   
SORTDEVT SYSDA                     
SORTNUM 0                   

Executing the generated DDL and utilities fails with the following error for the load utility

 DSNU070I    280 08:43:47.08 DSNUGDFL - KEYWORD OR OPERAND 'REPLACE' INVALID   
           WITH 'RESUME(YES)'                                                 
DSNU070I    280 08:43:47.08 DSNUGDFL - KEYWORD OR OPERAND 'STATISTICS' INVALID
             WITH 'RESUME(YES)'                                                

The REPLACE and STATISTICS keywords are not valid with RESUME YES.

Why is this invalid combination of statements being generated and how can it be resolved?


  

Environment

Release : 20.0

Component : CA RC/Compare for DB2 for z/OS

Resolution

This Analysis is using a customized model. In the load utility model, the REPLACE and STATISTICS keywords have been hard-coded with no conditional logic based on the value of the %RESUME symbolic variable. Given that these two keywords are not valid for RESUME YES then conditional logic is required to prevent this combination of keywords.

For example to only generate the REPLACE keyword when RESUME NO is generated then the following logic can be used.

#IF(%RESUME,=,NO)
RESUME NO REPLACE
#ELSE
RESUME YES
#ENDIF




Additional Information

You can find further information on this specific requirement in the manual under Model Services, frequently-asked-questions

For your information, when tablespace is not dropped and recreated, RESUME(YES) is generated for ALTER or COMPARE strategies. If the tablespace is dropped and recreated, then RESUME(NO) is generated for the first table and RESUME(YES) generated for other tables in the tablespace.