SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)
Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-9
J
InstallSqlmx (continued)
using the script 3-25
Integrity, definitional 1-4
INTERACTIVE_ACCESS 6-3
Interface description files 3-19
Internal names, SQL objects 8-14
INTERVAL data type 7-25
INVALID attribute, TMF online
dumps 12-10
Invalid programs 15-8
ISO88591 6-8
ISOLATION_LEVEL, ANSI
compliance 6-12
Item names 7-21
J
JDBC A-1
JDBC/MX driver
description of 1-17
installation 3-4
K
Key prefix 4-18
Keys
clustering, indexes 7-31
index 4-16
primary, null values 7-29
KEYTAG column 4-16
Key-sequenced files
accessing 4-5
clustering keys 4-5
description of 4-3
structure 4-5, 4-6
L
Label data
correcting 12-32
description of 12-26
Local autonomy 13-2, 13-12
Local partitions 13-23
Locally distributed database 13-1
Locks 15-9, 15-10
LOCK-WAITS counter, Measure 15-9,
15-10
Logical file structures 4-3
M
Maintaining local autonomy 11-10
Maintaining query execution plan
validity 11-14
Managing a database 9-1
Managing permissions for files in Guardian
space 11-13
Managing permissions for files in OSS
space 11-13
MAX function, optimization 4-18
MAXEXTENT attribute, altering index
attributes 9-20
MAXEXTENTS attribute, altering table
attributes 9-24
MAX_ROWS_LOCKED_FOR_
STABLE_ACCESS 6-3
Measure
CALLS counter 15-8
description of 15-4
DISK-READS counter 15-9, 15-10
ELAPSED-BUSY-TIME counter 15-8
ELAPSED-RECOMPILE-TIME
counter 15-9
fallback A-1
FILE entity 15-5, 15-6, 15-9
index creation 9-9
LOCK-WAITS counter 15-9, 15-10
MESSAGES counter 15-9
MESSAGES-BYTES counter 15-9
OPENS counter 15-8
RECOMPILES counter 15-9
RECORDS-ACCESSED counter 15-9
RECORDS-USED counter 15-9
SQLPROC entity 15-5
SQLSTMT entity 15-5