Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008

    Unanswered: DB2 migration from V8.2 to 9.7

    please advise me.

    Finally we are going to migrate our DB2 v8.2 to v9.7 fp3a.
    The new version is going to be in a WIN 2008 64bit , in the virtual machine which is ESXi4.1 (Vsphere) Enterprise Plus.

    The question is, are there any special setup or configuration for the DB2 Performance wise need to be considered ?

    Please advise.


  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    DB2 9.7 memory and process architecture is very much different from that of DB2 8. Try to avoid adding virtualization complexity to the migration process. Your best bet would be to set up a real (not virtualized) DB2 9.7 environment and subject it to as much stress testing as you can provide. Begin with setting most parameters to AUTOMATIC, allowing the DB2 self-tuning memory manager (STMM) to do its job. Monitor the database and application performance and adjust the parameters where necessary.

    Once you are happy with the database performance, you can move it into a virtualized environment and verify, via additional stress testing, that it behaves as desired. In most cases you should not over-allocate virtual RAM and storage: define only as much virtual RAM as you have physically installed, and map each virtual LV to a real one. CPU can often be over-allocated, but that also depends on your actual system performance.

Posting Permissions

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