SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Installation and Management Guide—640325-001
Index-8
J
benefits of 9-8
description of 4-12
OR operations 4-18
sort operations 4-18
ordering rows 4-18
parallel maintenance 15-17
partitioning 15-19
primary key 4-16
querying metadata about 8-46/8-50
unique 4-14
Index-only access 4-17
Indices
restoring 12-24
INFO command, mxtool
description of 12-26
Guardian files 8-3, 12-32
INITIALIZE DISK command, SCF 12-39
Installing SPRs for H-series RVUs 3-3
Installing Visual Query Planner 3-16
InstallSqlmx
command options 3-21
error messages 3-22
phases of 3-19
syntax 3-21
using the script 3-18
Integrity, definitional 1-4
Interface description files 3-14
Internal names, SQL objects 8-10
INTERVAL data type 7-27
INVALID attribute, TMF online
dumps 12-10
Invalid programs 14-9
ISO88591 6-4
ISOLATION_LEVEL, ANSI compliance 6-8
Item names 7-23
J
JDBC/MX driver
description of 1-13
installation 3-4
K
Key prefix 4-18
Keys
clustering, indexes 7-33
index 4-16
primary, null values 7-31
KEYTAG column 4-16
Key-sequenced files
accessing 4-6
clustering keys 4-5
description of 4-3
structure 4-5, 4-6
L
Label data
correcting 12-33
description of 12-27
Large Block Support 4-3
Local autonomy 13-2, 13-12
Locally distributed database 13-1
Locks 14-10, 14-11
LOCK-WAITS counter, Measure 14-10,
14-11
Logical file structures 4-3
M
Maintaining local autonomy 11-10
Maintaining query execution plan
validity 11-13
Managing a database 9-1
Managing permissions for files in Guardian
space 11-13
Managing permissions for files in OSS
space 11-12
MAX function, optimization 4-18
MAXEXTENT attribute, altering index
attributes 9-20
MAXEXTENTS attribute, altering table
attributes 9-24
Measure