Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Explain transactions, commits and rollbacks in DB2.

Answers were Sorted based on User's Feedback



Explain transactions, commits and rollbacks in DB2...

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

Explain transactions, commits and rollbacks in DB2...

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

Explain transactions, commits and rollbacks in DB2...

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

Post New Answer



More DB2 Interview Questions

What is page size in db2?

0 Answers  


What is schema in db2?

0 Answers  


Name the various locking levels available?

0 Answers  


What is Declaration Generator(DCLGEN)?

1 Answers  


What is package in db2 mainframe?

0 Answers  






How can you get the number of rows impacted by the last executed query?

1 Answers  


What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  


What is null indicator in db2?

0 Answers  


How to get the ddl of a table in db2?

0 Answers  


Where is the output of EXPLAIN stored?

2 Answers  


What are the three lock types?

2 Answers  


What is a precompiler?

2 Answers  






Categories