SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-9
M
Label data (continued)
description of 12-27
Large Block Support 4-3
Local autonomy 13-2, 13-12
Locally distributed database 13-1
Locks 14-9, 14-10
LOCK-WAITS counter, Measure 14-9,
14-10
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
MAX_ROWS_LOCKED_FOR_
STABLE_ACCESS 6-3
Measure
CALLS counter 14-9
description of 14-4
DISK-READS counter 14-9, 14-10
ELAPSED-BUSY-TIME counter 14-9
ELAPSED-RECOMPILE-TIME
counter 14-9
FILE entity 14-5, 14-6, 14-10
index creation 9-9
LOCK-WAITS counter 14-9, 14-10
MESSAGES counter 14-9
MESSAGES-BYTES counter 14-9
OPENS counter 14-8
RECOMPILES counter 14-9
RECORDS-ACCESSED counter 14-9,
14-10
Measure (continued)
RECORDS-USED counter 14-9, 14-10
SQLPROC entity 14-5
SQLSTMT entity 14-5
SQL-NEWPROCESS counter 14-8
SQL-NEWPROCESS-TIME
counter 14-8
SQL-OBJ-RECOMPILE-TIME
counter 14-8
SQL-STATEMENT-RECOMPILES
counter 14-8
SQL-STATEMENT-RECOMPILES-
TIME counter 14-8
statistics reports 14-6
Measuring performance 14-1/14-10
Memory management
considerations 15-15
MESSAGES counter, Measure 14-9
Messages files 3-14
MESSAGE-BYTES counter, Measure 14-9
Metadata 8-2, 8-5
Metadata tables
list of 8-6/8-10
structure of 8-5
Metadata, querying
catalog attributes, displaying 8-23
catalog Guardian location,
displaying 8-22
catalog UID, displaying 8-20
catalogs on a node, displaying 8-21
catalog, displaying local or remote 8-21
column attributes, displaying 8-54
columns in a constraint, NOT
NULL 8-52
columns in a constraint, primary key or
unique 8-51
columns in a constraint, referential
integrity 8-53
columns in a table, displaying 8-48
columns in a view, displaying 8-49
columns in an index, displaying 8-50