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

COMMIT & SYNC POINT
IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Preetha Ramkumar

New User


Joined: 07 Mar 2006
Posts: 9
Location: Hyderabad
PostPosted: Mon Mar 27, 2006 12:06 pm
 Reply with quote
An interview question:

1.What is the difference between COMMIT & SYNC POINT?

2.Suppose the db2 pgm which is used is not having any COMMIT,will the database updations get reflected.
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 463
PostPosted: Mon Mar 27, 2006 5:11 pm
 Reply with quote
Hi Preets,

Quote:
Suppose the db2 pgm which is used is not having any COMMIT,will the database updations get reflected.


After successful completion of the Program DB2 automatically commit all the updates.

Hope this helps

Regards
Rupesh
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
PostPosted: Mon Mar 27, 2006 7:39 pm
 Reply with quote
Quote:
1.What is the difference between COMMIT & SYNC POINT?

Are they related anyway. to make a comparison .????

Regards,
Priyesh.
Back to top
View user's profile Send private message
rambabu
Currently Banned
New User


Joined: 18 Apr 2005
Posts: 67
PostPosted: Tue Mar 28, 2006 9:18 am
 Reply with quote
comitt is used comitt the transaction with terminating the task.
sycpoint is used to comitt the transaction with out terminating the task.
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 -> Mainframe Interview Questions

 

Similar Topics
Topic Forum Replies
No new posts Point and Shoot )PTNS TSO/ISPF 0
No new posts A directory in the pathname was not f... ABENDS & Debugging 0
No new posts How to remove DECIMAL POINT (.) from ... SYNCSORT 10
No new posts Sync logic between VSAM files and DB2... COBOL Programming 9
No new posts filter COMMIT/ROLLBACK statements DFSORT/ICETOOL 13
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us