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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-7
G
FILEINFO utility (continued)
volume recovery 12-2
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-14
interface description 3-14
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-3, 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-14
HEADING attribute 7-32
HIST_NO_STATS_REFRESH_
INTERVAL 6-3
HIST_SCRATCH_VOL 6-8
HIST_SECURITY_WARNINGS 6-3
I
import
appending data 10-39
to multiple partitions in
parallel 10-39
to tables 10-38
command options 10-23
examples of loading SQL/MX
tables 10-33/10-34
format file considerations 10-25
guidelines for loading and appending
data into tables 10-22
input file considerations 10-25
loading partitions 10-31
managing constraints 10-29
managing indexes 10-30
managing partitions 10-28
managing triggers 10-30
running on empty tables 10-27