dbexport utility

The dbexport command unloads a database into text files that you can later import into another database. The command also creates a schema file.
Remember: You must have DBA privileges or log in as user informix to export a database.

Syntax

>>-dbexport----------------------------------------------------->

     .---------------------------------------------------.               
     V                                                   |               
>--+---+-----------------------------------------------+-+--database-+-><
   |   +- -c    ---------------------------------------+             |   
   |   +- -d-------------------------------------------+             |   
   |   +- -no-data-tables--tablenames------------------+             |   
   |   +- -no-data-tables-accessmethods--accessmethods-+             |   
   |   +- -nw------------------------------------------+             |   
   |   +- -q-------------------------------------------+             |   
   |   |                                               |             |   
   |   +-| Destination Options |-----------------------+             |   
   |   +- -ss------------------------------------------+             |   
   |   +- -si------------------------------------------+             |   
   |   '- -X-------------------------------------------'             |   
   '-+-----------+---------------------------------------------------'   
     +- -V-------+                                                       
     '- -version-'                                                       
Element Purpose
-c Makes dbexport complete exporting unless a fatal error occurs.
-d Makes dbexport export simple-large-object descriptors only, not simple-large-object data.
-q Suppresses the display of error messages, warnings, and generated SQL data-definition statements.
-ss

Generates database server-specific information for all tables in the specified database.

This option specifies initial and next-extent sizes, fragmentation information if the table is fragmented, the locking mode, the dbspace for a table, the blobspace for any simple large objects, and the dbspace for any smart large objects.

-si

Excludes the generation of index storage clauses for non-fragmented tables.

Note: The -si option is available only with the -ss option.
-X Recognizes HEX binary data in character fields.
-no-data-tables

Prevents data from being exported for the specified tables. Only the definitions of the specified tables are exported.

Accepts a comma-separated list of names of tables for which data will not be exported.

-no-data-tables-accessmethods

Prevents data from being unloaded using the specified access methods.

Accepts a comma-separated list of names of access methods. Tables using those access methods are not unloaded.

-nw Generates the SQL for creating a database without the specification of an owner.
-V Displays the software version number and the serial number.
-version Extends the -V option to display additional information about the build operating system, build number, and build date.
database Specifies the name of the database that you want to export.

Destination Options

|--+---------------------------------------------------------------+--|
   +- -o--directory------------------------------------------------+   
   '- -t--device-- -b--blocksize-- -s--tapesize--+---------------+-'   
                                                 '- -f--pathname-'     
Element Purpose
-b blocksize Specifies, in kilobytes, the block size of the tape device.
-f pathname Specifies the name of the path where you want the schema file to be stored, if you are storing the data files on tape.
-o directory Specifies the directory on the disk in which dbexport creates the database.exp directory. This directory holds the data files and the schema file that dbexport creates for the database.
-s tapesize Specifies, in kilobytes, the amount of data that you can store on the tape.
-t device Specifies the path name of the tape device where you want the text files and, possibly, the schema file stored.

When you write to disk, dbexport creates a subdirectory, database.exp, in the directory that the -o option specifies. The dbexport utility creates a file with the .unl extension for each table in the database. The schema file is written to the file database.sql. The .unl and .sql files are in the database.exp directory.