When using the CA Datacom VSAM Transparency product (called VT), it may be necessary to know the attributes or the DBID and Table used within a particular VIT (VSAM Interface Table).
DVVTPPR is a utility program created to report on the settings within a VIT.
There is a great deal of information produced in the report; some of the most common details queried are the VSAM file name, the VSAM record length, and the CA Datacom/DB DBID and Table.
DVVTPPR will issue a message to identify the release that created each VIT (all examples here refer to the sample VIT DVVUTPR):
DVR0004W DVVUTPR IS A RELEASE 2.1 VIT.
It will then give the details for each VIT processed:
VSAM INTERFACE TABLE INFORMATION FOR DVVUTPR
A single VIT can contain references to multiple VSAM files (there is one VIT per application program); here is a sample of the report showing one VSAM file entry for file CUSTMR, which has records that are 153 bytes long, and which used CA Datacom/DB DBID 10 and Table CUS (excess spaces elided):
VSAMNM : CUSTMR ... BASE : YES ... STRNO : ACB ... REUSE : NO
RKNAME : IDNO ... RKP : 0 ... RKLEN : 5
GETIT : NO ... WF2 : NO ...
DBID : 0010 ... MDB : NO ... MDTNM :
VRECDLN: 153 ... CISIZE : 2048 ... TRBOFE : NO
DBFILE : CUS
Details on running this report are found in the CA Datacom VSAM Transparency Version 14.0 User Guide (see below for the URL). Here is a sample job step:
//LISTVIT EXEC PGM=DVVTPPR
//STEPLIB DD DISP=SHR,DSN=<<- CA DATACOM/DB CABDLOAD
// DD DISP=SHR,DSN=<<- YOUR APPLICATION VIT LOADLIB
// DD DISP=SHR,DSN=<<- CA DATACOM VSAM TRANSPARENCY CABGLOAD
//PRINTER DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSABEND DD SYSOUT=*
//SYSIPT DD *
. . .
For more information about using the DVVTPPR utility, please refer to the CA Datacom VSAM Transparency Version 14.0 User Guide, in the section “Producing and Evaluating Reports.”
As always, please contact CA Technologies support for CA Datacom if you have further questions.