Altering a database

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

Authorities 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 database window.

  2. Type a new default buffer pool name for the table spaces within the database, or select a buffer pool name from the list. This does not apply to the table spaces already existing within the database. Remember that 32KB buffer pools apply only to table spaces. The buffer pool for table spaces can be the same as the buffer pool for indexes.

  3. Type a new default buffer pool for the indexes within the database, or select a buffer pool name from the list. This does not apply to indexes that already exist within the database. The buffer pool name must identify a 4KB buffer pool. The buffer pool for indexes can be the same as the buffer pool for table spaces.

  4. Type a new default storage group name, or select from the list. 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.

Related information: