As indicated, use multiple disks for db, and/or look into db2_parallel_io (see the redbook).
On 28 jul. 2011, at 17:50, Huebner,Andy,FORT WORTH,IT wrote: > Does anyone have any "under documented" tuning tips for TSM 6.2 on AIX? We > are going to build new systems next week. > > AIX 6.1 > P6 - 2 CPU 32GB RAM > TSM 6.2.? > Any SAN disk config I want. (within reason) > > All SAN disks are RAID 5 thin provisioned. > Should I split the DB onto multiple drives? (TSM 5.4 DB is 165GB @ 70% used) > Separate log drive, but how big? > > Thank you, > > Andy Huebner > > This e-mail (including any attachments) is confidential and may be legally > privileged. If you are not an intended recipient or an authorized > representative of an intended recipient, you are prohibited from using, > copying or distributing the information in this e-mail or its attachments. If > you have received this e-mail in error, please notify the sender immediately > by return e-mail and delete all copies of this message and any attachments. > > Thank you. -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622