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 32 KB 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 4 KB 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.

  5. In the CCSID field, specify which of the compatible default coded character set identifiers (CCSIDs) you want to use. The available CCSIDs define either a Euro symbol or a codepoint such as the International Currency Symbol (ICS). All databases and all table spaces within an encoding scheme (EBCDIC or ASCII) should be altered at the same time. Once you have changed the value, you cannot alter this field again. See the DB2 UDB for OS/390 Version 6 Installation Guide for a table of compatible CCSIDs for both encoding schemes.

Related information: