Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270


What db2 400?

1188


How can you find out the # of rows updated after an update statement?

1114


How do I add a column to an existing table in db2?

1032


How to retrieve rows from a db2 table in embedded sql?

1389


What is ibm db2 connect?

997


What is the physical storage length of time data type?

1124


What is page size in db2?

973


Which is faster delete or truncate?

1127


How does db2 sample database connect?

1027


Outputs of explain are with matchcols = 0. What does this signify?

1055


What does db2 mean?

1016


How do I import a csv file into db2?

989


Define data page.

1065


What is with ur in db2?

1313