START DATABASE is an executable command that can be issued interactively, embedded in a host language, or dynamically prepared.
To execute the START DATABASE command, users must possess either overall SYSADM, SYSCTRL for the location, DBADM authority on the database, or the STARTDB privilege for the database.
START DATABASE (database-name) [ACCESS (RW | RO)]
| database-name | Identifies the database to be started. |
Description
The START and STOP DATABASE commands are used primarily in conjunction with setting up and accessing Read Only Shared (ROSHARE) databases. A START DATABASE command must be issued after a STOP DATABASE command in order to make the tables in a ROSHARE database accessible to other locations.
The START DATABASE command is permanent until a STOP DATABASE command is executed, even if the user logs out or the Server is brought down. When a START DATABASE command is issued to start a database in RW mode, a value of "W" is placed in the IBMREQ column of the SYSIBM.SYSDATABASE table.
The ACCESS clause introduces either the default read-write (RW) option or the read-only (RO) option. ACCESS (RO) must be added to the START DATABASE command to start a ROSHARE database in read-only mode. Read-only mode allows users at other locations to directly read (select) data in the ROSHARE database.
ROSHARE database owners must issue a START DATABASE command (RW option default) before attempting to insert, update or delete records in the database.