IBM 000-8697 Manual De Usuario

IBM Informix OnLine Database Server Administrator’s Guide

If you do not specify a destination for the data and schema files, the directory
database

.exp is placed in the current working directory. The schema file is

written to the file database.sql.

If you use the -f option, the schema file is written to the disk pathname
specified. Once on disk, you can examine and modify the schema file before
you use it with dbimport.

If you use the -o option, the directory specified as directory cannot exist. It is
created by dbexport and its directory group is informix. The schema file is
written to the file database.sql in the specified directory.

If you use the -s option, the tape size is limited to 2,097,151 KB. The limit is
required because of the way in which dbexport and dbimport track their
position into the tape.

The following command exports the stores5 database to tape with a block
size of 16 KB and a tape capacity of 24,000 KB. The schema file is written to
/tmp/stores5.imp.

dbexport -t /dev/rmt0 -b 16 -s 24000 -f /tmp/stores5.imp

stores5

The following command exports the stores5 database to the directory named
/usr/informix/export/stores5.exp

:

dbexport -o /usr/informix/export stores5

names the directory on disk where you want the

ASCII

 data

files and the schema file stored.

specifies in kilobytes the amount of data that can be stored on
the tape.

names the pathname of the tape device where you want the

ASCII

 data files and, possibly, the schema file stored.