@
8IBM Informix OnLine Database Server Administrator’s Guide
OQCABDEFGHIJKLMNPRSTUVWXYZ
Logging
blobspace data 4-22
buffered logging and fast
recovery 4-40
buffered versus unbuffered 3-34
comparison of blobspace to
dbspace 4-18
dbspace data 4-19
description of 4-18
monitoring activity 3-80
role of blobspace free-map
page 2-148, 4-22
transaction logging 1-26
Logical consistency
description of 4-39
Logical log buffer
changing size 3-93
description of 2-66
flushing 2-68
if it becomes full 2-69
role in dbspace logging 4-21
tuningsize for performance 5-11,
5-15
Logical log file
access denied during long
transaction 2-160
adding 3-28
backing up a file 3-36
backup criteria for
blobpages 4-27
backupson another machine 3-19
changing database logging
status 3-33
changing size 3-24
configuration guidelines 3-14
contents 2-68, 2-156, 3-15
description of 1-26, 2-86
disk location 1-46
displaying contents 7-51
dropping 3-30
effect on blobspace activity 2-158
ending continuous backups 3-38
factors affecting the rate of
filling 2-157
filling in rotation 2-155, 2-160,
3-15, 3-27
freeing 3-39
function of 2-154, 4-18
identification numbers 3-27
if a backup is interrupted 3-42
if the files fill during an
archive 3-59
importance of backups 3-14
importanceof freeing a file 2-155,
3-15
initial configuration values 1-26
limits on number and size 2-157
maximum number 3-23
mirroring a dbspace containing a
file 4-15
monitoring space, activity 3-80
moving to another dbspace 3-31
number and size 2-156
reading the log file 7-51
reserved page information 2-98
role in data consistency 4-18
role in fast recovery 4-40,
4-43to 4-44
role in multiple residency 9-10
starting continuous backups 3-37
status 3-26
switching to activate new
blobspace 2-159
switching to the next file 3-39
triple buffering 2-66
what happens during
backup 4-26
Logical log record
BEGPREP for two-phase commit
protocol 9-44
blobspace blobs omitted 4-24
description of 2-154
displaying records in log 7-51
ENDTRANS for two-phase
commit protocol 9-45
factors that affect the number
written 2-157
flushingunder two-phase commit
protocol 9-47
HEURTX for two-phase commit
protocol 9-45
how to interpret record
displays 7-55
IBM Informix STAR-specific
records 9-44
needed for data consistency 4-18
PREPARE for two-phase commit
protocol 9-44
role in fast recovery 4-42,
4-43to 4-44
size 2-157
span pages, not files 2-156
TABLOCKS for two-phase
commit protocol 9-45
types 7-56, 7-57
Logical log tape device
changing block size 3-21
changing pathname 3-18
changing tape size 3-22
implicationsof single-tape-device
environment 3-52
initial configuration
guidelines 1-29
Logical page number 2-124
LOGSIZE parameter
changing 3-24
description of 1-14
initial configuration value 1-27
LOGSMAX parameter
changing 3-23
description of 1-14
initial configuration value 1-36
Long transaction
description of 3-40
mentioned within two-phase
commit discussion 9-29, 9-33,
9-36, 9-37, 9-40, 9-48, 9-49
recovery requires data
restore 2-161
role played by high-water
marks 2-159
tracked by Log Begin field of
tbstat -u 9-61
LRU queue
description of 2-57
FLRU queue 2-57
MLRU queue 2-57
role in buffer pool
management 2-58
tuning parameters for
performance 5-17
LRU write 2-77
LRUS parameter
description of 1-15
initial configuration value 1-37
tuning for performance 5-17