var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am using DB2 8.1.3 on unix AIX,
I have tables that creates and loaded every day from text file.
we are doing "runstats on table TABLE with distribution and detailed indexes all".
one day the load was from ixf file and then the runstats not work.
and the response time from the table was very bad
my question is why at DB2 7 we not have this problem any time
perhaps tuning problem?
Please help me!!
Can you post erorr message?
the loading finished good and the script not doing runstats if ther is ixf file
the fact was very slowly to our web site until we doing runstats manually
and we didn't get any error , and at version 7 we hadn't this problem
I would suggest you report this to IBM ...
BTW, are you replacing the data with LOAD REPLACE ??? IF yes, you can collect the statistics as a part of the LOAD itself ... I think it is faster than doing a RUNSTATS on its own
Visit the new-look IDUG Website
, register to gain access to the excellent content.