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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-11
M
Metadata, querying (continued)
SQL/MP names in a schema,
displaying 8-37
SQL/MX release, displaying 8-62
system schema tables, locating 8-21
system schema version,
displaying 8-63
table attributes, displaying 8-34, 8-35
tables containing a column,
displaying 8-57
tables in a catalog, displaying 8-31
tables in a schema, displaying 8-32
view attributes, displaying 8-36
views in a schema, displaying 8-36
Migrating nodes for improved query plan
performance 11-15
Migration
basics 14-1
Enscribe database 14-14
MPALIAS metadata 14-2
planning for 14-2/14-4
SQL/MP database 14-1/14-15
to Release 2.1 or 2.0 A-2, A-3
tools for moving data 14-15
MIN function, optimization 4-18
Mirrored disk volumes 5-6, 12-38
MODIFY
adding partitions 9-12
, 9-21
description of 10-9
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
MODIFY (continued)
online and offline partition
management 10-10
recovering a failed request and
resetting flags 10-13
table reloading 10-11
TMF considerations 10-10
using RECOVER and FUP
RELOAD 10-13
verifying that a flag is set in a
partition 10-13
Module files
system 3-17
user 3-18
Modules
checking with DISPLAY USE OF 11-20
converting globally placed to locally
placed 11-23
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-21
displaying in a local directory 11-21
falling back globally placed modules
and their applications 11-25
falling back locally placed modules and
their applications 11-26
managing 11-15
producing globally placed or locally
placed 11-16
recompiling 11-15
removing 11-22
securing globally placed 11-17
securing locally placed 11-19
Moving applications to a remote node 11-9
MSCF_ET_REMOTE_MSG_
TRANSFER 6-3
Multinode installations 14-2
Multiple character sets 1-5
mxcierrors.cat file 3-18