Sybase IQ certified on HP-UX 11.31 [CR 476205]

As of Sybase IQ 12.7 ESD #3, the following section updates “Adjusting kernel parameters” in Chapter 1, “Installing Sybase IQ,” in the Sybase IQ Installation and Configuration Guide.

Adjusting kernel parameters

You also need to adjust certain HP-UX kernel parameters to run Sybase IQ, as follows:

For HP-UX 11.31, invoke the HP System Management Homepage (SMH) to verify and set parameters.
For HP-UX 11.23, 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.

**Table 2: HP-UX parameters**
Parameter	HP-UX 11.31 suggested value	HP-UX 11.23 Itanium suggested value	HP-UX 11.23 RISC suggested value
STRMSGSZ	0	0	0
bufpages	n/a	n/a	n/a
max_thread_proc	4096	4096	4096
maxfiles	2048	2048	2048
maxfiles_lim	2060	2060	2060
maxswapchunks	n/a	n/a	n/a
maxusers	n/a	n/a	n/a
nfile	n/a	20000	20000
nkthread	8416	8416	4096
sema	n/a	n/a	n/a
semmap	n/a	n/a	n/a
semmni	7082	7082	7082
semmns	14164	14164	14164
shmmax	2147483647 (0X7FFFFFFF)	2147483647 (0X7FFFFFFF)	2147483647 (0X7FFFFFFF)
swapmem_on	0	0	0
unlockable_mem	n/a	10240	10240
maxdsiz_64bit	17179869184 (0x400000000)	17179869184 (0x400000000)	17179869184 (0x400000000)
maxrsessiz_64bit	1073741824	1073741824	n/a
maxssiz_64bit	1073741824	1073741824	268435456 (0x10000000)
maxtsiz_64bit	4294967296 (0x100000000)	4294967296 (0x100000000)	4294967296 (0x100000000)

After setting these parameters as required, reboot your system.

Notes

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).