Operation and recovery

Db2 provides useful processes to help you operate and recover Db2.

Controlling Db2 operations by using commands
You can control most aspects of the operational environment by issuing commands. For most commands, Db2 issues output in the form of messages. Db2 also issues system messages for other situations. To operate and recover Db2 successfully, you must know how to issue commands and retrieve and interpret command output messages and system messages.
Starting and stopping Db2
You start and stop Db2 by using the START DB2 and STOP DB2 commands.
Submitting work to Db2
Application programs that run under TSO, IMS, or CICS® can use Db2 resources by executing embedded SQL statements or Db2 and related commands.
Scheduling administrative tasks
The administrative task scheduler runs tasks that are defined in a task list according to a requested schedule. Tasks can be stored procedures or JCL jobs.
Monitoring and controlling Db2 and its connections
You can control and monitor various aspects of a Db2 for z/OS environment. These operations require you to have more of an understanding of what Db2 is doing.
Monitoring and controlling Db2 by using profile tables
You can create profiles to monitor and control various aspects of a Db2 subsystem in specific application contexts, especially for remote applications that use TCP/IP connectivity to access Db2 for z/OS.
Managing the log and the bootstrap data set
The Db2 log registers data changes and significant events as they occur. The bootstrap data set (BSDS) contains information about the data sets that contain the log. You can perform a variety of tasks to ensure that Db2 logging satisfies the needs of your environment.
Restarting Db2 after termination
When you need to restart Db2 after Db2 terminates normally or abnormally, keep in mind these considerations, which are important for backup and recovery, and for maintaining consistency.
Maintaining consistency across multiple systems
Data consistency issues arise when Db2 acts in conjunction with other systems, such as IMS, CICS, or remote database management systems (DBMSs).
Backing up and recovering your data
Db2 supports recovering data to its current state or to an earlier state. You can recover table spaces, indexes, index spaces, partitions, data sets, and the entire system. Developing backup and recovery procedures at your site is critical in order to avoid costly and time-consuming loss of data.
Reading log records
Reading Db2 log records is useful for diagnostic and recovery purposes.