STOP DATABASE

The STOP DATABASE command restricts all access to the named database.

Restriction: This topic applies to Windows environments only.

Invocation

STOP DATABASE is an executable command that can be issued interactively, embedded in a host language, or dynamically prepared.

Authorization

To execute the STOP DATABASE command, users must possess either overall SYSADM or SYSCTRL authority for the location, DBADM authority on the database, or the STOPDB privilege for the database.

Syntax

STOP DATABASE (database-name)

Parameters:

database-name

Identifies the database to be stopped.

Description

The STOP and START DATABASE commands are used primarily in conjunction with setting up and accessing Read Only Shared (ROSHARE) databases. A STOP DATABASE command must be issued on the "dummy" database before the owner of the physical (ROSHARE) database can create or alter tables. A STOP command must also be issued against the physical database and all related dummy databases before the ROSHARE database owner can drop tables.

The STOP DATABASE command can also be used by any database owner to restrict access (of any kind) to the database -- perhaps before a backup operation. Users must remember to issue a START command on the "stopped" database, when normal access is desired.