FDREPORT Tape Management Reporting


Data is not all DASD related. Much exists on tape, and those tapes can reside on racks within an installation’s data center, in powerful Virtual Tape System (VTS), or in external vaults for use as backups or for disaster recovery. Tape Management systems have evolved to manage the physical tapes, but only have basic reporting systems. Complex reports must be generated by the installation’s staff writing programs or command procedures.

FDREPORT is able to extract information from Broadcom CA 1 and IBM’s DFSMSrmm products and process it just as it does for DASD related information. This information can be formatted, filtered, sorted, and summarized using FDREPORT’s existing facilities.

Important

An extract file must be created prior to creating FDREPORT reports. The extract can be done in the same FDREPORT execution using the EXTRACT command (see FDREPORT-PUNCH-Statement) or from a prior execution of FDREPORT that used the EXTRACT command to create an extraction file.

IBM DFSMSrmm Data Set Record Cross-Reference

For DATATYPE=RMMDSN, the data set record is described by the IBM EDGRXEXT macro & the mapping is:

EDGRXEXT
Field Name

FDREPORT
Field Name(s)

Field Description

XDDSNAME

TDDSNAME

Data set name

XDCRDATE

TDCRDATE

Create date of data set record

XDCRTIME

TDCRTIME

Create time of data set

XDCRSID

TDCRSYS

Create system id of data set record

XDLCDATE

TDLCDATE

Last change date of data set record

XDLCTIME

TDLCTIME

Last change time of data set record

XDLCUID

TDLCUSER

Last change user id of data set record

XDLCSID

TDLCSYS

Last change system id of data set record

XDUNITAD

TDCRUNIT

Creating drive address

XDRECFM

TDRECFM

Record format

XDVOLSEQ

TDVOLSEQ

Volume sequence number

XDLRECL

TDLRECL

Logical record length

XDBLKSZ

TDBLKSIZ

Physical block size

XDOWNDSN

TDOWNER

Data set owner

XDSECLEV

TDSECCLS

Security class - short

XDSECLNG

TDSCLASS

Security class - long

XDCOMP

TDTAPFLG=CPK

Compaction used - Y/N

XDLRDDAT

TDLRDATE

Date data set last read

XDLWTDAT

TDLWDATE

Date data set last written

XDMCNAME

TDSMSMGC

SMS management class

XDVRSVAL

TDVRSMVA

VRS management value

XDSGNAME

TDSMSSTG

SMS storage group name

XDSCNAME

TDSMSSTC

SMS storage class name

XDDCNAME

TDSMSDTC

SMS data class name

XDCRTJBN

TDCRJOB

Creating JOB name

XDVRSTYP

TDVRSTYP

Matching VRS type

XDVRSNAM


Matching VRS name

XDVRSJBN

TDMVJOB

Matching VRS job name mask

XDRETDAT

TDRTDATE

Retention date

XDSTEPNM

TDCRSTEP

Creating step name

XDDDNAME

TDCRDDNM

Creating DD name

XDDSSIZE

TDAPRSIZ

Approx. size of file kbytes

XDABEND

TDTAPFLG=ABN

Data set closed by abend - Y/N

XDCAT

TDCATFLG

Tape data set catalog flags

XDVRSR

TDTAPFLG=VRS

Retained by VRS - Y/N

XDDELETED

TDTAPFLG=DSP

DELETED by disposition - Y/N

XDRSVMW1


Reserved

XDVRSSCH

TDPVRSUB

Primary VRS subchain name

XDVRSXDS

TDPVDATE

Primary VRS subchain start date

XD2VNME

TDSVRSNM

Secondary VRS name mask

XD2VJBN

TDSVRSJN

Secondary VRS job name mask

XD2VSCH

TDSVRSUB

Secondary VRS subchain name

XD2VXDS

TDSVDATE

Secondary VRS subchain start date

XDPERCENT

TD%FULL

Percentage of volume used by data set

XDCPGM

TDCRPGM

Creating program name

XDLPGM

TDLUPGM

Last used program name

XDLJOB

TDLUJOB

Last use JOB name

XDLSTEP

TDLUSTEP

Last use step name

XDLDDNM

