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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are concurrency issues?

1097


what is the sqlcode -501

13152


What is dbrm library?

1055


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2066


How connect db2 database to datastage?

1243


How do you find the maximum value in a column in db2?

1106


Which isolation level provides highest data integrity?

1118


What type of database is db2?

971


Can there be more than one cursor open for any program?

1169


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1102


What is copy pending status in db2?

1127


How would you find out the total number of rows in a db2 table?

1053


What is the syntax for seeing the columns and data types of a table in the db2 database?

1169


what is utility for parm lib

2377


What is the role of schema in the db2 database?

1275