Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: DB2 Upgrade to 64bit

    My instance is currently db2 8.2 fixpack9 and running on 32 bit. We plan to upgrade the instance to 64 bit soon. Is there a rule of thumb for how much to increase buffer pools after the upgrade ? Are there IBM documentations with suggestions ?


  2. #2
    Join Date
    May 2003
    Just make sure that you don't exceed the amount of physical memory on the machine when taking into consideration OS usuage, other application usuage, and all DB2 usuage of memory. DB2 does not like virtual memory (swapping).

    Obviously, there is no need to create bufferpools that are larger than the total amount of space used in the tables and indexes.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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