//CONTROLS DD * CONFIG DEFAULT CONTINUE ON WARNING //SYSIN DD DSN=NALUR.ARY06243.S203505.M946620.EXECSQL, // DISP=(OLD,KEEP) //* ...................... ...................... 2.6 Recovering the entire subsystem You can use Recovery Expert for z/OS to recover a DB2 subsystem. You can choose to recover an entire operational subsystem, including the directory, catalog, and all application spaces, to a point-in-time or to current. Attention: This support is only available when you use DB2 for z/OS version 8 or later, and you use the RESTORE SYSTEM utility. For more information about the RESTORE SYSTEM utility, see DB2 UDB for z/OS V8 Utility Guide and Reference, SC18-7427. The recovery process for the entire subsystem is the same as for any DB2 object up to the Objects page in the Recovery Expert for z/OS GUI client. When on the Objects page, select the DB2 subsystem to recover. Selecting a DB2 subsystem is mutually exclusive with selecting any other DB2 objects: You cannot select it if you select any other DB2 objects, and you cannot select any other DB2 objects after selecting the DB2 subsystem. The recovery process proceeds the same as for any DB2 object. However, the generated recovery plan invokes the RESTORE SYSTEM utility to recover the entire DB2 subsystem to the selected point-in-time. Note: To use the RESTORE SYSTEM capability, ensure that one or more BACKUP SYSTEM utilities have been issued previously. In the following sections, we describe the process of recovering a non-data sharing system and a data sharing system. 2.6.1 Recovering a non-data sharing subsystem Before you start the recovery of a DB2 subsystem, you must have at least one instance of the execution of the BACKUP SYSTEM utility recorded in the bootstrap data set (BSDS). For this scenario, we assume that one or more BACKUP SYSTEM utilities are successfully issued and the Recovery Expert for z/OS agent is aware of the history of these utilities in the BSDS. You must meet the Data Facility Storage Management Subsystem (DFSMS) requirements for the DB2 system catalog, directory, and active logs to successfully use the BACKUP SYSTEM utility. Figure 2-135 on page 202 shows the DB8W subsystem selected for recovery in the navigation pane. In Figure 2-136 on page 203, specify the RBA to which to recover to (we assume that you have determined what this RBA must be based on some external source of information). Figure 2-137 on page 204 shows the generated recovery plan that has two jobs in it: One that creates a conditional restart entry in the BSDS, and the second job that performs the actual restore of the backup taken with the BACKUP SYSTEM utility. Figure 2-138 on page 205 lists the instructions that you must follow to perform a successful Chapter 2. User scenarios 201