DB2 Server for VSE & VM: Data Restore Guide

TRANSLATE

>>-TRANSLATE---------------------------------------------------><

Purpose

Use the TRANSLATE command to increase the performance when later restoring the complete database or parts of it from a DB2 archive.

The Data Restore feature command TRANSLATE can be used to increase the performance when later restoring the complete database or parts of it from a DB2 archive. TRANSLATE reads the DB2 archive tapes twice and creates tapes or disk files that can be used as input for the Data Restore RESTORE or RELOAD, as if it were a Data Restore archive made via Data Restore BACKUP. TRANSLATE improves the performance of the recovery operation.

TRANSLATE is required to Data Restore RESTORE from a DB2 database, or the database can be restored using the standard DB2 restore facility. For Data Restore RELOAD, TRANSLATE is optional.

The TRANSLATE process can be started at any time and does not affect the operation of your database manager. When this process should run depends on your environment:

• either immediately following the archive,
• or preceding the restore of either the database (RESTORE) or part of the database (RESTORE, RELOAD).

Files

The Data Restore TRANSLATE requires some input and output files:

For VM only:

• SYSIN file - contains the command to be processed.
• SYSPRINT file - Data Restore feature creates a report that lists the SYSIN values, messages and results.

  For VM and VSE:

• ARCHIV - workfile
• ARIARCH - input file from a DB2 archive
• LMBRWRK - workfile or cluster which contains pages for tables containing LONG columns.

  SYS0001, HEADER and DIRWORK will be used by a later RELOAD function.

• SYS0001 - workfile, stores active pages
• HEADER - workfile, stores header pages
• DIRWORK - workfile, stores the directory pages

Figure 159 is an example of a function report for the TRANSLATE function on a DB2 FULL archive.

Figure 159. Sample Report after Translation of a DB2 Server for VM FULL Archive

XTS9-143 TRANSLATE XTS9-143 /* XTS9-196 Do you want to continue the TRANSLATE process ? XTS9-406 ENTER 0(CANCEL) OR 1(CONTINUE) XTS9-403 REPLY IS 1 XTS9-100 DATA RESTORE FEATURE VERSION 7.1.0 --> XTS9-229 The file is a DB2 FULL archive XTS9-193 Mount first tape of a database server archive XTS9-406 Enter 0(CANCEL) or 1(CONTINUE) XTS9-403 REPLY IS 1 XTS9-013 TABLE SQLDBA .ACTIVITY MAY BE RELOADED XTS9-013 Table SQLDBA .DEPARTMENT MAY BE RELOADED XTS9-007 Processing successfully completed

Figure 160 is an example of a function report for the TRANSLATE function on a DB2 regular archive.

Figure 160. Sample Report after Translation of a DB2 Server for VM Regular Archive

XTS9-143 TRANSLATE XTS9-143 /* XTS9-196 Do you want to continue the TRANSLATE process ? XTS9-406 ENTER 0(CANCEL) OR 1(CONTINUE) XTS9-403 REPLY IS 1 XTS9-100 DATA RESTORE FEATURE VERSION 7.1.0 --> XTS9-229 The file is a DB2 regular archive XTS9-193 Mount first tape of a database server archive XTS9-406 Enter 0(CANCEL) or 1(CONTINUE) XTS9-403 REPLY IS 1 XTS9-013 TABLE SQLDBA .ACTIVITY MAY BE RELOADED XTS9-013 Table SQLDBA .DEPARTMENT MAY BE RELOADED XTS9-007 Processing successfully completed

Notes:

1. The translate process reads DB2 Server for VM database archive tapes twice.

2. When the message XTS9-193 is displayed you have to remount the archive tapes beginning with the first archive tape.

3. You can restore the whole database from the translated DB2 Server for VM database archive, as well as restoring parts of the database.