Re: Very Severe Performance Problems on my 7.22 UC2

> Hi everybody, > I have been having some severe performance problems on my > development box in the last couple of weeks, and it is obviously > something I have changed !! If only I know what and why. Some > processess went from 2.5 hrs to over 8hrs !! By the way, we did have a > big database changes. I am hence running update statistics high on the > entire database. This process normally takes about 21 hrs, but it > looks like it will take over a couple of days this time !! > OK some details:- > > Informix 7.22 UC2 on IBM AIX ver 4.1 > Single CPU m/c Well - since this is a developement box, I'm going to guess that things are changing with the instance. Has update statistics been run recently? What changes have recently occured with the databases in the instance? What changes have recently occured with the programs hitting the instance? Have you checked out sysmaster:syssqexplain? My guess is that you've been adding a lot of data to some test tables and things that used to be quickly are now taking a lot longer, simply because there's more data and you're doing scans. Are your chunks raw devices? OPTCOMPIND might need to be set to zero. Madison Pruet