dbexport使用手册

dbexport
dbexport实用程序将数据库卸出到ASCII文件或磁带。dbimport实用程序使用dbexport产生的模式文件和数据重建数据库。用户可以通过编辑模式文件来修改由dbimport生成的数据库模式。

dbexport实用程序的语法：
-c 指示如果没有致命错误，则输出全部信息。
-d 仅输出blob描述符，不输出blob数据。
-q 在标准输出设备上不显示错误信息，警告和所生成的SQL数据定义语句。
-ss 为指定数据库中所有的表产生特定于数据库服务器的信息，对7.1动态服务器而言，-ss选项
使dbexport输出初始extent和附加extent的大小，分段存储信息(如果表已分割)，上锁的方式，表所在的dbspace，任意blob数据的blobspace信息等。
-X 标识符符字段中的HEX二进制数据。

目标选项
-o 命令存储ASCII文件和模式文件的磁盘目录。Directory是磁盘目录名，其指定的目录必须是
没有存在的。
-t 指定存储ASCII文件和模式文件的磁带设备名。
-b 指定磁带设备块大小，block以KB为单位，该值必须能为所使用的设备接受。
-s 指定磁带的最大数据存储量。
-f 如果将数据文件存储到磁带上，-f选项用于指定存储在磁盘上的模式文件名。用户在使用
dbimport之前可以检查或修改模式文件。

---

>>-dbexport----------------------------------------------------->
 
     .----------------------------------.
     V                                  |
>--+---+------------------------------+-+--database-+----------><
   |   +- -c--------------------------+             |
   |   +- -d--------------------------+             |
   |   +- -q--------------------------+             |
   |   |                         (1)  |             |
   |   +-| Destination Options |------+             |
   |   +- -ss-------------------------+             |
   |   '- -X--------------------------'             |
   '- -V--------------------------------------------'
 

Notes:

1. See page

Element	Purpose	Key Considerations
-c	Makes dbexport complete exporting unless a fatal error occurs	References: For details on this option, see .
-d	Makes dbexport export simple-large-object descriptors only, not simple-large-object data	References: For information about simple-large-object descriptors, see the IBM Informix: Optical Subsystem Guide. Restrictions: Not supported by SE.
-q	Suppresses the display of error messages, warnings, and generated SQL data-definition statements	None.
-ss	Generates database server-specific information for all tables in the specified database	References: For details on this option, see .
-X	Recognizes HEX binary data in character fields	None.
-V	Displays product version information	None.
database	Specifies the name of the database that you want to export	Additional Information: If your locale is set to use multibyte characters, you can use multibyte characters for the database name. References: If you want to use more than the simple name of the database, refer to the Database Name section of the IBM Informix: Guide to SQL Syntax.

You must have DBA privileges or log in as user informix to export a database.

Global Language Support

When the environment variables are set correctly, as described in the IBM Informix: GLS User's Guide, dbexport can handle foreign characters in data and export the data from GLS databases. For more information, refer to .

End of Global Language Support

You can use delimited identifiers with the dbexport utility. The utility detects database objects that are keywords, mixed case, or have special characters and places double quotes around them.

In addition to the data files and the schema file, dbexport creates a file of messages named dbexport.out in the current directory. This file contains error messages, warnings, and a display of the SQL data definition statements that it generates. The same material is also written to the standard output unless you specify the -q option.

During the export, the database is locked in exclusive mode. If dbexport cannot obtain an exclusive lock, it displays a diagnostic message and exits.

Tip:

The dbexport utility can create files larger than 2 GB. To support such large files, make sure your operating system file-size limits are set sufficiently high. For example, on UNIX, set ulimit to unlimited.