The user who creates a database with the CREATE DATABASE statement establishes the logging status or buffering mode for that database. For more information on the CREATE DATABASE statement, see the IBM Informix Guide to SQL: Syntax.
If the CREATE DATABASE statement does not specify a logging status, the database is created without logging.
Only the database server administrator can change logging status. Managing the Database-Logging Mode, describes this topic. Ordinary end users cannot change database-logging status.
If a database does not use logging, you do not need to consider whether buffered or unbuffered logging is more appropriate. If you specify logging but do not specify the buffering mode for a database, the default is unbuffered logging.
End users can switch from unbuffered to buffered (but not ANSI-compliant) logging and from buffered to unbuffered logging for the duration of a session. The SET LOG statement performs this change within an application. For more information on the SET LOG statement, see the IBM Informix Guide to SQL: Syntax.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]