SQL/MX 2.x Installation and Management Guide (H06.04+)

Index
HP NonStop SQL/MX Installation and Management Guide—540436-001
Index-18
T
System defaults (continued)
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-13
System schema tables, locating 8-15/8-22
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
Tables (continued)
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-31/8-35
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-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-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