467,882 Members | 1,232 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

Multiple Temp Tablespaces


A friend of mine inheritted a system that had 2 4k temp tablespaces
each assigned to a different bufferpool. This brought up a number of
questions for me.

1) Does anyone know in general how db2 handles multiple temp
tablespaces of the same page size?

2) I had read somewhere that with multiple temp tablespaces of the
same size db2 will basically use them both in a round robin fashion and
that this is not efficient. First is this true and second why is this
not efficient?

3) Since in my friend's case each temp tablespace is assigned to a
different bufferpool how does db2 manage the movement of data between
the temp tablespaces and the bufferpools if it operates as I stated in
question 2?

4) How does the tablespace assigment of the core tables play into
this? For example, if I do a simple select from a table that is
assigned to a 4k bufferpool, say buf1, will it try to use the temp
tablespace also assigned to buf1?
Thanks in advance for any clarifications provided.


Apr 9 '06 #1
  • viewed: 1243

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CK | last post: by
2 posts views Thread by Charles-Antoine Giuliani | last post: by
1 post views Thread by Christos Kalantzis | last post: by
1 post views Thread by mark | last post: by
10 posts views Thread by rAinDeEr | last post: by
3 posts views Thread by dcruncher4 | last post: by
7 posts views Thread by =?Utf-8?B?TG9zdEluTUQ=?= | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.