Interested to Buy Any Domain ? << Click Here >> for more details...
Explain transactions, commits and rollbacks in DB2.
- 3 Answers
- 8350 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar
Transaction is any basic operation in DB2 like Insert,
Update, Delete is called transaction.
Commit: Make the changes permanently in database
Rollback: Get back the changes to the database.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / s
Transactions are programs that run under the transaction
managers like CICS, IMS/TM. Transactions require excellent
response times.
Commit makes the database changes permanent that was made
during a unit of recovery ie. from one consistency point to
another.
Rollbacks reverses the changes made to the database during
a unit of recovery.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
When the like statement is used?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What will the DB2 optimizer do?
How Plan is created while executing the query using SPUFI?
Define check constraint.
What is an alias and how does it differ from a synonym?
What is dbrm? When it will be created?
what is the difference between declaring the cursor in WS section and Procedure division?
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is difference between alias and synonym in db2?
What is with ur in db2?
COBOL 
