SELECT and EXCLUDE Statement for FDRAPPL

SELECT statement

The SELECT statement specifies the data sets to be dumped by FDRAPPL. SELECT CATDSN= scans the system catalogs for the specified data sets and then scans the volumes found in the catalog to back up those data sets. SELECT DSN= or ALLDSN should also specify VOL= or VOLG= to specify the volumes to be searched. If other operands are specified (such as CRDAYS= or GDG), the data set is backed up only if it meets those criteria.

EXCLUDE statement

The EXCLUDE statement can be used to exclude certain data sets from a more encompassing SELECT. Since data sets are compared to the statements in the order specified, EXCLUDE statements should usually precede SELECT statements.

SELECT and EXCLUDE statement syntax

SELECT\|EXCLUDE
	ALLDSN\|CATDSN=filter\|DSN=filter
	,CATLIMITGDG=n
	,DATA=NONE
	,DSORG=([DA][EF][PS][PO][UM][UN])
	,GDG
	,VOL=vol\|VOLG=volg
	,UPDATE

SELECT and EXCLUDE statement rarely used operands

There are some additional operands that can be specified on a SELECT statement, but they are rarely used with FDRAPPL. Their definitions can be found in SELECT-EXCLUDE-and-MOUNT-Statements. They are:


	,CATALOG=dsn\|MCATALOG
	,CATBYPERR
	,CRDAYS=
	,DATA=ALL
	,PRTALIAS

VSAM clusters

VSAM clusters can be selected by FDRAPPL only by the base cluster name with the DSN= or CATDSN= operand. If selected, FDRAPPL backs up all of the components associated with this cluster that exist on the volumes processed. This includes Alternate Indexes (AIXs) and key range components. The component names are reported by FDRAPPL followed by the base cluster name. FDRAPPL dumps to the backup file all of the associated VVR records found in the “SYS1.VVDS” data set. For further information, see VSAM-Special-Considerations.

SELECT statement operands

ALLDSN

Specifies that all the data sets encountered on the volumes specified by VOL= or VOLG= are to be selected or excluded. DSN=** is equivalent to ALLDSN.

Important

SELECT ALLDSN does not select certain data sets (such as SYS1 data sets) as documented in Exceptions to Automatic Archiving.
DSN=, CATDSN= and ALLDSN are mutually exclusive. One and only one of them must be specified on each SELECT/EXCLUDE statement.

CATDSN=

Specifies a fully-qualified data set name or a filter to be used for generic data set selection from system catalogs, as described in Generic-Data-Set-Name-Selection.

If a fully-qualified name is specified, that name is located in the system catalogs, and the volume serials from the catalog become an implied VOL= parameter. Specification of a relative generation number for GDG data sets is supported (for example, CATDSN=A.B(–1)).

If a filter is specified, then catalogs are scanned for all cataloged data sets matching the filter, and they are processed as if a SELECT CATDSN=dsn was present for each of them. It may be necessary to specify MAXCARDS=nnnnn on the DUMP statement if a large number of data sets are selected by the filter.

Additional considerations for CATDSN=filter are explained in Generic-Data-Set-Name-Selection. For VSAM clusters, the filter is only compared to the base cluster name. Component names, PATH names and AIX (alternate index) cluster and component names are not tested.

CATDSN= is supported only on SELECT statements (not on EXCLUDE).

If the VOL=/VOLG= operand is also specified on a SELECT statement with CATDSN=, then only data sets cataloged to those volumes are selected. For example,

CATDSN=INVENTRY.WIDGET.WAREHOUS

CATDSN=CLAIMS.**(0),VOLG=INS

CATDSN=PROD++.**.LIB*

Normally, CATDSN= does not display the data sets it selects from the catalogs; you will see the names only when FDRAPPL actually finds and selects the data sets in the VTOCs of the volumes to which they are cataloged. To display all of the data sets selected specify PCATDSN=filter.

DSN=

Specifies a fully-qualified data set name or a filter to be used for generic data set selection, as described in Generic-Data-Set-Name-Selection. This name or filter is used when scanning the VTOCs of selected volumes. VOL= or VOLG= should also be specified to identify the volumes to be scanned for these data sets. For VSAM clusters, only the cluster name is compared; you cannot select by component name. For example,

DSN=INVENTRY.WIDGET.WAREHOUS

DSN=CLAIMS.**

DSN=PROD++.**.LIB*

DSN= does not have any special support for selecting GDGs. However, if it is used in conjunction with the GDG operand then only GDGs are selected.

CATLIMITGDG=

May be used with CATDSN=filter to limit the selection of GDGs from the catalogs. It does not affect the selection of cataloged non-GDG data sets, but if the filter selects a GDG then:

n - Causes only the most recently created “n” generations to be selected.

–n - Causes only generation “–n” to be selected.

Default: All the generations of selected GDGs are selected unless a relative generation number is specified at the end of the filter, for example, CATDSN=filter(-2).

DATA=

NONE - Specifies that FDRAPPL dump allocation information about the selected data sets, but not actually back up any data tracks. Can be used when the data sets are to be allocated by FDRAPPL but the contents of the data sets are recreated by another means. DATA=NONE must also be specified when restoring data sets that were dumped with DATA=NONE.

DSORG=

Specifies that the data set is not to be selected unless its DSORG matches one of the DSORG values specified. If more than one DSORG is specified, they must be enclosed in parentheses. Valid DSORG values are:

DA - BDAM

EF - VSAM

PS - Sequential

PO - Partitioned

UM - Unmovable

UN - Undefined

GDG

Only data sets that are generations of a Generation Data Group (GDG) are selected.

VOL=

Specifies a volume serial number (up to 6 characters) to which this statement applies. When used with CATDSN=, only data sets cataloged to this volume are selected. If DSN= is specified, either VOL= or VOLG= is required, and those volumes are scanned for the specified data sets.

VOLG=

Specifies a volume serial number prefix (up to five characters) to which this statement applies. When used with CATDSN=, only data sets cataloged to these volumes are selected. If DSN= is specified, either VOL= or VOLG= is required, and those volumes are scanned for the specified data sets.

UPDATE

Data sets that match this SELECT statement are selected only if the update indicator is set in their Format 1 DSCB, indicating that it has been updated since the last backup. Resetting of this flag is dependent on the setting of global option APPLUPDT. If APPLUPDT=NO, Volume Backup controls this DSCB flag, if APPLUPTD=YES, Application Backup controls this flag. If you use Application Backup and wish to only backup data sets that have been updated since the last backup, you can use this option in conjunction with the APPLUPDT=YES setting to do this. This backup strategy will save the resources required to store the redundant backups and save the overhead of backing up infrequently updated data sets.

For more information about this option, see FDR global option ABR.