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

Describe the elements of the SELECT query syntax?

3 Answers  


How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,


Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  


what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,


What is -904 sql code? How to resolve it?

3 Answers  


What is cursor stability?

1 Answers  


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


What does db2 blu stand for?

0 Answers  


What is dpf in db2?

0 Answers  


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


What is the purpose of rollback and commit?

0 Answers  


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

0 Answers  


Categories