DB2 Server for VSE & VM: Data Restore Guide

Data Restore SELECT

SELECT is a function of the Data Restore feature and allows you to select data from DB2 tables directly out of the dbextents, bypassing the database manager. With the Data Restore feature you can select tables while the database manager is online or offline.

Note:

The Data Restore SELECT function does not execute local date and time user exits, nor does it execute field procedures on the selected columns. Any table without LONG columns can be specified. This restriction is true even when the database manager is online.

Data Restore SELECT writes the selected data to the DATAUNL file in a format that the DBSU DATALOAD facility can use. To help with the use of the DBSU DATALOAD facility, DBSU control statements are written to SYSPRINT.

If SELECT is used when the database manager is online, the Data Restore feature requests an exclusive lock on the dbspace. This lock ensures that no one can update data while the Data Restore feature is processing the SELECT request.

Purpose

Data Restore SELECT allows you to retrieve data while the database manager is offline, for example due to a failure. This can be of help during error recovery if no backup of the data is available.

Note:

Do not rely upon this, because, for example, the ability to retrieve data from a defect disk is limited, as described in Recovery From a Logical Error.

Files

The Data Restore SELECT 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:

• DATAUNL - this file will contain the selected data when OUTPUT=TAPE/DASD is specified.