Explain transactions, commits and rollbacks in DB2.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database alias db2?

584


Is it possible to create an Instance in DB2 using DB2 Control Center ?

618


What is dpf in db2?

652


What is a system catalog table in db2?

568


What is the difference between bind and rebind in db2?

832






How can you classify the locks in db2?

620


What is db2 look?

563


How to find the number of rows in db2 tables?

605


Explain in brief how does db2 determine what lock-size to use?

582


What do you mean by commit and rollback?

583


How to find the number of rows in a db2 table?

638


What is a db2 package?

586


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1563


What is bind in db2?

593


Give a brief description of db2 isolation levels?

587