Re: tbstat

From: mission critical <yukonc@teleport.com> > >I want to find out how much dbspace we have available. I've >seen mention of the command tbstat to show how large each table >is, though I can't find the command in my informix manual. >Is this what I should be using? > >We're on 9.12 tbcheck/oncheck -pe. Is 9.12 Y2K-compliant? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

tbstat -d will give you your dbspace/chunk layout. This will tell you how much available space you have free in your chunks that correspond to your dbspaces, which if I read your question correctly was what you were looking for. Keep in mind that the units given are in pages, so on a solaris system a page is 2k while on an NT system it's 4k. If you're looking to find out how large each table is, tbcheck -pt <database_name>:<table_name> will give you the specifics of that table. Obnoxio The Clown wrote: > From: mission critical <yukonc@teleport.com> > > > >I want to find out how much dbspace we have available. I've > >seen mention of the command tbstat to show how large each table > >is, though I can't find the command in my informix manual. > >Is this what I should be using? > > > >We're on 9.12 > > tbcheck/oncheck -pe. Is 9.12 Y2K-compliant? > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com -- Phillip Tien Database Administrator Whole Foods Market, Inc. Sometimes I think you have to march right in and demand your rights, even if you don't know what your rights are, or who the person is you're talking to. Then on the way out, slam the door.