Re: master db diagram

---- you wrote: > Yeah, what he said. Yes mostly trial and error. I am in the process of > building a monitoring tool using SMI but it is still just an outline of an > application. BTW anyone have any suggested reports? Current plan includes: > > o Basic statistics analysis including BR, RA Utilization, Buffer cache > turnover rate (anyone know how to determine when stats were last zero'd?), If you just want the date Dude, try: SELECT l2date(sh_pfclrtime) profile_cleared FROM sysshmvals Otherwise, try: SELECT DATETIME(1970-01-01 00:00:00) YEAR TO SECOND + sh_pfclrtime UNITS SECOND profile_cleared FROM sysshmvals AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com