For
heavy uses of tempspace, and optimal performance we create tempspace on a
SAN Fibre disk array with 1 huge DMS tempspace (per node), then drop the 1st one
that IBM creates for you (on your install drive).
Using
a DMS serves the following purposes:
- You save yourself the dynamic allocations at run time (can be physical, physical disk IO is an expensive performance hit)
- You are reserving space on a drive that might otherwise be thought of as available
Fibre
controllers over a SAN offer 100 MB/sec throughput as opposed to 10MB/sec
SCSI. SANs work best when you have more concurrent traffic; so using a SAN
especially appeals to DB2 EEE.
-----Original Message-----We need to increase our tempspace to accomadate creating indexes. We would like to create a large tempspace and not mirror it. Are there any implications? Also, if you have two tempspaces does DB2 use both of them via striping?
From: Chris Bonin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 11:34 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Mirroring your TempspaceThanks in advance..
Chris Bonin
Database Administrator
North Carolina Dept. of Revenue ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
