The SET Statement

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Other Data Restore Utilities > Restoring Table-level Data > The archecker Schema Reference >

The SET Statement

The SET statement controls the different features in the table-level unload library.

Syntax

>>-SET--+-COMMIT TO--number------------------+-----------------><
        |               .-,----------------. |
        |               V                  | |
        '-WORKSPACE TO----+-dbspace------+-+-'
                          |         (1)  |
                          '-dbslice------'

Notes:

Extended Parallel Server Only

Element	Description
number	Sets the number of records to insert before committing during a physical restore. The default is 1000.
dbspace	The dbspaces to use for the working storage space. The default is the root dbspace. You cannot use temporary dbspaces for the working storage space.
dbslice	The dbslices to use for the working storage space.

The archecker utility creates several tables for the staging of logical log records during a logical restore. These tables are created in the sysutils database and stored in the working storage space.

Examples

SET COMMIT TO 20000;
SET WORKSPACE to dbspace1;