Filter
Top Products
7-8 IBM Informix OnLine Database Server Administrator’s Guide
Destination Options
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
-o directory names the directory on disk where you want the ASCII data
files and the schema file stored.
-s tapesize specifies in kilobytes the amount of data that can be stored on
the tape.
-t device names the pathname of the tape device where you want the
ASCII data files and, possibly, the schema file stored.