1. Manuals
  2. Brands
  3. Computer Equipment
  4. Server
  5. IBM
  6. Computer Equipment
  7. Server

IBM 000-8697 Buffer Contents, Causes of Flushing

1 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 702
Download on canonical page 702 pages, 4.15 Mb
2-68 IBM Informix OnLine Database Server Administrator’s Guide
Logical Log Buffer
Buffer Contents
Logicallog records are written continuously during OnLine operation. Even
ifa database is not created with transaction logging, administrative changes
(such as adding a dbspace or a chunk) and data definition statements, such
asCREATE TABLE or DROP TABLE, are logged. (SELECT statements arenever
logged.) The logical log files contain five types of records:
SQL data definition statements for all databases
SQL data manipulation statements for databases that were created
with logging
Record of a change to the logging status of a database
Record of a checkpoint
Record of a change to the configuration
(Refer topage 2-155 for further information about the factors that influence
the number and size of logical log records that are written to the logical log
files.)
Causes of Flushing
Three events cause the logical log buffer to flush:
One of the logical log buffers becomes full.
A transaction is committed within a database that uses unbuffered
logging.
A checkpoint occurs.
Refer topage 2-70 for a definition of a checkpoint. Refer to page 2-72 for a
description of the checkpoint procedure.
If a transaction is committed in a database with unbuffered logging, the
logicallog buffer is immediately flushed. This might appear to be a source of
some disk space waste. Typically, many logical log records are stored on a
singlepage. But because the logical log buffer is flushed in whole pages, even
ifonly one transaction record is stored on the page, the whole page is flushed.
Inthe worst case, a single COMMIT logical log record (“commit work”) could
occupya page on disk, and all remaining space on the page would be unused.
MENU

Models

Contents