SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-2
B
Applications (continued)
example 2-1
Archiving SQL objects 4-17
ASCII character set 5-20
ASCII collating sequence 5-20, 5-44
Attributes
altering catalog 7-15
altering table 7-16
altering view 7-18
FILEINFO display 6-10
specifying column 5-28
AUDIT attribute
altering index attributes 7-19
protection views 4-15
similarity check rules 10-28
Audit dump 4-11
Audit flag 6-4
Audit trails
See also TMF subsystem
AUDITCOMPRESS attribute 4-15
configuring 4-10, 4-13, 4-15
constraint creation 5-53
COPY utility 8-14
description 4-10
file recovery 11-13
index creation 7-5
UPDATE STATISTICS statement 14-11
volume recovery 11-12
AUDITCOMPRESS attribute
audit trail data 4-15, 5-17
similarity rules 10-28
AUDITED backup option 9-34
Audited objects, archiving 4-18
AUDITED option 11-8
Auditing
DUP operations 9-5
TMF guidelines 4-13
TMF requirements 4-12
volumes 4-12, 5-4
AUDITONLY option 4-17
Authorization
See also Security
requirements summary 4-5/4-8
rules 4-4
Safeguard 4-8, 4-9
schemes 4-2/4-4, 12-4
AUTOCOMPILE flag 10-9
AUTOCREATECATALOG option 11-2
Automatic recompilation
avoiding 14-25
causes 10-7
gathering statistics 13-6
occurrence 10-7
performance considerations 10-9,
14-25
predicting 10-7
query execution plans 10-12
RECOMPILES counter 13-9
recorded time 10-4
Autonomy, local
description 12-2, 12-5
SQL compiler options 10-9
AUTOWORK option 4-16
Avoiding 10-14
B
Backing up
AUDITED option 9-34
daily 4-19
database, time required 9-33
file-mode 4-24
indexes 4-22
periodic 4-20
programs, OBEY command file 9-34
SQL objects 9-33, 9-34
SQL programs 9-33, 9-34
strategies 4-17
timestamps as a basis 4-20
views 4-22