| Computers Forum Index » Computer - Databases - IBM DB2 » Please help! set integrity using system tablespace... |
|
Page 1 of 1 |
|
| Author |
Message |
| Arun Srinivasan... |
 Posted: Thu Oct 29, 2009 9:07 am |
|
|
|
Guest
|
1. Why would set integrity use system temporary tablespace?
2. I created one system temp tablespace with 5 g on all nodes - and my
table has table partitioning enabled ALONG WITH hash partitioning
while the exception table is normal (but still hashed using the same
keys),
Still it is using the system temp tablespace and reporting no
available pages!!! How can I know whats it doing? rebuilding index or
whatever? There is like 10 million rows in the table waiting to be run
in production.
Your help is highly appreciated |
|
|
| Back to top |
|
|
|
| mirof007... |
| Posted: Thu Oct 29, 2009 5:33 pm |
|
|
|
Guest
|
Have you tried running an explain on it? It might give you some clues
as to what it is doing. Also, try increasing the size of the
bufferpool associated with the tablespace you want it to use, I think
the choice is cost based if there are multiple temp tablespaces
available.
Regards,
Miro |
|
|
| Back to top |
|
|
|
| Willem Fischer... |
| Posted: Mon Nov 09, 2009 10:30 pm |
|
|
|
Guest
|
On Oct 29, 6:33 pm, mirof007 <mirof... at (no spam) gmail.com> wrote:
Quote: Have you tried running an explain on it? It might give you some clues
as to what it is doing. Also, try increasing the size of the
bufferpool associated with the tablespace you want it to use, I think
the choice is cost based if there are multiple temp tablespaces
available.
I had a similar issue with log space, maybe the two are related. I ran
out of transaction log space when generated columns had to be re-
generated. DB2 won't need transaction log, and possibly tempspace, if
you order DB2 not to regenerate the contents of the generated columns.
Try playing with
set integrity for xx immediate unchecked; |
|
|
| Back to top |
|
|
|
|
