IBM 000-8697 Manual de usuario descargar pdf (Pagina 486)

100

101

7-8 IBM Informix OnLine Database Server Administrator’s Guide

Destination Options

Ifyoudonotspecifyadestinationforthedataandschemaﬁles,thedirectory

database.exp is placed in the current working directory. The schema ﬁle is

written to the ﬁle database.sql.

If you use the -f option, the schema ﬁle is written to the disk pathname

speciﬁed. Once on disk, you can examine and modify the schema ﬁle before

you use it with dbimport.

If you use the -o option, the directory speciﬁed as directory cannot exist. It is

created by dbexport and its directory group is informix. The schema ﬁle is

written to the ﬁle database.sql in the speciﬁed 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 ﬁle is written to

/tmp/stores5.imp.

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

Thefollowingcommandexportsthestores5database to thedirectorynamed

/usr/informix/export/stores5.exp:

dbexport -o /usr/informix/export stores5

-o directory names the directory on disk where you want the ASCII data

ﬁles and the schema ﬁle stored.

-s tapesize speciﬁes in kilobytes the amount of datathat can be stored on

the tape.

-t device names the pathname of the tape device where you want the

ASCII data ﬁles and, possibly, the schema ﬁle stored.

1 2 ... 481 482 483 484 485 486 487 488 489 490 491 ... 701 702

Comentarios a estos manuales

Sin comentarios

IBM 000-8697 Manual de usuario Pagina 486

Comentarios a estos manuales

Relacionado con productos y manuales para Software de base de IBM 000-8697