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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-19
U
TMF subsystem (continued)
concepts 5-10
creating and managing online
dumps 5-14
description of 5-10
determining a level of data
protection 5-13
determining size requirements 5-13
DUMP FILES command 12-1
file recovery 5-12, 12-1, 12-2
guidelines for configuring 5-13
INFO DUMPS, OBEYFORM
command 5-9
invalidation of online dumps 5-15
online dumps 5-11
INVALID attribute 12-10
performing 5-9
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-4
TMF subsystem (continued)
transaction backout 5-11
transactions 5-10
using MXCI 5-19
using the DUMP FILES command 5-17
TMFSERVE process, opening 2-5
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-8
UDR_JAVA_OPTIONS 6-5, 6-12
UID
changing catalog, schema, and object
UIDs 12-35
description of 8-20
UNDONEEDED flag (FILEINFO) 12-2,
12-3
Unique indexes 4-14
UPDATE STATISTICS statement,
indexes 9-9, 9-10
UPDATES 14-10
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