TAPEDB Definitions

DBRECORD Field	Description
ACCT	User Field. Defaults to Job Accounting and Programmer. (Same field as USER_DATA.)
ACTIVE_FILES	Number of active files on tape.
ACTUAL_VOL_IND	Indicates volser in tape label not the same as in TAPEDB. See exported virtual volumes.
ACTUAL_VOLSER	Volser in tape label when TAPEDB differs. See exported virtual volumes.
AGENT	Indicates if this tape is dedicated for use by distributed systems; that is, UNIX or Windows. 'Y' = Tape is dedicated to distributed system use 'N' = Normal tape not used by distributed systems
BASEVOL	First volume of multivolume chain.
BLKCNT	Number of blocks in file for this volume.
BLKSIZE	Maximum size of blocks for data set.
BTHDATE	Date tape bought or assigned to CA TLMS. (Same field as PURDATE.)
CDATE	Date the data set was created.
CDDNAME	DDNAME of file when data set created.
CDS_FILE_SEQ	File sequence number of control data set.
CJOB	Name of job which created data set.
CLNCNT	Number of times tape was cleaned.
CLOSE_IND	Indicates if the data set is closed. 'F' =Close end-of-file 'E' =Close end-of-volume
COMPRESSION	Percent of achieved for this data set.
COPYCAT_IND	Indicates if tape created by CA TLMS Copycat. 'C' = Tape created by CA TLMS Copycat
COUNT	Times used since tape was certified.
CPUID	CPU ID when data set created.
CREATE_PROGRAM	Program that created the data set.
CSTEP	Job step that created the data set.
CTIME	Time the data set was created.
CUNIT	UCB ID when data set created.
DATE_CERTIFY	Date when tape last certified.
DATE_SCRATCHED	Date when tape scratched.
DATECLN	Date when tape last cleaned.
DEN	Recording density of tape.
DSN	Name of data set.
DSN_KEEP_DATE	Last date the tape is to be prevented from being scratched, if the tape is retained by keep date.
EDMID	ID of external data manager which controls this tape. (Same as OWNER.)
EXPDT	JCL expiration date value.
FILE_PERCENTAGE	Percent of the tape used for this data set.
FILE_IS_CAT	Indicates if file cataloged is not used by CA TLMS.
FILECNT	Highest file sequence on this tape.
FILESEQ	File sequence number of data set.
FORMAT_INDICATOR	Indicates physical format of tape DB record. For use by CA I/O modules, client EARL programs should use field names only. Physical size and location of fields may vary with versions.
LABEL_TYPE	Tape label type. (SL, NL, AL, ETC.)
LAST_USE_PROGRAM	Program which last used data set.
LDATE	Date data set was last used.
LJOB	Job name which last used data set. Not used by CA TLMS.
LRECL	Record size for data set.
LTIME	Time data set last used. Not used by CA TLMS.
LUNIT	UCB which last used data set.
MOVEDATE	Date when tape last moved to new location.
NON_RES_IND	Indicates tape not under CA TLMS control. DB record created from transaction.
OUTCODE	Location of tape.
OUTDATE	Date tape was made out-of-service.
OUTLOC	Location of tape.
OWNER	Name of external data manager. Same field as EDMID.
PERM_READ_CLEAN	Permanent read errors since cleaned. (Not used by CA TLMS.)
PERM_READ_INIT	Permanent read errors since initialized. (Not used by CA TLMS.)
PERM_WRITE_CLEAN	Permanent write errors since certified. (Not used by CA TLMS.)
PERM_WRITE_INIT	Permanent write errors since certified.
PRODUCT_CODE	'TL' for CA TLMS 'L0' for CA 1.
PRODUCT_RELEASE	Version of product which created this record.
PURDATE	Date tape was bought or assigned to CA TLMS. (Same field as BRTHDATE.)
RECFM	Record format for data set.
RECORD_TYPE	Record type created from. 'B' = VMF '1' = Close output transaction '2' = Close input transaction '6' = Open transaction '3' = Update transaction
ROBOT_NUMBER	Automated tape library (ATL) number X'01' thru X'FF'.
ROBOT_TYPE	Automated tape library (ATL) type. 'IBM', 'STORTEK', 'MEMOREX', 'BOSCH', 'GRAU', 'COMPAREX', 'HDS', 'VIBM', 'VSTORTEK', 'VSUTMYN', 'VSTERLNG'
RTN_DATA	Retention Data
SCRATCH_IND	Indicates if tape is scratched. 'Y' =Tape is scratch 'N' =Tape is not scratch
SCRATCH_SOURCE	ID of source of scratch. '1' =Scratched by TRS '2' =Scratched by JCL DISP= '3' =Scratched Manually '4' =Scratched by an EDM
SERVICE_IND	Indicates if tape is in service. (Can be used online) 'IN' =In-service 'OUT' =Out-of-service Or user-supplied code for reason tape out-of-service.
SLOT	Cabinet/slot or box where tape is located.
SMS_CLASS	IBM SMS management class name for tape.
SPARE_FLAG	Spare Indicator.
STACKING_FULL	Indicates if this stacking volume has been marked full. Y - Tape is full - no additional files will be added by realtime stacking. N - Tape is not full - additional files can be stacked.
STACKING_INUSE	Indicates if stacking is currently in use on this or another system sharing the VMF. Y - Tape is in use. N - Tape is not currently in use.
STACKING_VOLUME	Indicates if this tape contains one or more files created by realtime stacking. Y - tape includes stacked file(s). N - tape is not a stack volume or if it is a scratch pool defined with SCRATCH=YES, it has not been used yet
TAPE_LENGTH	User supplied length of tape.
TAPE_TYPE	User supplied type of tape.
TEMP_READ_CLEAN	Number of temporary read errors since the tape was cleaned.
TEMP_READ_INIT	Number of temporary read errors since the tape was certified.
TEMP_WRITE_CLEAN	Number of temporary write errors since the tape was cleaned.
TEMP_WRITE_INIT	Number of temporary write errors since the tape was certified.
RES_CERTIFY	Number of times tape was certified.
TRTCH	Tape recording technique.
USECLN	Number of times used since cleaned.
USECNT	Number of times used since certified.
USER_DATA	User field. Defaults to job accounting and programmer. (Same field as ACCT.)
USES_CERTIFY	Number of times used since certified.
VENDOR	Name of tape manufacturer. Brand.
VLT_SPEC_REQ	Not used by CA TLMS.
VOL_DEGAUS	Not used by CA TLMS.
VOL_PERCENTAGE	Total percent of the tape that has been used.
VOLSEQ	Sequence number on tape in a multiple volume set.
VOLSER	Volume serial number in TAPEDB.
VOLUME_COUNT	Number of volumes in multi-volume set.
VOLUME_EXPDT	Maximum EXPDT of any data set on tape.
VOLUME_KEEP_DATE	Maximum keep-date of any data set on tape.
WORM_ID	World-wide-unique cartridge ID.
WORM_COUNT	Number of times cartridge was mounted and a write operation done.