Anybody Using Power4 or Power5 platforms?

Data Goob

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

Roger

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

Data Goob

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