dbexport and dbimport command usage

The dbexport and dbexport commands are described in migration.pdf

dbexport

Usage:
 dbexport <database> [-X] [-c] [-q] [-d] [-ss]
  [{ -o <dir> | -t <tapedev> -b <blksz> -s <tapesz> [-f <sql-command-file>] }]
  NOTE: arguments to dbexport are order independent.
Element Purpose
-X Recognizes HEX binary data in character fields
-c Makes dbexport complete exporting unless a fatal error occurs
-q Suppresses the display of error messages, warnings, and generated SQL data-definition statements
-d Makes dbexport export simple-large-object descriptors only, not simple-large-object data
-ss Generates database server-specific information for all tables in the specified database
-o dir Names the directory on disk in which dbexport creates the database.exp directory

dbimport

Usage:
 dbimport <database> [-X] [-c] [-q] [-d <dbspace>]
  [-l [{ buffered | <log-file> }] [-ansi]]
  [{ -i <dir> | -t <tapedev> [ -b <blksz> -s <tapesz> ] [-f <script-file>] }]
  NOTE: <log-file> must be a complete path
        arguments to dbimport are order independent
Element Purpose
-X Recognizes HEX binary data in character fields
-c Instructs dbimport to complete importing even though it encounters certain nonfatal errors
-q Suppresses the display of error messages, warnings, and generated SQL data-definition statements
-d dbspace Names the dbspace where the database is created The default dbspace location is the rootdbs.
-l Establishes unbuffered transaction logging for the imported database
-l buffered Establishes buffered transaction logging for the imported database
-i dir Specifies the complete pathname on disk of the database.exp directory, which holds the input data files and schema file that dbimport uses to create and load the new database The directory name should be the same as the database name.

It's only fair to share...
Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

Leave a Reply