With this SAP DB Loader command, you can control the loading of application data and the database catalog.

<dbload_statement> ::=
DBLOAD [<configurationstream_spec>] <cataloginstream_spec> <datainstream_spec> [<packagestream_spec>] [<restart>]

You can also use the keywords LOAD DB instead of the keyword LOAD DB.

THE DBLOAD command can only be executed by the SYSDBA user.

You have unloaded the database catalog and its content with the DBEXTRACT command.

The DBLOAD command combines the commands CATALOGLOAD ALL and TABLELOAD ALL.

At least two data streams are required when loading:

• Data stream for the database catalog definitions <cataloginstream_spec>
• Data stream for the application data <datainstream_spec>

The system table TRANSFORMATIONMODEL and other system tables are filled.

• Unless you specify the data stream <configurationstream_spec>, all of the data contained in the data streams <cataloginstream_spec> and <datainstream_spec> are loaded.
• By specifying a data stream <configurationstream_spec>, you can exclude the application data of individual selected tables from the load process. The tables must be specified in the data stream by the specification of their owner and the table name.
  The information about which tables were not loaded is stored in the system tables. You can display these tables by displaying the system table TRANSFORMATIONPACKAGES. The tables excluded from the loading of the application data have the value TRUE in the column EXCLUDE.

The database catalog entries for the tables contained in <cataloginstream_spec> are always loaded, irrespective of possible restrictions of the data stream.

Differentiate between the following variants when making the required specifications in the data stream <configurationstream_spec>, depending on the medium from which you are loading the data streams:

• Variant 1: Loading from a file (FILE)
  The data stream must contain entries for the positions of table data that is to be excluded from the load process. You can find this information in the specifications for the data stream <packagestream_spec> of the corresponding DBEXTRACT command.
• Variant 2: Loading using a pipe (PIPE)
  The tables specified in the data stream are excluded from the transformation.

• The system tables are not unloaded unless you specify <packagestream_spec>.
• By specifying a data stream <packagestream_spec>, all entries of the table TRANSFORMATIONMODEL are unloaded to this data stream.

The application data and the database catalog definitions are loaded using the data streams <datainstream_spec> and <cataloginstream_spec>.

If necessary, all entries of the table TRANSFORMATIONMODEL are unloaded in the data stream <packagestream_spec>.

The load process cannot be successfully completed. In this case, the SAP DB Loader logs the cause of the error in the log file.