DB2 Server for VSE & VM: Control Center Operations Guide for VM

Chapter 24. Data Restore LISTLOG

Overview

The Data Restore LISTLOG function produces a report of the Logical Units of Work (LUWs) contained in the database log archives and active log for all the tables that were listed in the SYSIN file for a RELOAD with RECOVERY = YES. The database administrator will use the LISTLOG report to decide which LUWs will be re-applied to the database during the APPLYLOG function.

Control Center provides the user interface to Data Restore's LISTLOG where this function can be executed against the database's current RELOAD work files on the Data Restore machine's 191 disk. Normally, Control Center will execute a LISTLOG as part of the RELOAD RECOVERY=YES operation.

How LISTLOG Works

During the RELOAD RECOVERY=YES function, Data Restore produces work files to record all LUWs found for the tables listed in the RELOAD SYSIN file. These files are kept on the Data Restore machine's 191 disk. The LISTLOG function will be executed, and the LISTLOG report will be sent to the Control Center service machine and the DBA listed in the NOTIFY option.

Control Center requires that LISTLOG can only be executed against the current RELOAD work files.

The LISTLOG function will stop reporting table LUWs when it encounters a DROP statement for any of the affected tables. This includes any DROP statements that are used during DBSPACE reorganizations. NO LUWs can be recovered after a TABLE DROP statement. Also, if tables are using referential integrity, the log records will include the original SQL statement, plus any cascade response required to maintain referential integrity. During APPLYLOG, all the LUWS will be recreated by Data Restore. If referential integrity is active during the APPLYLOG, you may get unexpected results.

How to Invoke

To invoke LISTLOG, the DBA will select Option LL from the Data Restore Menu for immediate or scheduled execution.

At execution time, the Data Restore machine will perform necessary FILEDEFS and LABELDEFS, create the SYSIN file, and execute the LISTLOG routine (XTS91001 MODULE). The LISTLOG SYSPRINT (database LISTLOG) will be sent to the Control Center service machine and the DBA.

The LISTLOG will later be used to determine LUWS to recover during the APPLYLOG function.

LISTLOG Control and OUTPUT files

The basic files created will be:

Filename

Description

dbmach LISTSYIN

The SYSIN file created on the Data Restore machine to execute the LISTLOG. This file contains the Data Restore commands and options to be executed, and additional information provided by Control Center.

dbmach LISTLOG

The output listing of the LISTLOG created by Data Restore. This file will list all the LUWS recorded in the work files for the current RELOAD RECOVERY= YES.

LISTLOG ERROR

If errors occur before, during, or after execution of the function on the Data Restore machine, the LISTLOG ERROR file will indicate the error type. If an error condition was detected during Control Center processing, then the name of the module and the approximate line number of the error will be presented. The ERROR file is sent to all database administrators listed in the specific database's PARMS file.

Input and Output Media Processing

No tapes file processing is required. LISTLOG will use the work files for the database on the Data Restore machine's 191 disk as input.

Passwords

LISTLOG requires that the database password for user SQLDBA be included in the 'DBAPW=' SYSIN file control statement.

A password file (drmach LINKPWDS) file is required. Refer to Password File Setup for the Data Restore machine for instructions on how to implement Data Restore password support.

How to Invoke LISTLOG

The first entry panel of the LISTLOG tool is shown in Figure 136. Here you will specify immediate or scheduled LISTLOG execution.

Figure 136. Data Restore LISTLOG Utility Menu

+--------------------------------------------------------------------------------+
| mm/dd/yyyy                     CONTROL CENTER                       hh:mm:ss   |
|*----------------------- Data Restore LISTLOG Utility -----------------------*  |
|| Option ==> ___________________                           CTRLID: MSTRSRV1  |  |
||                                                          NODE:   WMAVM1    |  |
||                                                          DRMACH: SQMRESTR  |  |
||                                                                            |  |
||  Database ===> SQLDBA                                                      |  |
||                                                                            |  |
||                                                                            |  |
||   I  Initiate LISTLOG      Initiate LISTLOG for current RELOAD RECOVERY    |  |
||   S  Schedule LISTLOG      Schedule LISTLOG for current RELOAD RECOVERY    |  |
||   V  View LISTLOG          View the current LISTLOG for the database       |  |
||                                                                            |  |
||                                                                            |  |
||                                                                            |  |
||                                                                            |  |
||                                                                            |  |
||                                                                            |  |
||                                                                            |  |
||                                                                            |  |
|*---------------------------------------------------------------DRLSTL1------*  |
|PF1 HELP        PF3 END        PF8 View Unload Describe    PF10 Execute         |
|                                                                                |
|                                                                                |
+--------------------------------------------------------------------------------+

LISTLOG Job Descriptions

Parameter

Description

I

Execute the LISTLOG immediately.

S

Schedule the LISTLOG function for a later time. You will be presented with a job scheduling panel.

V

View the current LISTLOG report. If your RELOAD RECOVERY=YES completed successfully, then the current LISTLOG report can be used for the APPLYLOG function.