Interested to Buy Any Domain ? << Click Here >> for more details...
Explain transactions, commits and rollbacks in DB2.
- 3 Answers
- 8340 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 |
can we view the access paths created by dbrm ? how ? thx
How to fetch the uncommited data from table ?
What will the FREE command do to a plan?
What is nvl in db2?
select 100 records from million records ?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is a page?
What is buffrpool? Where we use it ?
Give the COBOL definition of a VARCHAR field.
What is a Resource Control Table(RCT)? Describe its characteristics.
Which command is used to remove all rows from a table?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
COBOL 
