Altering Db2 databases
You can alter a Db2 database by changing the description of a database at the current server.
Procedure
To change clauses that are used to create a database:
Issue the ALTER DATABASE statement.
It
supports changing the following attributes of a database:
- STOGROUP
- Use this option to change the name of the default storage group to support disk space requirements for table spaces and indexes within the database. The new default Db2 storage group is used only for new table spaces and indexes; existing definitions do not change.
- BUFFERPOOL
- Use this option to change the name of the default buffer pool for table spaces and indexes within the database. Again, it applies only to new table spaces and indexes; existing definitions do not change.
- INDEXBP
- Use this option to change the name of the default buffer pool for the indexes within the database. The new default buffer pool is used only for new indexes; existing definitions do not change.