By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Anybody Using Power4 or Power5 platforms?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.