DSNU2935I COPYDDN TEMPLATE invalid missing &SN. or &TS. for pending ALTER during Database Management Post Install ssid0001 Create REORG

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

Executing Database Management for Db2 for z/OS Post Install ssid0001 Create job and encountering 
the following when Dataset Name Mask %USERID..%DSNQUAL2..%DSNQUAL3..%DTQUAL is specified
in the ssid0000 Compare job generation:
        

DSNU2935I   DSNURORG - COPYDDN TEMPLATE IS INVALID BECAUSE OF  
            MISSING &SN. OR &TS. FOR PENDING ALTER


The above occurs during the REORG execution in the ssid0001 Create job when moving tables
to individual tablespaces as part of the UTS conversion process.

Resolution

For the following condition:

DSNU2935I   DSNURORG - COPYDDN TEMPLATE IS INVALID BECAUSE OF  
            MISSING &SN. OR &TS. FOR PENDING ALTER    

Database Management for Db2 for z/OS r20 PTF LU09809 modified the hlq.CDBASAMP member RMMODTXT
used during the ssid0000 Compare COMPRT and DDLCOMP steps:
++SAMP(RMMODTXT) DISTLIB(ADBASAMP) SYSLIB(CDBASAMP) .
 

The behavior experienced was due to the incorrect version of hlq.CDBASAMP member RMMODTXT being utilized.