Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Stored Procedure in infinite loop

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Mon Apr 19, 2010 4:42 pm    Post subject: Stored Procedure in infinite loop
Reply with quote

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
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8165
Location: East Dubuque, Illinois, USA

PostPosted: Mon Apr 19, 2010 4:58 pm    Post subject:
Reply with quote

Contact your site support group for help. They should have been your FIRST reference, not us.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Apr 19, 2010 8:40 pm    Post subject:
Reply with quote

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
View user's profile Send private message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Tue Apr 20, 2010 1:03 am    Post subject: Reply to: Stored Procedure in infinite loop
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 20, 2010 1:19 am    Post subject:
Reply with quote

Hello,

If the SP was stopped, what was printing the additional lines?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Apr 20, 2010 6:40 am    Post subject: Re: Reply to: Stored Procedure in infinite loop
Reply with quote

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
View user's profile Send private message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Tue Apr 20, 2010 2:01 pm    Post subject:
Reply with quote

No, I stopped it giving the STOP PROCEDURE command in the DB2 commands.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 20, 2010 7:36 pm    Post subject:
Reply with quote

Hello,

To repeat:
Quote:
If the SP was stopped, what was printing the additional lines?


d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us