TDLUDDNM

Last use DD name

XDLDEVN

TDLUUNIT

Last use device number

XDDSNSEQ

TDDSNSEQ

Data set sequence number new

XDLABNO

TDLABLNO

Label number LABEL=(xx,ll) new

XDEXPDT


Data set expiration date

XDEXPDTO

TDOEDATE

Original data set expiration date

XDDEFRET

TDTAPFLG=DRU

Default RETPD used

XDBESKEY

TDBESKEY

BES key index

XDBLKCNT

TDBLKCNT

Block count

XDTOTAL_BLKCNT

TDTBKCNT

Total block count across all volumes

XDESB

TDESDATE

Expiration data set by - of the data set

XDUCDATE

TDUCDATE

Data set last “user” change date

XDUCTIME

TDUCTIME

Data set last “user” change time

XDVEX

TDTAPFLG=VEX

VRSEL exclude - Y/N

XDComp_Rat

TDCOMPRT

Compression ratio for the file

XDPhys_size

TDPHYSIZ

Actual amount of data on tape after compression

XVFACTOR

TDSIFACT

Size factor

XVRMSB

TDRTVALU

Retention value

XVSTATUS

TDSTATUS

Volume status

XVVOLSER

TDVOLSER

Tape volume serial number

IBM DFSMSrmm volume record Cross-Reference

For DATATYPE=RMMVOL, the volume record is described by the IBM EDGRXEXT macro & the mapping is:

EDGRXEXT
Field Name

FDREPORT
Field Name(s)

Field Description

XVVOLSER

TVVOLSER

Volume serial number

XVPVOL

TVPRVVOL

Previous volume in sequence

XVNVOL

TVNXTVOL

Next volume in sequence

XVSTVOL

TVTAPFL2=STAC

Stacked volume volser (SV/LV)

XVMDMVID

TVMVLSID

Multi-data set multi-volume set ID

XVCRDATE

TVCRDATE

Create date of volume record

XVCRTIME

TVCRTIME

Create time of volume record

XVCRSID

TVCRSYS

Create system ID of volume record

XVLCDATE

TVLVDATE

Last change date of volume record

XVLCTIME

TVLVTIME

Last change time of volume record

XVLCUID

TVLCUSER

Last change user id of volume record

XVLCSID


Last change system id of volume record

XVEXPDTO

TVOEDATE

Expiration data - original

XVEXPDT

TVEXDATE

Expiration date - current

XVDEN

TVMEDDEN

Recording density

XVCOMP


Compaction used - Y/N

XVTUSE

TVUSEBYT

Tape usage in kbytes

XVSTORID

TVLOCAT

Current location name

XVDEST

TVDESTNM

Destination name

XVSTBIN

TVBIN

Bin number

XVOBIN

TVOBIN

Previous bin number

XVSTDATE

TVMVDATE

Movement tracking date

XVRETDAT

TVRTVALU

Retention date calculated by VRS

XVLONLOC

TVLOAN

Loan location

XVOLNLOC

TVPVLOAN

Previous loan location

XVLRDDAT

TVLRDATE

Date volume last read

XVLWTDAT

TVLWDATE

Date volume last written

XVASDATE

TVASDATE

Assigned date

XVASTIME

TVASTIME

Assigned time

XVOWNID

TVOWNER

Volume owner user ID

XVCRUID

TVUSERID

Creating user ID

XVCRJOB

TVCRJOB

Creating JOB name

XVSECLEV

TVSECCLS

Security level - short

XVSECLNG

TVSCLASS

Security level - long

XVVOLSEQ

TVVOLSEQ

Volume sequence number

XVSTATUS

TVSTATUS

Volume status

XVPENDRS

TVAVAIL=PE

Volume pending release - Y/N

XVVRS

TVAVAIL=VI

Volume retained by VRS - Y/N

XVLOAN

TVAVAIL=ON

Volume on loan - Y/N

XVOPEN

TVAVAIL=OP

Volume is opened - Y/N

XVOCER


Volume recorded by O/C/EOV - Y/N

XVDEFRET

TVTAPFL3=DRU

PARMLIB default retention used to generate the volume EXPDT - Y/N

