This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes Temporary or Regular space??? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal
JavaRanch » Java Forums » Databases » JDBC
Reply 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
posted private message
0
Quote
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???
 
Similar Threads
Reading RAM
Volume free space
Swing
Java + AS400 API
why datafile for TEMP tablespace is not listed in the V$DATAFILE