A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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.
rocket mass heater
subject: Temporary or Regular space???
Java + AS400 API
Volume free space
why datafile for TEMP tablespace is not listed in the V$DATAFILE
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015