ManagingDB2 Databaseswith SMS 59
6.2.3.1 Storage Classes
The followingexample Storage Classes can be used for Data Warehouse table
spaces:
• SCDBMED
• SCDBTEST
• SCDBFAST
6.2.3.2 Management Classes
The followingexample Management Classes can be used for Data Warehouse
table spaces:
• MCDB20
• MCDB21
• MCDB22
6.2.4 Development and TestDatabases
Developmentand test databases are not essential for immediate business needs.
Their performance and availabilityr equirements should not havepriori tyover
production databases. Some customers with permanent developmentand t est
database environments mayhave stricter requirements than those shown here.
Testenvironments used for performance and capacity testing may also have
stricter requirements.
6.2.4.1 Storage Classes
The followingexample Storage Classes can be used for developmentand test
table spaces:
• SCDBTEST
6.2.4.2 Management Classes
The followingexample Management Classes can be used for development and
test table spaces:
• MCDB21
• MCDB22
6.2.5 Summary
Table17 on page 60 shows some examples ofhow the SMS Storage Classes and
Management Classes can be combined to provide for differentdatabase
requirements. In thistable, the concepts of low, average, good, and high,
represent service levels agreedupon betweenthe 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 spacesin DB2 user databases.