XVPPTAPE


Program product tape - Y/N

XVLABEL

TVLABEL=AL/AUL/NL/SL/SUL

Label type - SL/AL/NL/SUL/AUL

XVBLP

TVLABEL=BLP

Volume last written BLP - Y/N

XVRETS

TVACTION=RET/SCR

Return action - OWNER/SCRATCH

XVREPL

TVACTION=REP

Replace on release - Y/N

XVINIT

TVACTION=INI

Reinitialize - Y/N

XVERASE

TVACTION=ERA

Security erase - Y/N

XVNTFY

TVACTION=NOT

Notify owner - Y/N

XVOWNAC

TVOWNACC

Owner access - R/U/A

XVUSERAC

TVACCESS

User access - R/U

XVVMUSE

TVVOLENV=V

VM use - Y/N

XVMVSUSE

TVVOLENV=M

MVS use - Y/N

XVNAME

TVMEDNAM

Media name

XVRACK

TVRACK

Rack number

XVPPNUM

TVPRDNUM

Program product number

XVVER

TVPRDVER

Version/release/model number

XVFEAT

TVFCODE

Feature code

XVACCINF

TVACCNT

Accounting information

XVUSEFLD

TVUSRDSC

User description

XVACCLST


Number of access list entries

XVAUTIDS


Authorized user IDs area

XVHLOC

TVHOMLOC

Home location name

XVTRANS

TVTAPFL2=VOLU

Volume in transit - Y/N

XVLOCTYP

TVLOCTYP

Location type

XVDESTYP

TVDESTYP

Destination type

XVOLOC

TVOLOC

The previous location name

XVSGNAME

TVSMSSTG

Storage group name

XVMEDREC

TVMEDRFM

Volume recording format

XVMEDTY

TVMEDTYP

Media type

XVMEDCMP

TVTAPFL1=MEDI

Compaction technique

XVMEDATR

TVTAPFL1=READ

Special attributes - NONE/RDCOMPAT

XVDSNAM1

TVF1DSN

First file data set name

XVMVMODE

TVTAPFL2=MANU

Move mode - A - AUTOMOVE/M - MANUALMOVE

XVDSNREC

TVTAPFL2=DATA

Data set recording - Y/N

XVALCUR

TVLBLCUR

ANSI current label version

XVALREQ

TVLBLREQ

ANSI required label version

XVBMEDN

TVBINMED

Bin media name

XVOBMEDN

TVOBNMED

Previous bin media name

XVNLOC

TVREQLOC

Required location name - as determined by VRS or command

XVLUDEV

TVLRUNIT

Last used drive

XVACTSCR

TVPEND=SCR

Pending action: return to scratch - Y/N

XVACTREP

TVPEND=REP

Pending action: replace volume - Y/N

XVACTRET

TVPEND=RET

Pending action: return to owner - Y/N

XVACTINI

TVPEND=INI

Pending action: initialize - Y/N

XVACTERA

TVPEND=ERA

Pending action: erase - Y/N

XVACTNOT

TVPEND=NOT

Pending action: notify - Y/N

XVACTRSV


Reserved

XVABEND


Data set closed by abend - Y/N

XVHOMTYP

TVHOMTYP

Home location type

XVNEXTYP

TVRQLOCT

Next location type

XVVOLTYPE_
LOGICAL

TVTAPFL1=LOGI

Volume type - LOGICAL

XVVOLTYPE_
PHYSICAL

TVTAPFL1=PHYS

Volume type - PHYSICAL

XVVOLTYPE_
STACKED

TVTAPFL1=STAC

Volume type - STACKED

XVRELIXD

TVTAPFL2=EXPD

Ignore EXPDT - Y/N

XVRELSI

TVTAPFL2=SCRA

Scratch immediate - Y/N

XVRELRSV


Reserved

XVCONTNR

TVCONTNR

In container name

XVRQPRTY

TVMVPRTY

Movement priority

XVCAPACITY

TVCAPBYT

Volume capacity in Mbytes

XVRBYSET

TVTAPFL1=RETA

Volume retained by set - Y/N

XVEXPTOKEN

TVEXPTOK

RMM export token

