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

i want to maintain uniqueness on pdf without make lf??????????

1891


Explain about dbrm.

782


Is the primary key a clustered index?

828


Which component is used to execute the sql statements?

832


B37 abend during spufi?

1207


List out the data types available.

912


Define check constraint.

836


What is reorg and runstats in db2?

936


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2140


What is the difference between cursor stability and repeatable read isolation levels?

904


What is release/acquire in bind?

861


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2002


How connect db2 database to datastage?

974


What is dbrm? What it contains? When it will be created?

795


What is meant by dclgen?

848