Usage stats w/ table level granularity
Posted in 1993
Topics: Performance & Tuning, Storage & Space Management, Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues
Hello, Is there any way to retrieve statistics regarding usage of disks by Informix? We have an RS/6k Mod 350H, under AIX 3.2, using Informix OnLine 4.10 (SQL 4.10, RDS 4.10, 4GL 4.10). Our live database occupies approx 2 GB across 4 disks. I've set them up so the root dbspace is on a separate disk from the data dbspaces. However, in the interests of performance, I would like to have some way of finding which tables get hit the most during queries/updates/etc by our users (we have users dialing in and performing queries, and on-site users performing updates). I've checked all the tbcheck and tbstat options; however, they only seem to be able to provide dbspace, or at the most, chunk, level statistics. Is there any way I can run a cron'd job that will let me know which tables are being accessed? Ideally, I'd like to run a cron that'll produce # of accesses/5 min period, for the first five minutes of every hour, and then average those numbers. This will allow me to reconfigure the database to increase performance by putting specific (large) tables near the centers of the disks. BTW, the dbspaces reside on raw partitions. Is this possible? Please respond by email. If there seems sufficient interest, I'll post a summary. Thanx, Ashu ============================================================================ Ashu Tiwary Internet email: atiwary@lonestar.utsa.edu ============================================================================