S
Stefan Marquardt
Guest
Since yesterday I am struggling with hanging batch process. They did the to-do but did not end and consumes 100% of a single cpu. Need to kill them, db is still up. This morning I noticed the java process for the appserver with 100% cpu, identified a server and killed it by the explorer. Then the _proapsv of this appserver starts having 100% CPU, until now. The logfile shows nothing, DB I/O was 0. Later I tried to delete records in a table in the procedure editor: FOR EACH table where field BEGINS "A" EXCLUSIVE-LOCK: DELETE table. END. I noticed a slow I/O and decided to chunk transaction and pressed CTRL-C. After this I got PROGRESS (not responding) and now this prowin32 consumes 100% CPU too without any I/O. Identified my usr 52 in promon: REMC/ABL, shows Dbkey 27614 on SRV 2 No-locks, no running transaction, no further entry in logfile.
Continue reading...
Continue reading...