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

<dbextract_statement> ::=
DBEXTRACT [<configurationstream_spec>] <catalogoutstream_spec> <dataoutstream_spec> [<packagestream_spec>] [<restart>]

You can also use the keywords EXTRACT DB instead of the keyword DATAEXTRACT.

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

The DBEXTRACT command combines the commands CATALOGEXTRACT ALL and TABLEEXTRACT ALL.

At least two data streams must be created when unloading:

• Data stream for the database catalog definitions <catalogoutstream_spec>
• Data stream for the application data <dataoutstream_spec>

The system table TRANSFORMATIONMODEL and other system tables are filled.

• Unless you specify the data stream <configurationstream_spec>, the entire database is unloaded.
• By specifying a data stream <configurationstream_spec>, you can exclude the application data of individual selected tables from the unload 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 unloaded is stored in the system tables. You can display these tables by displaying the system table TRANSFORMATIONPACKAGES. The tables excluded from the unload of the application data have the value TRUE in the column EXCLUDE.

• 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 are unloaded to the data streams <dataoutstream_spec> and <catalogoutstream_spec>.

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

You can use the corresponding DBLOAD command to restore the database catalog and the application data.

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