RE: sysmaster database

At 10:26 AM 08/03/1999, samir BADAOUI wrote: > > >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 ? Be very, very careful using the base tables rather than the views. Those tables are subject to change WITHOUT NOTICE in any release. The tables definitions are NOT guaranteed. Dick > >>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 >