Starting and Stopping a Database Instance 

Use

If the database instance is in the ONLINE operational state, database users with the requisite authorizations can execute operations in the database instance, e.g. define, change and display data, as well as create, change and delete database users, etc.

Administration tasks for the database instance are carried out by DBM operators using the Database Manager. This involves executing DBM commands. The majority of these commands must be executed in the ONLINE operational state. If DBM commands require the database instance to be in the OFFLINE or ADMIN operational state, this is explicitly specified in the command description under “Prerequisites”.

To read the prerequisites for starting and stopping the database instance, see Database Manager CLI, db_online, db_offline

Procedure

Start the database instance (transfer to the ONLINE operational state)

Call the Database Manager CLI, log on as operator DBM with the password DBM, connect to the database instance DEMODB, transfer to the ONLINE operational state:

>dbmcli –u DBM,DBM –d DEMODB db_online

OK

Stop the database instance (transfer to the OFFLINE operational state)

Call the Database Manager CLI, log on as operator DBM with the password DBM, connect to the database instance DEMODB, transfer to the OFFLINE operational state:

>dbmcli –u DBM,DBM –d DEMODB db_offline

OK

Display the current operational state of the database instance

Call the Database Manager CLI, log on as operator DBM with password DBM, connect to the database instance DEMODB, display the operational state of the database instance:

>dbmcli –u DBM,DBM –d DEMODB db_state

OK

OFFLINE