RE: sysmaster database

ok Jamie, I have taked a look in the sysmaster database and I have foun that table (systabinfo). But I have found a other thing that can help : the systabinfo is a view of table sysptnhdr so I think it's mutch better to query that table (sysptnhdr). What do you think ? >From: Jamie Kohm <jkohm@trusted.net> >To: "'samir BADAOUI'" <samir_badaoui@hotmail.com> >CC: "'informix-list@iiug.org'" <informix-list@iiug.org> >Subject: RE: sysmaster database >Date: Tue, 3 Aug 1999 12:51:52 -0400 > >Samir, > >The table is systabinfo. I query this table often to get the available >space for a table. I've never had trouble with it. You should get a copy >of Lester Knutsen's, "Exploring the Sysmaster Database" article from IIUG. > It has information on other sysmaster tables. > >Jamie Kohm >Lead Unix Admin/DBA >NSI > >-----Original Message----- >From: samir BADAOUI [SMTP:samir_badaoui@hotmail.com] >Sent: Tuesday, August 03, 1999 9:46 AM >To: informix-list@iiug.org >Subject: sysmaster database > >Hi friends, >I want to know witch table(s) in the sysmaster database contain the >following informations : >- nbr. of page used by each table >- nbr. of page allocated to each table >I know that oncheck -pt do this, but I want to do it from sysmaster cause I >have to find other informations too. >And if there is any risque to select from this table(s) (if it's a pseudo >table for example ) >Thanks ! > > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com