Sybase log

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Subind - 08 Sep 2008 16:08 GMT

Hello All,

Is there a way to determine which stored proc / SQL ran on a given day
in Sybase?
Does Sybase maintain a log which have these information?

Thanks in advance,
Subind.

Reply to this Message

Bret_Halford - 08 Sep 2008 16:38 GMT

> Hello All,
>
[quoted text clipped - 4 lines]
> Thanks in advance,
> Subind.

Which of Sybase's database products are you asking about?
(Adaptive Server Enterprise? SQL Anywhere? IQ?)

If ASE, you can use the auditing feature to audit all cmdtext sent by
clients.
You can also use the mda monitoring table monSysSQLText if you
configure the
"max sql text monitored" configuration high enough to store a full
day's worth,
so arrange for a scheduled job to regularly flush the contents to more
permanent
storage. monSysStatement can give you exactly which stored
procedures ran and when.

Reply to this Message

Subind - 08 Sep 2008 17:09 GMT

> > Hello All,
>
[quoted text clipped - 18 lines]
> storage. monSysStatement can give you exactly which stored
> procedures ran and when.

Hi,
I'm using ASE 15.0
I was just going through the MDA documentation over net. Thanks for
this information.

--
Subind.

Reply to this Message

Marcin Najs - 12 Sep 2008 13:01 GMT

Subind pisze:

> Hello All,
>
[quoted text clipped - 4 lines]
> Thanks in advance,
> Subind.

Hi,
You can turn on Auditing for ASE (or you can use MDA tables)
More details: http://infocenter.sybase.com

Regards,

Signature

Marcin Najs

Reply to this Message