CA Tuesday Tip from JD Paquet, Principal Support Engineer, for Aug 19, 2014
Beside the DDSDCLM comparator transaction which is strongly recommended before upgrading CA Datacom to the next release,
there is a new verifier transaction coming with CA Datacom 14.0.
The process reads all occurrences of the following entity-types:
AREA, DATABASE, CONSTRAINT, ELEMENT, FILE, FIELD, KEY, PARTITION-COLUMN-VALUE, SYNONYM, TABLE and VIEW.
It will:
1- Attempt to load module DD140SD (case of release 14.0)
2- Read the DATA-DICT database structure in PROD and report on differences
See, CA Datacom Datadictionary Batch Reference Guide at:
https://support.ca.com/cadocs/7/CA%20Datacom%20DB%2014%200-ENU/Bookshelf_Files/PDF/DatacomDD14--Batch_Ref_ENU.pdf
The verifier transaction is: -SDC VERIFY
See sample output below (with an error being generated):
*-----------------------------------------------------------------
* CODE USER-NAME,PSWD,DATABASE-ID
* -USR HALJO03
*-----------------------------------------------------------------
Date: 08/11/2014 Time: 11.36.46 ******************************************
* CA Datacom Datadictionary
Security Level: 1 * Maintenance Report
* COPYRIGHT (C) 1990-2011 CA. ALL RIGHT
User: HALJO03 ******************************************
*-----------------------------------------------------------------
* -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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
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: HALJO03 ******************************************
***** END OF JOB *****