SELECT Command

The SELECT command allows a user to process only those data sets that satisfy the specified selection test(s). This command is required unless you have CA Disk sysparm SELECTRE specified with a value of N.

If a SELECT statement is specified, in order for a data set to be selected, ALL tests specified on a single SELECT command must be met. If only one parameter is specified, only that single test must be met for selection to take place.

For example, if the DSNAMES= parameter or the VOLUMES= parameter, but not both, are specified on a single command, conceptually think process only these data sets or process only these volumes. If both the DSNAMES= and VOLUMES= parameters are specified, conceptually think process only these data sets if defined on one of these volumes.

If multiple SELECT commands are specified for any given action command, this has the effect of a logical OR between SELECT commands. That is, if any SELECT command is true, the data set is processed, regardless of whether other SELECT commands test true or not (see EXCLUDE exception below).

Note: If an EXCLUDE command immediately precedes or follows any SELECT command, special rules apply. See SELECT and EXCLUDE Rules for a further explanation.

SELECT DSNAMES=,COMPONENTS,TABLE=,VOLUMES=,UNIT=,VAMPOOL=,SGNAME=,VTOCS, CATALOGS=,CRITERIA=

DSNAMES=

You can specify up to ten fully qualified names or CA Disk patterns.

The reason for this option is that the SELECT and EXCLUDE commands control the data sets that are selected. If any SELECT command is specified without the DSNAMES= parameter, all data sets are selected. If multiple SELECT commands are entered and you want them to all process the same data sets, the data set list must be copied to each SELECT, as in the following example:

SCAN REALVOLS
    SELECT DSN=(SYS1/,SYS2/),CRITERIA=(TRKS,GT,200)
    SELECT DSN=(SYS1/,SYS2/),CRITERIA=(EXTENTS,GT,3)
         REPORT SVDICT,MVDICT

Because a SELECT DSNAMES= statement is already very restrictive, you cannot specify the VTOCS, nor CATALOGS= parameters on the same SELECT statement. You can, however, add the COMPONENTS, TABLE=, VOL=, VAMPOOL=, SGNAME= or CRI= parameters.

For improved performance for VSAM while using the REPORT command, see the section COMPONENTS in the chapter "Reports."

COMPONENTS

Specifying this parameter can eliminate the need for CA Disk to access the catalog to retrieve the cluster name for VSAM components that do not meet the SELECT DSNAMES= or TABLE= list. This saves significant processing time and also prevents many broken VSAM cluster messages (those that see components outside of the range of the DSNAMES= or TABLE= parameters).

This COMPONENTS parameter is only allowed on SELECT DSNAMES= or SELECT TABLE= commands.

This COMPONENTS parameter is ineffective under SCAN CATALOGS= or FIND commands and when checking fields that are not available within the FMT1 DSCB. This parameter should only be used with those SELECT CRITERIA fields that search the FMT1 information, NOT those parameters that review fields contained in the catalog or FILES, such as MODIFIED or ARCDT. The COMPONENT parm is intended for use mainly with the FMT1 DSCB date fields, (such as F1CREDT, F1MODDT) or if the SELECT CRITERIA= parameter is not used.

Use this parameter if you have installed DFP release 3.1 or above, have installed a VSAM allocation manager product or have taken administrative action to ensure that VSAM components have names that relate to their associated cluster names, or when not processing VSAM data sets.

For example, to report on format-1 DSCBs starting with VSAM created today on your VSAM volumes:

//jobname JOB (acct,info),etc.
//STEP EXEC DMS
SCAN REALVOLS
SELECT DSNAMES=VSAM/,VOL=VSAM/,COMPONENTS,CRITERIA=(F1CREDT,EQ,TODAY)
REPORT MVD,COMPONENTS

TABLE=

Specify the name of a member in the parmlib data set containing the list (table) of fully qualified data set names or patterns.

Note: Data sets are not automatically selected because of their appearance in this list. If any other parameters are specified on the same SELECT command, all parameters must be true for the data set to be selected. For example, in the following command, the data set must both be listed in the member named IMSDSNS and must have been backed up within the last five days:

SELECT TABLE=IMSDSNS,CRITERIA=(ARCDT,GE,TODAY-5),DSN=/

Because a SELECT TABLE= statement is already very restrictive, you cannot specify the VTOCS, nor CATALOGS= parameters on the same SELECT statement. You can, however, add the DSNAMES=, COMPONENTS, VOLUMES=, VAMPOOL=, SGNAME= or CRITERIA= parameters.

