FastSort Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series

191

192

193

194

195

196

197

198

199

200

Sorting From NonStop SQL/MP

FastSort Manual—429834-003

8-11

Configuring a CREATE INDEX Statement

The CREATE INDEX statement precedes all configuration information for the parallel

load operation. SQL/MP reads only CREATE INDEX statements in the configuration

file. The syntax for CREATE INDEX is as follows:

LOCALONLY

directs SQL/MP to run the SORTPROG and RECGEN processes only on the local

node. For performance reasons, the default location is remote. If there is no

remote node, then SORTPROG and RECGEN run locally. Use this option only on

systems with remote nodes to preserve software behavior available in previous

RVUs. If you specify LOCALONLY, it must be the first CREATE INDEX statement

in the configuration file.

BASETABLE

applies the attributes you specify to the record generator processes that read the

base table.

INDEX

applies the attributes you specify to the sort processes that write to index

partitions.

{LOCALONLY}

CREATEINDEX{BASETABLE}{DEFAULT [node-name] default-attr }

{INDEX }{partition attr [,attr ]... }

where default-attr is:

[ CPU ( num [, num ] ... ) ]

[ NOSCRATCHON (scratchvol [, scratchvol ]...) ]

[ NUMRECS ( number ) ]

[ PRI ( priority ) ]

[ PROGRAM (filename ) ]

[ SCRATCH (scratchvol [, scratchvol ]...) ]

[ SCRATCHON (scratchvol [, scratchvol ]...) ]

[ SWAP ( swapvol ) ]

and where attr is:

[ CPU (num ) ]