You can use this Loader command to control the unloading of the entire database catalog or parts of it.
THE CATALOGEXTRACT ALL command can only be executed by the database system administrator (SYSDBA user).
<catalogextract_command> ::= CATALOGEXTRACT <part_spec> <outstream_spec>
You can also use the keywords EXTRACT CATALOG instead of the keyword CATALOGEXTRACT.
·
CATALOGEXTRACT
ALL
The outstream_spec data stream
contains all the commands for creating a database session and SQL statements
for data definition that are required for the definition of the entire
database catalog.
You can use external backup tools
to unload data.
·
CATALOGEXTRACT
USER
The outstream_spec data stream contains all the commands for creating a
database session and SQL statements for data definition that are required for
the definition of the parts of the database catalog that belong to the
specified user.
·
CATALOGEXTRACT
TABLE
The specified table is a basis table. The user is the owner of this table.
The outstream_spec data stream contains all the SQL statements for data
definition that are required for the definition of the table and the database
catalog objects connected to it.
During unloading, the outstream_spec data stream is created for the database catalog definitions.
The system table TRANSFORMATIONMODEL and other system tables are filled.
The desired parts of the database catalog are unloaded to the outstream_spec data stream.
You can use the corresponding CATALOGLOAD command to restore these database catalog objects.
Errors
The unload process cannot be successfully completed. In this case, the Loader logs the cause of the error in the log file.
The values PACKAGEGUID and CLIENTNODE are also written to the log file.