Explain transactions, commits and rollbacks in DB2.
Answer Posted / 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 View All Answers
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What db2 400?
How can you find out the # of rows updated after an update statement?
How do I add a column to an existing table in db2?
How to retrieve rows from a db2 table in embedded sql?
What is ibm db2 connect?
What is the physical storage length of time data type?
What is page size in db2?
Which is faster delete or truncate?
How does db2 sample database connect?
Outputs of explain are with matchcols = 0. What does this signify?
What does db2 mean?
How do I import a csv file into db2?
Define data page.
What is with ur in db2?