Re: Meaning of npused in systables.

In article <2u717t$78o@emory.mathcs.emory.edu>, chrisc@spamis.jcdc.eta.gov (Christopher Cale) says: > > > >I am running Online 5.01.UD3 on an RS/6000. I have the need to >know the amount of disk space that individual tables are using and >naturally thought that I could utilize the value of "npused" in the >systables table. However, I find that some of the tables show a >negative value for this column, even immediately after running >"update statistics". How should I interpret this? >And, if this is not the correct method to determine disk usage, >what is? > >Thanks in advance! > The only valid way to see what a table is occupying is tbcheck -pe . If you want to know how much space is available within the space a table has allocated, then use tbcheck -pT <db>:<table> . ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ Jim Burks jburks@promus.com ~ ~ Database Administrator / Systems Engineer ~ ~ The Promus Companies, Inc. Memphis, TN USA ~ ~ http://stargate.promus.com/public/jbb.html ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~