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

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-19
T
System defaults (continued)
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 6-8
QUERY_CACHE 6-8
QUERY_CACHE_
STATEMENT_PINNING 6-9
QUERY_CACHE_MAX_ VICTIMS 6-8
QUERY_CACHE_REQUIRED_
PREFIX_KEYS 6-9
READONLY_CURSOR 6-12
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT 6-4, 6-10,
6-12
SAVE_DROPPED_TABLE_ DDL 6-4
SAVE_DROPPED_TABLE_DDL 6-10
SCRATCH_DISKS 6-10
SCRATCH_DISKS_ EXCLUDED 6-10
SCRATCH_DISKS_
PREFERRED 6-11
setting and updating 6-1
TEMPORARY_TABLE_
HASH_PARTITIONS 6-11
TEMPORARY_TABLE_HASH_
PARTITIONS 6-5
TIMEOUT 6-11
UDR_JAVA_OPTIONS 6-5, 6-11
UPD_ABORT_ON_ERROR 6-5
VARCHAR_PARAM_DEFAULT_SIZE 6
-5
System module files 3-17
System schema tables, locating 8-15/8-21
SYSTEM_DEFAULTS table
description of 6-1, 6-2
inserting rows 6-2
updating 6-2
T
T9053APG 3-2
T9053APO 3-2
Tables
adding 9-15
altering 9-22
altering privileges 9-25
attributes, specifying 7-19
command summary 1-17
controlling access 16-2
creating 7-11
creating views 7-37
database layout 4-10
description of 4-10
dropping 9-36
file structure 4-5
key-sequenced 4-3
local partitions 13-23
matching data types 7-30
opens statistics 15-8
organization 7-11
partitioned 7-15, 16-14
querying metadata about 8-30/8-34
recovering 12-12
restoring 12-22
view security 7-37
Tasks, database management 1-17
TEMPORARY_TABLE_
HASH_PARTITIONS 6-11
TEMPORARY_TABLE_HASH_
PARTITIONS 6-5
Test database 12-38
TIME option, TMF file recovery 12-2, 12-3
TIMEOUT 6-11
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
concepts 5-10