By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,939 Members | 1,602 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,939 IT Pros & Developers. It's quick & easy.

RUNSTATS and JDBC

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
g.****@ids-scheer.de (Gerald Khin) wrote in message news:<4c**************************@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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.