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

Index
HP NonStop SQL/MX Installation and Management Guide—640325-001
Index-9
M
CALLS counter 14-10
description of 14-5
DISK-READS counter 14-10, 14-11
ELAPSED-BUSY-TIME counter 14-10
ELAPSED-RECOMPILE-TIME
counter 14-10
FILE entity 14-6, 14-7, 14-11
index creation 9-9
LOCK-WAITS counter 14-10, 14-11
MESSAGES counter 14-10
MESSAGES-BYTES counter 14-10
OPENS counter 14-9
RECOMPILES counter 14-10
RECORDS-ACCESSED
counter 14-10, 14-11
RECORDS-USED counter 14-10,
14-11
SQLPROC entity 14-6
SQLSTMT entity 14-6
SQL-NEWPROCESS counter 14-9
SQL-NEWPROCESS-TIME
counter 14-9
SQL-OBJ-RECOMPILE-TIME
counter 14-9
SQL-STATEMENT-RECOMPILES
counter 14-9
SQL-STATEMENT-RECOMPILES-
TIME counter 14-9
statistics reports 14-7
Measuring performance 14-1/14-11
Memory management
considerations 15-15
MESSAGES counter, Measure 14-10
Messages files 3-14
MESSAGE-BYTES counter,
Measure 14-10
Metadata 8-2, 8-5
Metadata tables
list of 8-6/8-9
structure of 8-5
Metadata, querying
catalog attributes, displaying 8-26
catalog Guardian location,
displaying 8-25
catalog UID, displaying 8-23
catalogs on a node, displaying 8-24
catalog, displaying local or remote 8-24
column attributes, displaying 8-63
columns in a constraint, NOT
NULL 8-61
columns in a constraint, primary key or
unique 8-60
columns in a constraint, referential
integrity 8-61
columns in a table, displaying 8-57
columns in a view, displaying 8-58
columns in an index, displaying 8-59
commands for displaying
information 8-2
constraint attributes, displaying 8-55
constraints on a table, displaying 8-54
constraints on a table, locating 8-53
DDL locks on a table, displaying 8-39
DDL locks on an index, displaying 8-48
description of 8-2
detecting database
inconsistencies 8-69
index attributes, displaying 8-49
index states, displaying 8-50
indexes in a table, displaying 8-47
indexes in a table, locating 8-46
metadata tables, list of 8-6/8-9
object schema version, displaying 8-70
objects in a schema, displaying 8-34
partition attributes, displaying 8-52
partitions for a table or index,
displaying 8-51
privileges for a column, displaying 8-68
privileges for a table, displaying 8-66
privileges for a view, displaying 8-67
schema attributes, displaying 8-35