Interested to Buy Any Domain ? << Click Here >> for more details...
Explain transactions, commits and rollbacks in DB2.
- 3 Answers
- 8152 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 can you display the current date & current time ?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How do you select a row using indexes in db2?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
How does the processing of a correlated subquery differ from a non correlated subquery?
how to check the table is empty or not?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What is a cursor and what is its function?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What happens to a cursor after a commit?
COBOL 
