I am running Sybase 11.9.2 on HP-UX 11.11. Server has 8GB Ram and

shmmax is setup as 5368708120

Total Memory in sybase:

total memory 14336 1740000 870000 870000

** I cannot increase Total Memory above 2GB in Sybase **

# ipcs -mbs
IPC status from /dev/kmem as of Thu Jul 10 15:02:50 2003
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 0 0x411c025e --rw-rw-rw- root root 348
m 1 0x4e0c0002 --rw-rw-rw- root root 61760
m 2 0x41201542 --rw-rw-rw- root root 8192
m 3 0x301c63c0 --rw-rw-rw- root root 1048576
m 2804 0x5e10005d --rw------- root root 512
m 25605 0x2e845e95 --rw------- sybase amos 1073635328
m 406 0x2e845e96 --rw------- sybase amos 699240448
T ID KEY MODE OWNER GROUP NSEMS

Adaptive Server Enterprise/11.9.2/1031/P/HP9000-735/HP-UX 10.2/FBO/Fri Aug 14 10:49:29 1998 (not sure why '10.2' is showing here?)

#uname -r
B.11.11
#

Any ideas on this one please (apologies if this problem has being posted here before)

Mick

1) Did you execute a 2) Did zou read the Sybase Release Bulletin for ASE 11.9 on HP-Ux ?

Looks like 32 bit release (11.9.2), you may need the 64 bit release (11.9.3) to use more than 2GB of memory. Though I am less certain of this on HP-UX than I am on Solaris.