DB2 Server for VSE & VM: Data Restore Guide

RELOAD



>>-RELOAD----CREATOR=creator---TNAME=tname---------------------->
 
>-----+--------------------+---+----------------+--------------->
      '-NEWCREATOR=creator-'   '-NEWTNAME=tname-'
 
>-----+-------------+---+---------------------+----------------->
      '-OWNER=owner-'   '-DBSPACE=dbspacename-'
 
>-----FUNCT=--+-NEW-----+--------------------------------------><
              +-ADD-----+
              '-REPLACE-'

Purpose

Use the RELOAD command to reload tables.

Operands

RELOAD
Executes a reload of a table.

FUNCT
Specifies the reload option to use:

PURGE
Deletes all rows from the table NEWCREATOR.NEWTNAME and restores all the rows from the table CREATOR.TNAME into it.

NEW
Creates the table NEWCREATOR.NEWTNAME and restores all the rows from CREATOR.TNAME into it.

ADD
Inserts all the rows from CREATOR.TNAME into the table NEWCREATOR.NEWTNAME.

REPLACE
Drops and recreates the table NEWCREATOR.NEWTNAME, restores all the rows from the table CREATOR.TNAME into it, and recreates all the indexes, referential integrity, views, grants, comments and labels.
Note:This option creates the table even if the table did not exist previously.

TNAME
Specifies the name of the table to be restored.

CREATOR
Specifies the creator of the table to be restored.

NEWTNAME
Specifies a new table name, in case you want to reload a table with a different name.

NEWCREATOR
Specifies a new creator for the table, in case you want to reload a table with a different creator.

The CREATOR.TNAME table is reloaded into NEWCREATOR.NEWTNAME.

If you do not specify these optional parameters, Data Restore uses TNAME for NEWTNAME and CREATOR for NEWCREATOR, so the table will be reloaded with the same name.

DBSPACE
Specifies the name of the dbspace which will contain the table to be restored. This parameter must be specified for FUNCT=NEW and FUNCT=REPLACE. If the table CREATOR.TNAME exists, the default value for the parameter is the name of the dbspace where this table resides.

OWNER
Specifies the owner of the dbspace which contains table to be restored. If you do not specify an owner, PUBLIC is assumed. This parameter must be specified for private dbspaces.

Usage Notes

  1. If the table to be reloaded contains a LONG column, a file called LMBRWRK is created and used as a workfile. LMBRWRK contains all of the data pages of the dbspace containing the table with LONG columns.
  2. If the first character on the SYSIN card is *, the card not used. The SYSIN is displayed on the PRINTER.
  3. An OPTIONS statement can also be specified (for more information see OPTIONS and CONTROL Statements).
  4. To reload more than one table, specify more RELOAD functions in SYSIN (up to 90 tables can be reloaded in one SYSIN).
  5. To list the tables that can be reloaded from a BACKUP or UNLOAD file, use the DESCRIBE function (refer to Chapter 13, Displaying the Contents of an Archive File for details).

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