Any way to get table level read/write info on version 5.x?
Posted in 1997
Sujit Pal — — source: Informix-list mailing list archive (1991-1998)
Hi All Is there any way to get table level read/write information from a = version 5.x engine like you have in sysmaster:sysptprof table in version = 7.x? All I can think of is to compare the number of rows 1 weeks apart off a = production system for each table and check to see the growth rate. This = will give me an approximate idea of the number of writes per table. For the number of reads the most granular I can go to is to use tbstat = -D to see the read/writes across chunks. I would like to have an idea of = the number of accesses per table so I can redistribute the tables across = chunks so the hits are not skewed. Undocumented functions or onchecks with awk/sed, anyone? TIA Sujit Pal