XVPERCENT

TV%FULL

Volume percentage full

XVDSNNO

TVDSNCNT

Number of data sets on volume

XVLABNO1


Label of first file on volume

XVDCRSID

TVCRSYS1

First file creation system ID

XVVOLCNT

TVLVSOVS

Last volume sequence number of a volume set

XVMVDSNAM1


First dsname of a volume set

XvDestBin

TVDBNNUM

Destination bin number

XvDestBinMedia

TVDBNMED

Destination bin media name

XvVol1

TV1LBVOL

VOL1 label volser

XvVendor

TVVENDOR

Vendor information

XvWWID

TVWWID

Unique world wide ID

XvVwmc

TVWRMTCT

Write mount count

XVTRErr

TVTRDERR

Temporary read errors

XVTWERR

TVTWTERR

Temporary write errors

XVPRERR

TVPRDERR

Permanent read errors

XVPWERR

TVPWTERR

Permanent write errors

XvKeyLabel1

TVEKEYL1

Encryption key label 1

XvKeyEncod1

TVEKEYM1

Key encoding mechanism 1

XvKeyLabel2

TVEKEYL2

Encryption key label 2

XvKeyEncod2

TVEKEYM2

Key encoding mechanism 2

XvMedinf

TVMEDFIN

Media information

XvIRMMUSE

TVVOLENV=IRMM

IRMM use - Y/N

XvWORM

TVTAPFL1=WORM

WORM - Y/N

XVFACTOR

TVSIFACT

Space/size factor

XVAPPUSE


Data written XVAPPUSE is FACTORED

XVUSE

TVUSECNT

Volume use count

XVHOLD

TVAVAIL=VH

Volume hold - Y/N

XVESB


EXPDT set by - of the volume

XVUCDATE

TVUCDATE

Volume last “user” change date

XVUCTIME

TVUCTIME

Volume last “user” change time

XvRetMet

TVRETMET

Retention method

XvRMSB

TVRETMSB

Retention method set by

XVComp_Rat

TVCOMPRT

Compression ratio for the volume

XVPhys_Used

TVPHYSPA

Actual space used by all files after compression (FACTORED)

CA 1 field Cross-Reference

For DATATYPE=CA1DSN and DATATYPE=CA1VOL, the data set record is described by the CA Tape Management CTMDREC macro and the mapping is:

CTMDREC
Field Name

Product

FDREPORT
Field Name(s)

Field Description

DBFORMAT

CA 1


Format Indicator

DBRECTYP

CA 1


Record Type

DBPROD

CA 1


Product Code

DBREL

CA 1


Product Release

DBVOLSER

CA 1

TDVOLSER / TVVOLSER

Volume Serial Number

DBVOLSEQ

CA 1

TDVOLSEQ / TVVOLSEQ

Volume Sequence

DBBASVOL

CA 1

TDBASVOL

First Volume (Base Volume)

DBFILSEQ

CA 1

TDDSNSEQ

File Sequence Number

DBFILCNT

CA 1

TDFILCNT

File Count

DBEXPDT

CA 1

TDEXPDT

Expiration Date

DBDSN

CA 1

TDDSNAME

Data Set Name

DBRECFM

CA 1

TDRECFM

Record Format

DBLRECL

CA 1

TDLRECL

Logical Record Length

DBBLKSIZ

CA 1

TDBLKSIZ

Block Size

DBBLKCNT

CA 1

TDBLKCNT

Block Count

DBCDATE

CA 1

TDCRDATE

Creation Date

DBCTIME

CA 1

TDCRTIME

Creation Time

DBCJOB

CA 1

TDCRJOB

Creation Job

DBCSTEP

CA 1

TDCRSTEP

Creation Step

DBCDDNME

CA 1

TDCRDDNM

Creation DDname

DBCUNIT

CA 1

TDCRUNIT

Creation Unit

DBCLSIND

CA 1

TDCLSIND / TVCLSIND

Close Indicator

DBLDATE

CA 1

TDC1LUDT / TVLRDATE

Last Use Date

DBLTIME

CA 1

TVLRTIME

Last Use Time

DBLJOB

CA 1

TDLUJOB

Last Use Job

