How Can Statistics Be Updatee Using SQL

Monday, August 06, 2007


 Post new reply
I'm afraid. you are mistaken ... You can do runstats from local or remote as long
as you are able to connect to the database ... But the reason you are unable to
RUNSTATS from java is that - RUNSTATS is a command and not SQL ...

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0012547.htm

If you are atleast on FP9 of Version 8, then you can use ADMIN_CMD stored procedure
to do RUNSTATS.

Posted by Agoglife at 10:02 AM  

0 comments:

Post a Comment