Explain transactions, commits and rollbacks in DB2.
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 |
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is catalog database in db2?
What is the maximum length of sqlca?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What is UNION,UNION ALL?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is sqlcode -922 ?
What are the two types of logging in the db2 database? Explain them.
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What is a db2 cursor?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.