Re: master db diagram

"Carlson@WHSmith" wrote: > > "Art S. Kagel" 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?), etc. > > Got it . . . check out sysmaster:sysshmvals.sh_curtime?? > Nope, that's the current time. Looks like it may be sysmaster:sysshmvals.sh_pfclrtime though. (I'm guessing that is pf=profile clr=clear time=time) -- David Kleppinger Assoc. Dir. of Admin. Computing Dallas Theological Seminary