Data Set Options for Relational Databases |
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 |
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.
See Also |
BL_DB2DATACLAS= Data Set Option
BL_DB2DEVT_PERM= Data Set Option
BL_DB2MGMTCLAS= Data Set Option
BL_DB2STORCLAS= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.