aspose file tools*
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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Temporary or Regular space???