IBM 000-8697 User Manual

IBM Informix OnLine Database Server Administrator’s Guide

The statements in the

ASCII

schema file that create tables, views, and indexes

and grant privileges do so using the name of the person who originally
created the database. In this way, the original owner retains

DBA

 privileges

for the database and is the owner of all the tables, indexes, and views. In
addition, whoever executes the dbimport command also has

DBA

privileges

for the database.

The dbimport utility creates a database and loads it with data from input

ASCII

files generated by dbexport. The

ASCII

files consist of a schema file that

is used to re-create the database and data files that contain the database data.

The dbimport utility can read the

ASCII

 files from the following three

location options:

■

All input files are located on disk.

■

All input files are located on tape.

■

The schema file is located on disk, and the data files are located on
tape.

Refer to

 for more details about the contents and use of the schema

file generated by dbexport.

The dbimport utility supports the following create options for the new
database:

■

Create an

ANSI

-compliant database (includes unbuffered logging).

■

Start transaction logging for a database (unbuffered or buffered
logging).

■

Specify the dbspace where the database will reside.

The user who runs dbimport is granted

DBA

privilege on the newly created

database.

The dbimport process locks each table as it is being loaded and unlocks the
table when the loading is completed.