Re: Monitor table growth

If you run update statistics regularly you can check the systables table. there is a column names nrows that provides the number of rows in the table. Beware that if it is current ONLY after UPDATE STATISTICS is run! I would just create a table where you can store the results and compare. i.e. store table name, date, and number of rows. Then you can analyze the data programmatically (or SQL) on whatever criteria you want. -Bill } } We are running Informix 5.03 on DGUX 4.11. We monitor the growth of our } database by running tbcheck -pT. } } Does anybody know of a strategy or automated process/commands to track table } growth and indicate, for example, if a certain table has suddenly increased } in size? } } Thanks, } } Darren Fuller. } } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison emails: ennis@ssax.com ennis@starnetusa.com