Starting and Stoping DB2 Databases

Starting DB2 Databases:

RW - Allows programs to read from and write to the database.
RO - This Read Only.
UT - This access code only allows access to this database by DB2 utility programs.
FORCE - This option is seldom used, as it does not generate database integrity.

Stoping DB2 Databases

STOP DATABASE (*) - stops all database which you have the authority to stop.
STOP DATABASE(database name)

stops the one database specified.

STOP DATABASE(DATABASE NAME) PART(N)

stops a particular database partition.

STOP DB(database name) SPACE(tablespace name)

stops the specified TS.