systoolstmpspace : %%When is this tablespace used %%

[beena]

We have a UDB 9.1 fp 1 mutlipartition environment.... .

We noticed the database directory filesystem on NODE 0 reaches 100
%... and SYSTOOLSTMPSPAC E tablespace (managed by automatic storage)
runs out of space...

Unable to figure out the process that will be using this
SYSTOOLSTMSPACE ..
I checked to see if any of the process that uses SYSTOOLSTMPSPAC E
mentioned in the info center is running...Could n't find anything
explicit....... ...

Does Global temporary tables use this tablespace?

Any clues/ suggestions appreciated much.....

[Jeroen van den Broek]

Re: systoolstmpspac e : %%When is this tablespace used %%

On 17 apr, 06:41, beena <beena....@gmai l.comwrote:

We have a UDB 9.1 fp 1 mutlipartition environment.... .
>
We noticed the database directory filesystem on NODE 0 reaches 100
%... and SYSTOOLSTMPSPAC E tablespace (managed by automatic storage)
runs out of space...
>
Unable to figure out the process that will be using this
SYSTOOLSTMSPACE ..
I checked to see if any of the process that uses SYSTOOLSTMPSPAC E
mentioned in the info center   is running...Could n't find anything
explicit....... ...
>
Does Global temporary tables use this tablespace?
>
Any clues/ suggestions appreciated much.....

Can't you just drop and recreate it as described here:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/c0023713.htm

--
Jeroen