DB2 Server for VSE & VM: Data Restore Guide

CONTROL Statement Parameters

Figure 158. CONTROL statement

.-DBNAME=dbname-. >>-CONTROL--+---------------+---+------------------------+------> '-BASE=dbname---' '-DATE=date---TIME=time--' >-----+-------------------+---+-------------+-------------------> | .-YES--. | '-DBAPW=dbapw-' '-VERIFY--+-NO---+--' >-----+----------------------+---+------------------------+---->< '-READPW=read password-' '-WRITEPW=write password-'

DBNAME

Dbname of database to process. This parameter is optional for the VSE environment (BASE is equivalent to DBNAME parameter).

DATE

Date of BACKUP.

This parameter must be specified when restoring from an archive that is not the last archive executed. The date format is provided by your system.

TIME

Time of BACKUP.

This parameter must be specified when restoring from an archive that is not the last archive executed. The time format is HH:MM:SS.

VERIFY

With VERIFY=YES parameter: if the parameter DBNAME on the CONTROL statement is different from the archive TAPE/DASD the RELOAD job terminates immediately. (default value).

With VERIFY=NO parameter: even if the parameter DBNAME on the CONTROL statement is different from the archive TAPE/DASD, the process continues.

DBAPW

RELOAD function needs DBA authority to execute all commands necessary to restore a table. A connect to SQLDBA is issued during processing. If SQLDBA user's password has changed between BACKUP and RELOAD function, the new password must be specified on CONTROL statement.

This parameter must be specified for SELECT and UNLOAD functions.

It will appear as asterisks on output for confidentiality reasons.

READPW

Data Restore links application server's minidisks during processing, if the minidisks are password protected, the READ password must be specified (VM only) for SELECT, UNLOAD, RELOAD and SHOWDBS functions (all minidisks must be defined with the same password).

WRITEPW

Data Restore links application server's minidisks during processing, if the minidisks are password protected, the WRITE password must be specified (VM only) for BACKUP and RESTORE functions (all minidisks must be defined with the same password).