Utility dataset name is truncated as it is too long resulting in error messages RMA229W and RMA178E.

book

Article ID: 38111

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction

Issue:

RC/Compare Analysis fails with error RMA178E indicating that there is a problem with the data set names generated by RC/Migrator Model Services. The error message is preceded by warning messages RMA229W, reporting that generated data set names have been truncated.

RMA178E DATASET NAME dataset_name IS USED BY TWO DIFFERENT UTILITIES IN THIS ANALYSIS OUTPUT.

RMA229W MODEL SERVICES GENERATED DSN HAS BEEN TRUNCATED TO 44 BYTES: dataset-name

It is the truncation of the data set names that is resulting in the RMA178E error.

 

Cause:

The truncation of the data set names generated by Model Services for these utilities, is most likely caused by the customizing of the DSN Symbolic Variable in Model Services.

For example, if the DSN Symbolic Variable has been customized to include the %OBJECT conditional symbol then that could cause data set names to exceed the allowable maximum of 44 characters, particularly for table related utilities.

 

Resolution:

Review the DSN Symbolic Variable definition in the relevant Model Services utility model. 

Using the %OBJECT variable will result in possible truncation particularly for long table names, so we would not recommend the use of %OBJECT variable in table related utilities such as FUNLD and FLOAD.

The default definition for the DSN symbol is:

DSN %USERID..%DSNQUAL2..%DSNQUAL3

For table related utilities the DSNQUAL2 and DSNQUAL3 variables equate to the following:

%DSNQUAL2 = database name

%DSNQUAL3 = table identifier TIDxxxxx

The default definition should provide a working solution without any truncation.

 

Additional Information:

Further information can be found in the Utility Model Services Chapter of the RC/Migrator wiki.

https://docops.ca.com/ca-rc-migrator-for-db2-for-z-os-and-ca-rc-compare/19/en/getting-started/profile-and-expert-profile-options/utility-model-services/symbolic-parameters

Environment

Release:
Component: RCM