I think, If you use DMS then you can not reorg two tables at the same time.
-----Original Message-----
From: Fortier, Christi (PCA) [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:38 AM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: Mirroring your Tempspace
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-----
From: Chris Bonin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 11:34 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Mirroring your Tempspace
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?
Thanks 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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