DBLUNIT

CA 1

TDLRUNIT / TVLRUNIT

Last Use Unit Address

DBCPYCAT

CA 1

TDC1FLG3 / TVC1FLG3

COPYCAT Created Tape

DBDEN

CA 1

TDTLDENS / TVC1DENS

Density

DBLABTYP

CA 1

TVLABEL

Label Type

DBSCRIND

CA 1

TDC1FLG1 / TVC1FLG1

Scratch Indicator

DBTRTCH

CA 1

TDC1RECT

Recording Technique

DBUSECLN

CA 1

TVC1CLUC / TVC1RECT

Uses Cleaned

DBTMSCLN

CA 1

TVC1CLCT

Times Cleaned

DBDTECLN

CA 1

TVC1CLDT

Date Cleaned

DBINTDTE

CA 1

TVC1FUDT

Initial Date

DBUSETOT

CA 1


Total Uses

DBDTEMOV

CA 1

TVMOVEDT

Date Moved

DBOUTLOC

CA 1

TVC1OACD

Out Location Code

DBINUSE

CA 1

TDC1FLG4 / TVC1FLG4

Is the Volume In-Use

DBNOSTAK

CA 1


Is the Volume Stackable

DBSTACK

CA 1


Files Dynamically Stacked

DBVPERC

CA 1

TV$FULL

Percent of Volume in Use

DBFPERC

CA 1

TD%FULL

Percent of Volume Used by File

DBCOMPRS

CA 1

TDCOMPRT

Compression Rate

DBTRDCLN

CA 1


Temp Read Clean

DBTWTCLN

CA 1


Temp Write Clean

DBPRDCLN

CA 1


Perm Read Clean

DBPWTCLN

CA 1


Perm Write Clean

DBTRDINT

CA 1


Temp Read Init

DBTWTINT

CA 1


Temp Write Init

DBPRDINT

CA 1


Perm Read Init

DBPWTINT

CA 1


Perm Write Init

DBVENDOR

CA 1

TVENDOR

Vendor

DBDRVIND

CA 1


Out of Service Indicator

DBCPUID

CA 1


CPUID

DBVOLOWN

CA 1

TVOWNER

Volume Owner (EDM ID)

DBUSRDTA

CA 1

TVACCNT1

User Data

DBVOLCNT

CA 1


Volume Count

DBCPGM

CA 1

TDCRPGM

Creating Program

DBLPGM

CA 1

TDLUPGM

Last Used Program

DBROBTY

CA 1

TVC1ROBT

Robot Device Type

DBROBID

CA 1

TVC1ROID

Robot Device Number

DBACTVOL

CA 1


Actual Volser of Tape

DBACTUAL

CA 1


Actual Volser In Use Indicator

DBSMSMC

CA 1

TDSMSMGC

SMS Management Class

DBAGENT

CA 1


Tape Agent

DBVDEGAU

CA 1

TDC1FLG4 / TVC1FLG4

Volume Has Been Degaussed

DBFISCAT

CA 1

TDC1FLG2 / TVC1FLG2

File is on OS Catalog

DBVSR

CA 1


Tape Vaulted Due to Spec Req

DBNRS

CA 1


Tape is Non-Resident

DBOUTSLT

CA 1


Out Slot

DBWRMWID

CA 1

TVWWID

World Wide WORM ID

DBWRMWMC

CA 1

TVWRMTCT

Write Mount Count

DBWRMFLG

CA 1


WORM Indicator

DBBYTPRC

CA 1


Byte Percentage

DBRESVA1

CA 1


Reserved

DBKEYIDX

CA 1

TDBESKEY

Tape Encryption Key Index

DBRESVD3

CA 1


Reserved

DBSCRFLG

CA 1


Scratch Flag

DBTMPIND

CA 1


Temporary Data Set Indicator

DBPREVOL

CA 1


Previous Volume

DBNXTVOL

CA 1


Next Volume

DBFSTVOL

CA 1


First Volume

DBFSTDSN

CA 1


First DSNB

DBLSTDSN

CA 1


Last DSNB

DBCURDSN

CA 1


Current DSNB

DBPRVDSN

CA 1


