BL_DB2STORCLAS= Data Set Option

Specifies a storage class for a new SMS-managed data set.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	none
Requirement:	To specify this option, you must first set BULKLOAD=YES.
Data source:	DB2 under z/OS
See:	BL_DB2DATACLAS= data set option, BL_DB2DEVT_PERM= data set option, BL_DB2MGMTCLAS= data set option, BL_DB2UNITCOUNT= data set option, BULKLOAD= data set option

Syntax

Details

Example

Syntax

BL_DB2STORCLAS=storage-class

Details

A storage class contains the attributes that identify a storage service level that SMS uses for storage of the data set. It replaces any storage attributes that you specify in BL_DB2DEVT_PERM=.

This option applies to the control file (BL_DB2IN), the input file (BL_DB2REC), and the output file (BL_DB2PRINT) for the bulk loader. Use this option to specify a management class for a new SMS-managed data set. If SMS is not installed or active, the operating environment ignores any storage class that BL_DB2MGMTCLAS= passes. Your site storage administrator defines the storage class names that you can specify when you use this option.

Example: Generate SMS-Managed Control and Data Files

This example generates SMS-managed control and data files. It does not create the table, and you need not run the utility to load it.

libname db2lib db2 ssid=db2a;
data db2lib.customers (bulkload=yes
      bl_db2ldext=genonly
      bl_db2in='testuser.sysin'
      bl_db2rec='testuser.sysrec'
      bl_db2tblxst=yes
       bl_db2ldct1='REPLACE'
      bl_db2dataclas='STD'
      bl_db2mgmtclas='STD'
      bl_db2storclas='STD');
set work.customers;
run;