Re: Performance Decreasing
Are you adding dynamic memory segments as the system is up?
Run onstat -g seg. If you have many segments of type V when your
system is slow this could be a signifcant part of the problem.
-Bill
}
} :Our system has encountered a problem. At the beginning, the system
} retrieves
} :the data from the database very fast using index search. However, the
} :performance is greatly declined as our system running a long period (4
} :hours, only one program).
}
} :When set explain on, we discover the informix using index searching. We
} wonder
} :why the performance is dropped ? Could anyone encounter this problem ?
}
} :Our informix server is Online 7.11 UC1 in HP-UX 10.01.
}
} >This sounds like something we have been encountering recently. It
} >uncovered a bug in Online (7.11 UC1 on Solaris) due to contention. We
} >found out about the bug from Tech support last Friday, so I haven't had
} >time to track it down, or even see if the slowdown phenomenon is related.
}
} Have you tried setting OPTCOMPIND to 1? The default is 2 I believe. We
} saw some strange behavior when the default was used on our HP 7.12
} system. Tech support responded that our problem was a known bug with
} OPTCOMPIND when set to 2. I'm not saying that your problem is a bug, but it
} might be worth checking into.
}
} Good Luck
}
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com