Starting databases

The privilege can be explicitly granted, or it can belong implicitly to a level of authority (DBMAINT and above). The command starts the database, but not necessarily all the objects that it contains. Any table spaces or index spaces in a restricted mode remain in a restricted mode and are not started.

The START DATABASE (*) command does not start the Db2 directory (DSNDB01), the Db2 catalog (DSNDB06), or the Db2 work file database (called DSNDB07, except in a data sharing environment). Start these databases explicitly by using the SPACENAM option. Also, the START DATABASE (*) command does not start table spaces or index spaces that have been explicitly stopped by the STOP DATABASE command.

Use the PART keyword of the START DATABASE command to start the individual partitions of a table space. It can also be used to start individual partitions of a partitioning index or logical partitions of a nonpartitioning index. The started or stopped state of other partitions is unchanged.

The START DATABASE and STOP DATABASE commands can be used with the SPACENAM and PART options to control table spaces, index spaces, or partitions.