7-8 IBM Informix OnLine Database Server Administrator’s Guide
Destination Options
Ifyou 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 filedatabase.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 asdirectory cannot exist. It is
created bydbexport and its directory group is informix. The schema file is
written to the filedatabase.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 whichdbexport 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
Thefollowing command exports the stores5 database to the directory named
/usr/informix/export/stores5.exp:
dbexport -o /usr/informix/export stores5
-odirectory names the directory on disk where you want the ASCII data
files and the schema file stored.
-stapesize specifies in kilobytes the amount of data that can be stored on
the tape.
-tdevice names the pathname of the tape device where you want the
ASCII data files and, possibly, the schema file stored.