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
 
How to put DB2 wait time ?

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

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Thu Nov 22, 2007 3:17 am    Post subject: How to put DB2 wait time ?
Reply with quote

My requirements are as follows
1. Update a table (after 20 rows put a Commit stmt)
2. After each commit, wait for one minute and resume the transaction and that should run for one hour (not greater than or less than one hour)

My question is "are we having any cobol syntax to put DB2 wait time for a minute? "Please let me know if you have an idea
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Thu Nov 22, 2007 5:10 am    Post subject:
Reply with quote

The wait one minute and run for exactly one hour requirement seems completely arbitrary though and pointless. This seems like homework, I can't see a business doing this run for only one hour crap. It doesn't account for differences in the data size or a starvation of resources for the job.

What if all the rows aren't in after an hour or you run out of rows in that hour. Are we talking an hour of CPU time or an hour of wall time? What if the job starts and the system is so loaded down that your job doesn't get any CPU for over an hour? Has the program actually met the hour run time requirement? And, if it doesn't get any CPU time at exactly that hour mark and therefore can't end at exactly an hour are you going to lose points on the assignment?

There is no DB2 wait time, you need to build this into your COBOL logic. You will also increase the CPU time of your program for no reason other than to introduce a wait period and that increases costs to your business.

I seem to be asking more questions of the posters lately than giving answers...
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
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts DSNACCOX (can it be run on 1 db/ts, t... SRICOBSAS DB2 5 Sat May 06, 2017 12:59 am

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