Can I know the last time when I run 'onstat -z' ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

roger@star2000.com.tw - 29 Dec 2007 05:40 GMT

Is ids server will record the timestamp when we run 'onstat -z' ?
Can I get any information from sysmaster database or else ?

Reply to this Message

Richard Harnden - 29 Dec 2007 10:37 GMT

> Is ids server will record the timestamp when we run 'onstat -z' ?
> Can I get any information from sysmaster database or else ?

Yes it does.

sysmaster:sysshmvals.sh_pfclrtime holds that as a long, use dbinfo to
convert it.

SELECT sh_pfclrtime, dbinfo('UTC_TO_DATETIME', sh_pfclrtime)
FROM sysmaster:sysshmvals

Reply to this Message