and tools that are able to recognize them.
What -
°°ÿ9.1E 003634125 4GL Development SystemThu Apr 13 13:39:05 2006
°°ÿ9.1E 003634126 Query/RESULTSThu Apr 13 13:39:05 2006
°°ÿ9.1E 003634127 Enterprise DBThu Apr 13 13:39:05 2006
°°ÿ9.1E 003634128 WebSpeed Trans SvrThu Apr 13 13:39:05 2006
°°ÿ9.1E 003634129 Progress AppServerThu Apr 13 13:39:05 2006
°°ÿ9.1E 003651785 Fathom Repl PlusThu Apr 27 16:12:10 2006
Mfg/pro EB2 SP1
SunOS mfgdbp01 5.10 Generic_147440-25 sun4u sparc SUNW,SPARC-Enterprise
Problem -
Periodically / various times of the day / every few weeks / a database will go into a freeze state. Typically users complain that the screen is blank or the transaction they were in won't move or other users cannot log into the database. We user Powerterm to connect to the server. I have looked at the server / database with iostat /sar / promon / protop / etc... and cannot detect the exact cause.
Question -
Are there other tools available to help me analyze the problem? Are there any other recommendations you have or could suggest? TIA
What -
°°ÿ9.1E 003634125 4GL Development SystemThu Apr 13 13:39:05 2006
°°ÿ9.1E 003634126 Query/RESULTSThu Apr 13 13:39:05 2006
°°ÿ9.1E 003634127 Enterprise DBThu Apr 13 13:39:05 2006
°°ÿ9.1E 003634128 WebSpeed Trans SvrThu Apr 13 13:39:05 2006
°°ÿ9.1E 003634129 Progress AppServerThu Apr 13 13:39:05 2006
°°ÿ9.1E 003651785 Fathom Repl PlusThu Apr 27 16:12:10 2006
Mfg/pro EB2 SP1
SunOS mfgdbp01 5.10 Generic_147440-25 sun4u sparc SUNW,SPARC-Enterprise
Problem -
Periodically / various times of the day / every few weeks / a database will go into a freeze state. Typically users complain that the screen is blank or the transaction they were in won't move or other users cannot log into the database. We user Powerterm to connect to the server. I have looked at the server / database with iostat /sar / promon / protop / etc... and cannot detect the exact cause.
Question -
Are there other tools available to help me analyze the problem? Are there any other recommendations you have or could suggest? TIA