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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-2
B
Applications (continued)
environment 1-1
moving programs from development to
production 11-3
moving to remote node 11-8
reasons not to move a program with
compiled modules 11-4
running on a remote node 11-9
writing to recover from temporary
service organizations 11-1
Archiving SQL/MX objects 5-30
ASCII character set 7-23
Attributes
altering 9-23
column, specifying 7-32
Audit bit, changing 12-33
Audit trails 12-2
AUDITCOMPRESS attribute
altering index attributes 9-20
altering table attributes 9-24
audit trail data 7-22
Audited objects, archiving 5-7
Authorization, Safeguard 5-4
Automatic recompilation
avoiding 15-20
gathering statistics 14-6
performance considerations 15-20
RECOMPILES counter 14-9
Autonomy, local
description of 13-12
queries 13-2
B
Backing up
and restoring programs 11-30
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
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
objects not restored 5-34
other restrictions on operations 5-34
RESTORE command 12-22
restoring catalogs 12-23
restoring indexes 12-24
restoring RI constraints 12-24
restoring schemas 12-23
restoring SPJs 12-24
restoring table partitions 12-23
restoring tables 12-23
restoring triggers 12-24
restoring views 12-24
SHOWDDL file creation 12-24
using the RESTORE command
SHOWDDL option 12-24
using the RESTORE SHOWDDL ON
option 5-36
BACKUP command, PARTONLY
option 5-33
Base tables
creating 7-11
creating views of 7-39
using exclusively in database 4-10
Benchmark, performance 14-1