Have you tried a "volatile" table ?





"Diego Figueira "
<db2udbdba-ezmlms
hield-x11159085.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
01/24/2006 03:06
PM Subject
RE: RUNSTATS from SP?










Thanks Serge for your prompt reply!

Yes, I know the ADMIN_CMD() is available in V8.2.2, but unfortunately we
have V8.1.6, so we cannot call that procedure... I've found the
following code to call the RUNSTATS from a SP in C:
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0505sto
lze/?ca=drs- But I would prefer a simpler solution, or at least a
version of this in Java (if possible)...
Our application needs to update statistics every time it performs a
massive load or deletion of records in order to work properly. Any kind
of help is welcome!

Thanks again,

Diego

-----Original Message-----
From: Serge Rielau
[mailto:db2udbdba-ezmlmshield-x174015.[Email address protected]
Sent: lunes, 23 de enero de 2006 18:15
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