finding out when procedure created

Posted in 2012

Summary

Karl Oliver asked how to find when a stored procedure was created, as sysprocedures did not show it. Art Kagel said the creation time is not recorded in the catalog and only the logical log records would show it. Joe Plugge said tracking it would be a welcome enhancement, and Karl agreed. No workaround beyond the logs was given.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Security, Permissions & Auditing

KARL OLIVER — Thu, 19 Apr 2012 22:21:35 — source: IIUG Forums & Mailing Lists

help please I want to know how to find out when procedure created. I thought it would be in table sysprocedures,cant see it though. The audit file shows date it was dropped and created. I want to confirm this.

↪ replying to KARL OLIVER

Art Kagel — Thu, 19 Apr 2012 22:40:07 — source: IIUG Forums & Mailing Lists

Not recorded on the database catalog. You would have to look through the logical log records. Art On Apr 19, 2012 6:21 PM, "KARL OLIVER" <karl.oliver@maf.govt.nz> wrote: > help please > I want to know how to find out when procedure created. > I thought it would be in table sysprocedures,cant see it though. > The audit file shows date it was dropped and created. I want to confirm > this. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b15a58b6820b104be0fdab1

↪ replying to Art Kagel

Plugge, Joe R. — Thu, 19 Apr 2012 23:06:29 — source: IIUG Forums & Mailing Lists

I am not alone here when I say that would be a welcomed feature enhancement if the creation date for the procedure/function was tracked in the system catalog. ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] On Behalf Of Art Kagel [art.kagel@gmail.com] Sent: Thursday, April 19, 2012 5:40 PM To: ids@iiug.org Subject: Re: finding out when procedure created [26759] Not recorded on the database catalog. You would have to look through the logical log records. Art On Apr 19, 2012 6:21 PM, "KARL OLIVER" <karl.oliver@maf.govt.nz> wrote: > help please > I want to know how to find out when procedure created. > I thought it would be in table sysprocedures,cant see it though. > The audit file shows date it was dropped and created. I want to confirm > this. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b15a58b6820b104be0fdab1 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Plugge, Joe R.

KARL OLIVER — Fri, 20 Apr 2012 03:24:52 — source: IIUG Forums & Mailing Lists

yes I agree Joe. seems strange date is not recorded