DDSDCLM Verifier Transaction and its purpose
Article ID: 17716
Updated On:
Products
Datacom
Datacom/AD
Datacom/DB
Issue/Introduction
The Datacom DDSDCLM utility has a Verifier Transaction SDC VERIFY. What is it's purpose?
Environment
z/OS
Resolution
Execution of the DDSDCLM utility Comparator Transaction (-SDC vvv,stat) is strongly recommended before upgrading Datacom to the next release. Starting with 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 Datacom Datadictionary and verifies that each occurrence passes the edit requirements for the current release of the 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
See documentation section DDSDCLM - Comparing DATA-DICT Prior to Upgrading
Feedback
Yes
No
Powered by
