SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-24
U
Tables (continued)
PHYSVOL option 5-18
preallocating space 5-14
primary keys 3-4, 5-11
purging data 8-18
relative 3-1, 3-10, 5-14
renaming 7-36
reorganizing 8-1
restoring 11-2, 11-6
security 5-37, 10-29
security dependencies of indexes 4-5
similarity check rules 10-27
statistics, updating 14-7
USAGES catalog table 10-16
VERSIONS catalog table 6-15
view security 3-15, 5-38
TABLES catalog table, displaying
information 6-4, 6-5, 6-6
TACL DEFINEs, example 10-35, 10-36
Tasks, database management 1-10
Temporary files 14-28
Test database 11-33, 14-12/14-15
TIMEOUTS counters, Measure 13-10,
13-11
Timestamps
backups 4-20
creation, similarity check rules 10-27
views 6-5
TMF subsystem
command files 2-2
configuring 4-13
COPY utility 8-14
planning for requirements 4-12
recovery 4-1
catalogs 11-29
database 11-11
files 11-13, 11-14
network considerations 12-16
overview 4-10/4-17
volumes 1-5, 11-1, 11-11
TMF subsystem (continued)
requirements 2-1
RETAINDEPTH option 4-16
SQLCI 4-16
starting 2-2
transactions
automatic generation 4-16
constraint creation 5-53
index creation 7-5
recovery 4-10
UPDATE STATISTICS
statement 14-11
Tools
database management 1-10
performance measurement 13-1
recovery 11-1
statistics gathering 13-1
Trails, audit
See Audit trails
Transaction
See also TMF subsystem
backout 4-11
description 4-10
user-defined 2-14, 4-16
Transaction Management Facility (TMF)
See TMF subsystem
Transactions
See TMF subsystem, transactions
TRANSIDS catalog table
description 5-2
securing 5-7, 7-15
shorthand view creation 5-40
U
Unavailable access paths 10-13
Underlying tables, similarity check
rules 10-27
UNDONEEDED flag (FILEINFO) 11-12,
11-13
UNION operation 6-10