Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

require WAIT syntax in job

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
jaspal

New User


Joined: 22 May 2007
Posts: 68
Location: mumbai

PostPosted: Mon Jun 01, 2009 7:13 pm    Post subject: require WAIT syntax in job
Reply with quote

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

Robert Sample

Global Moderator


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

PostPosted: Mon Jun 01, 2009 7:21 pm    Post subject:
Reply with quote

What business reason could you possibly have to do this?
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4649
Location: Raleigh, NC, USA

PostPosted: Mon Jun 01, 2009 7:22 pm    Post subject: Reply to: require WAIT syntax in job
Reply with quote

A simple search found all of these related topics:

http://www.ibmmainframes.com/viewtopic.php?t=35372
http://www.ibmmainframes.com/viewtopic.php?t=16779
http://www.ibmmainframes.com/viewtopic.php?t=13553
http://www.ibmmainframes.com/viewtopic.php?t=9953
http://www.ibmmainframes.com/viewtopic.php?t=9708
Back to top
View user's profile Send private message
jaspal

New User


Joined: 22 May 2007
Posts: 68
Location: mumbai

PostPosted: Mon Jun 01, 2009 7:28 pm    Post subject:
Reply with quote

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

New User


Joined: 22 May 2007
Posts: 68
Location: mumbai

PostPosted: Mon Jun 01, 2009 8:35 pm    Post subject:
Reply with quote

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

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Tue Jun 02, 2009 1:29 am    Post subject:
Reply with quote

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

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Jun 02, 2009 1:39 am    Post subject:
Reply with quote

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

Site Director


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

PostPosted: Tue Jun 02, 2009 2:53 am    Post subject:
Reply with quote

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

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Jun 02, 2009 3:12 am    Post subject:
Reply with quote

Quote:
some hack to dance around the problem.


but that means figuring out the problem.......
Back to top
View user's profile Send private message
jaspal

New User


Joined: 22 May 2007
Posts: 68
Location: mumbai

PostPosted: Tue Jun 02, 2009 9:02 am    Post subject:
Reply with quote

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

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Tue Jun 02, 2009 6:39 pm    Post subject:
Reply with quote

Is this GOAW8TAX program distributed wiith some system software? Where does it come from?
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts NDM syntax checking without actually ... GAPX1 All Other Mainframe Topics 0 Wed Jun 07, 2017 2:36 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
This topic is locked: you cannot edit posts or make replies. Job to wait and continue based on reply yugendran COBOL Programming 5 Wed Oct 05, 2016 1:46 pm
No new posts Require help in DB2 Query Shruti Takkar DB2 3 Wed Aug 03, 2016 10:57 pm
No new posts Syntax for running batch history repo... polymathtarun CA Products 1 Tue Jun 21, 2016 1:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us