Filter
Top Products
Managing DB2 Databases with SMS 59
6.2.3.1 Storage Classes
The following example Storage Classes can be used for Data Warehouse table
spaces:
• SCDBMED
• SCDBTEST
• SCDBFAST
6.2.3.2 Management Classes
The following example Management Classes can be used for Data Warehouse
table spaces:
• MCDB20
• MCDB21
• MCDB22
6.2.4 Development and Test Databases
Development and test databases are not essential for immediate business needs.
Their performance and availability requirements should not have priority over
production databases. Some customers with permanent development and test
database environments may have stricter requirements than those shown here.
Test environments used for performance and capacity testing may also have
stricter requirements.
6.2.4.1 Storage Classes
The following example Storage Classes can be used for development and test
table spaces:
• SCDBTEST
6.2.4.2 Management Classes
The following example Management Classes can be used for development and
test table spaces:
• MCDB21
• MCDB22
6.2.5 Summary
Table 17 on page 60 shows some examples of how the SMS Storage Classes and
Management Classes can be combined to provide for different database
requirements. In this table, the concepts of low, average, good, and high,
represent service levels agreed upon between the storage administrator and the
DB2 administrator. These examples are not meant to be exhaustive, but are
intended to provide an idea on how the SMS classes can be used to manage
table spaces in DB2 user databases.