System Tables 

Definition

One important log function of the Loader is storing Loader-relevant information in system tables.

Use

When you install the database system, the following system tables are created for the Loader:

●     CODEPAGE

●     MAPSCHEMANAMES

●     TRANSFORMATIONMODEL

●     TRANSFORMATIONMONITOR

●     TRANSFORMATIONPACKAGES

●     TRANSFORMATIONRESOURCES

●     TRANSFORMATIONSTATISTICS

●     TRANSFORMATIONSTEPS

Structure

The database administrator is the owner of these system tables. The tables are generated in the SYSLOADER schema. You need to specify the schema to access these tables.

SELECT * FROM sysloader.transformationmodel
WHERE PACKAGEGUID = <package_guid>

The Loader logs information on the runtime responses of export and import processes in the TRANSFORMATION system tables. You can also configure a transformation using the system tables.

The Loader uses the entries in the system tables to restart commands. You can use this ability to restart by using the RESTART option of the command.

See also:

Restarting

Additional Log Functions (package_spec)