RMA178E in DDLCOMP step of Database Management for Db2 Post Install Compare ssid0000 job
search cancel

RMA178E in DDLCOMP step of Database Management for Db2 Post Install Compare ssid0000 job

book

Article ID: 32859

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The Database Management for Db2 for z/OS Post Install Tailoring ssid0000 Compare job is failing with message:

RMA178E DATASET NAME xxxxxxx.xxxx.DATA.E
IS USED BY TWO DIFFERENT UTILITIES IN THIS ANALYSIS OUTPUT

Resolution

If message RMA178E occurs in the DDLCOMP step there is something wrong with the Dataset Name Mask being used.  
This mask is used to generate the dataset names used for utilities in the script such as UNLOAD, LOAD, and COPY.

When generating the COMPARE (ssid0000) job within Post Install a screen is presented with parameters one of them is:

     Dataset Name Mask.........> %USERID..%DSNQUAL2..%DSNQUAL3..%TOSSID

This should not be modified, these are automatic symbolics that will get resolved when executed.  In the generated JCL the mask shows in the DDLCOMP PARMFILE as:

   MODDSNMK %USERID..%DSNQUAL2..%DSNQUAL3..%TOSSID

If this is accidentally changed it could cause the data set naming to be incorrect and create duplicates if all the qualifiers do not exist.

The RC/Migrator Guide/Wiki documents how the automatic symbolics above are populated:

  • USERID - Identifies the TSO ID that submitted the analysis.

 

  • TOSSID - Identifies the To subsystem name.

 

  • %DSNQUAL2 – Used in data set name qualification and set to a value as follows:

For table- and index-related utilities, this value is the database name (the same as  %DBNAME).

For all other utilities, this value is the object creator (the same as  %CREATOR).

 

  •         %DSNQUAL3 -  Used in data set name qualification and set to a value as follows:

For table-related utilities, this value is the 3-byte literal TID followed by the object identifier for the table in 5-byte character format. 

For index-related utilities, this value is the index space name (same as %TSNAME).