recompute statistics in db2 via JDBC

dr_suresh20 · #1 (**permalink**) 01-20-06, 04:28

We are inserting huge amount of data (could be several millions) during a fact upload. Therefore after the upload we recomputed the statistics. In oracle this can be done using the following sql statement:

analyze table <table_name> compute statistics

Do you know if there is any equivalent statement in DB2? I know there is runstats but it has to run via JDBC like a SQL statement.

Thanks.

sathyaram_s · #2 (**permalink**) 01-20-06, 05:14

If you are on V8 FP9 or above, you can use the Stored Proc ADMIN_CMD.

Otherwise, you'll have to call it using a command line only - may be invoked from your Java

Cheers
Sathyaram

Quote:

Originally Posted by dr_suresh20

We are inserting huge amount of data (could be several millions) during a fact upload. Therefore after the upload we recomputed the statistics. In oracle this can be done using the following sql statement:

analyze table <table_name> compute statistics

Do you know if there is any equivalent statement in DB2? I know there is runstats but it has to run via JDBC like a SQL statement.

Thanks.

dr_suresh20 · #3 (**permalink**) 01-20-06, 07:44

thanks for your response.

Internet Services

Web Development

Digital Marketing

Consumer Tech