7-14 IBM Informix OnLine Database Server Administrator’s Guide
Create Options
Create Options
A database that is ANSI-compliant uses unbuffered logging. In addition, the
ANSI rules for transaction logging are enabled. For more information about
ANSI-compliant databases, see the CREATE DATABASE statement in
IBM Informix Guide to SQL: Reference.
If you do not specify a dbspace name, the database is created in the root
dbspace by default.
The -l option is equivalent to the WITH LOG clause of the CREATE DATABASE
statement.
The following command imports the stores5 database from the
/usr/informix/port/stores5.exp directory into the current directory. The new
database is ANSI-compliant, and the transaction log file is specified as
stores5.log in /usr/work.
dbimport -c stores5 -i /usr/informix/port -ansi /usr/work/stores5.log
-ansi creates an ANSI-compliant database.
-d dbspace names the OnLine dbspace where the database will be created.
-l establishes unbuffered transaction logging for the imported
database.
-l buffered establishes buffered transaction logging for the imported
database.
Create
Options
-d dbspace
-l
-ansi
buffered
