syscat.tables vs. 'LIST TABLESPACES SHOW DETAILS'

[billhoves]

Why is it when, using the CLP, I issue
'LIST TABLESPACES SHOW DETAILS' I get the correct number of
pages allocated for each tablespace, yet when I
use a select statement, say for tablespace id=0
SELECT NPAGES, FPAGES from SYSCAT.TABLES where TBSPACEID=0
I get -1 for each column ??
I need to use either a CLI, API, or embedded SQL command
to get the tablespace size. Am I barking up the right tree ?
TIA, Bill

 

[dbmsguy]

have you run 'runstats' lately? probably populated by runstats. Paul

http://www.dbmsguy.com

 

[billhoves]

Is there a non-intrusive way to get this information. I need
to extract it without the ability to execute any commands
that may steal processing time. The information must already
exist, since the LIST TABLESPACES command returns it ??

Any ideas ??

 

[dbmsguy]

I do believe that list tablespaces is getting it from the OS level....

if you have your containers on filesystems, you can just do a 'bf' and see how full they are....

if you have your containers on raw partitions, then I expect that you could do it through some other unix command.

HOWEVER, you should be running 'runstats' regularly anyway. I once had a little script that I wrote that would extract the stats from a LIST TABLESPACES and put all the info in a table for later analysis. Paul

http://www.dbmsguy.com