@
4IBM Informix OnLine Database Server Administrator’s Guide
OQCABDEFGHIJKLMNPRSTUVWXYZ
DDaemon process
description of 2-33
user process type flag 2-30
Data consistency
blob timestamp and isolation
levels 2-44
consistency-checking code 4-6
fast recovery 4-39
role of timestamp pairs 2-44
Data restore
minimizing time needed 3-48
procedure 4-45
recovery after a long
transaction 2-161
tape requirements 4-47
tapes needed 3-61
what happens during a
restore 4-50 to 4-52
when is restore needed 4-45
Data row
big-remainder page 2-127
blob descriptor component 2-145
displaying row contents 3-77
forward pointer 2-125, 2-127
home page 2-123, 2-127
migration 4-52
obtaining the rowid 3-77
storage strategies 2-123
storing data on a page 2-125
Database
adding logging 3-33
creating, what happens on
disk 2-108
description of 2-85
ending logging 3-33
limits 2-110
logging, buffered and
unbuffered 3-33
making ANSI-compliant 3-33
migration 4-52
monitoring 3-74
stores5 demonstration
database Intro-5
unloading data using
dbexport 7-5
Database server process
cleanup performed by
tbundo 2-34
coordinator under two-phase
commit 9-18
description of 2-30
killing a process 2-31to 2-32
killing with tbmode -z 7-69
monitoring 3-86
orphaned processes 2-31
participant under two-phase
commit 9-18
role of current server in
distributed-data queries 9-16
roleof currentserverintwo-phase
commit protocol 9-19
setting with SQLEXEC 1-55
specified as sqlturbo 2-30
SQLEXEC environment
parameter 2-30
tracked in shared-memory user
table 2-54
Database tblspace
location in root dbspace 2-87
relation to systable 2-109
structure and function 2-107
tblspace number 2-107
Data-recovery mechanisms
archiving 4-30
data restore 4-45
fast recovery 4-39
logging 4-18
mirroring 4-14
dbexport utility
contents of the schema file 7-9
description of 7-5
migrating with dbimport 4-62
overview of migration
methods 4-52
syntax 7-6
dbimport utility
create options 7-14
description of 7-10
input file location options 7-12
migrating with dbexport 4-62
overview of migration
methods 4-52
syntax 7-11
dbload utility
batch size 7-19
command file
character-position
examples 7-29
character-position FILE
statement 7-26
syntax check 7-18
comparison to LOAD
statement 4-59
description of 7-15
migrating with UNLOAD
statement 4-60
overview of migration
methods 4-52
starting line number 7-18
DB-Monitor
access and use 6-3
Archive menu and options 6-10
Dbspaces menu and options 6-7
Force-Ckpt option 6-9
how to access 1-10
Logical-Logs menu and
options 6-11
Main menu and options 6-4
Mode menu and options 6-8
Parametersmenu and options 6-6
Status menu and options 6-5
DBREMOTECMD environment
variable 8-27
dbschema utility
description of 7-32
including synonyms 7-33
specifying a table, view, or
procedure 7-35
DBSERVERNAME parameter
changes for multiple
residency 9-13
description of 1-13
initial configuration value 1-32
Dbspace
adding a chunk 3-94
bit-map page 2-143
blob page structure 2-146
blob storage 2-145
blob timestamps 2-44
changing maximum
number 3-111
creating 3-97