DB2 graphic  QMF Version 8

Managing data sets

The data sets for the table spaces and indexes might be user or DB2 managed. How these data sets are managed determines what you must do to enlarge table spaces and indexes.

Storage groups for DB2 managed data sets

A storage group is a named set of DASD volumes from which space can be drawn for the objects that the storage group supports. For each control table with an index, the index and the table space share a common storage group, as Table 37 indicates.

Workstation database server users: Storage groups do not apply.

Table 37. Control table storage groups
Table Table space Storage group
Q.PROFILES DSQTSPRO DSQSGPRO
Q.ERROR__LOG DSQTSLOG DSQSGLOG
Q.OBJECT__DIRECTORY DSQTSCT1 DSQSGCT1
Q.OBJECT_REMARKS DSQTSCT2 DSQSGCT2
Q.OBJECT__DATA DSQTSCT3 DSQSGCT3

VSAM clusters for user managed data sets

You need a VSAM cluster for each table space and each index to manage the control-table data sets. You define these clusters using VSAM statements, and link the resulting clusters to DB2 with SQL CREATE queries. The link between a cluster and its DB2 object is in the name of the cluster and the name of the ICF (Integrated Catalog Facility) in which the cluster is cataloged.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004