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

Posted in 2007

Summary

The original poster asked how to list the tables in a dbspace with their sizes. Doug Conrey suggested oncheck -pe, which failed with a configuration file warning; bozon said to set INFORMIXDIR and ONCONFIG and mentioned system tables. Radhika Gadde supplied a sysmaster query joining sysptnext and systabnames using DBINFO('dbspace', partnum). Answered.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management

Doug Conrey — Wed, 14 Feb 2007 09:39:33 -0700 — source: Usenet: comp.databases.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

↪ replying to Doug Conrey

venkatreddy19@gmail.com — 14 Feb 2007 10:11:18 -0800 — source: Usenet: comp.databases.informix

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

↪ replying to venkatreddy19@gmail.com

bozon — 14 Feb 2007 10:26:43 -0800 — source: Usenet: comp.databases.informix

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.

↪ replying to bozon

venkatreddy19@gmail.com — 15 Feb 2007 02:05:38 -0800 — source: Usenet: comp.databases.informix

> 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 ?

↪ replying to venkatreddy19@gmail.com

Radhika Gadde — Thu, 15 Feb 2007 18:19:45 +0530 — source: Usenet: comp.databases.informix

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 >

Related threads

Glossary

dbspace