What is the DDSDCLM Verifier Transaction and what is its purpose?

book

Article ID: 17716

calendar_today

Updated On:

Products

Datacom DATACOM - AD Ideal CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction

Question:

CA Datacom DDSDCLM utility has a Verifier Transaction. What is the purpose?

Answer:

Execution of the DDSDCLM utility Comparator Transaction (-SDC vvv,stat) is strongly recommended before upgrading CA Datacom to the next release. Starting with CA Datacom version 14.0, there is a new Verifier Transaction (-SDC VERIFY).

The Verifier Transaction process reads all occurrences of the following entity-types in the CA Datacom Datadictionary and verifies that each occurrence passes the edit requirements for the current release of the CA Datacom Datadictionary:

AREA, DATABASE, CONSTRAINT, ELEMENT, FILE, FIELD, KEY, PARTITION-COLUMN-VALUE, SYNONYM, TABLE and VIEW.

The verifier transaction is:

-SDC VERIFY

Here is partial sample output execution DDSDCLM -SDC VERIFY. Note the DDPFI20001 error being generated in this example:

              *-----------------------------------------------------------------
              *  CODE USER-NAME,PSWD,DATABASE-ID                                
              *  -USR user                                                  
              *-----------------------------------------------------------------
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *                  Maintenance Report     
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
              *-----------------------------------------------------------------
              *  -SDC VERIFY                                                    
              *-----------------------------------------------------------------
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR AREA                         
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR DATABASE                     
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR CONSTRAINT                   
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR ELEMENT                      
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR FILE                         
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR FIELD                        
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR KEY                          
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR PARTITION-COLUMN-VALUE       
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR SYNONYM                      
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR TABLE                        
                                                                                
  **** ERROR ****  RETURN CODE = DDPFI20001  BAD DUP-MSTR-KEY FOR CHG-MSTR-KEY 
                                                                              ..
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *                    Detail Report        
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
ENTITY-TYPE: TABLE                              DESC: PAYROLL MASTER FILE       
NAME: PAYROLL                                                           (0001)PR
AUTHOR:                                   CONTROLLER:                           
DATE-ADDED: 04/14/09        DATE-LAST-CHANGED: 08/11/14        TIME-OF-CHANGE: 0
                                                                                
ATTRIBUTE.......................  ..................................(ATTRIBUTE V
                                                                                
ENABLE                            Y                                             
LENGTH                            00039                                         
FILENAME                          PAYROLL                                       
AUTHID                            SYSUSR                                        
SQLNAME                           PAYROLL                                       
SQL-ACCESS                        Y                                             
CONSTRAINT                        N                                             
FIPS                              N                                             
SQL-SECURITY                      N                                             
ENCRYPTION-TYPE                                                                 
ENCRYPTION-METHOD                                                               
DBMS-USED                         DATACOM                                       
SQL-INTENT                        Y                                             
SQL-CATAL-DATE                    08/07/13                                      
SQL-CATAL-TIME                    174852                                        
DATACOM-NAME                      PAY                                           
DATACOM-ID                        001   
DUPE-MASTER-KEY                   N                                             
CHNG-MASTER-KEY                   Y                                             
LOGGING                           Y                                             
RECOVERY                          Y                                             
COMPRESSION                       N                                             
PIPELINE-OPTION                   Y                                             
COMPRESS-EXIT                                                                   
ENCRYPTION-KEY                                                                  
CLUSTER-KEY-LEN                   000                                           
CLUSTER-KEY-ID                    000                                           
MAX-RECORD-SIZE                   00040                                         
MONITOR-NM                                                                      
DD-ENTITY-TABLE                   N                                             
ENTY-NAME-LEN                     00                                            
ENTY-HIST-VERS                    000                                           
BASE-NAME                         HUMAN-RESOURCE                                
BASE-VER                          00001                                         
DATABASE-ID                       00001                                         
DD-MASTER-KEY                     NUMBER                                        
DB-MASTER-KEY                     EMPNO                                         
DD-NATIVE-KEY                     NUMBER                                        
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *                    Detail Report        
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
ENTITY-TYPE: TABLE                              DESC: PAYROLL MASTER FILE       
NAME: PAYROLL                                                           (0001)PR
AUTHOR:                                   CONTROLLER:                           
DATE-ADDED: 04/14/09        DATE-LAST-CHANGED: 08/11/14        TIME-OF-CHANGE: 0
                                                                                
ATTRIBUTE.......................  ..................................(ATTRIBUTE V
                                                                                
DB-NATIVE-KEY                     EMPNO                                         
DL1T-CONSTRAINT                   N                                             
DDD-SYNCH                         Y                                             
CNS-UNIQUE                        N                                             
CNS-DOMAIN                        N        
CNS-REFERENCED                    N                                             
CNS-REFERS                        N                                             
CNS-SAME-BASE                     Y                                             
TABLEKIND                                                                       
FALLBACK                                                                        
PARTITION                         N                                             
ANY-PARTITION-AUTHID                                                            
ANY-PARTITION-SQLNAME                                                           
ANY-PARTITION-DATACOM-NAME                                                      
MOVE-ROW-TO-NEW-PARTITION         N                                             
SEGMENT-NM                                                                      
INIT-PARM                                                                       
COMPRESS-RTN                                                                    
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG005I       BEGIN OCCURRENCE VERIFICATION FOR VIEW                         
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
DDSDCG000I VERIFICATION EXECUTION COMPLETE                                      
Date: 08/11/2014  Time: 11.36.46      ******************************************
                                      *               CA Datacom Datadictionary 
Security Level: 1                     *               Comparator Result Report  
                                      *  COPYRIGHT (C) 1990-2011 CA.   ALL RIGHT
User: user                            ******************************************
                                                                                
               *****  END OF JOB  *****

Additional Information:

Refer to the CA Datacom Datadictionary Batch Reference Guide chapter on DDSDCLM - Comparing DATA-DICT Prior to Upgrading at

https://support.ca.com/cadocs/7/CA%20Datacom%20DB%2014%200-ENU/Bookshelf_Files/PDF/DatacomDD14--Batch_Ref_ENU.pdf

Environment

Release: DATABB00200-14-Datacom/AD
Component:

Attachments

1558534739840TEC616239.zip get_app