RE: sysmaster database

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