Oninit cdi / Archive
Talk to an expert →

Listing all the tables in using a dbspace in Informix

Posted in 2007

Topics: Storage & Space Management

venkatreddy19@gmail.com — — source: Usenet: comp.databases.informix

Is there a way to list all the tables which use a specific dbspace as well as their sizes in Informix. regards V

↪ replying to venkatreddy19@gmail.com
Superboer — — source: Usenet: comp.databases.informix

dbaccess sysmaster <<! select * from systabnames where dbinfo("dbspace",partnum) = "yourdbspace"; --maybe join it up tosysextents.or... ! Superboer On 14 feb, 17:25, venkatredd...@gmail.com wrote: > Is there a way to list all the tables which use a specific dbspace as > well as their sizes in Informix. > > regards > V

Glossary