RE: Listing all the tables in using a dbspace in Informix

oncheck -pe <dbspace name> DC > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of venkatreddy19@gmail.com > Sent: Wednesday, February 14, 2007 9:26 AM > To: informix-list@iiug.org > Subject: Listing all the tables in using a dbspace in Informix > > Is there a way to list all the tables which use a specific dbspace as > well as their sizes in Informix. > > regards > V > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

I tried using oncheck -pe <dbspace name> and got the following message WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. V

On Feb 14, 1:11 pm, venkatredd...@gmail.com wrote: > I tried using oncheck -pe <dbspace name> and got the following > message > > WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. > > V Make sure $INFORMIXDIR and $ONCONFIG are set and that you have permissions with your login ID to access them. There is also system tables that can give you this information.

> Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > permissions with your login ID to access them. There is also system > tables that can give you this information. System tables which can list out all the tables in a particular dbspace ?

Hi, You can use the following query to get the table names in a specific dbspace. select the sysmaster database then run this query... select tabname from sysptnext, systabnames where pe_partnum = partnum and DBINFO("dbspace",partnum)="your dbspace name here" order by tabname; Thanks, Radhika On 15 Feb 2007 02:05:38 -0800, venkatreddy19@gmail.com < venkatreddy19@gmail.com> wrote: > > > Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > > permissions with your login ID to access them. There is also system > > tables that can give you this information. > > > > System tables which can list out all the tables in a particular > dbspace ? > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >