Database-logging status
You must use transaction logging with a database to take advantage of any of the features listed in Database server processes that require logging.
Every database
that the database server manages has a logging status. The logging
status indicates whether the database uses transaction logging and,
if so, which log-buffering mechanism the database employs. To find
out the transaction-logging status of a database, use the database
server utilities, as explained in Monitor the logging mode of a database. The database-logging
status indicates any of the following types of logging:
- Unbuffered transaction logging
- Buffered transaction logging
- ANSI-compliant transaction logging
- No logging
All logical-log records pass through the logical-log buffer in shared memory before the database server writes them to the logical log on disk. However, the point at which the database server flushes the logical-log buffer is different for buffered transaction logging and unbuffered transaction logging. For more information, see How the database server uses shared memory and Flush the logical-log buffer.