IBM 000-8697 Manual Do Utilizador

Operating OnLine

You can make any one of the following changes to a database:

■

Add logging (buffered or unbuffered) to a database

■

End logging for a database

■

Change logging from buffered to unbuffered

■

Change logging from unbuffered to buffered

■

Make a database

ANSI

-compliant

Add logging to a database to take advantage of transaction logging or other
OnLine features that require logging, such as deferred checking.

End logging to reduce the amount of OnLine processing: for example, if you
are loading many rows into a single database from a recoverable source, such
as tape or an

ASCII

 file. (However, if other users are active, you lose the

records of their transactions until you reinitiate logging.)

If you are operating in an

IBM I

nformix

STAR

 environment, you might need

to change the logging status from buffered to unbuffered, or vice versa, to
permit a multidatabase query. (Refer to the

SET LOG

 statement in

eference.)

You can only make a database

ANSI

-compliant from within

DB-M

onitor;

therefore, you must be logged in as user informix. All other logging status
changes can be performed by either user informix or root.

If you use

DB-M

onitor to make any of these changes, you must take OnLine

to quiescent mode. If you use the command-line utilities, you can make the
changes while OnLine is in online mode.

You must create a level-0 archive before you add logging to a database. How
you create the archive (in online or quiescent mode) has implications for
database management. Read the following paragraphs to help you decide
which approach to use.