HP 3000 Manuals HP 3000 Manuals
Index
A
adding
log files
ADDLOG
ad hoc query
defined
ALL
parameter
ALLBASE/Replicate
statements
ALTDBE
ALTER TABLE
archive logging
defined
attribute
defined
AUDIT ELEMENTS
CHECKPOINT
COMMENT
DATA
audit log
records
records, viewing
AUDIT LOG
parameter
audit logging
enabling
enabling, example
audit log records
audit_name
AUDIT NAME
authority
defined
AUTHORIZATION
authorization group
defined
AUTOSTART
avoiding deadlock situations
B
backup
master
slave
static
base table
defined
batch mode
error messages
C
CHANGELOG
to change current log file
changing
DBEnvironment parameters
check constraint
defined
CHECKPOINT
audit element
class
defined
clustering index
defined
column
defined
column authorization
defined
column list
defined
COMMENT
audit element
COMMENT PARTITION
components of ALLBASE/Replicate
concurrency
defined
configurations
design issues
partition
types
connection
network
constraint
defined
converting a DBEnvironment
CPU time
CREATE PARTITION
CREATE TABLE
creating
DBEnvironment, hints
log file
master database, example
master, hints
slave database, example
slave, hints
cursor stability (CS)
defined
D
data
loading
unloading
DATA
audit element
parameter
data analysis
defined
database
defined
design issues
parameters
database administrator (DBA)
defined
database design
defined
data control language
defined
data definition
defined
language defined
data manipulation
defined
data manipulation language
defined
data type
defined
DBA authority
defined
DBCore
defined
DBECon file
defined
DBEConFile
in recovery
DBECreator
defined
DBEFile
defined
DBEFileSet
defined
DBEnvironment
defined
parameters, changing
DBEUserid
defined
DDL
activities
partitions
statements
dedicated slave
hints for replicating to
DEFAULT PARTITION
DEFINITION
design issues
configurations
user written applications
direct update
defined
direct updates
DISABLE AUDIT LOGGING
DROP PARTITION
dummy DBEnvironment
E
embedded SQL program
defined
ENABLE AUDIT LOGGING
enabling
audit logging
audit logging, example
entire DBEnvironment, replicating
entity
defined
environment variables
table of
error messages
during soft resynchronization
in batch mode
example
creating master database
creating slave database
enabling audit logging
explicit locking
defined
expression
defined
F
failure modes
foreign key
defined
G
generating
schema with SQLGEN
GET AUDITPOINT
global_commit_id
group
defined
H
hard resynchronization
defined
immediately after
overview
using to recover master
hash structure
defined
hints for replication
host variable
defined
I
implicit locking
defined
index
defined
index scan
defined
indirect update
defined
indirect updates
initial loading of master
integrity constraint
defined
interruptions
extended, planned of master
extended, planned of slave
extended, unplanned of master
extended, unplanned of slave
recovery from
short, planned of master
short, planned of slave
short, unplanned of master
short, unplanned of slave
isolation level
defined
ISQL
defined
loading data
unloading data
UNLOAD/LOAD
J
join
defined
K
keeping up
checking slave for
key
defined
key column
defined
key value
defined
L
LOAD
loading
data
master
master, hints
slave
slave, hints
tables
local_commit_id
LOCK AUDITPOINT
locking
defined
LOG COMMENT
log file
adding
creating
orphaned
size
usable
log_file_timestamp
logging
defined
M
maintaining synchronization
manually replicated DDL activities
master
creating
creating, hints
database creating
loading
starting
starting Replicate
starting soft resynchronization
master DBEnvironment
defined
MAXPARTITIONS
message catalog
defined
message file
defined
migration
mirror image
define
mixed mode
modified source file
defined
module
defined
multiple masters
replicating
replicating to one slave
N
native language
defined
network
connection
NMMGR.PUB.SYS
nodename
hints
slave
nonarchive logging
defined
non-DDL statements
NONE partition
nonReplicate database
SQLMigrate
normalization
defined
O
object
defined
openlog message
operating system
priority
optimizer
defined
options
setting on master
setting on slave
orphaned log files
owner
defined
P
parameter
AUDIT ELEMENTS
AUDIT LOG
AUDIT NAME
COMMENT PARTITION
DEFAULT PARTITION
MAXPARTITIONS
parameters
database
of START DBE NEW
partition
COMMENT
configurations
DEFAULT
defined
NONE
Replicate
schema
table
types
user-defined
partition_id
PartsDBE
defined
predicate
defined
preparing master
preprocessor
defined
primary DBEnvironment
defined
primary key
defined
priority by operating system
procedure
defined
projection
defined
protecting transactions
PURGEALL
PURGEFILE
Q
query
defined
query language
defined
query result
defined
R
read committed (RC)
defined
read uncommitted (RU)
defined
records
audit log
recover
dynamic environment
for soft resynchronization
master, hints
orphaned log files
tables acting in master role
referential constraint
defined
relational operations
defined
relationship
defined
relation (table)
defined
removing test transactions
repeatable read (RR)
defined
replicate
defined
Replicate
audit log
defined
partition
starting on master
starting on slave
replicating
entire DBEnvironment
log files
multiple masters to one slave
subset of DBEnvironment
two-way
REPMAST
defined
REPSLAVE
defined
RESTORE
using for recovery
using to restore to slave
RESTORELOG
restoring
entire DBEnvironment to slave
using dynamic restore commands
result table
defined
RESYNCdebug
resynchronization
defined
overview
type used for failures
RESYNCpriority
RESYNCrptnotrx
RESYNCsleep
RESYNCstoplog
RESYNCtrxfile
role switching of master and slave
rollback recovery
defined
rollforward recovery
defined
row
defined
rule
defined
run authority
defined
S
schema
defined
partition
slave database
SCR
Array
defined
detailed structure
fields
maintain synchronization
SCR Array
defined
secondary DBEnvironment
defined
section
defined
SECTION
parameter
serial scan
defined
setting options
on master
on slave
SETUPRECOVERY
SHOWDBE
SHOWLOG
example
using to find usable log files
size of log file
slave
adding log files
ahead of master
backup
creating, example
creating, hints
database schema
dedicated, replicating to
loading
loading, hints
nodename
not keeping up
starting
starting, hints
starting Replicate
starting soft resynchronization
starting with DDL partitions
slave DBEnvironment
defined
SocketName
soft resynchronization
defined
options on master
options on slave
overview
recovering from interruptions
setting up
starting
starting on master
starting on slave
steps
stopping
using to recover master
using to recover tables
special authority
defined
SQL
defined
SQLAudit
using to check if keeping up
viewing audit log records
SQLCore
defined
SQLGEN
defined
generating schema
SQLMigrate
defined
SQLUtil
ALTDBE
defined
PURGEALL
RESTORE
RESTORELOG
SETUPRECOVERY
SHOWDBE
STORE
STORELOG
STOREONLINE
START DBE NEW
creating dummy DBEnvironment
using
START DBE NEWLOG
using
starting
master, hints
Replicate on master
Replicate on slave
slave DBEnvironment
slave, example
slave, hints
soft resynchronization
soft resynchronization on master
soft resynchronization on slave
startup parameters, verifying
static backup
stopping soft resynchronization
STORAGE
STORE
using for recovery
STORELOG
STOREONLINE
storing
entire master DBEnvironment
entire source DBEnvironment
structured query language
defined
subquery
defined
subset of DBEnvironment, replicating
suggestions for replication
switching master and slave roles
Synchronization Checkpoint Records (SCR)
system
catalogs
table
SYSTEM
defined
system catalog
defined
system table
defined
system view
defined
T
table
defined
loading
partition
system
unloading
table authority
defined
testing
applications
on master
on slave
timing issues
manually replicated DDL activities
transaction
defined
transaction identifier
defined
transactions
protecting
two-way replication
U
unique constraint
defined
unique index
defined
UNLOAD
unloading
data
tables
usable log files
user-defined partitions
user written applications
design issues
V
validation
defined
variables
environment
verifying
slave parameters
startup parameters
view
defined
viewing
audit log records
W
WRAPDBE
wrapper DBEnvironment
Wrapper DBEnvironment
defined