Previous DSNB

DBNXTDSN

CA 1


Next DSNB

DBHD1DSN

CA 1


DSN17

DBUNUS2

CA 1


Unused

DBCATCNT

CA 1


Catalog Count

DBRDSOVR

CA 1


RDS Override Indicator

DBDELIND

CA 1


Delete Indicator

DBCLNIND

CA 1


Clean Indicator

DBUSRIND

CA 1


Updated User Indicator

DBINTCIN

CA 1


Internal Change Indicator

DBXBYJUL

CA 1


Expired by Julian

DBXBYLDT

CA 1


Expired by Last Date

DBXBYCYC

CA 1


Expired by Cycle

DBXBYCAT

CA 1


Expired by Catalog

DBXBYSMS

CA 1


Expired by SMS

DBXBYTMS

CA 1


Expired by TMS Interface

DBRECIND

CA 1


Recreated Indicator

DBOOUTIN

CA 1


Opened for Output Indicator

DBRDCAT

CA 1


Read via Catalog Indicator

DBDYNIND

CA 1


DYNAM/T Controlled Indicator

DBEDMIND

CA 1


EDM Controlled Indicator

DBBADIND

CA 1


Bad Type Indicator

DBLUPDAT

CA 1


Last Update Cause

DBAUDDTE

CA 1


Audit Date

DBAUDTIM

CA 1


Audit Time

DBUSERID

CA 1


Userid

DBAUCODE

CA 1


Audit Code

DBRESVD4

CA 1


Reserved

DBDSNACT

CA 1


Active DSNB Indicator

DBAUBLK

CA 1


Exception Codes

DBVFLAG1

CA 1


Volume Flag1

DBVFLAG2

CA 1


Volume Flag2

DBVFLAG3

CA 1


Volume Flag3

DBVFLAG4

CA 1


Volume Flag4

DBVFLAG5

CA 1


Volume Flag5

DBVFLAG6

CA 1


Volume Flag6

DBRESVD5

CA 1


Reserved

DBDFLAG1

CA 1


DSNB Flag1

DBDFLAG2

CA 1


DSNB Flag2

DBRESVD6

CA 1


Reserved

DBRELEVM

CA 1


Released by External Vault Mgr

DBERASE

CA 1


Data Set Erase Required

DBDEFEXP

CA 1


Default EXPDT Used at Open

DBMULTIF

CA 1


Additional Files Exist on Tape

DBFRAREA

CA 1


Vault From Area

DBFDSLOT

CA 1


Vault From Slot

DBPSEQ

CA 1


Vault Pattern Number

DBDSEQ

CA 1


DSN Sequence Number

DBSIZE

CA 1


Size of Vault Record

DBFRASUB

CA 1


Vault From Subcode

DBOUTSUB

CA 1


Vault Out Subcode

DBLBLT

CA 1


Label Type Information

DBGVDISP

CA 1


Displ in DSN for GDG Name

DBCJOB1

CA 1


Creating Job for Sort

DBCRTDT1

CA 1


Creating Date for Sort

DBCRTTI1

CA 1


Creating Time for Sort

DBLCODE

CA 1


Code for Pseudo Vaults

DBGOOVOO

CA 1


Generation/Version Number

DBODATE

CA 1


Old Expiration Date

DBCLNDAT

CA 1


Original Clean Date

DBCLNIN

CA 1


Clean Tape Indicator

DBUNCIND

CA 1


Uncatalog Indicator

DBSCRP

CA 1


Scratch Subpool

DBRETLN

CA 1


Length of Retention Extension

Field name tables

The FDREPORT Field Name tables list the field names that can be used in REPORT, SORT, and SUMMARY statements as well as PUNCH masks and TITLE statements. See FDREPORT-Field-Names for a description of layout of these tables.

DATATYPE-CA1DSN-Field-Name-Table - for tape data set fields in CA 1

DATATYPE-CA1VOL-Field-Name-Table - for tape volume fields in CA 1

DATATYPE-RMMDSN-Field-Name-Table - for tape data set fields in DFSMSrmm

DATATYPE-RMMVOL-Field-Name-Table - for tape volume fields in DFSMSrmm

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*