SQL/MX 2.x Installation and Management Guide (H06.04+)

Index
HP NonStop SQL/MX Installation and Management Guide—540436-001
Index-10
M
Metadata, querying (continued)
DDL locks on an index, displaying 8-42
description of 8-2
detecting database
inconsistencies 8-63
index attributes, displaying 8-43
index states, displaying 8-44
indexes in a table, displaying 8-41
indexes in a table, locating 8-40
metadata tables, list of 8-6/8-13
object schema version, displaying 8-64
objects in a schema, displaying 8-29
partition attributes, displaying 8-46
partitions for a table or index,
displaying 8-45
privileges for a column, displaying 8-62
privileges for a table, displaying 8-60
privileges for a view, displaying 8-61
schema attributes, displaying 8-30
schema feature version,
displaying 8-64
schema owner, displaying 8-30
schema UID, displaying 8-27
schema version, displaying 8-64
schemas in a catalog, displaying 8-25
schemas on a node, displaying 8-28
SQL/MP alias name attributes,
displaying 8-39
SQL/MP names in a schema,
displaying 8-38
SQL/MX version, displaying 8-63
system schema tables, locating 8-21
system schema version,
displaying 8-64
table attributes, displaying 8-35, 8-36
tables containing a column,
displaying 8-58
tables in a catalog, displaying 8-32
tables in a schema, displaying 8-33
view attributes, displaying 8-37
Metadata, querying (continued)
views in a schema, displaying 8-37
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-12
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
converting globally placed to locally
placed 11-25
displaying all dependent on a specific
object 11-20
displaying all modules and dependent
objects 11-19