DB2 Server for VSE & VM: Data Restore Guide

UNLOAD

.-,-------------. V | >>-UNLOAD---DBSPACE=(--+----dbspacename---+-+---)---------------> '-*------------------' >-----+---------------------+---+---------------------+-------->< '-COND=--+-INCLUDE-+--' '-MODE=--+-ONLINE--+--' '-EXCLUDE-' '-OFFLINE-'

Purpose

The UNLOAD command unloads dbspaces to an output file.

Operands

DBSPACE=

Identify the list of dbspaces to unload.

dbspacename

Identify the names of dbspaces to process (default value for owner is PUBLIC).

*

Identify that all dbspaces are included in the list. To unload a specific dbspace, enter the name of the dbspace. To unload several dbspaces at the same time, enter the list of dbspace names separated by a comma.

COND=

Identify whether the list of dbspaces is to be included or excluded for unloading.

INCLUDE

Specify that the list identifies those dbspaces that are to be included in unloading. This is the default.

EXCLUDE

Specify that the list identifies those dbspaces that are to be excluded in unloading.

MODE=

Identify whether the application server is running or not during the UNLOAD process.

ONLINE

Specify that the application server is up.

OFFLINE

Specify that the application server is down.

Usage Notes

The UNLOAD command can include up to 90 dbspace names on a maximum of 10 SYSIN lines. In VSE, the REWIND parameter on the OPTIONS line, can be used to specify whether the output tape should be positioned (REWIND=YES) on not (REWIND=NO). In VM, you can use the LEAVE parameter on the FILEDEF for the output file to achieve the same results.