Data Set Options for Relational Databases

BL_DB2UNITCOUNT= Data Set Option

Specifies the number of volumes on which data sets can be extended.

Default value:	none
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS Support:	DB2 under z/OS

Syntax
Syntax Description
Details
See Also

Syntax

BL_DB2UNITCOUNT=number-of-volumes

Syntax Description

number-of-volumes: specifies the number of volumes across which data sets can be extended. It must be an integer between 1 and 59. This option is ignored if the value is greater than 59. See the details in this section.

Details

This option applies only to the input file (BL_DB2REC data set), which is the file that must be loaded into the DB2 table.

You must specify an integer from 1-59 as a value for this option. This option is ignored if the value is greater than 59. However, the value depends on the unit name in BL_DB2DEVT_PERM=. At the operating environment level an association exists that defines the maximum number of volumes for a unit name. Ask your storage administrator for this number.

An error is returned if you specify a value for this option that exceeds the maximum number of volumes for the unit.

The data class determines whether SMS-managed data sets can be extended on multiple volumes. When you specify both BL_DB2DATACLAS= and BL_DB2UNITCOUNT=, BL_DB2UNITCOUNT= overrides the unit count values for the data class.

For sample code, see the BL_DB2STORCLAS= Data Set Option.