What is the DDSDCLM Verifier Transaction and what is its purpose?
Article ID: 17716
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
Environment
Release: DATABB00200-14-Datacom/AD
Component:
Component:
Attachments
Feedback
Yes
No
Powered by
