It would be nice if there were instrumentation something like that
provided by Platinum for DB2.

Another thing to add to my wish-list / to-do eventually list.

Sigh

On Mon, 2005-03-21 at 08:44 +1100, Alan McDonald wrote:
>
> I was trying to track the internal progress of a SP that was running
> quite slow.
>
> I created an external table, then wrote to the table at various
> points from within the SP and updated using CURRENT_TIME and a note
> field. Of course, as I later learned from the documentation the
> CURRENT_TIME was set at the beginning of the SP and never
> incremented.
>
> I finally figured out what was causing the slow processing, but I
> would like to know for the future if something like this is
> possible. I tried to Google, but only got information as to why it
> doesn't work.
>
> Is there any way to get a real CURRENT_TIME from within a SP?
>
> Thanks,
>
> Rick
>
> use 'NOW' instead of CURRENT_TIME
> Alan
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>