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 Figure 1 and Flush the logical-log buffer.


Copyright© 2019 HCL Technologies Limited