SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)
Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-20
U
TMF subsystem (continued)
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
fallback A-1
file recovery 5-12, 12-1, 12-2
guidelines for configuring 5-13
INFO DUMPS, OBEYFORM
command 5-8, 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-3
RECOVER FILES command
description of 12-2
example of 12-18
examples of 12-4
indexes 12-12
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-17
performance 15-1
statistical 15-1
Triggers
adding 9-16
altering 9-25
dropping 9-38
restoring 12-23
U
UCS2 6-8
UDR_JAVA_OPTIONS 6-5, 6-11
UID (unique identifier) 8-22
UNDONEEDED flag (FILEINFO) 12-2,
12-3
Unique identifier (UID) 8-22
Unique indexes 4-14
UPDATE STATISTICS statement,
indexes 9-10, 9-11
UPDATES 15-10
Updating statistics 12-10
UPD_ABORT_ON_ERROR 6-5
UPSHIFT attribute 7-30
User aliases for the InstallSqlmx script 3-25
User module files 3-18
User permissions 7-9
Using DDL_DEFAULT_LOCATIONS to
distribute primary range partitions 7-17
Using RDF to set up a backup system 5-21
Using the SYSKEY 7-14