Do you want to learn why Database backups are different from file backups? Click HERE to find out.
Do you want to learn why
Database backups
are different from file backups?
Click HERE to find out.
FDREPORT FIELD NAMES for DFHSM Data
The following tables list the field names that can be used to report on DFHSM data in REPORT, SORT, and SUMMARY statements as well as PUNCH masks and TITLE statements. The field name tables are listed by DATATYPE showing the fields available for the specified DATATYPE.
The following FDREPORT data sources are also available
The tables shown the following information for each field, full descriptions can be found on the FDREPORT fields page:
- Field Name
- XSEL - selection criteria
- REP - can you report on this field?
- SORT - can you report on this field?
- SUMM - Can you summarise by this field?
- PUN - Can you use this field in a punch mask?
- Leng - How long is this field?
- Attr - How is the field is displayed?
- Description - A brief description of the field
DATATYPE BCDS FIELD NAME TABLE
This is the operand list for all data sets (both VSAM and non-VSAM). BCDS extracts data set information from the DFSMShsm Backup Control Data Set (BCDS) a VSAM cluster
| DATATYPE=BCDS Field Name Table | ||||||||
| Field Name | XSEL | REP | SORT | SUMM | PUN | Len | Attr | Description |
| %FREE | A | Y | Y | V | Y | 3 | NUM | Tracks not in use within a data set as a percentage |
| %USED | A | Y | Y | V | Y | 3 | NUM | Tracks in use within a data set as a percentage |
| ADATE | A | Y | Y | V | Y | D | DATE | Archive date |
| ADAYS | A | Y | Y | V | Y | 5 | NUM | Days since archived |
| ATIME | A | Y | Y | V | Y | 8 | TIME | Archive time - hhmmss (APPL backup only) |
| BYTES | A | Y | Y | S | Y | B | BYTE | Allocated space (bytes / kB / MB) |
| BYTESFRE | A | Y | Y | S | Y | B | BYTE | Unused space (bytes / KB / MB) |
| BYTESTRK | A | Y | Y | V | Y | 5 | NUM | Bytes per track (calculated) |
| BYTESUSE | A | Y | Y | S | Y | B | BYTE | Used space (bytes / KB / MB) |
| BLKSIZE | A | Y | Y | V | Y | 5 | NUM | Data set block size |
| BLKSTRK | A | Y | Y | V | Y | 4 | NUM | Number of blocks per track |
| CLUSTER | A | Y | Y | V | Y | 44 | CHAR | Cluster name (ICF VSAM) |
| COMPTYPE | E | Y | Y | N | N | 5 | CHAR | Component type (ICF VSAM): AIXDA - AIX data component AIXIN - AIX index component DATA - Base cluster data component INDEX - Base cluster index component |
| DATACLAS | E | Y | Y | V | Y | 8 | CHAR | SMS data class |
| Note: This field supports selection via a mask. | ||||||||
| DEVCLASS | E | Y | N | V | Y | 4 | CHAR | Device class |
| DEVTYPE | E | Y | Y | V | Y | 7 | CHAR | Device type |
| DSGROUP | A | Y | 44 | CHAR | Data set group name | |||
| DSIND | E | Y | Y | V | N | 2 | HEX | Data set indicators (printed in hex): LASTV (x'80' - Last volume MULT8 (x'20') - Block size multiple of 8 PASSA (x'10') - Read / write password PASSW (x'14') - Write password RACF (x'40') - Discrete profile UPDAT (x'02') - Data set updates |
| DSNAME | A | Y | Y | C | Y | 44 | CHAR | Data set name / VSAM component name |
| DSORG | E | Y | Y | V | Y | 3 | CHAR | Data set organization AM - All VSAM DA - Direct access EF - ICF VSAM HFS - Hierarchical File System IAM - Innovation Access Method IS - ISAM PO - Partitioned (PDS) POE - Partitioned Data Set Extended (PDSE) PS - Physical Sequential PSE - PS Extended format (large sequential) U - Unmovable (may be appended to other forms) UM - Unmovable (alternate format) UN - Undefined |
| INDEX | E | Y | Y | V | Y | 8 | CHAR | Index volume from data set name |
| INDEXNUM | Y | Y | V | Y | 3 | NUM | # of index level in the data set or cluster name that is extracted into field INDEX | |
| KEYLEN | A | Y | Y | V | Y | 3 | NUM | Data set key length |
| LRDATE | A | Y | Y | Y | Y | D | DATE | Last reference date |
| LRDAYS | A | Y | Y | Y | Y | 5 | NUM | Days since last referenced |
| LRECL | A | Y | Y | V | Y | 5 | NUM | Data set logical reference length |
| MGMTCLAS | E | Y | Y | V | Y | 8 | CHAR | SMS management class |
| Note: This field supports selection via a mask. | ||||||||
| NAME | Y | Y | N | Y | 44 | CHAR | Data set name or VSAM cluster name | |
| NTMIGRAT | A | Y | Y | N | N | 8 | CHAR | Number of times data set has been migrated (MCDS) or backed up (BCDS) |
| RANK | A | Y | Y | N | N | 6 | NUM | Rank within sorted data (assigned) |
| RECFM | E | Y | Y | V | Y | 5 | CHAR | Record format: A - ASA control character B - Blocked F - Fixed M - Machine control character S - Standard/spanned T - Track overflow U - Undefined V - Variable * - None of the above |
| RUNDATE | A | Y | Y | Y | Y | D | DATE | Run date |
| RUNTIME | A | Y | Y | Y | Y | 8 | TIME | Run time - hhmmss |
| SIZE | A | Y | Y | S | Y | 5* | NUM | Allocated tracks |
| Note: The width of the size fields (in tracks) is 6 if the FATDISK option is enabled. | ||||||||
| SIZEFREE | A | Y | Y | S | Y | 5* | NUM | Tracks not in use within data set extents |
| Note: The width of the size fields (in tracks) is 6 if the FATDISK option is enabled. | ||||||||
| SIZEUSED | A | Y | Y | S | Y | 5* | NUM | Tracks in use within data set extents |
| Note: The width of the size fields (in tracks) is 6 if the FATDISK option is enabled. | ||||||||
| SMSFLAGS | E | Y | Y | V | N | 4 | CHAR | SMS-managed data set flag byte in DSCB: MANAGED (S) - SMS-managed NOBCS (N) - Not cataloged REBLOCK (R) - Reblockable DADSMCRT (D) - DADSM assigned blksize PDSE (I) - Partitioned data set extended PDSEX (X) - Hierarchical File System (HFS) ATTREXTN (E) - Extended Attribute (EA) STRIPE (Z) - Extended Format (EF) |
| SNAME | Y | N | N | N | 20 | CHAR | Short data set name or VSAM cluster name (first 20 bytes only) | |
| SOURCE | E | Y | Y | N | N | 7 | CHAR | Source of the data record: ARCHIVE - Archive control file BCDS - HSM backup control data set CATALOG - System catalog CATARCH - Auto-recall records from catalog appended with Archive Control File (ACF) data CATVTOC - Catalog records appended with VTOC and VVR data of selected volume(s) MCDS - DFSMShsm migration control data set TVTOC - FDR FDRABR or FDRDSF backup file(s) VTOC - VTOC of volume VTOCVVR - VTOC of volume appended with VVDS data |
| SPLCLS | Y | N | N | N | 27 | CHAR | Split ICF cluster name on two lines | |
| SPLDSN | Y | N | N | N | 27 | CHAR | Split data set name on two lines | |
| SPLNAME | Y | N | N | N | 27 | CHAR | Split data set name or ICF cluster name on two lines | |
| STORCLAS | E | Y | Y | V | Y | 8 | CHAR | SMS storage class |
| Note: This field supports selection via a mask. | ||||||||
| SYSID | A | Y | Y | Y | Y | 4 | CHAR | System identification from SMF |
| TRKCYL | Y | Y | V | N | 3 | NUM | Number of tracks per cylinder | |
| TRKSVOL | Y | Y | S | Y | 6 | NUM | Number of tracks on this volume | |
| TVTOCDSN | A | Y | Y | V | Y | 44 | CHAR | Input backup dsn |
| UCBID | E | Y | N | V | Y | 8 | HEX | UCB 4-byte device type (hex) |
| VOLGROUP | A | Y | CHAR | Volume group | ||||
| Note: This field supports selection via a mask. | ||||||||
| VOLSQ | A | Y | Y | V | Y | 3 | NUM | Data set volume sequence number |
| VOLUME | A | Y | Y | Y | Y | 6 | CHAR | Volume serial number |
| Note: This field supports selection via a mask. | ||||||||
| XDSNAME | E | Y | CHAR | Extended data set name (selection only) | ||||
DATATYPE MCDS FIELD NAME TABLE
This is complete list of all operands that are available for use with DATATYPE=MCDS. MCDS extracts data set information from the DFSMShsm Migration Control Data Set (MCDS), a VSAM cluster. A LOCATE SVC (SVC 26) is issued to determine if data sets extracted from the MCDS are still cataloged for auto recall under DFSMShsm.
| DATATYPE=MCDS Field Name Table | ||||||||
| Field Name | XSEL | REP | SORT | SUMM | PUN | Len | Attr | Description |
| %FREE | A | Y | Y | V | Y | 3 | NUM | Tracks not in use within a data set as a percentage |
| %USED | A | Y | Y | V | Y | 3 | NUM | Tracks in use within a data set as a percentage |
| ADATE | A | Y | Y | V | Y | D | DATE | Archive date |
| ADAYS | A | Y | Y | V | Y | 5 | NUM | Days since archived |
| ATIME | A | Y | Y | V | Y | 8 | TIME | Archive time - hh.mm.ss |
| BYTES | A | Y | Y | S | Y | B | BYTE | Allocated space (bytes / kB / MB) |
| BYTESFRE | A | Y | Y | S | Y | B | BYTE | Unused space (bytes / KB / MB) |
| BYTESTRK | A | Y | Y | V | Y | 5 | NUM | Bytes per track (calculated) |
| BYTESUSE | A | Y | Y | S | Y | B | BYTE | Used space (bytes / KB / MB) |
| BLKSIZE | A | Y | Y | V | Y | 5 | NUM | Data set block size |
| BLKSTRK | A | Y | Y | V | Y | 4 | NUM | Number of blocks per track |
| CATALOG | E | Y | Y | V | Y | 3 | CHAR | Catalog status: CAN - Cataloged to candidate volume DRF - DASD read failure ERR - Cataloged to another volume NO - Not cataloged ONL - Only cataloged UNK - Cataloged, but unable to process with LOCATE YES - Cataloged to this volume |
| Note: This can be expensive to collect if a large number of data sets are to be reported | ||||||||
| CLUSTER | A | Y | Y | V | Y | 44 | CHAR | Cluster name (ICF VSAM) |
| COMPTYPE | E | Y | Y | N | N | 5 | CHAR | Component type (ICF VSAM): AIXDA - AIX data component AIXIN - AIX index component DATA - Base cluster data component INDEX - Base cluster index component |
| CRDATE | A | Y | Y | Y | Y | D | DATE | Creation date |
| CRDAYS | A | Y | Y | V | Y | 5 | NUM | Days since created |
| DATACLAS | E | Y | Y | V | Y | 8 | CHAR | SMS data class |
| Note: This field supports selection via a mask. | ||||||||
| DAYSEXP | A | Y | Y | V | Y | 5 | NUM | Days until expire |
| Note: If the expiration date is 99.000 or 99.365 or above, this is set to 65535. | ||||||||
| DEVCLASS | E | Y | N | V | Y | 4 | CHAR | Device class |
| DEVTYPE | E | Y | Y | V | Y | 7 | CHAR | Device type |
| DSGROUP | A | Y | 44 | CHAR | Data set group name | |||
| DSIND | E | Y | Y | V | N | 2 | HEX | Data set indicators (printed in hex): LASTV (x'80') - Last volume MULT8 (x'20') - Block size multiple of 8 PASSA (x'10') - Read / write password PASSW (x'14') - Write password RACF (x'40') - Discrete profile UPDAT (x'02') - Data set updates |
| DSNAME | A | Y | Y | C | Y | 44 | CHAR | Data set name / VSAM component name |
| DSSN | E | Y | Y | Y | Y | 6 | HEX | HEX Volume serial number field in DSCB |
| Note: This field supports selection via a mask. | ||||||||
| DSORG | E | Y | Y | V | Y | 3 | CHAR | Data set organization AM - All VSAM DA - Direct access EF - ICF VSAM HFS - Hierarchical File System IAM - Innovation Access Method IS - ISAM PO - Partitioned (PDS) POE - Partitioned Data Set Extended (PDSE) PS - Physical Sequential PSE - PS Extended format (large sequential) U - Unmovable (may be appended to other forms) UM - Unmovable (alternate format) UN - Undefined |
| EXPDATE | A | Y | Y | V | Y | D | DATE | Expiration date |
| EXPDAYS | A | Y | Y | V | Y | 5 | NUM | Days until expire |
| Note: If the expiration date is 99.000 or 99.365 or above, this is set to 65535. | ||||||||
| HSMCDCSZ | A | Y | Y | Y | Y | 10 | NUM | Size of migration volume in 2k blocks (HSM MCDS) |
| HSMIGVOL | E | Y | Y | Y | Y | 6 | CHAR | First migration volume (HSM BCDS / MCDS) |
| Note: This field supports selection via a mask. | ||||||||
| INDEX | Y | Y | V | Y | 8 | CHAR | Index volume from data set name | |
| INDEXNUM | Y | Y | V | Y | 3 | NUM | # of index level in the data set or cluster name that is extracted into field INDEX | |
| KEYLEN | A | Y | Y | V | Y | 3 | NUM | Data set key length |
| LRDATE | A | Y | Y | Y | Y | D | DATE | Last reference date |
| LRDAYS | A | Y | Y | Y | Y | 5 | NUM | Days since last referenced |
| LRECL | A | Y | Y | V | Y | 5 | NUM | Data set logical reference length |
| LRTIME | Y | Y | N | N | 8 | TIME | Last reference time - hh.mm.ss (IAM / ICF VSAM) | |
| MGMTCLAS | E | Y | Y | V | Y | 8 | CHAR | SMS management class |
| Note: This field supports selection via a mask. | ||||||||
| NTMIGRAT | A | Y | Y | N | N | 8 | CHAR | Number of times data set has been migrated (MCDS) or backed up (BCDS) |
| NAME | Y | Y | N | Y | 44 | CHAR | Data set name or VSAM cluster name | |
| OPTCD | E | Y | Y | V | Y | 2 | CHAR | Option code byte: A - (DAM) Actual addressing BC - ICF VSAM catalog C - (SAM) Chained scheduling using PCI DB - (DAM) Dynamic buffering E - (DAM) Extended search F - (DAM) Feedback I - (IS) Independent overflow area IC - ICF VSAM data set L - (IS) Delete M - (IS) Master index R - (IS) Reorganization criteria RB - (DAM) Relative block addressing RE - (DAM) Read exclusive TO - (DAM) Track overflow UF - (IS) Full track index write W - (All) Write validity check Y - (IS) Cylinder overflow area |
| RANK | A | Y | Y | N | N | 6 | NUM | Rank within sorted data (assigned) |
| RECFM | E | Y | Y | V | Y | 5 | CHAR | Record format: A - ASA control character B - Blocked F - Fixed M - Machine control character S - Standard/spanned T - Track overflow U - Undefined V - Variable * - None of the above |
| RECTYPE | Y | Y | V | N | 3 | NUM | FDREPORT data record type: 1 - Volume record 2 - Data set / component record 4 - Volume summary record 8 - Prior compressed data record 9 - Prior active fields record 64 - Compressed data record 128 - Active fields record | |
| RECVER | Y | Y | V | Y | 4 | CHAR | FDREPORT product version record format | |
| RUNDATE | A | Y | Y | Y | Y | D | DATE | Run date |
| RUNTIME | A | Y | Y | Y | Y | 8 | TIME | Run time - hh.mm.ss |
| SCLUSTER | Y | N | N | N | 20 | CHAR | Short cluster name (first 20 bytes only) | |
| SDSN | Y | N | N | N | 20 | CHAR | Short data set name (first 20 bytes only) | |
| SECAFLAG | E | Y | Y | V | Y | 5 | CHAR | Secondary allocation flags: BLK - Allocated in blocks CON - Contiguous (CONTIG) CYL - Allocated in cylinders FIV - Five largest extents (ALX) MAX - Largest extent (MXIG) RND - Rounded to cylinders (ROUND) TRK - Allocated in tracks |
| SECALLOC | A | Y | Y | Y | Y | 8 | NUM | Secondary allocation quantity |
| SIZE | A | Y | Y | S | Y | 5* | NUM | Allocated tracks |
| Note: The width of the size fields (in tracks) is 6 if the FATDISK option is enabled. | ||||||||
| SIZEFREE | A | Y | Y | S | Y | 5* | NUM | Tracks not in use within data set extents |
| Note: The width of the size fields (in tracks) is 6 if the FATDISK option is enabled. | ||||||||
| SIZEUSED | A | Y | Y | S | Y | 5* | NUM | Tracks in use within data set extents |
| Note: The width of the size fields (in tracks) is 6 if the FATDISK option is enabled. | ||||||||
| SMSFLAGS | E | Y | Y | V | N | 4 | CHAR | SMS-managed data set flag byte in DSCB: MANAGED (S) - SMS-managed NOBCS (N) - Not cataloged REBLOCK (R) - Reblockable DADSMCRT (D) - DADSM assigned blksize PDSE (I) - Partitioned data set extended PDSEX (X) - Hierarchical File System (HFS) ATTREXTN (E) - Extended Attribute (EA) STRIPE (Z) - Extended Format (EF) |
| SNAME | Y | N | N | N | 20 | CHAR | Short data set name or VSAM cluster name (first 20 bytes only) | |
| SOURCE | E | Y | Y | N | N | 7 | CHAR | Source of the data record: ARCHIVE - Archive control file BCDS - HSM backup control data set CATALOG - System catalog CATARCH - Auto-recall records from catalog appended with Archive Control File (ACF) data CATVTOC - Catalog records appended with VTOC and VVR data of selected volume(s) MCDS - DFSMShsm migration control data set TVTOC - FDR, FDRABR, or FDRDSF backup file(s) VTOC - VTOC of volume VTOCVVR - VTOC of volume appended with VVDS data |
| SPLCLS | Y | N | N | N | 27 | CHAR | Split ICF cluster name on two lines | |
| SPLDSN | Y | N | N | N | 27 | CHAR | Split data set name on two lines | |
| SPLNAME | Y | N | N | N | 27 | CHAR | Split data set name or ICF cluster name on two lines | |
| STORCLAS | E | Y | Y | V | Y | 8 | CHAR | SMS storage class |
| Note: This field supports selection via a mask. | ||||||||
| SYSID | A | Y | Y | Y | Y | 4 | CHAR | System identification from SMF |
| TRKCYL | Y | Y | V | N3 | NUM | Number of tracks per cylinder | ||
| TRKSVOL | Y | Y | S | Y | 6 | NUM | Number of tracks on this volume | |
| TVTOCDSN | A | Y | Y | V | Y | 44 | CHAR | Input backup data set name |
| UCBID | E | Y | N | V | Y | 8 | HEX | UCB 4-byte device type (hex) |
| VOLGROUP | A | Y | CHAR Volume group | |||||
| Note: This field supports selection via a mask. | ||||||||
| VOLSQ | A | Y | Y | V | Y | 3 | NUM | Data set volume sequence number |
| VOLUME | A | Y | Y | Y | Y | 6 | CHAR | Volume serial number |
| Note: This field supports selection via a mask. | ||||||||
| XDSNAME | E | Y | CHAR | Extended data set name (selection only) | ||||
Published with permission of Innovation Data Processing