Note: By default, these tables are stored in PARMLIB. However, you can store them in an alternative data set if you desire. For details, see Alternate DDname for User Tables in the Systems Guide.

VOLUMES=

If you are running under the FIND command or you let CA Disk sysparm VOLSELRE default, you can optionally specify a list of volumes to be selected. If you are running under the SCAN command and have CA Disk sysparm VOLSELRE specified with a value of Y, you must specify one of the parameters SGNAME=, VAMPOOL=, UNIT=, or VOLUMES=.

You can specify up to 30 volumes or volume patterns.

The reason for this option is that the SELECT and EXCLUDE commands control the volumes that are scanned. If any SELECT command is specified without the VOLUMES= parameter or the UNIT= parameter, all volumes are scanned, regardless of any other SELECT commands. If multiple SELECT commands are entered and you want them to all process the same volumes, the volume list must be copied to each SELECT, as in the example below:

SCAN REALVOLS
SELECT VOL=(LABS/,WORK/),CRITERIA=(TRKS,GT,200),DSN=/
SELECT VOL=(LABS/,WORK/),CRITERIA=(EXTENTS,GT,3),DSN=/
REPORT SVDICT,MVDICT

You can add the DSNAMES=, COMPONENTS, TABLE=, VTOCS, CATALOGS= or CRITERIA= parameters on the same SELECT statement. VOLUMES= is mutually exclusive with the other volume-oriented SELECT command parameters of UNIT=, VAMPOOL= and SGNAME=. This means that VOLUMES= cannot be specified with UNIT=, VAMPOOL= or SGNAME= on the same SELECT statement.

UNIT=

If you are running under the FIND command or you let CA Disk sysparm VOLSELRE default, you can optionally specify a list of units to be selected. If you are running under the SCAN command and have CA Disk sysparm VOLSELRE specified with a value of Y, you must specify one of the parameters SGNAME=, VAMPOOL=, UNIT= or VOLUMES=. This parameter must also be used to specify the unit addresses for any offline volumes to be backed up by VBACKUP.

You can specify up to 16 unit addresses or patterns. The valid pattern characters for this parameter are '*', '?' and '/'. Leading zeroes in the unit number must be specified if pattern characters that can match multiple characters are used, for example: UNIT=50? will select units 0500 and 0501 where UNIT=50/ will select units 5000 and 50FF but not 0500 or 0501.

The reason for this option is that the SELECT and EXCLUDE commands control the volumes that are scanned. If any SELECT command is specified without the VOLUMES= or UNIT= parameter, all volumes are scanned, regardless of any other SELECT commands. If multiple SELECT commands are entered and you want them to all process the same units, the unit list must be copied to each SELECT, as in the example below:

SCAN REALVOLS
	SELECT UNIT=(500,501,240?),CRITERIA=(TRKS,GT,200),DSN=/
	SELECT UNIT=(500,501,240?),CRITERIA=(EXTENTS,GT,3),DSN=/
		REPORT SVDICT,MVDICT

You can add the DSNAMES=, COMPONENTS, TABLE=, VTOCS, CATALOGS= or CRITERIA= parameters on the same SELECT statement. UNIT= is mutually exclusive with the other volume-oriented SELECT command parameters of VOLUMES=, VAMPOOL= and SGNAME=. This means that UNIT= cannot be specified with VOLUMES=, VAMPOOL= or SGNAME= on the same SELECT statement.

VAMPOOL=

This parameter is only valid when CA Allocate (Volume Allocation Manager) is active on the system. It allows selection at the CA Allocate pool level.

For example, SELECT VAMPOOL=(SYSTEM,DMS*) would cause CA Disk to check if the volume being processed or the cataloged volume of a data set being processed for selection is in the CA Allocate pool named SYSTEM or in pools whose names start with DMS.

Note: If you choose to use pattern matching for this parameter, you must use the CA Allocate pattern conventions. SMS managed volumes are not included for VAMPOOL. If you have an SMS volume that matches patterns in your VAMPOOL, they will be bypassed, as they are not part of the CA Allocate pool.

To accomplish this selection CA Disk searches the in-memory copy of the CA Allocate pools using the volume currently being processed by a SCAN REALVOLS or the volume to which a data set being processed by a SCAN CATALOGS command is cataloged. A table of pool names containing this volume is generated. The generated table of pool names is then compared to the pool names or patterns coded in the VAMPOOL parameter to determine if a match exists.

