IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Timeout with COMMIT and ROLLBACK


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
JayC

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Mon Jan 19, 2009 10:42 pm
Reply with quote

An Application process is said to TIMEOUT when it is terminated cause it has been suspended beyond a preset interval.
COMMIT and ROLLBACK operations do not timeout. My question is will there ever be situation where a COMMIT or a ROLLBACK operation will be waiting ? Suspended ? I was of the idea that these two operations never wait ...its executed immediately.
Hope someone can correct me if I am wrong

Thank you.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Jan 20, 2009 6:15 am
Reply with quote

Hello,

Quote:
My question is will there ever be situation where a COMMIT or a ROLLBACK operation will be waiting ?
Most unlikely.

It is even less likely that this is the cause of your newly encountered "long time between commit" problem.
Back to top
View user's profile Send private message
JayC

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Tue Jan 20, 2009 2:28 pm
Reply with quote

Thank you Dick
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts filter COMMIT/ROLLBACK statements DFSORT/ICETOOL 13
No new posts CICS application timeout CICS 3
No new posts CICS Transaction Timeout CICS 2
No new posts Commit limit for Delete query through... DB2 10
No new posts Commit a DB2 Table on Unix Server and... DB2 3
Search our Forums:

Back to Top