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


what is check point and restart Logic ? why do we go for
that ??

Answers were Sorted based on User's Feedback



what is check point and restart Logic ? why do we go for that ??..

Answer / milky

Checkpoint-Restart logic is used when your program performs
a large number of database updates or inserts. If you want
to process and insert say 1000 records in a table, and your
program abends at 726th record, then if the checkpoint
frequency has been set to 100, then, on restart the program
will start processing from 701th record as each processing
of 100 records results in a COMMIT.

Is This Answer Correct ?    68 Yes 5 No

what is check point and restart Logic ? why do we go for that ??..

Answer / harsha

check point and restart logic are mainly used when our
table has 1000 records and we are getting abend after 100
records and we want to start the execution after 100th
record we use this.for this we have to use check points for
every 100 records

Is This Answer Correct ?    41 Yes 12 No

Post New Answer

More DB2 Interview Questions

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,


What is the difference between drop table and delete table?

0 Answers  


If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,


What is the database descriptor?

2 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


What is the difference between plan and package in db2?

0 Answers  


i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,


What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,


What is dbrm? What it contains?

0 Answers  


How do you pull up a query which was previously saved in qmf?

0 Answers  


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  


Categories