Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: luw on solaris vs luw on linux

    Does anyone have any experiences with any performance differences (if any) when running db2 luw on similar size solaris and linux servers ?

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Are you talking about Sun SPARC processors, or Solaris running on an similar sized Intel based platform? Might be hard to compare systems with a Sun SPARC processor with one that has Intel processors.

    If the two systems were anywhere close in performance, I would prefer Linux on Intel processors due to much large number of other DB2 customers on that platform, and therefore better likelihood that someone else has found a bug in the DB2 code specific to that platform (and reported it to IBM) before me.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by Marcus_A View Post
    I would prefer Linux on Intel processors due to much large number of other DB2 customers on that platform
    True, but it would be nice to see how db2 performs on a ZFS filesystem.
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  4. #4
    Join Date
    Apr 2004
    Posts
    190
    Yes, we're talking Sun SPARC vs Intel EM64T.

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by dr_te_z View Post
    True, but it would be nice to see how db2 performs on a ZFS filesystem.
    If you have an OLTP application/database, hopefully your bufferpool hit ratio will mask any differences. Memory (for large buferpools) is relatively cheap, especially since it is not used to calculate DB2 license costs (as are CPU cores).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by Marcus_A View Post
    If you have an OLTP application/database, hopefully your bufferpool hit ratio will mask any differences.
    Shhhht, not so loud: Scott can hear you. Did you not attend his class?

    Quote Originally Posted by Marcus_A View Post
    especially since it is not used to calculate DB2 license costs (as are CPU cores).
    True when you purchase > 'workgroup edition'
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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