Home | Previous Page | Next Page   Logging and Log Administration > Logging >

Settings or Changes for Logging Status or Mode

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 ]