View previous topic :: View next topic
|
Author |
Message |
Nicolas Tuan Yu
New User
Joined: 13 Apr 2012 Posts: 3 Location: China
|
|
|
|
There are 3 JOBs which running in MVS environment with the same JOBNAME,
The JOB executes to call some stored procedure automatically in WLM.
Normally, only one of them can be executed,but this time all of them were executed.
When I execute a batch, there is an error as bellow:
Error Log:
INVOCATION OF FUNCTION OR PROCEDURE SPCFTS.P510_CMRGETD FAILED DUE TO REASON 00E79002. SQLCODE=-471, SQLSTATE=55023
I have no idea how to deal with this kind of problem, because it runs in public environment, and we could not stop DB2 or restart environment.
I have tried '$p jobname' or '$c jobname,a=asid',but the job could not be cancelled.
And I execute some COMMAND below, it still can not work.
STOP PROCEDURE
VARY WLM,APPLENV=name,QUIESCE and MVS Cancel
I will appreciate if there is somebody Who can help me fix this problem.
Looking forward your answer. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Do you mean a "Started Task" rather than a "JOB"?
There are options for the $p which increase its severity and power, but before you go looking at the manual, why don't you get someone in your technical support to sort it out? If you mess something up whilst experimenting, you might not be the most popular of bunnies. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
This is definitely one of those problems where your site support group needs to get involved. Depending upon which release of z/OS your site runs, and how the started tasks are set up in the system, there's a number of possible reasons and they have different solutions. |
|
Back to top |
|
|
Nicolas Tuan Yu
New User
Joined: 13 Apr 2012 Posts: 3 Location: China
|
|
|
|
Robert Sample wrote: |
This is definitely one of those problems where your site support group needs to get involved. Depending upon which release of z/OS your site runs, and how the started tasks are set up in the system, there's a number of possible reasons and they have different solutions. |
The technical support team has been involved to execute statement and investagate result.
I am just incharge of applying for executing statement.
In TSO TASID, task displays as System addr spaces
My system information is:
MVS Information: z/OS 01.12.00
JES Information: JES2 / z/OS1.12 / HJE7770
The task is trigger executed by STORED PROCEDURE |
|
Back to top |
|
|
Nicolas Tuan Yu
New User
Joined: 13 Apr 2012 Posts: 3 Location: China
|
|
|
|
Bill Woodger wrote: |
Do you mean a "Started Task" rather than a "JOB"?
There are options for the $p which increase its severity and power, but before you go looking at the manual, why don't you get someone in your technical support to sort it out? If you mess something up whilst experimenting, you might not be the most popular of bunnies. |
The technical support team has been involved to execute statement and investagate result.I am just incharge of applying for executing statement.
I mean a "System addr spaces" |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
The technical support team has been involved to execute statement and investagate result.I am just incharge of applying for executing statement. |
This needs to be clarified. . . I do not understand what this tells me |
|
Back to top |
|
|
|