Explain transactions, commits and rollbacks in DB2.
- 3 Answers
- 7461 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 is the default page size of buffer pools?
Is db2 free?
What are the contents of a dclmgen?
define clustering index.
What is the latest version of ibm db2?
What is view db2?
What is dbrm library?
What is the usage of open cursor command?
What is schema in db2?
What is runstats and reorg in db2?
Define sqlca.
Before you give the explain statement, what are the prerogatives?
What is explain in db2?
What do you mean by rollback?
What is the role of data manager in the db2 database?
