ManagingDB2 Databaseswith SMS 61
6.3.1.1 Storage Classes
The followingexample Storage Classes can be used for online production table
spaces:
• SCDBCRIT
6.3.1.2 Management Classes
The followingexample Management Class can be used for online production
table spaces:
• MCDB20
6.3.2 Work Database
AllDB2 subsystems use table spaces in a Work database. For example, theWork
database stores an intermediate result of a query,or is the workareafor an
internal sort of a result table. Toavoid contention with DB2 environments
requiring high performance,the t ablespaces in theWork database should not go
to the Storage Group where the high performance table spaces are placed
(SGFASTand SGCRIT).
The Workdatabase only stores temporary data. If the Work database is lost, DB2
rebuilds itscontents automatically on a restart, or manually with a START
DATABASE command. This should be adequate for most production
environments, no special availabilityrequirements are nec essary.
6.3.2.1 Storage Classes
The followingexample Storage Classes can be used for developmentand test
table spaces:
• SCDBMED
6.3.2.2 Management Classes
The followingexample Management Class can be used for development and test
table spaces:
• MCDB20
6.3.3 Summary
Table18. DB2System DatabaseRequirements
Databases Performance Availability Migration Storage
Group
Catalog Good VeryHigh NO SGDBCRIT
Directory Good VeryHigh NO SGDBCRIT
Work Good Low NO SGDB20