Dbspace logging
The database server uses the following
logging process for operations that involve data stored in dbspaces:
- Reads the data page from disk to the shared-memory page buffer
- Copies the unchanged page to the physical-log buffer, if required
- Writes the new data to the page buffer and creates a logical-log record of the transaction, if required
- Flushes the physical-log buffer to the physical log on disk
- Flushes the logical-log buffer to a logical-log file on disk
- Flushes the page buffer and writes it back to disk