58 Storage Management with DB2 for OS/390
6.2.1 Online Production Databases
The databases used in production normally contain important data and have
special availabilityand security requirements. Performance may become a critical
issue, if the databases are used in an online environment.
Because online production databases containimpor tant data, the DB2 Database
Administrators typicallymonitor them very frequently. These databases are
sometimes placed on specific disks to manage the data individually.These
databases should not be mixed on adisk with other high activity databases or
data sets.
6.2.1.1 Storage Classes
The followingexample Storage Classes can be used for online production table
spaces:
• SCDBMED
• SCDBFAST
• SCDBCRIT
6.2.1.2 Management Classes
The followingexample Management Class can be used for online production
table spaces:
• MCDB20
6.2.2 Batch ProductionDatabases
Most production databases are accessed both in batch and online. In this case,
the more restrictiverequirement for online databases should be applied to the
batch environment. Thisdes criptionapplies only to databases exploited in a
batch environment.
6.2.2.1 Storage Classes
The followingexample Storage Classes can be used for batch production table
spaces:
• SCDBMED
• SCDBFAST
6.2.2.2 Management Classes
The followingexample Management Classes can be used for batch production
table spaces:
• MCDB20
• MCDB21
• MCDB22
6.2.3 Data Warehouse Databases
Data Warehousedatabases contain a special type of production data. Their
requirement is normally more oriented to usability and end user access. The end
users expects performanceto be r easonable(and this is a subjective matter),
and the same applies to availability.Some customers run applications in their
Data Warehouse environment,and their requirements could become similar to
batch or evenonline production.