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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-10
M
Measure (continued)
SQL-NEWPROCESS counter 15-8
SQL-NEWPROCESS-TIME
counter 15-8
SQL-OBJ-RECOMPILE-TIME
counter 15-8
SQL-STATEMENT-RECOMPILES
counter 15-8
SQL-STATEMENT-RECOMPILES-
TIME counter 15-8
statistics reports 15-6
Measuring performance 15-1/15-10
Memory management considerations 16-9
MESSAGES counter, Measure 15-9
Messages files 3-18
MESSAGE-BYTES counter, Measure 15-9
Metadata 8-2, 8-5
Metadata migration
description of 14-7
fallback considerations 14-7
metadata tables 14-5
migrating DEFAULTS metadata 14-11
migrating ODBC metadata 14-12
migrating SQL/MP aliases 14-8
migrating stored procedures 14-14
requirements 14-6
Metadata tables
list of 8-6
/8-13
structure of 8-5
Metadata, querying
catalog attributes, displaying 8-25
catalog Guardian location,
displaying 8-24
catalog UID, displaying 8-22
catalogs on a node, displaying 8-23
catalog, displaying local or remote 8-23
column attributes, displaying 8-56
columns in a constraint, NOT
NULL 8-54
columns in a constraint, primary key or
unique 8-53
Metadata, querying (continued)
columns in a constraint, referential
integrity 8-55
columns in a table, displaying 8-50
columns in a view, displaying 8-51
columns in an index, displaying 8-52
commands for displaying
information 8-2
constraint attributes, displaying 8-48
constraints on a table, displaying 8-47
constraints on a table, locating 8-46
DDL locks on a table, displaying 8-33
DDL locks on an index, displaying 8-41
description of 8-2
detecting database
inconsistencies 8-62
index attributes, displaying 8-42
index states, displaying 8-43
indexes in a table, displaying 8-40
indexes in a table, locating 8-39
metadata tables, list of 8-6/8-13
object schema version, displaying 8-63
objects in a schema, displaying 8-28
partition attributes, displaying 8-45
partitions for a table or index,
displaying 8-44
privileges for a column, displaying 8-61
privileges for a table, displaying 8-59
privileges for a view, displaying 8-60
schema attributes, displaying 8-29
schema feature version,
displaying 8-63
schema owner, displaying 8-29
schema UID, displaying 8-26
schema version, displaying 8-62
schemas in a catalog, displaying 8-24
schemas on a node, displaying 8-27
SQL/MP alias name attributes,
displaying 8-38