FastSort Manual

Index
FastSort Manual—429834-003
Index-7
O
O
Online help, HELP command 3-18
ORDER BY clause, SQL/MP 1-10, 8-4
OSIMAGE file 1-4
Output files
EDIT C-4
entry-sequenced C-2
estimating size 4-8
EXCLUSION mode, TO command 3-28
existing 3-31
file types, SORTMERGESTART 1-9,
5-24
key-sequenced 3-30, C-3
options summary 1-3
partitioned C-5
relative C-2
requirements for existing 3-31
slack space for key-sequenced 3-30
specifying file access with
SORTMERGESTART 5-23
summary of types C-1
tape C-4
TO command 3-28, 3-29
unstructured C-2
using FUP to load a blocked tape
file 1-9
valid types 3-30
Output records
format, SORTMERGESTART 5-22
receiving in extended memory 5-15
returning to a process 4-6
returning with
SORTMERGERECEIVE 5-13
P
Paging (swapping) files 6-10
PARALLEL EXECUTION ON option,
SQL/MP
configuring CREATE INDEX
statement 8-9
PARALLEL EXECUTION ON option,
SQL/MP (continued)
default configuration 8-9/8-10
description 1-11, 8-7
sample CREATE INDEX configuration
file 8-10
scratch and swap files for CREATE
INDEX 8-10
scratch files 8-16
Parallel sorting
See also PARALLEL EXECUTION ON
option, SQL/MP
configuring a distributor-collector 6-10
configuring subsorts in SUBSORT
command 3-26
description of 6-1
errors 6-14
improving performance 6-11
mirrored disks 6-13
returning error information 5-10
scratch block size for subsorts 6-11
setting up 6-3
specifying in procedures 4-3
testing configuration 6-13
Parameters, displaying with SHOW
command 3-25
Partitioned files
creating a partitioned scratch file 9-8
FastSort input C-5
FastSort output C-5
Partitioned index, SQL/MP
description 1-10
loading data 8-7
loading multiple indexes in
parallel 8-15
Performance
improving with parallel sorting 6-11
Measure program 6-13
tuning configuration of subsort
processes 6-13
Permutation and key sort, example 2-11