One thing should be mentioned about having multiple tempspace's... At a
presentation from Tech Conference last fall (Tuning DB2 for High Volume Web
Applications), they said you should only have one temp tablespace. The
reasoning for only one is that DB2 has to do some checking each time you
use tempspace to figure out which one to use if there are multiple defined.
Note : you would need one for each pagesize if you are using more than just
the default 4k pagesize for tablespaces.
I've never measured this, so I'm just going from the presentation.
Thanks.
John Lantz
Zurich North America
Pierre Saint-Jacques <[EMAIL PROTECTED]>@lists1.ba.best.com on
03/21/2001 02:22:03 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: DB2EUG: Mirroring your Tempspace
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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
