Monitor and Report on Table Sizes
Tables in an OnLine database seem to take on a life of their own, especially in a heavily used system with many developers. It is a twofold problem. First, there's the problem of proliferation of tables. This will be addressed later in a table warehouse program.
The second part of the space problem concerns the growth of existing tables. In other sections, we have seen various programs for performing data archiving and table cleaning, but to do any of these, the DBA needs to know where the problem lies. We need a way to track the size and space utilization of tables.
At first glance, this seems to be an easy task. Just write a report that looks at the system catalogs. There are a couple of problems to this, the ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
