topic Re: Progress database program in Operating System - HP-UX

Progress database program

kenlo — Fri, 21 Mar 2003 17:39:23 GMT

Installed Progress 8.3.B database in striping logical volume in L-class server(HP-UX 11.0). After 3 weeks, database crash. Display I/O error from console. But, used "cstm" tool to check server hardware, no fail. Finally, delete striping disk group and restore database. No error occur again until now. Any body had this kind of experience? Please provide tips to identify this problem

Ken

Re: Progress database program

Michael Steele_2 — Fri, 21 Mar 2003 17:42:27 GMT

What does LOGTOOL say?

STM > TOOLS > UTILITY > RUN > LOGTOOL > FILE > VIEW > RAW SUMMARY.

Note the first and last dates of transactions and calculate the difference. If the difference is short, like 4 hours, then this is important to note. Now read down the report of hardware addresses and observe the integer numbers in parenthesis. Anything over 150 in this 4 hour period should be called into HP for replacement.

sar -v 5 5
sar -d 5 5
sar -u 5 5
vmstat 5 5

Please catenate and attach.

Re: Progress database program

Julio Yamawaki — Mon, 24 Mar 2003 15:23:52 GMT

Hi,

what kind of I/O error, I'd like to see the entire error message.
Also, have you checked the .lg file to see any Progress error message?