Posted on 2004-09-06
I Am about to set up a DB2 server and wanted to get a critique of what I plan to do. Please feel free to rip this to shreds
IBM ServRAID 5i
RAID-5 (6 disks, stripesize 16k)
HDD 4.7 avg seek, 10,000 rotation TR 320
The database will be combined OLTP/Queries (Its a financial services system for a small/mid sized company, 70 users using a Java/Browser based front end). Reporting will also be done off this server (mostly out of hours).
I will have 2 massive fact tables which make up about 1/3 of overall data.
I have turned on DB2_STRIPED_CONTAINERS and set DB2_PARALLEL_IO=*
The area I am mainly interested in planning at the moment is physical layout (altho I welcome tips on any relevent area).
Here are my plans:
Put most tables in the userspace1, assigning most of the bufferpool to that space.
Create a DMS tablespace for the 2 big tables, giving eact one 3 containers of about 3GB each.
I intend to make the extent=16 and the prefetch=64.
I am using, does multiple containers give any benefit? Taking RAID into account etc. am I making the right chioce for tablespace/extent/prefetch sizes?
Any feedback on what I have so far? Am I totally deluded?
Cheers in advance.