SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-4
Examples—=_DEFAULTS
Examples—=_DEFAULTS

These commands are all legal commands that alter the =_DEFAULTS DEFINE:
ALTER DEFINE =_DEFAULTS, VOLUME \SYS1.$VOL1.PERSNL;
ALTER DEFINE =_DEFAULTS, CATALOG $VOL1.CAT1;
ALTER DEFINE =_DEFAULTS, VOLUME $VOL1.PAYROLL;
VOLUME $VOL1.ORDENTRY;
SYSTEM \SYS2;
ALTER DEFINE =_DEFAULTS, SWAP $VOL1;

This example uses the INFO DEFINE command to display the current setting of
the =_DEFAULTS DEFINE:
>>INFO DEFINE =_DEFAULTS, DETAIL;
CLASS DEFAULTS
VOLUME \SYS2.$VOL1.ORDENTRY
CATALOG \SYS1.$VOL1.CAT1
SWAP \SYS2.$VOL1
=_SORT_DEFAULTS DEFINE
=_SORT_DEFAULTS is a system DEFINE that specifies defaults for FastSort
operations. It can affect SQL performance because SQL uses FastSort for queries and
utility operations.
=_SORT_DEFAULTS affects sorts performed as part of an SQL statement executed in
parallel if you do not specify scratch and swap files in a configuration file or by some
other mechanism. In this case, SQL uses the scratch and swap files specified in the
=_SORT_DEFAULTS DEFINE
.
ADD DEFINE =_SORT_DEFAULTS,
CLASS SORT [ , param value ] ...
param value is:
{ BLOCK block-size }
{ CPU cpu-number }
{ CPUS subsort-cpu-list }
{ MODE mode-type }
{ NOSCRATCHON ( volume-list ) }
{ NOTCPUS cpu-list-not-subsort }
{ PRI process-priority }
{ PROGRAM file }
{ SCRATCH file }
{ SCRATCHON ( volume-list ) }
{ SEGMENT extended-segment-size }
{ SUBSORTS define-list }
{ SWAP file-name }
{ VLM { ON | OFF } }