HP 3000 Manuals HP 3000 Manuals
Index
A
aborting programs
with TERMINATE USER
administration
DBA guidelines
MPE guidelines
system
aging
in data buffer calculations
arithmetic expressions
causing serial scans
authorization
effect on performance
B
balancing load
by separating files
batch reports
with SQLMON
BEGIN WORK
monitoring
BETWEEN
optimization of
B-tree
and indexes
buffer
calculating size of log buffer
log data
monitoring I/O
types used by ALLBASE/SQL
BULK option
in queries
C
caching
of directory information
of sections and DBCore directory
stored sections
calculations
overhead
checkpoints
monitoring
cluster count
and indexes
defined
clustering indexes
monitoring
using
COMMIT WORK
and log buffer
causing I/O
monitoring
compatibility
of data types
compression
of data pages
concurrency
improving
conjunctive normal form
in OR optimization
constraint
PCR
conversion
avoiding in UNION operations
of data
SMALLINT to INTEGER
correlated subqueries
effect on performance
cursor stability (CS)
using
D
data
conversion
logical design
physical design
data buffer
and pseudo-mapped I/O
high miss rate
insufficient space
miss rate
swapping
data buffer pages
adjusting with SQLMON
calculating number of
monitoring I/O
monitoring objects
monitoring swapping
used by ALLBASE/SQL
data definition
reduces concurrency
data storage
data page compression
DBA guidelines
for system administration
DBCORERR
deadlock
lock allocation failure
DBEFile
defined
monitoring capacity
organization
DBEFileSet
defined
determining contents
full
DBEnvironment
specifying in SQLMON
DDL Enabled flag
and directory caching
improving concurrency
setting to NO
deadlock
and savepoints
caused by locking
detection
example in SQLMON
monitoring
default value
adding column with
deletions
tips on
design
logical
of queries
physical
detached files
identifying
directory caching
defined
when DDL Enabled is set to NO
dirty reads
defined
disjunctive normal form
in OR optimization
disk space
increasing usage
monitoring
used for sorting
display options
setting for SQLMON
dynamic statements
performance of
E
echoing
SQLMON batch input
editor
high performance, for tables
EXIT
F
factor
in optimization
file
load balancing
monitoring capacity
opening
running out of space
saving space
filtering SQLMON information
DBEFileSets
lock mode
lock object
number of items displayed
filters
avoiding propagation by user
format
data page
DBEFile
page table page
rows of user data on data pages
TID
tuple header
freezing
to examine deadlock
to examine lock allocation failure
G
GENPLAN
analyzing queries with
using to observe the optimizer's choices
H
hanging
SQLMON session
hashing
and TRUNCATE TABLE
compared to B-tree index
monitoring overflow pages
monitoring tasks
removing overflow pages
Static Hash Screen
storage on DBEFile pages
using
HELP
host variables
and scan buffer
hot spots
defined
I
IMAGE database
storage of table
index
BETWEEN predicates
B-tree compared to hashing
B-tree splits and logging
clustering
design of
LIKE predicates
maintaining
MIN/MAX predicates
monitoring clustering
monitoring I/O
monitoring tasks
NULL values
OR predicates
page splitting
placement on disks
poorly clustered
storage on DBEFile pages
table size
to improve I/O
UNION queries
USASCII columns
when needed
indirect row
avoiding
defined
monitoring
unloading and reloading to avoid
INSTALL
after preprocessing
I/O
balancing load of
caused by COMMIT WORK
data buffers
empty DBEFile space
fastest available disk
flooding with checkpoints
improving
incurred by inserts
log buffers
minimizing disk contention
monitoring buffers
monitoring data I/O
monitoring for DBEFile
monitoring for indexes
monitoring for logging
monitoring for program
monitoring for sessions
monitoring for tables
monitoring logging I/O
nested loop joins
pseudo-mapped
shortening I/O path
small tables
system buffer pool
wasted
IO Data Program Screen
IO Data Session Screen
IO Log Program Screen
IO Log Session Screen
IO Screen
IO subsystem
isolation level
determining
improving concurrency with
KEEP CURSOR
locking of system catalog
locks
sorted query results
types of
J
joins
avoiding
compared with subqueries
denormalizing instead of
nested loop
optimization of
sort/merge
K
KEEP CURSOR
use of
key columns
updating
L
latch
use of
leaf pages
storage
LIKE
optimization of
LOAD
hashed table
initial
non-hash table
to avoid indirect rows
to improve cluster count
to recluster indexes
to remove overflow pages
load balancing
explained
Load Program Screen
Load Screen
Load Session Screen
Load subsystem
Lock Impede Screen
locking
allocation failures
and deadlocks
avoiding contention
cause of waits
causing delays
causing transaction delays
contention
filtering information
for KEEP CURSOR
influenced by data definition
monitoring contention
monitoring tasks
on the system catalog
overview
requests
row level
selecting types of
sequence of events
SQLMON screens
subsystem in SQLMON
wait %
waits
Lock Memory Screen
lock object
defined
Lock Object Screen
Lock Screen
Lock Session Screen
Lock subsystem
Lock TabSummary Screen
logging
archive mode on IO screen
choosing number and size of files
choosing number of buffer pages
definition of log
file capacity
file placement on disks
insufficient buffer space
monitoring errors
monitoring file space
monitoring I/O
monitoring program I/O
monitoring session I/O
monitoring tasks
LRU (least recently used) algorithm
in calculating data buffer pages
M
memory
available real
latches
limit reached
locks
monitoring usage
row level locks
shared, calculating
used in sorting
menus
displaying in SQLMON
MIN/MAX
optimization of
monitoring
with SQLMON
MPE/iX
use of C and D queues
multiconnect
using
N
nested loop join
explained
network use
guidelines for
NLS data
USASCII columns
non-correlated subqueries
effect on performance
non-leaf pages
storage
normalization
in logical design
pros and cons
NULL values
avoiding
indirect rows
tuple migration
O
operating system buffer
used by ALLBASE/SQL
optimization
BETWEEN predicates
LIKE predicates
MIN/MAX predicates
OR predicates
overview
updates of key columns
optimizer
choice of join method
observing results with GENPLAN
overriding with SETOPT
OR
optimization of
organization
DBEFile
page
output
of SQLMON
overhead
generated by SQLMON
overnormalization
avoiding
Overview Program Screen
Overview Screen
Overview Session Screen
Overview subsystem
P
page
clean
compression
dirty
in DBEFiles
no-log
overflow
page splitting
of B-tree indexes
page table page
defined
in DBEFiles
parallel serial scans
advantages of
PCR
defined
performance
basic concepts
summary of topics
pin
use of
predicate
BETWEEN
LIKE
MIN/MAX
OR
preprocessing
with a development DBE
procedures
and rules
program
monitoring data I/O
monitoring load
monitoring logging I/O
monitoring status
propagation of filters
avoiding
pseudo-mapped files
restrictions
PUBLIC ROW
overview
Q
queries
design of
importance in design
R
read committed (RC)
using
read uncommitted (RU)
using
referential constraint
and index design
and TRUNCATE TABLE
enforced with a PCR
monitoring clustering
monitoring I/O
monitoring tasks
REFETCH statement
and RC or RU
refresh
setting cycle
setting rate
revalidation
avoiding at run time
ROLLBACK WORK
and transactions
monitoring
row
how stored on DBEFile page
row level locking
overview
rules
and procedures
runtime control blocks
choosing size of
latches
locks
monitoring
row level locking
running out of
S
SampleIO Indexes Screen
SampleIO Objects Screen
SampleIO Screen
SampleIO subsystem
SampleIO TabIndex Screen
SampleIO Tables Screen
sampling
setting display
setting with SQLMON
savepoint
defined
scan buffer
different from data buffer
scan type
avoiding serial scans
overview of choices for optimization
using parallel serial scans
screens
invoking in SQLMON
section caching
defined
sections
defined
semi-permanent
SELECT
compared to FETCH with cursor
design of
session
monitoring data I/O
monitoring load
monitoring locks
monitoring logging I/O
monitoring status
monitoring tasks
SET
SET CYCLE
SET DBECONNECT
SET DBEFILESET
SET DBEINITPROG
SET DBENVIRONMENT
SET DISPLAYSAMPLES
SET ECHO
SET LOCKFILTER
SET LOCKOBJECT
SET LOCKTABFILTER
SET MENU
SETOPT
modifying access optimization plan with
using to override the optimizer's choices
using to specify join method
SET OUTPUT
SET REFRESH
SET SAMPLING
SET SORTIODATA
SET SORTIOLOG
SET SORTLOAD
SET SORTLOCK
SET SORTSAMPLEIO
SET TOP
SET USERTIMEOUT
shared memory
calculating
shared tuple header
explained
size of objects
monitoring
slot table
defined
sorting
large sorts
methods used in ALLBASE/SQL
overview
sort/merge join
explained
SQLMON
batch reports
defined
leaving
monitoring tasks
online help
screen command summary
starting
troubleshooting with
SQLMON Commands
EXIT
HELP
SET
SET CYCLE
SET DBECONNECT
SET DBEFILESET
SET DBEINITPROG
SET DBENVIRONMENT
SET DISPLAYSAMPLES
SET ECHO
SET LOCKFILTER
SET LOCKOBJECT
SET LOCKTABFILTER
SET MENU
SET OUTPUT
SET REFRESH
SET SAMPLING
SET SORTIODATA
SET SORTIOLOG
SET SORTLOAD
SET SORTLOCK
SET SORTSAMPLEIO
SET TOP
SET USERTIMEOUT
SQLMON Screens
IO
IO Data Program
IO Data Session
IO Log Program
IO Log Session
Load
Load Program
Load Session
Lock
Lock Impede
Lock Memory
Lock Object
Lock Session
Overview
Overview Program
Overview Session
SampleIO
SampleIO Indexes
SampleIO Objects
SampleIO TabIndex
SampleIO Tables
Static
Static Cluster
Static DBEFile
Static Hash
Static Indirect
Static Size
summary
Static Cluster Screen
Static DBEFile Screen
Static Hash Screen
Static Indirect Screen
Static Screen
Static Size Screen
Static subsystem
storage
B-tree indexes
hash tables
log data
user table data on DBEFile pages
subqueries
compared with joins
subsystem
IO
Load
Lock
navigating in SQLMON
Overview
SampleIO
Static
swapping
monitoring
pages
system administration
DBA guidelines
MPE guidelines
network guidelines
system catalog
defined
DML only mode
page locks on
query results
sorting
user data in
SYSTEM.INDEX
monitoring for cluster count
T
table
and DBEFileSets
checking type
indexes for large tables
monitoring I/O
monitoring locks
monitoring tasks
partitioning large tables
size and row level locking
storage on DBEFile pages
suggestions on creation
temporary
table editor
design for
temporary space
controlling
in sorting
reported by SQLMON
used in system catalog
terminal reads
avoiding locks around
TERMINATE USER
use of
throttle wait queue
monitoring
throughput
monitoring
TID
and indexes
defined
on SampleIO Objects screen
use of TID scans
timeout
and transaction limit
setting for SQLMON
using
transaction
delays
design of
impeded
limit reached
maximum number of
monitoring tasks
monitoring with Load Screen
monitoring with Overview Screen
using short transactions
troubleshooting
with SQLMON
TRUNCATE TABLE
use of
tuning hints
tuple
how stored on DBEFile page
tuple body
explained
tuple buffer
different from data buffer
tuple header
explained
TurboIMAGE
storage of table
types of data
compatibility of data types
U
UNION
and indexes
avoiding conversions with
UNLOAD
to avoid indirect rows
to improve cluster count
to remove overflow pages
UPDATE STATISTICS
cluster count
indexes
invalidating sections
large tables
VALIDATE
V
VALIDATE
and UPDATE STATISTICS
validation
avoiding at run time
explained
stored sections
VARCHAR data
and tuple migration
variable length data
avoiding
W
wait queue
monitoring
timeouts