Filter
Top Products
Managing DB2 Databases with SMS 49
SCDBFAST This Storage Class is intended for table spaces belonging to
applications requiring performance. It provides high performance
and good availability.
SCDBCRIT This Storage Class is intended for table spaces belonging to
critical applications. It provides high performance and continuous
availability. SMS attempts to place these table spaces on disks
with dual copy or on RAID.
SCDBTEST This Storage Class is intended for environments with lower
requirements. Examples are test systems, development systems,
and data warehouse environments. These table spaces will have
average performance and average availability.
Table 12. SMS Storage Classes for DB2 Databases
6.1.4 SMS Management Class
Table 13 on page 50 shows three examples of Management Classes for DB2
table spaces. The purpose of these three Management Classes is to allow
different DFSMShsm specifications for DB2 table spaces and index spaces.
These Management Classes are:
MCDB20 This Management Class is intended for production table spaces
and table spaces that require average or higher availability. This
Management Class inhibits DFSMShsm migration of table
spaces.
MCDB21 This Management Class is intended for table spaces that are
allowed to migrate. This Management Class causes migration
after one week of inactivity; and after two weeks in level 1, the
table space will migrate to level 2. For example, this Management
Class can be used for Data Warehouse table spaces.
SCDBMED SCDBFAST SCDBCRIT SCDBTEST
DIRECT RESPONSE (MSEC) 10 5 5 20
DIRECT BIAS Yes
SEQUENTIAL RESPONSE (MSEC) 10 5 5 20
SEQUENTIAL BIAS
SUSTAINEDDATARATE(MB/sec)10202010
AVAILABILITY
a
a. Continuous=Duplexed or RAID Disk, Preferred=Array Disk, Standard=Array or Simplex Disk
Preferred Preferred Continuous Standard
ACCESSIBILITY
b
b. If a device with Concurrent Copy capability is desired, specify Continuous or Continuous Preferred
Standard Standard Standard Standard
GUARANTEED SPACE No No No No
GUARANTEED SYNCHRONOUS WRITE No No No No
CACHE SET NAME
CF DIRECT WEIGHT
CF SEQUENTIAL WEIGHT