You can have multiple tempspaces. DB2 will decide which to use based on
workload at the tablespace level at the time of running the function
requiring tbslp usage.
So creating indexes for example, DB2 could choose one space at one time
and the other another time. There's no rhyme or reason apart from
workload to choosing the tblsp.
If it<s only for creating indexes and so on, then I'd seriously
reconsider mirroring that tblsp.
HTH, Pierre.
Chris Bonin wrote:
> 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
