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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-2
B
Applications (continued)
environment 1-1
migrating 11-1
moving 11-3
moving to remote node 11-9
running on a remote node 11-9
Archiving SQL/MX objects 5-30
ASCII character set 7-21
Attributes
altering 9-24
column, specifying 7-30
Audit bit, changing 12-32
Audit trails 12-2
AUDITCOMPRESS attribute
altering index attributes 9-20
altering table attributes 9-24
audit trail data 7-19
Audited objects, archiving 5-7
Authorization, Safeguard 5-4
Automatic recompilation
avoiding 16-14
gathering statistics 15-6
performance considerations 16-14
RECOMPILES counter 15-9
Autonomy, local
description of 13-12
queries 13-2
B
Backing up
and restoring programs 11-28
frequency 5-30
periodic 5-31
timestamps as a basis for 5-31
Backup and Restore 2
backing up and restoring SPJ class or
JAR files 5-35
backing up and restoring SPJ
metadata 5-35
backing up catalogs 5-32
Backup and Restore 2 (continued)
backing up constraints 5-33
backing up indexes and index
partitions 5-33
backing up schemas 5-32
backing up tables and partitions 5-32
description of 5-27
executables and modules 5-35
frequency of backups
daily 5-31
periodic full 5-31
timestamp 5-31
objects not restored 5-34
other restrictions on operations 5-34
RESTORE command 12-21
restoring catalogs 12-22
restoring indexes 12-23
restoring RI constraints 12-23
restoring schemas 12-22
restoring SPJs 12-23
restoring table partitions 12-22
restoring tables 12-22
restoring triggers 12-23
restoring views 12-23
SHOWDDL file creation 12-23
using the RESTORE command
SHOWDDL option 12-23
using the RESTORE SHOWDDL ON
option 5-36
BACKUP command, PARTONLY
option 5-33
Base tables
creating 7-11
creating views of 7-37
using exclusively in database 4-10
Benchmark, performance 15-1
Blocks, key-sequenced file 4-6
Broken bit, changing 12-33
BROKEN flag 12-32
Broken partitions, recovering 12-32