NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
Z-6
Considerations—=_SQL_CAT_HEAP_LIMIT
heap-space-size
is the amount of heap space for the SQLCAT process, in megabytes. This value can
range from 8 to 2047. SQL does not use the node, volume, and subvolume portions
of the file name if supplied.
Considerations—=_SQL_CAT_HEAP_LIMIT
•
If there is an error in heap-space-size, SQL returns a warning, and SQLCAT
runs with the default heap space size.
•
The =_SQL_CAT_HEAP_LIMIT DEFINE can be used from TACL, SQLCI, or a
user process (for embedded SQL).
Examples—=_SQL_CAT_HEAP_LIMIT
•
The following TACL command specifies 32 MB of SQLCAT heap space:
32> ADD DEFINE =_SQL_CAT_HEAP_LIMIT, CLASS MAP, FILE M32
•
The following TACL command directs SQL to use its default value for heap space
size:
33> DELETE DEFINE =_SQL_CAT_HEAP_LIMIT
=_SQL_CMP_CPUS_node DEFINE
The =_SQL_CMP_CPUS_node DEFINE is a system DEFINE that directs SQL to
limit CPUs used in a parallel query to a specified node.
_node
is the node associated with the CPUs to use for the query. _node is optional; the
default value is the current node.
Xhhhh
is the letter X (uppercase) followed by up to four hex characters. X has no purpose
other than to make the DEFINE syntactically correct. The hex character or
characters represent a unique configuration of available CPUs. For a sample
configuration and conversion from binary code to hex characters, see Considerations
in this entry.
Considerations—=_SQL_CMP_CPUS_node
•
Scope of =_SQL_CMP_CPUS_node
To specify available CPUs, add this DEFINE before you compile the query.
=_SQL_CMP_CPUS_node affects all parallel query plans compiled while the
ADD DEFINE =_SQL_CMP_CPUS_node, CLASS MAP, FILE Xhhhh