Register / Login
Win a copy of
The Little Book of Impediments (e-book only)
this week in the
Agile and Other Processes
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.
Java + AS400 API
Volume free space
why datafile for TEMP tablespace is not listed in the V$DATAFILE