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.
Databases are always logged in Extended Parallel Server.
Only the database server administrator can change logging status. Managing Database-Logging Status, describes this topic. Ordinary end users cannot change database-logging status.
If you 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 ]