IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

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

eference.

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

 in /usr/work.

dbimport -c stores5 -i /usr/informix/port -ansi /usr/work/stores5.log

creates an

ANSI

-compliant database.

names the OnLine dbspace where the database will be created.

establishes unbuffered transaction logging for the imported
database.

establishes buffered transaction logging for the imported
database.

Create

Options

-d dbspace

-l

-ansi

buffered