Database monitoring

Hi list, is there an easy way I can monitor growth of database tables , highly accessed dbspaces / tables ? Any scripts? TIA Mukund

onstat -D & onstat -g iof will tell you which dbspaces are being hit hardest. onstat -g ppf (if TBLSTATS is set to 1 in the ONCONFIG file) to track table usage. onstat -d to track available space by chunk from which you can calculate the results by dbspace (see mention of dbsavail below). oncheck -pe or oncheck -pT to track the space used by a table. Get my package utils_ak which contains my dbsavail utility (script and executable versions) to track space by dbspace (sorted by free space). Utils_ak is available free from the IIUG Software Repository and contains other space management related tools. Art S. Kagel Mukund D Shevkar wrote: > > Hi list, is there an easy way I can monitor growth of database tables , > highly accessed dbspaces / tables ? Any scripts? > > TIA > > Mukund