Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    5

    Unanswered: DB2 not able to find RAM after 2.71GB

    Hi,

    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.

    Thanks,
    Harpreet

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What are your DB2NTWORKSET registry variable values? If you haven't changed the default, try setting min and max to 1G and see if it helps.

  3. #3
    Join Date
    Sep 2004
    Posts
    5
    Thanks,
    But as per IBM, this registry variable is for WIndows NT only. And we are using Windows 2003.

    Regards,
    Harpreet

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The differences between WinNT and Win 2003 are much less than Microsoft would like you to believe.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •