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

Index
HP NonStop SQL/MX Installation and Management Guide—540436-001
Index-7
G
Files
See also Tables
characteristics 4-3
command summary 1-13
consistent, recovering 12-32
EDIT 7-22
EMS events 3-6
executable 3-9
header 3-15
interface description 3-15
messages 3-14
recovering 12-2, 12-4
reorganizing 10-2
SPJ product 3-12
SQL/MX 3-8
structure 4-3, 4-5
FILE, Measure entity
access costs 14-10
description of 14-5
statistics 14-6
FIRST KEY clause 7-32
FIXUP command, mxtool
broken objects 12-32
description of 12-25
examples of 12-20, 12-21, 12-35
timestamps 12-11
FLOAT data type 7-26
FLOATTYPE 6-3, 6-7
FUP
RELOAD command 10-2
STATUS command 10-4
SUSPEND command 10-4
Using RELOAD to generate more
accurate query plans 15-17
G
GEN_MAX_NUM_PART_DISK_
ENTRIES 6-3
GEN_MAX_NUM_PART_NODE_
ENTRIES 6-3
GOAWAY command, mxtool
damaged objects 12-36
description of 12-26
Guardian files
physical names 1-7
retrieving information 12-31
H
Hardware
changing or moving 14-1
requirements 2-1
HASHPARTFUNC function 7-18
Header files 3-15
HEADING attribute 7-32
HIST_NO_STATS_REFRESH_
INTERVAL 6-3
HIST_SCRATCH_VOL 6-7
HIST_SECURITY_WARNINGS 6-3
I
import
appending data 10-35
to multiple partitions in
parallel 10-34
to tables 10-33
command options 10-22
examples of loading SQL/MX
tables 10-30/10-32
format file considerations 10-24
guidelines for loading and appending
data into tables 10-22
input file considerations 10-24
loading partitions 10-29
managing constraints 10-27
managing indexes 10-28
managing partitions 10-26
managing triggers 10-28
running on empty tables 10-25
running on populated tables 10-26
Inconsistencies, detecting 8-63