my dog learned polymorphism*
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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???