We are running stress test on DB2 8.1.6 (32-Bit) Enterprise Server Edition. It is crashing after consuming 2.71GB of RAM. Total RAM in the system is 8GB and AWE settings are made to access the RAM. DB2_AWE as well boot.ini (/PAE) are set as it used to be when using DB7.2.5 version, from which we have migrated now.
DB2 is not able to find RAM after this, as it started saying "not enough memory to process the statement" and some other memory/heap related messages start appearing in the log. Any ideas why it is not exceeding this limit, while for DB2 7.2, same settings were using upto 3.6GB RAM peacefully.
Other difference we have is, DB2 7.2 was running on Win2000, and DB2 8.1.6 is running on Win2003 Enterprise Server Edition.
Any help in this direction will be highly appreciated.