SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
Index-17
T
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 6-4
QUERY_CACHE 6-4
QUERY_CACHE_
STATEMENT_PINNING 6-5
QUERY_CACHE_MAX_ VICTIMS 6-4
QUERY_CACHE_REQUIRED_
PREFIX_KEYS 6-5
READONLY_CURSOR 6-8
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT 6-6
, 6-8
SAVE_DROPPED_TABLE_DDL 6-6
SCRATCH_DISKS 6-6
SCRATCH_DISKS_ EXCLUDED 6-6
SCRATCH_DISKS_ PREFERRED 6-7
setting and updating 6-1
TEMPORARY_TABLE_
HASH_PARTITIONS 6-7
TIMEOUT 6-7
UDR_JAVA_OPTIONS 6-7
System module files 3-13
System schema tables, locating 8-11/??
SYSTEM_DEFAULTS table
description of 6-1
, 6-2
inserting rows 6-2
updating 6-1
T
Tables
adding 9-14
altering 9-22
altering privileges 9-25
attributes, specifying 7-21
command summary 1-13
controlling access 15-2
creating 7-11
creating views 7-39
database layout 4-10
description of 4-10
dropping 9-34
file structure 4-5
key-sequenced 4-3
matching data types 7-32
opens statistics 14-9
organization 7-12
partitioned 7-16, 15-19
querying metadata about 8-36/8-41
recovering 12-13
restoring 12-23
view security 7-39
Tasks, database management 1-13
TEMPORARY_TABLE_
HASH_PARTITIONS 6-7
Test database 12-40
TIME option, TMF file recovery 12-2, 12-3
TIMEOUT 6-7
Timestamps, backups 5-31
TMF subsystem
ADD DUMPS command 5-15
ALTER DUMPS command 5-15, 12-10
audit dumps 5-11
audit trails 5-10, 12-1
audited files 5-11
command files 2-3
concepts 5-10
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
file recovery 5-12, 12-1, 12-2
guidelines for configuring 5-13
INFO DUMPS, OBEYFORM
command 5-9
invalidation of online dumps 5-15
online dumps 5-11
INVALID attribute 12-10
performing 5-9