A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Temporary or Regular space???
Joined: Aug 21, 2006
Aug 01, 2008 11:27:00
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.
I agree. Here's the link:
subject: Temporary or Regular space???
why datafile for TEMP tablespace is not listed in the V$DATAFILE
Volume free space
Java + AS400 API
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014