Hello! I recently upgraded from 10.0B to 10.1B (on AIX) and have had issues with the dbanalys report ever since. I think a lot of it has to do with the chain analys being added, I would only get information from some of the tables in the db and the index analys wouldn't give me any information, this past weekend it actually affected the application due to locking, I assume all this is related. I know I can use -scan which should help so I'm fine with that. The question I have now is, I noticed today that my scatter factor on a lot of my tables have gone down to under 3.0 (i had quite a few over 3 before the upgrade), is this normal after an upgrade or does 10.1B calculate the scatter factor differently? I can definitely trace the change from the upgrade, ei. Sunday before upgrade about 20 tables with scatter factor above 3.0 the day of the upgrade only 1 table has a scatter factor over 3.0.
Thanks
Thanks