Please Help w/ SMI Query
Posted in 1998
Topics: Storage & Space Management, Server Administration, Platform-Specific Issues
On Informix 7.24.UC3 on Solaris (2.5 or 2.6), using the SMI tables, how do I find out in how many different chunks a table resides? I've looked at the schema for the sysmaster database, but all I can find is information about extents, nothing to link them to the chunks in which they reside. I have a number of tables for which I am alerted by the onprobe/dbcockpit alarm for fragmentation, but it is because the tables are so large that they span multiple two Gb chunks. I want to modify the alarm query so that it not only evaluates the number of extents a table uses, but also takes into consideration how many chunks the table spans. For example, alarm with databasename and tablename where: (# of fragments > (1.5 * # of chunks in which the table resides)) AND (# of fragments > 8) Please reply to mecory@gte.net , as I will be on holiday until 1/4/99. Thank you VERY much for your experience, insight, and consideration! Have a great holiday! Mark E. Cory Informix DBA Portland, OR, USA