SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)
Index
HP NonStop SQL/MX Installation and Management Guide—640325-001
Index-10
M
schema feature version,
displaying 8-70
schema owner, displaying 8-35
schema UID, displaying 8-27
schema version, displaying 8-70
schemas in a catalog, displaying 8-25
schemas on a node, displaying 8-28
SQL/MP alias name attributes,
displaying 8-45
SQL/MP names in a schema,
displaying 8-44
SQL/MX version, displaying 8-69
system schema tables, locating 8-21
system schema version,
displaying 8-70
table attributes, displaying 8-41, 8-42
tables containing a column,
displaying 8-64
tables in a catalog, displaying 8-37
tables in a schema, displaying 8-38
view attributes, displaying 8-43
views in a schema, displaying 8-43
Migrating nodes for improved query plan
performance 11-14
MIN function, optimization 4-18
Mirrored disk volumes 5-6, 12-40
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
converting globally placed to locally
placed 11-27
displaying all dependent on a specific
object 11-21
displaying all modules and dependent
objects 11-20
displaying dependent objects for one or
more specified modules 11-20
displaying in a local directory 11-22
grouping to run multiple DISPLAY USE
OF operations 11-23/11-26
managing 11-15
producing globally placed or locally
placed 11-15
recompiling 11-14
removing 11-26
securing globally placed 11-16
securing locally placed 11-17
Moving applications to a remote node 11-8
Multiple character sets 1-5
mxcierrors.cat file 3-14
MXCI, starting 3-16
MXCMP file 3-9
MXCS 1-12
MXESP file 3-9
MXGNAMES