Register / Login
Win a copy of
Android Programming: The Big Nerd Ranch Guide
this week in the
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
JDBC and Relational Databases
Temporary or Regular space???
posted 8 years ago
How to find out through SQL command which table space(temprary or regular) is there on DB2?though listing we are able to get userspace..
but hw to know whether its a regular or Temporary space.
LIST TABLESPACES SHOW DETAIL
These shows the list, but after gettin for example the Userspace, there i want to find whether its regular or temporary.
It would be great if any one can help me on this.
Boost this thread!
Java + AS400 API
Volume free space
why datafile for TEMP tablespace is not listed in the V$DATAFILE