Database Alter Option

The Database Alter screen performs all functions of the ALTER DATABASE statement. The alter statement changes the definition of a database and can be used to change all the parameters used initially to create the database, except for the Database Name and Creator ID. For more information about the fields on this screen, see the online help.
carcudb2
The Database Alter screen performs all functions of the ALTER DATABASE statement. The alter statement changes the definition of a database and can be used to change all the parameters used initially to create the database, except for the Database Name and Creator ID. For more information about the fields on this screen, see the online help.
After you make changes, press PF3 and a confirmation screen appears where you can accept, edit, or reject the DDL. To alter or change a database name or creator ID, you can use RC/Alter or CA RC/Migrator.
When changing the database Roshare field from Owner to None or None to Owner, RC/Alter will generate the correct VSAM alters for any user defined tablespace or index. The alter statements change the share options parameter of the data set. This parameter must be SHAREOPTION(1,3) for shared objects. RC/Alter does not fully support a read to owner or owner to read alter in the Roshare field. Users must stop and start the databases. For more information about altering the ROSHARE option of a database, see the IBM
DB2 Administrative Guide, Volume 2
.