I heard DB2 32bit can only safely use up to 1.1 gigabytes of shared
memory. I've summed up the ten DB2 memory components that utilize
shared memory on the TP1 instance and it adds up to 1,036,091,392
bytes. However, I noticed another DB2 instance GP1 that totals
1,822,097,408. Obviously, 1.8 gb is way beyond the 1.1GB "shared
memory limitation". The GP1 seems to be running fine without
crashing. I've listed the relevant DB2 configurations of the two
example instances TP1 & GP1 below.

Is the 32bit DB2 shared memory max limitation officially documented
anywhere? Is it really 1.1 GB? Or is it 1.2 GB? Or is it something
else entirely?

(Again, I realize that 64bit DB2 has higher memory limits but both of
these example instances are 32 bit DB2.)

Thanks for any insights and help


instance TP1 (on AIX 4.3.3):
Backup buffer default size (4KB) (BACKBUFSZ) = 4096
Restore buffer default size (4KB) (RESTBUFSZ) = 4096
Sort heap threshold (4KB) (SHEAPTHRES) = 61440
Database heap (4KB) (DBHEAP) = 47104
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 4096
Log buffer size (4KB) (LOGBUFSZ) = 1024
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 52248
Buffer pool size (pages) (BUFFPAGE) = 45056
Max storage for lock list (4KB) (LOCKLIST) = 25600
Package cache size (4KB) (PCKCACHESZ) = 8192
252952 total shared memory
db2tp1 25> bc
252952*4096
1036091392

instance GP1 (on AIX 5):
Backup buffer default size (4KB) (BACKBUFSZ) = 4096
Restore buffer default size (4KB) (RESTBUFSZ) = 4096
Sort heap threshold (4KB) (SHEAPTHRES) = 61440
Database heap (4KB) (DBHEAP) = 20000
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 4000
Log buffer size (4KB) (LOGBUFSZ) = 1024
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 20480
Buffer pool size (pages) (BUFFPAGE) = 281520
Max storage for lock list (4KB) (LOCKLIST) = 40000
Package cache size (4KB) (PCKCACHESZ) = 8192
444848 total shared memory
db2gp1 7> bc
444848*4096
1822097408