Re: Dbspace Question.

Abhay Mannur <amannur@spf.fairchildsemi.com> offerred: + +Hi, +I'm sure of the 6 dbspaces assigned to a perticular database. +Also I'm sure that no other tables from any other databases are residing +there. <snip> +I'm curious about the free pages in each chunk. +Most of them show 3 used pages. Every chunk created has 3 "overhead" pages in them, at least: 2 system reserved pages and 1 chunk free list page. +Some of them has different number of used pages. In addition to the above, the first chunk in any dbspace also contains a tblspace tblspace (sort of table of contents for the dbspace). Initially, this is 50 pages in size (with 1 page for each table created in that dbspace), but will grow as needed. If you, at any point, had > 50 tables in that dbspace, then the tblspace tblspace will have grown in 50 page increments. If these two do not account for all the space used in the chunks, the oncheck -pe suggested by another poster will tell you what else is in there. Dave ** Dave Kosenk <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training