Re: Batch job slows down

Thanks for your input ! Before we first ran into the problem we ran dostats once a week. There is no error messages from dostats, what I meant by that it fails somehow is a thought of some internal error in the server that sometimes casues an incorrect statistics. We ran a new dostats last night, the problem remains. There are no other jobs running at the same time. Regarding the other suggestions we are now doing a number of things: - a case is opened with EMC to analyze the SAN - we will set upp a copy of the database on another server and try the things that you have suggested (this will then also test the idea to create the tables and indexes on other disks) (reorg of tables, fragmenting and others. - we will also trie to analyze each step and SQL statement in the program to find which one uses most time, the cost according to SQL EXPLAIN is 10 for the SQL with the highest cost and for most of them 1, so we need to time them instead - we will also upgrade the version in the new test environment, there might be some corrections in later versions that helps One idea that I have is that update statistics indeed does what it is supposed to but as distribution changed the optimizer used a bad access path in some cases. We where then lucky when we did a new update statistics, the distribution at that time caused a fasteraccess path. Now we are constantly getting a bad access path due to how distribution looks right now. I will get back as we proceed