You also need to adjust certain HP-UX kernel parameters to run Sybase IQ. The HP System Administration Manager (SAM) allows verification and setting of these parameters. Generally superuser or “root” privileges are needed to run SAM. Use the Kernel Configuration submenu to change the parameters listed in the following table.
Parameter |
HP-UX 11.0 and HP-UX 11.i suggested value |
HP-UX 11.23 Itanium suggested value |
|---|---|---|
STRMSGSZ |
65000 |
0 |
bufpages |
2048 |
n/a |
max_thread_proc |
4096 |
4096 |
maxfiles |
2048 |
2048 |
maxfiles_lim |
2060 |
2060 |
maxswapchunks |
16384 |
n/a |
maxusers |
512 |
n/a |
nfile |
20000 |
20000 |
nkthread |
4096 |
8416 |
sema |
1 |
n/a |
semmap |
7084 |
n/a |
semmni |
7082 |
7082 |
semmns |
14164 |
14164 |
shmmax |
2147483647 (0X7FFFFFFF) |
2147483647 (0X7FFFFFFF) |
swapmem_on |
0 |
0 |
unlockable_mem |
10240 |
10240 |
maxdsiz_64bit |
17179869184 (0x400000000) |
17179869184 (0x400000000) |
maxrsessiz_64bit |
n/a |
1073741824 |
maxssiz_64bit |
268435456 (0x10000000) |
1073741824 |
maxtsiz_64bit |
4294967296 (0x100000000) |
4294967296 (0x100000000) |
After setting these parameters as required, reboot your system.
The swapmem_on parameter is set to 0 because setting it to 1 increases paging and deactivation activity.
The maxswapchunks parameter is increased to raise the limit of configurable swap space beyond the default.
For HP-UX 11.23 Itanium, set the nkthread value greater than (nproc + 100).
