Altering a database

A database is a set of DB2 structures. Use the Alter Database window to alter the attributes of a selected data base within your current subsystem. The name of the data base that you are altering is shown in the top left of the window, along with the subsystem name.

Authorizations and privileges

To alter a database:

You can change the buffer pool, the storage group, or the shared status of the database.

  1. Open the Alter data base window.

  2. Specify a new default buffer pool name. This will be the default buffer pool for the table spaces and indexes within the database; not the table spaces and indexes already existing within the database. Remember that 32KB buffer pools apply only to table spaces. If a 32KB buffer pool name is specified, the default buffer pool for indexes in the database is BP0.

  3. Specify a new default storage group name. This STOGROUP name is the name of the storage group to be used as a default storage group to support DASD space requirements for table spaces and indexes within the database. Not the table spaces and indexes already existing with the database.

  4. Select the radio button that describes whether or not the database is to be shared with other DB2 subsystems using shared read-only data. This selection is NOT valid if the database was defined with ROSHARE READ, or if the database is a system database. The first selection, OWNER, means that the database is shared, and the current server is the DB2 that can update the database. The second selection, NONE, means that the database is not shared.

  5. Click OK to alter the data base.

Related information: