Explain transactions, commits and rollbacks in DB2.
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 database manager in db2?
What is a collection in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is isolation level in db2?
How to create backup table in db2?
How do we specify index to include or not during bind process.
What is db2 bind?
What is bind and rebind in db2?
What is access path in db2?
What are the contents of a dclmgen?
What is the information associated with sysibm.syslinks table?
How would you find out the total number of rows in a db2 table?
Explain db2.
What is the role of data manager in the db2 database?
What is null in db2?