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

dbimport: Create a Database

Thestatements 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 retainsDBA 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.
dbimport: Create a Database
The dbimport utility creates a database and loads it with data from input
ASCIIfiles generated by dbexport. The ASCII files consist of a schema file that
isused to re-create the database and data files that contain the database data.
Thedbimport 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 topage 7-9 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 anANSI-compliant database (includes unbuffered logging).
■Start transaction logging for a database (unbuffered or buffered
logging).
■Specify the dbspace where the database will reside.
Theuser who runs dbimport is granted DBA privilege on the newly created
database.
Thedbimport process locks each table as it is being loaded and unlocks the
table when the loading is completed.