Register / Login
Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JDBC and Relational Databases
Temporary or Regular space???
posted 7 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.
Don't get me started about those stupid
Java + AS400 API
Volume free space
why datafile for TEMP tablespace is not listed in the V$DATAFILE