Filter
Top Products
Managing DB2 Databases with SMS 61
6.3.1.1 Storage Classes
The following example Storage Classes can be used for online production table
spaces:
• SCDBCRIT
6.3.1.2 Management Classes
The following example Management Class can be used for online production
table spaces:
• MCDB20
6.3.2 Work Database
All DB2 subsystems use table spaces in a Work database. For example, the Work
database stores an intermediate result of a query, or is the workarea for an
internal sort of a result table. To avoid contention with DB2 environments
requiring high performance, the table spaces in the Work database should not go
to the Storage Group where the high performance table spaces are placed
(SGFAST and SGCRIT).
The Work database only stores temporary data. If the Work database is lost, DB2
rebuilds its contents automatically on a restart, or manually with a START
DATABASE command. This should be adequate for most production
environments, no special availability requirements are necessary.
6.3.2.1 Storage Classes
The following example Storage Classes can be used for development and test
table spaces:
• SCDBMED
6.3.2.2 Management Classes
The following example Management Class can be used for development and test
table spaces:
• MCDB20
6.3.3 Summary
Table 18. DB2 System Database Requirements
Databases Performance Availability Migration Storage
Group
Catalog Good Very High NO SGDBCRIT
Directory Good Very High NO SGDBCRIT
Work Good Low NO SGDB20