467,151 Members | 920 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,151 developers. It's quick & easy.

Anybody Using Power4 or Power5 platforms?

We're considering the Power5 hardware platform.

Anybody out there have any experience positive or negative with DB2 in this
environment?

We're curious how much horsepower we need for a rather large data mart.

--DG--

Nov 12 '05 #1
  • viewed: 1076
Share:
2 Replies
Yes. we are using P4+ with Linux Suse SLES 8 and DB2 UDB v8 for
pseries and it's working verry well.... at least sine we configured
the disks properly.
We had some problem with where to put db2 log files, on a RAW-device
or on raid volume... Conclusion of our tests :
DON'T have the log files on an internal disk(s), slow
insert/update/delete
DON'T have the log files on a external disk(s) without a hw raid
controller, faster insert/update/delete than internal disks but it's
still slower than if you had a hw raid controller.
DB2's log files should be on a external Raid0, Raid1 or Raid5
depending on the number of disks available, fast insert/update/delete.
RAW devices is an option IF you have these raw device's on external
disks...Internal raw device's is not an option , to slow.
Nov 12 '05 #2
Thanks Roger!

We'll be staying away from RAID5, and hopefully go for external drives. Will
probably move right into Power5.

-DG-

Roger wrote:
Yes. we are using P4+ with Linux Suse SLES 8 and DB2 UDB v8 for
pseries and it's working verry well.... at least sine we configured
the disks properly.
We had some problem with where to put db2 log files, on a RAW-device
or on raid volume... Conclusion of our tests :
DON'T have the log files on an internal disk(s), slow
insert/update/delete
DON'T have the log files on a external disk(s) without a hw raid
controller, faster insert/update/delete than internal disks but it's
still slower than if you had a hw raid controller.
DB2's log files should be on a external Raid0, Raid1 or Raid5
depending on the number of disks available, fast insert/update/delete.
RAW devices is an option IF you have these raw device's on external
disks...Internal raw device's is not an option , to slow.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Fred | last post: by
9 posts views Thread by svenn.are@bjerkem.de | last post: by
reply views Thread by Another DB2 UDB DBA | last post: by
1 post views Thread by Aaron Lee | last post: by
42 posts views Thread by (PeteCresswell) | last post: by
5 posts views Thread by Michael Sperlle | last post: by
71 posts views Thread by desktop | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.