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...

Can any one tell me about Restart logic in DB2.

Answer Posted / girish kumar

suppose if we have 1000 rows for update, while we updating
incase if we get abend occures at 999 even a single record
could not be saved to database with out execute commit.
so that if we can place a commit for every 100 records
incase abend occres at 999 cursor start for 900 onwords by
issuing rollback along with commit.


this is db2 logic better to refer MUTTU REFRESHNER

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is syscat in db2?

1020


What are union and union all?

991


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1282


What is the use of db2?

1061


Mention the various locks that are available in db2.

1050


B37 abend during spufi?

1464


What is the use of value function?

1161


What is db2 purescale?

1012


How many databases can be created inside an instance in db2 ?

1043


What is dbrm in db2 database?

1128


Can we insert update delete in view?

975


Where can you declare a cursor in a cobol-db2 program?

1085


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1068


What is ibm db2 used for?

1091


What is db2 and what is the use of db2 optimizer?

1071