FDREPORT DFSMShsm Reporting

IBM DFSMShsm reporting

FDREPORT customers who are also using IBM’s DFSMShsm DASD management system (or its older version DFHSM), can use FDREPORT to read the database files created by HSM and report on their contents. The DFSMShsm data sets supported by FDREPORT are:

BCDS - information on backups of current data sets.
MCDS - information on migrated data sets.

This allows you to use all the power and flexibility of FDREPORT to generate reports about the data that DFSMShsm is managing.

With the exception of HSMCDCSZ, HSMIGVOL, and NTMIGRAT, there are no new field names defined when reporting from DFSMShsm data. Instead, data fields from the DFSMShsm records and calculated values are mapped into standard FDREPORT field names.

IBM DFSMShsm BCDS Cross-Reference

For DATATYPE=BCDS, the BCDS data set record is described by the IBM MCB macro and the mapping is:

BCDS Field Name	FDREPORT Field Name	Field Description
MCK	DSN	Data set name
MCBFRVOL	VOL	Volume Serial Number
MCBDBU	ADATE	Date Backed Up
MCBTBU	ATIME	Time Backed Up
	ADAYS	Days since backup (calculated)
MCBDLRPD	LRDATE	Last Reference Date
	LRDAYS	Days since last reference (calculated)
MCBDSORG	DSORG	Data set Organization
MCBRECFM	RECFM	Record Format
MCBBLKSZ	BLKSIZE	Block Size
MCBKEYLN	KEYLEN	Key Length
MCBDSIND	DSIND	Data set Indicators
MCBSIZE	SIZE	Allocated Tracks
MCBSIZEB	BYTESUSE	Bytes Used
	BYTES	Bytes Allocated (calculated)
MCBNBC	NTMIGRAT	Number of times data set was backed up
MCBVSN	HSMIGVOL	First Backup Volume
MCCFRUCB	UCBID	UCB 4-byte Device Type (hex)
MCCSCNAM	STORCLAS	SMS storage class
MCCMCNAM	MGMTCLAS	SMS management class
MCCMDNAM	DATACLAS	SMS data class
MCCSMSFG	SMSFLAGS	SMS-managed data set Flag Byte
MCBBDSN	TVTOCDSN	Name of Backup Copy
	SOURCE	“BCDS”

IBM DFSMShsm MCDS Cross-Reference

For DATATYPE=MCDS, the MCDS data set record is described by the IBM MCD macro and the mapping is:

MCDS Field Name	FDREPORT Field Name	Field Description
MCK	DSN	Data set name
MCDFRVSN	VOL	Volume Serial Number
MCDUCBTY	UCBID	UCB 4-byte device type(hex)
	DEVTYPE	DASD device type (for example, 3390)
MCDFLGS	DSSN	MGRATx (x=migration level)
MCDDLC	CRDATE	Creation Date
	CRDAYS	Days since Creation (calculated)
MCDEXPDT	EXPDATE	Expiration Date
	EXPDAYS	Days since Expiration (calculated)
MCDDLR	LRDATE	Last Reference Date
MCDTLR	LRTIME	Last Referenced Time
	LRDAYS	Days since Last Reference (calculated)
MCDDMIG	ADATE	Date Archived (Migrated)
MCDTMIG	ATIME	Time Archived (Migrated)
	ADAYS	Days since Migration (calculated)
MCDDSORG	DSORG	Data set Organization
MCDRECFM	RECFM	Record Format
MCDOPTCD	OPTCD	Option Code
MCDBLKSZ	BLKSIZE	Block Size
	BLKSTRK	Blocks/track (calculated)
	BYTESTRK	Bytes/track (calculated)
MCDKEYLN	KEYLEN	Key Length
MCDDSIND	DSIND	Data set Indicators
MCDSIZE	SIZE	Allocated Tracks
	SIZEUSED	Used Tracks (calculated)
	SIZEFREE	Free Tracks (calculated)
MCDSIZEB	BYTES	Bytes Allocated
	BYTESUSE	Bytes Used (calculated)
	BYTESFRE	Bytes Free (calculated)
	%USED	Percentage used (calculated)
	%FREE	Percentage free (calculated)
	LSTAR	Last Used ttttrr
MCDSCNAM	STORCLAS	SMS storage class
MCDMCNAM	MGMTCLAS	SMS management class
MCDMDNAM	DATACLAS	SMS data class
MCDSMSFG	SMSFLAGS	SMS-managed data set Flag Byte
MCDSCAL1	SECAFLAG	Secondary Allocation Flags
MCDSCAL3	SECALLOC	Secondary Allocation Quantity
MCDNMIG	NTMIGRAT	Number of times data set was migrated
MCDVSN	HSMIGVOL	First migration volume serial number
MCDCSZ	HSMCDCSZ	Size on Migration Volume
MCDMCANM	TVTOCDSN	Name of Migration Copy
	SOURCE	“MCDS”

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-BCDS-Field-Name-Table - for BCDS fields in IBM DFSMShsm

DATATYPE-MCDS-Field-Name-Table - for MCDS fields in IBM DFSMShsm