Explain transactions, commits and rollbacks in DB2.
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 load replace in db2?
What is deadlock?
How would one remove old reorg information from the DB2 catalog?
What is isolation level in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is dynamic SQL?
How can you split a table in to exactly half?
What is null in db2?
Where could you look if you had a question about whether a column has been defined as an index?
Describe the elements of the SELECT query syntax?
Give some example of statistics collected during RUNSTATS?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?