Interested to Buy Any Domain ? << Click Here >> for more details...
Explain transactions, commits and rollbacks in DB2.
- 3 Answers
- 8013 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 |
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
can all users have the privilage to use the sql statement select * (dml)?
What is the maximum size of varchar data type in db2?
what is the use of bind parameter, Replace?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is dbrm in db2 database?
how to resolve -805 . how to see dbrm and package not found
How many Buffer pools are there in DB2 and what are they?
What is the database descriptor?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
COBOL 
