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 32 KB buffer pools apply only to table spaces. If a 32 KB 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. 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 for OS/390 Version 5 Installation Guide for a table of compatible CCSIDs for both encoding schemes.

  6. Click OK to alter the data base.

Related information: