wood burning stoves 2.0*
The moose likes JDBC and the fly likes Temporary or Regular space??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Temporary or Regular space???" Watch "Temporary or Regular space???" New topic
Author

Temporary or Regular space???

sushant pattnayak
Greenhorn

Joined: Aug 21, 2006
Posts: 3
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.

Thanks
Sushant
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Temporary or Regular space???