IBM 000-8697 User Manual
Utilities
7-5
In This Chapter
This chapter describes the OnLine utilities that allow you to execute admin-
istrative tasks directly from the shell prompt.
istrative tasks directly from the shell prompt.
dbexport: Unload a Database and Schema File
The dbexport utility unloads a database into ASCII files. The dbexport utility
creates an ASCII schema file that dbimport uses to re-create the database
schema in another Informix environment. You can edit the schema file to
modify the database that dbimport creates.
creates an ASCII schema file that dbimport uses to re-create the database
schema in another Informix environment. You can edit the schema file to
modify the database that dbimport creates.
The dbexport utility supports the following three destination options:
■
Unloading a database and its schema file to disk
■
Unloading a database and its schema file to tape
■
Unloading the schema file to disk, where it can be examined and
modified, and unloading the database data files to tape
modified, and unloading the database data files to tape
You must either have
DBA
privilege or be logged in as user informix or root
to export a database.
The dbexport process locks the database in Exclusive mode during the
export.
export.
If you export a database to disk, be sure that you have enough disk space
available to hold an
available to hold an
ASCII
dump of all data in the database. Otherwise, use
the tape option.