Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Unanswered: Maximum memory limit for DB2 instance in windows


    We use db2 8.2 on windows 2000 platform.

    Our production server has 4GB main memory.

    Would like to know what is the maximum memory a given DB2 instance can have in windows 2000 system? Some one here tells me DB2 instance can address only up to 1GB in windows - but I have doubts - would like to check with experts.



  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    On Windows DB2 is subject to the same limitations as all Windows applications: user memory is limited to 2 GB (or 3 GB, if the system is configured accordingly). Extended memory (between 4 GB and 16 GB) can be used for extended bufferpools.
    "It does not work" is not a valid problem statement.

Posting Permissions

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