Operating OnLine 3-33
Change the Logging Status of a Database
Change the Logging Status of a Database
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
Addlogging to a database to take advantage of transaction logging or other
OnLine features that require logging, such as deferred checking.
Endlogging to reduce the amount of OnLine processing: for example, if you
areloading 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 anIBM Informix STAR environment, you might need
to change the logging status from buffered to unbuffered, or vice versa, to
permit a multidatabase query. (Refer to theSET LOG statement in
IBMInformix Guide to SQL: Reference.)
You can only make a databaseANSI-compliant from within DB-Monitor;
therefore, you must be logged in as userinformix. All other logging status
changes can be performed by either user informix or root.
If you use DB-Monitor 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.
Youmust 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.