|
View previous topic :: View next topic
|
| Author |
Message |
rakesh1155
New User
Joined: 21 Jan 2009
Posts: 84
Location: India
|
|
|
|
I have a Stored Procedure invoked by Java and has gone into infinite loop. And continuously displaying millions of lines in the WLM log sysout.
I cannot purge the WLM job.
I tried to Stop the SP but the log size has kept on increasing.
Please advise. |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Contact your site support group for help. They should have been your FIRST reference, not us. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| or your DBA can purge that, are you a DBA? Have you contacted them or your site support group, as Robert has said. It happened to me couple of times and they were my savers. |
|
| Back to top |
|
|
rakesh1155
New User
Joined: 21 Jan 2009
Posts: 84
Location: India
|
|
|
|
Yes, i contacted the DBA. The problem is solved now.
I was trying to figure out if there was any other way to stop that running of SP. Because, I had stopped the SP but it still seemed to be running printing millions of lines. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
If the SP was stopped, what was printing the additional lines? |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| rakesh1155 wrote: |
| Because, I had stopped the SP but it still seemed to be running printing millions of lines. |
This line is somewhat not clear to me. How do you stop the SP, what exactly you did - do you kill the thread executing SP under WLM? |
|
| Back to top |
|
|
rakesh1155
New User
Joined: 21 Jan 2009
Posts: 84
Location: India
|
|
|
|
| No, I stopped it giving the STOP PROCEDURE command in the DB2 commands. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
To repeat:
| Quote: |
| If the SP was stopped, what was printing the additional lines? |
d |
|
| Back to top |
|
|
|
|
