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
 

 

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
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 pm
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am
No new posts DD DUMMY & CPU TIME Nileshkul Testing & Performance analysis 16 Mon Dec 19, 2016 11:35 pm
This topic is locked: you cannot edit posts or make replies. Get a job submitted itself every time... arunsoods JCL & VSAM 3 Tue Nov 22, 2016 4:05 pm


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