how to find a dbspace for a table

Posted in 2005

Topics: Storage & Space Management, SQL Development & Query Writing

Thanh Ngo — Thu, 21 Apr 2005 13:13:43 -0500 — source: Usenet: comp.databases.informix

Can someone show me how to find which dbspace a table is on in database? I used below SQL but dbspace shows as 0 select trunc(partnum/16777216) dbspace, sum(nrows*rowsize) bytes, tabname from systables where tabtype = 'T' group by 1,tabname order by 1; Thanks for your help. Thanks, Thanh Ngo

↪ replying to Thanh Ngo

John Carlson — Thu, 21 Apr 2005 23:05:52 -0400 — source: Usenet: comp.databases.informix

On Thu, 21 Apr 2005 13:13:43 -0500, "Thanh Ngo" <t-ngo@ti.com> wrote: >Can someone show me how to find which dbspace a table is on in database? > >I used below SQL but dbspace shows as 0 > >select trunc(partnum/16777216) dbspace, >sum(nrows*rowsize) bytes, >tabname >from systables >where tabtype = 'T' >group by 1,tabname >order by 1; > >Thanks for your help. > What about select tabname, dbinfo("dbspace", partnum) from systables . .. depends on Informix version JWC

Glossary

dbspace