View previous topic :: View next topic
|
Author |
Message |
jaspal
New User
Joined: 22 May 2007 Posts: 68 Location: mumbai
|
|
|
|
Hi all,
i am having two procedure in a same job i want to place a hold on 2nd procedure for 5 minutes.
any one can assist on the syntax that is used to wait one proc or step in same job.
thanks,
Jaspal virk |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
What business reason could you possibly have to do this? |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
Back to top |
|
|
jaspal
New User
Joined: 22 May 2007 Posts: 68 Location: mumbai
|
|
|
|
Robert,
we have a job in which we have two procesdures thsi job would run once only . procudure one loads couple of database and proc 2 do balancing after taking unload from that tables.
i dont know its DB2 limitation whatosever ...proc 2 is unable to take unload using DSNUPROC utility .
and if we wait for some time nearly 1 - 5 minutes and run proc 2 only it works fine. we do have commit in loading component.
so i am not in postion to split the job into 2 .. so i planned to have wait parameter.
thanks
jaspal |
|
Back to top |
|
|
jaspal
New User
Joined: 22 May 2007 Posts: 68 Location: mumbai
|
|
|
|
thanks to moderators i have got the solution :
if we place below step :
//PS060 EXEC PGM=GOAW8TAX,PARM='00001500'
//*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
in between two procs it will hold the job without consuming CPu time for 15 secs
if you replace parm by '00100000' then it will hold for 10 mins.
thanks,
JAspal |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Waits (pauses) in batch jobs won't use CPU but they will unnecessarily tie up an initiator. Have you run this by your operations folks? |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
jaspal wrote: |
i dont know its DB2 limitation whatosever ...proc 2 is unable to take unload using DSNUPROC utility .
and if we wait for some time nearly 1 - 5 minutes and run proc 2 only it works fine. we do have commit in loading component.
|
What error are you getting, it would be much better to fix that just wait. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
but they will unnecessarily tie up an initiator |
And very possibly some other resources. . .
As Craig mentoned, you should fix the problem rather than implement some hack to dance around the problem. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
some hack to dance around the problem.
|
but that means figuring out the problem....... |
|
Back to top |
|
|
jaspal
New User
Joined: 22 May 2007 Posts: 68 Location: mumbai
|
|
|
|
well... i talk to DBA..according to him its limitation DB2 takes some time to write to tbale from buffer... so to hndle this i place a hold of 5 minutes in one job......... we are facing this problem when we are accessing same table in one job.
and the syntax i provided is woking fine. |
|
Back to top |
|
|
Bill Dennis
Active Member
Joined: 17 Aug 2007 Posts: 562 Location: Iowa, USA
|
|
|
|
Is this GOAW8TAX program distributed wiith some system software? Where does it come from? |
|
Back to top |
|
|
|