CALL <SCHEMA>.<STORE D_PROC_NAME>(<I N_1>,<IN_2>,<OU T_1>)
With the stuff in < > changing as applicable / adding extra IN/OUT values etc..
Ben Neffendorf
Last Activity: Sep 19 '07, 09:48 AM
Joined: Jun 27 '07
Location:
-
Not sure, but at a guess I'd say Environment 2 is attempting to cluster by index 3, where-as env 1 would be clustering by index 1 (assuming you created them in 1-2-3 order). At least I think that's how db2 works - unless you specify one of the indexes as clustering, it will pick the 1st one created. Even if runstats aren't collected, I guess that would alter the access paths.Leave a comment:
-
DB2V8.2 DPF CPU Usage
Hi all,
I'm working on a data warehouse split into 16 partitions. Whenever we run a query that involves a non-indexed predicate, the CPU hits 100% (mainly system CPU when checked with iostat). Anyone else experienced similar ? Is this correct, or is it a bug / config issue ?
Example query
Select * from table_a where non_indexed_col umn = 'AA'
It's DB2V8 FP13 on Solaris, I get the same results...
No activity results to display
Leave a comment: