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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-18
T
System defaults (continued)
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION 6-4, 6-13
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 6-8
QUERY_CACHE 6-9
QUERY_CACHE_
STATEMENT_PINNING 6-9
QUERY_CACHE_MAX_ VICTIMS 6-9
QUERY_CACHE_REQUIRED_
PREFIX_KEYS 6-9
READONLY_CURSOR 6-13
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT 6-4, 6-10,
6-13
SAVE_DROPPED_TABLE_ DDL 6-4
SAVE_DROPPED_TABLE_DDL 6-10
SCRATCH_DISKS 6-11
SCRATCH_DISKS_ EXCLUDED 6-11
SCRATCH_DISKS_
PREFERRED 6-11
setting and updating 6-1
TEMPORARY_TABLE_
HASH_PARTITIONS 6-11
TEMPORARY_TABLE_HASH_
PARTITIONS 6-5
TIMEOUT 6-12
UDR_JAVA_OPTIONS 6-5, 6-12
UNION_TRANSITIVE_PREDICATE 6-
6
UPD_ABORT_ON_ERROR 6-5
VARCHAR_PARAM_DEFAULT_SIZE 6
-5
System module files 3-13
System schema tables, locating 8-12/8-19
SYSTEM_DEFAULTS table
description of 6-1, 6-2
inserting rows 6-2
updating 6-2
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-8
organization 7-12
partitioned 7-16, 15-19
querying metadata about 8-28/8-32
recovering 12-13
restoring 12-23
view security 7-39
Tasks, database management 1-13
TEMPORARY_TABLE_
HASH_PARTITIONS 6-11
TEMPORARY_TABLE_HASH_
PARTITIONS 6-5
Test database 12-40
TIME option, TMF file recovery 12-2, 12-3
TIMEOUT 6-12
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-4