Re: DB2EUG: Mirroring your Tempspace

[Scott Hayes]

Chris,   Tempspaces are used in round-robbin sequence, so if you have two tempspaces, DB2 would alternate between the two of them.  To achieve parallel I/O, a tempspace should have multiple containers, and ideally these containers should be on different disks.  You should use only one tempspace if possible.   Regards, Scott   Have you seen our latest customer feedback?   "...DGI is to database utilities what CISCO is to networking..." Please have a look ... http://www.database-guys.com/guestbook/guestbook.html   ----- Original Message ----- From: Chris Bonin To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 11:33 AM 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