Filter
Top Products
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 availability and security requirements. Performance may become a critical
issue, if the databases are used in an online environment.
Because online production databases contain important data, the DB2 Database
Administrators typically monitor them very frequently. These databases are
sometimes placed on specific disks to manage the data individually. These
databases should not be mixed on a disk with other high activity databases or
data sets.
6.2.1.1 Storage Classes
The following example Storage Classes can be used for online production table
spaces:
• SCDBMED
• SCDBFAST
• SCDBCRIT
6.2.1.2 Management Classes
The following example Management Class can be used for online production
table spaces:
• MCDB20
6.2.2 Batch Production Databases
Most production databases are accessed both in batch and online. In this case,
the more restrictive requirement for online databases should be applied to the
batch environment. This description applies only to databases exploited in a
batch environment.
6.2.2.1 Storage Classes
The following example Storage Classes can be used for batch production table
spaces:
• SCDBMED
• SCDBFAST
6.2.2.2 Management Classes
The following example Management Classes can be used for batch production
table spaces:
• MCDB20
• MCDB21
• MCDB22
6.2.3 Data Warehouse Databases
Data Warehouse databases contain a special type of production data. Their
requirement is normally more oriented to usability and end user access. The end
users expects performance to be reasonable (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 even online production.