RE: RUNSTATS from SP?

RE: RUNSTATS from SP?

 

  


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


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