Filter
Top Products
48 Storage Management with DB2 for OS/390
Figure 14. Display a Data Class
Figure 15. Data Class DCDB2
6.1.3 SMS Storage Class
Some DB2 installations may use only one Storage Class for DB2, but in others,
the DB2 administrators may require several Storage Classes for DB2 table
spaces. Table 12 on page 49 shows four examples. These are:
SCDBMED This Storage Class is intended for the majority of table spaces. It
provides good performance and good availability.
DATA CLASS APPLICATION SELECTION
Command ===>
To perform Data Class Operations, Specify:
CDS Name . . . . . . 'ACTIVE'
(1 to 44 character data set name or 'Active' )
Data Class Name . . DCDB2 (For Data Class List, fully or partially
specified or * for all)
Select one of the following options :
2 1. List - Generate a list of Data Classes
2. Display - Display a Data Class
3. Define - Define a Data Class
4. Alter - Alter a Data Class
If List Option is chosen,
Enter "/" to select option Respecify View Criteria
Respecify Sort Criteria
Data Class Name : DCDB2
Description : DATA CLASS FOR DB2 TABLESPACES
Recorg . . . . . . . . . : LS
Recfm . . . . . . . . . :
Lrecl . . . . . . . . . :
Keylen . . . . . . . . . :
Keyoff . . . . . . . . . :
Space Avgrec . . . . . . : M
Avg Value . . . . : 1
Primary .....:1
Secondary . . . . : 1
Directory . . . . :
Retpd Or Expdt . . . . . :
Volume Count . . . . . . : 1
Add'l Volume Amount . :
Imbed . . . . . . . . . :
Replicate . . . . . . . :
CIsize Data . . . . . . : 4096
% Freespace CI . . . . . :
CA.....:
Shareoptions Xregion . . : 3
Xsystem . . : 3
Compaction . . . . . . . :