SQL/MP Installation and Management Guide

Managing a Distributed Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
12-14
Using the Processor Usage DEFINE
Third hex character: CPUs 8-11
Fourth hex character: CPUs 12-15
SQL translates each hex character into its binary counterpart. Each bit represents one
processor. If a bit is on, SQL uses the corresponding processor. If a bit is off, SQL does
not use the corresponding processor.
This hex conversion table shows how each hex character represents four processors
with on or off bits:
If you have fewer than 16 processors in a system, you can use fewer than four hex
characters in the FILE clause. SQL assumes that missing trailing hex characters are
zero, so the processors they represent are not used.
For a complete description of the syntax of the _SQL_CMP_CPUS DEFINE, see the
SQL/MP Reference Manual.
To use hex conversion to specify the processors you want to use:
1. Determine the processor numbers you want to use. For example, suppose that you
want to use processors 0, 1, 2, 3, 8, 10, 12, and 15.
2. Lay out the processor numbers from 0 through 15 (or your highest processor
number). Place a 1 under each specified processor you want to use. Place a 0
(zero) under each specified processor that should not be used.
3. Convert the numbers to their hex counterparts.
4. Use the hex characters in the FILE clause of the _SQL_CMP_CPUS DEFINE.
In this example, suppose that you want to use processors 0, 1, 2, 3, 8, 10, 12, and 15:
CPU #: + 0 1 2 3 + 4 5 6 7 + 8 9 10 11 + 12 13 14 15
ON/OFF: + 1 1 1 1 + 0 0 0 0 + 1 0 1 0 + 1 0 0 1
HEX value: F 0 A 9
Using this conversion, you can set the DEFINE as follows:
>> ADD DEFINE =_SQL_CMP_CPUS_SYS1, CLASS MAP, FILE XF0A9;
Hex Binary (CPUs on or off) Hex Binary (CPUs on or
off)
0 0000 8 1000
1 0001 9 1001
2 0010 A 1010
30011 B 1011
4 0100 C 1100
5 0101 D 1101
6 0110 E 1110
7 0111 F 1111