The SET statement

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

Syntax


1  SET
2.1  COMMIT TO number
2.1  WORKSPACE TO
2.2.1+ ,
2.2.1 dbspace
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.

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;