There is a limit of 30 on the number of pool names that can be placed in the generated table. If the volume used for the search is contained in more than 30 CA Allocate pools, the 31st and higher pool names will not be entered in the table and, therefore, will not be used in the compare for a match with the VAMPOOL parameter.

On each SELECT command statement, you can specify up to 22 CA Allocate pool names or CA Allocate pool name patterns.

There are four DSCL SELECT command volume-oriented parameters. They are VOLUMES=, UNIT=, VAMPOOL=, and SGNAME=, which are each mutually exclusive. This means that VAMPOOL= cannot be specified with VOLUMES=, UNIT= or SGNAME= on the same SELECT command statement.

SGNAME=

This parameter is only valid when IBM's Storage Management Subsystem (SMS) is active on the system. It allows selection at the DFSMS storage group level. Volumes and/or data sets will be selected for processing based on whether or not their volser belongs to a particular storage group name specified in the SGNAME= parameter.

For example, SELECT SGNAME=(SGLARGE,SG1/) would select all volumes and/or data sets that reside on the volumes, in the storage group of SGLARGE and in storage group names matching the pattern name of SG1/.

On each SELECT statement, you can specify up to 22 DFSMS storage group names or DFSMS storage group name patterns.

There are four DSCL SELECT command volume-oriented parameters. They are VOLUMES=, UNIT=, VAMPOOL=, and SGNAME=, which are each mutually exclusive. This means that SGNAME= cannot be specified with VOLUMES=, UNIT= or VAMPOOL= on the same SELECT command statement.

You can add the DSNAMES=, COMPONENTS, TABLE=, VTOCS, CATALOGS= or CRITERIA= parameters on the same SELECT statement.

VTOCS

Normally, DSCL processes user data sets only, and bypasses VTOCs, VTOC indexes, catalogs and VVDSs. Specify this parameter to have CA Disk process VTOCs and VTOC indexes. Because a SELECT VTOCS statement is already very restrictive, you cannot specify the DSNAMES=, COMPONENTS, TABLE=, CATALOGS= or CRITERIA= parameters on the same SELECT statement. You can, however, add a VOLUMES=, VAMPOOL= or SGNAME= parameter.

Note: The command SCAN REALVOLS is required for a SELECT VOL=/,VTOCS to backup vtocs.

CATALOGS=

Normally, DSCL processes user data sets only, and bypasses VTOCs, VTOC indexes, catalogs and VVDSs. Specify this parameter to have CA Disk process catalogs and VVDSs as specified by a fully qualified data set name or CA Disk pattern. Because a SELECT CATALOGS= statement is already very restrictive, you cannot specify the DSNAMES=, COMPONENTS, TABLE=, VTOCS nor CRITERIA= parameters on the same SELECT statement. You can, however, add a VOLUMES=, VAMPOOL= or SGNAME= parameter.

CRITERIA=

Specify the selection criteria to be met before any CA Disk action will occur. The criteria parameter is specified by a minimum of three subparameters as follows:

operand1,operator,operand2)

where the operands can consist of an expression as defined below. The maximum number of subparameters allowed is controlled by sysparm VSCRIMAX. Because a SELECT CRITERIA= statement is already very restrictive, you cannot specify the VTOCS nor CATALOGS= parameters on the same SELECT statement. You can, however, add the DSNAMES=, COMPONENTS, TABLE=, VOLUMES=, VAMPOOL= or SGNAME= parameters.

For logical operators, you can specify any of the following:

EQ: Equal to
NE: Not equal to
LT: Less than
LE: Less than or equal to
GT: Greater than
GE: Greater than or equal to

For operands, you can specify any of the following:

Decimal number constants, such as 10 or 1000.
Date constants in any acceptable CA Disk format, such as 96200, 96.200, 96/200, 19JUL96, 07/19/96, 1996200, 1996.200, 19JUL1996, 1996/200 or 07/19/1996. If CA Disk has trouble differentiating between a digit Julian date constant, such as 96200, and a decimal number constant, it will issue an appropriate message and ask you to use another format.
Constant values TRUE, FALSE, YES, NO, ON or OFF. TRUE, YES, and ON are all-equivalent. FALSE, NO, and OFF are all-equivalent.
Any of the DSCL select criteria field names listed below.
Expressions that use addition (+) or subtraction (-) to combine a constant value with a field name or other constant value. For example, the expression TODAY-30 represents the date 30 days ago.

Note: SELECT CRITERIA only applies to data set level processing so it is not honored for volume processing as when command VREPORT is being used.