Calling a RUNSTATS statement through JDBC fails due to a syntax error.
I guess that this is because RUNSTATS is no SQL. JNI is not an option
for me.

I wonder if there is some package or stored procedure (like the
DBMS_STATS package in Oracle) that I could use to compute statistics?

Gerald

g.khin@ids-scheer.de (Gerald Khin) wrote in message news:<4c8399c9.0311060525.35480a0c@posting.google. com>...
> Calling a RUNSTATS statement through JDBC fails due to a syntax error.
> I guess that this is because RUNSTATS is no SQL. JNI is not an option
> for me.
>
> I wonder if there is some package or stored procedure (like the
> DBMS_STATS package in Oracle) that I could use to compute statistics?
>
> Gerald

You can create a DB2 stored procedure written in C that calls
db2Runstats from DB2 Administrative API. Then you call this DB2 stored
proc from your JDBC application.

-Eugene