SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
Index-18
U
RELEASED attribute 12-10
operations that affect TMF online
dumps 5-15
preinstallation tasks 3-2
RECOVER FILES command
description of 12-2
example of 12-19
examples of 12-5
indexes 12-13
MXGNAMES utility 12-3
partitions 12-10
recovery
catalogs 12-6
database 5-20
dropped SQL/MX objects 5-20
files 12-2, 12-3
network considerations 13-25
volumes 1-3, 5-12, 12-1, 12-2
re-creating online dumps 5-15
specifying attributes 5-13
SQL/MX requirements for 5-12
START command 12-2
starting 2-3
transaction backout 5-11
transactions 5-10
using MXCI 5-19
using the DUMP FILES command 5-17
TMFSERVE process, opening 2-4
Tools
database management 1-13
performance 14-1
statistical 14-1
Triggers
adding 9-16
altering 9-25
dropping 9-36
restoring 12-24
U
UCS2 6-4
UDR_JAVA_OPTIONS 6-7
UID
changing catalog, schema, and object
UIDs 12-35
description of 8-23
UNDONEEDED flag (FILEINFO) 12-2,
12-3
Unique indexes 4-14
UPDATE STATISTICS statement,
indexes 9-9
, 9-10
UPDATES 14-11
Updating statistics 12-11
UPSHIFT attribute 7-32
User aliases for the InstallSqlmx script 3-19
User module files 3-13
User permissions 7-10
Using DDL_DEFAULT_LOCATIONS to
distribute primary range partitions 7-19
Using RDF to set up a backup system 5-21
Using the SYSKEY 7-15
V
VARCHAR columns, performance
issues 7-24
VARCHAR_PARAM_DEFAULT_SIZE 6-7
VERIFY utility, mxtool
description of 8-3
, 12-30
example of 12-20, 12-21
recovered objects 12-11
Verifying software 3-15
Versioning
issues 11-8
Versions
executable files 3-15
querying metadata about 8-69/8-71
Views
adding 9-17
altering 9-25