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

Document ID : KB000017716
Last Modified Date : 14/02/2018
Show Technical Document Details

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

File Attachments:
TEC616239.zip