DB2 Server for VSE & VM: Data Restore Guide


OPTIONS and CONTROL Statements

You can specify additional parameters for each of the Data Restore functions. Specify these parameters in the OPTIONS statement or the CONTROL statement.

The list of those parameters follows:

OPTIONS Statement Parameters

Figure 157. OPTIONS statement

>>-OPTIONS----+---------------------+---+-----------------+----->
              '-COMMITCOUNT=integer-'   '-WRKSIZE=integer-'
 
>-----+----------------------------+---------------------------->
      |                    .-1--.  |
      '-MSGCLASS=integer---+-2--+--'
 
>-----+-------------------------+---+---------------------+----->
      '-MSGDEV=integer---+-3-+--'   |          .-TAPE--.  |
                         +-1-+      '-DEVICE---+-DASD--+--'
                         '-2-'
 
>-----+---------------------+---+----------------------+-------->
      '-DEVICE2---+-TAPE-+--'   '-RESTARTCOUNT=integer-'
                  '-DASD-'
 
>-----+----------------+---+--------------------+--------------->
      |        .-M--.  |   |            .-E--.  |
      '-CASE---+-U--+--'   '-NOTATION---+-U--+--'
 
>-----+-----------------+---+---------------------+------------->
      '-NBVIEWS=integer-'   '-RECOVERY=--+-NO--+--'
                                         '-YES-'
 
>-----+-----------+---+--------------------+--+--------------+-->
      '-LANG=lang-'   '-CONFIRM=--+-NO--+--'  '-ARCHTYPE=DB2-'
                                  '-YES-'
 
>-----+-------------------------+---+-------------------+------><
      '-NBPASS=integer---+-2-+--'   '-REWIND=--+-YES-+--'
                         '-1-'                 '-NO--'
 

COMMITCOUNT
When the RELOAD or APPLYLOG function is invoked, this parameter executes a COMMIT WORK after the specified number of rows has been reloaded (no default value).

WRKSIZE
Available memory for the Data Restore feature to work, expressed in KB (default value is 2048KB for BACKUP function and 256KB for any other function). Take WKSIZE= NBP*5/1024 where NBP is the number of active pages of the database to be unloaded or backed up. If WKSIZE is not great enough Data Restore, at execution time, will send message XTS9-122 followed by XTS9-158 containing the value needed.

When reloading or restoring from an incremental backup, the WRKSIZE parameter must be equivalent to the value specified at backup time. Message XTS9-230 will display the required value.

MSGCLASS
1: All messages are displayed. This is the default.

2: Only error messages are displayed

MSGDEV
1: Messages are displayed on VSE SYSLOG or VM console

2: Messages are displayed on VSE SYSLST or VM SYSPRINT

3: Messages are displayed on both devices

DEVICE
TAPE: Archive on tape. This is the default.

DASD: Archive on disk

The following parameter, DEVICE2, is optional for the BACKUP or the UNLOAD function should the user want to perform a primary and a secondary backup of the archive in a single operation:

DEVICE2 For BACKUP Function

TAPE: A second archive copy is made on tape

DASD: A second archive copy is made on disk (ARCHIV2 must be specified in JCL or EXEC).

In the VM environment, this parameter only specifies that dual archiving is enabled. (It does not matter if the parameter is set to tape or DASD.) The FILEDEF for ARCHIV2 will determine whether tape or DASD output is created.

In the VSE environment, if tape is specified a TLBL ARCHIV2 must be defined. If DASD is specified, a DLBL must be specified for ARCHIV2.

DEVICE2 For RELOAD or RESTORE From an Incremental Backup File

TAPE: FULLARC TLBL must be specified for FULL backup file

DASD: FULLARC DLBL must be specified for FULL backup file

RESTARTCOUNT
When the RELOAD function is invoked, this parameter specifies how many rows will be skipped before reloading. This parameter is used for recovery after reload error, for that reason all reload cards in SYSIN must not be modified.

CASE

M: Mixed to display messages with lower and uppercase. This is the default.

U: Upper to display messages with upper case only, (for printers not supporting lower case).

LANG
To obtain Data Restore feature messages in a specific language, specify the National Language code on LANG parameter:
S001 - American English (AMENG). This is the default.
S002 - Upper case English
S003 - French
S004 - German
D001 - Japanese
D003 - Chinese

NOTATION

E: European: Numbers are displayed with point for thousand and comma for decimal. For example: 1.234.567,89. This is the default.

U: United States: Numbers are displayed with point for decimal and comma for thousand. For example: 1,234,567.89

RECOVERY

NO: No table recovery from log files is required. This is the default.

YES: The user wants to generate the file containing all modifications on reloaded tables from LOGS.

NBVIEWS
If the database contains many views (more than 200 for the reloaded tables) the user will specify the number of views estimated to recreate after RELOAD function (default value: 200).

CONFIRM
Only available in VM environment

YES: Before processing the function in SYSIN, Data Restore will prompt the operator to confirm the function to

NO: No confirmation for the process is required.

ARCHTYPE
DB2: The RELOAD function is to be processed directly from a standard DB2 Server for VSE & VM archive file.

NBPASS
For RELOAD processing from DB2 Server for VSE & VM archive indicates the number of reading passes.

2: For normal processing. This is the default.

1: can be specified on a Restart (for instance after a power failure) to avoid reading the DB2 Server for VSE & VM archive twice, only valid if the message XTS9-193: "Mount first tape of DB2 Server for VSE & VM archive" was previously received.

REWIND
For UNLOAD processing in VSE only, whether the output tape should be rewound during OPEN/CLOSE processing.

YES: Rewind during OPEN/CLOSE processing.

NO: Do not rewind during OPEN/CLOSE processing.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]