Starting an object with a specific status
You can start a database, table space, or an index space with a specific status that limits access to the object.
About this task
Objects can have the following status:
- Status
- Provides this access
- RW
- Read-write. This is the default value.
- RO
- Read-only. You cannot change the data.
- UT
- Utility-only. The object is available only to the Db2 utilities.
- RREPL
- Read-or-replication-only. The object is available as read-only unless the program is identified as a replication program.
Databases, table spaces, and index spaces are started with RW status when they are created. You can make any of them unavailable by using the STOP DATABASE command. Db2 can also make them unavailable when it detects an error.
Procedure
To
start objects that have a specific status:
In cases when the object was explicitly stopped, you can
make it available again by issuing the START DATABASE command.
Example
For example, the following command starts all table spaces
and index spaces in database DSN8D13A for
read-only access:
-START DATABASE (DSN8D13A) SPACENAM(*) ACCESS(RO)The system responds with this message:
DSN9022I - DSNTDDIS '-START DATABASE' NORMAL COMPLETION