you can simply cron a shell script job or simply call
a shell script in your Application process.

Dak'

--- Nihar Vaidya <[Email Address Removed] wrote:
>
> We had faced a similar problem last year, as our
> application also supports
> multiple databases. Runstats cannot be invoked using
> JDBC. We ended up using
> Runtime.exec() to do the runstats for DB2.
>
> I am not sure whether you can invoke runstats from
> within a db2 stored proc,
> but I would guess not.
>
> - Nihar
>
> -----Original Message-----
> From: Bill Province
> To: DB2 Lazy DBA
> Sent: 1/22/2003 5:41 PM
> Subject: Invoking RUNSTATS dynamically from an
> application
>
> Hi Gurus,
>
> We have mechanisms in our application where we
> will generate
> statistics for our tables at strategic points.
> Currently, for Sybase,
> SQLServer, and Oracle, we are able to do this within
> stored procedures.
> A bit of reading of the documentation for DB2
> suggests that this is
> simply not possible within DB2. Am I not reading
> this correctly?
>
> What is the best way to invoke RUNSTATS or the
> equivalent within our
> application? My current options are from within
> stored procedures, or
> from within a Java application using JDBC. I know
> that in a worst-case
> scenario, I could always do this by kicking off a
> shell process that
> runs a script, but I would really prefer to not take
> that route.
>
> Thanks.
>
> -- Bill Province
>
>
---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> To unsubscribe, e-mail:
> db2udbdba-[Email Address Removed] For additional commands, e-mail:
> db2udbdba-[Email Address Removed]


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
DB2 & UDB email list listserv db2-l LazyDBA home page