Interested to Buy Any Domain ? << Click Here >> for more details...
what is check point and restart Logic ? why do we go for
that ??
- 2 Answers
- 27434 Views
- CGI, UST, Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
When can an insert of a new primary key value threaten referential integrity?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
What is a base table?
What are the contents of dclgen?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What is db2? Explain.
how to resolve -805. give clear explination for that
What's the difference between DB2 active log and archive log? Thanks a lot...
What is lock contention?
what is plan? is plan executable or package?
COBOL 
