The Analysis of an RC/Compare strategy is generating an invalid combination of load statements.
STATISTICS INDEX(ALL) UPDATE ALL
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
DSNU070I 280 08:43:47.08 DSNUGDFL - KEYWORD OR OPERAND 'STATISTICS' INVALID
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?
Release : 20.0
Component : CA RC/Compare for DB2 for z/OS
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.
RESUME NO REPLACE
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.