I take it you've never used Platinum.

Platinum ties into the DB2 API directly. No stored procedures - minimum
overheads.

The equivalent in Firebird would be something that plugs in to
diagnostic hooks at the Y-valve and the engine levels. Until Vulcan
comes a bit further along, it would be a real mess to try to write
something like this.

The Platinum user interface sucks (TSO on MVS) but you can get real-time
stats on running processes and interpretive reports on historical data
from the logs.

On Mon, 2005-03-21 at 09:57 +1100, Nigel Weeks wrote:
>
> Why not use the event posting and handling of Firebird?
> Get your Stored Procedure to post events as it processes, and use another
> program to 'watch' the events...
>
> No extra storage tables, no fighting with 'now' and CURRENT_TIME issues...
>
> It'd be a very useful utility if someone wanted to write one...;-)
>
> Nige.
>
> > -----Original Message-----
> > From: David Johnson [mailto:d_johnson@...]
> > Sent: Monday, 21 March 2005 9:49 AM
> > To: firebird-support@yahoogroups.com
> > Subject: RE: [firebird-support] tracking progress of a SP
> >
> >
> > 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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > __________ NOD32 1.1030 (20050319) Information __________
> >
> > This message was checked by NOD32 antivirus system.
> > http://www.nod32.com
> >
> >
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>