It's an SQL API. All client interfaces support an SQL API to DB2. So you
can do runstats from Java, .NET, SQL Procedures....

Cheers
Serge

"Yao Sheila " <db2udbdba-ezmlmshield-x54225714.[Email address protected]
wrote on 01/23/2006 05:58:06 PM:

>
> I wonder what is the difference or advantage by using system procedure
> ADMIN_CMD to run stats or reorg?
>
>
> Thanks.
>
> Have a nice day,
>
> Sheila Yao
>
> -----Original Message-----
> From: Serge Rielau
> [mailto:db2udbdba-ezmlmshield-x174015.[Email address protected]
> Sent: Monday, January 23, 2006 4:15 PM
> To: LazyDBA Discussion
> Subject: Re: RUNSTATS from SP?
>
>
> Try the ADMIN_CMD() procedure in DB2 V8.2 (I think)
>
>
>
> "Diego Figueira " <db2udbdba-ezmlmshield-x78095642.[Email address
> protected] wrote on 01/23/2006 09:07:49 AM:
>
> > Hi all, is there a way to execute a RUNSTATS command from a Stored
> > Procedure?
> >
> >
> >
> > Thanks!
> >
> >
> >
> > Diego
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> > website: http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page