Interested to Buy Any Domain ? << Click Here >> for more details...
Explain transactions, commits and rollbacks in DB2.
- 3 Answers
- 8339 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepak
Transaction is any basic operation in DB2 like Insert,
Update, Delete is called transaction.
Commit-is use to save the records in data base for ex, I
have hundred records I got an abend in 50th records I can
save upto 49 records, and solve the issue and continue from
50th records,
Roll Back- it do not save the records if any abend occurs
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by between and in? Is between inclusive of specified range values?
What is dclgen in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What does reorg do in db2?
Why select is not preferred in embedded sql programs?
What is commit in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is coalesce in db2?
What is the physical storage length of date data type?
How to restart a DB2 program?
Which component is responsible for db2 startup and shutdown?
Explain what are the various isolation levels possible?
What is bind in db2?
Which components manage deadlocks in db2?
