IBM 5695-DF1 ユーザーズマニュアル
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.
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.
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.
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:
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.
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.
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
SUSTAINED DATA RATE (MB/sec)
10
20
20
10
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