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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-10
M
Metadata, querying (continued)
commands for displaying
information 8-2
constraint attributes, displaying 8-46
constraints on a table, displaying 8-45
constraints on a table, locating 8-44
DDL locks on a table, displaying 8-31
DDL locks on an index, displaying 8-39
description of 8-2
detecting database
inconsistencies 8-60
index attributes, displaying 8-40
index states, displaying 8-41
indexes in a table, displaying 8-38
indexes in a table, locating 8-37
metadata tables, list of 8-6/8-10
object schema version, displaying 8-61
objects in a schema, displaying 8-26
partition attributes, displaying 8-43
partitions for a table or index,
displaying 8-42
privileges for a column, displaying 8-59
privileges for a table, displaying 8-57
privileges for a view, displaying 8-58
schema attributes, displaying 8-27
schema feature version,
displaying 8-61
schema owner, displaying 8-27
schema UID, displaying 8-24
schema version, displaying 8-61
schemas in a catalog, displaying 8-22
schemas on a node, displaying 8-25
SQL/MP alias name attributes,
displaying 8-36
SQL/MP names in a schema,
displaying 8-35
SQL/MX version, displaying 8-60
system schema tables, locating 8-18
system schema version,
displaying 8-61
Metadata, querying (continued)
table attributes, displaying 8-32, 8-33
tables containing a column,
displaying 8-55
tables in a catalog, displaying 8-29
tables in a schema, displaying 8-30
view attributes, displaying 8-34
views in a schema, displaying 8-34
Migrating nodes for improved query plan
performance 11-14
MIN function, optimization 4-18
Mirrored disk volumes 5-6, 12-39
MODIFY
adding partitions 9-12, 9-21
description of 10-10
EMS messages 10-10
managing hash-partitioned
indexes 10-20
managing hash-partitioned
tables 10-19
managing range-partitioned
indexes 10-17
managing range-partitioned
tables 10-15
managing system-clustered tables and
indexes 10-21
online and offline partition
management 10-10
recovering a failed request and
resetting flags 10-13
table reloading 10-11
TMF considerations 10-11
using RECOVER and FUP
RELOAD 10-13
verifying that a flag is set in a
partition 10-13
Module files
system 3-13
user 3-13
Modules
checking with DISPLAY USE OF 11-19