Hello,

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!!

Regards,

Hi,

Can you post erorr message?

Grofaty

hello !

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

thank you

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

HTH

Sathyaram