Thank you for your reply Mr.TOM.
1.We are not using 'KILL -9' .
IMHO 99.44% of all latch related errors are due to kill -9.
You may not be using it but is it possible that someone else might be? I have seen:
1) Sys admins who don't talk to (or believe) their DBAs that are using kill -9. Sometimes behind the DBAs back.
2) Scripts, particularly orphan killers and idle user disconnect scripts that the admins either believed to be safe or, more than once simply forgot existed, be the root cause of these issues.
3) Help desks that either have a script or who manually use kill -9 to "fix" supposedly "hung" users.
4) Users who were just a little to knowledgeable about UNIX who kill their own sessions.
And lots of other use of kill -9 that is perhaps happening without your knowledge.
If your db is crashing with latch related errors it is
almost always because someone, somewhere is using kill -9 (or an equivalent, kill -9 isn't the only signal with the "untrappable" property).
So it is worth putting time into double and triple checking every imaginable source to make sure.
So check. And then check again. In the meantime:
But still very frequently the DB goes for ABNORMAL shutdown with ' SYSTEM ERROR: latch 16 depth -1. (3715) ' and generating file named procore in users home folder.
Have you logged an issue and sent these to PSC tech support?
2.My server Arch is Itanium 2 of HP rx3600 on 91D09.
May i have your valuable comments about this platform & progress 9.1D09?
9.1d09 is ancient and unsupported. You should upgrade to 9.1e04.
Personally I'm not much of an HP fanboy although the "r" series servers were IMHO the best ones they've produced in the last 10 years.
3. Is progress version 9.1E04 certified for HP rx3600 i.e. Itanium Arch?
Not according to the
Product Availability Guide
If it is not kill -9 (which I still place at a 99.44% probability) then it is a bug. Since you're running v9 your only recourse would then be to a) upgrade to 9.1e04 -- (which is 2 or 3 years old now) or b) upgrade to OpenEdge (10.1C is the current release).
