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
- 27426 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 |
If I have a view which is a join of two or more tables, can this view be updatable?
wht is d/f between union and joins ?
Is db2 a programming language?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is DB2 (IBM Database 2)?
What is the picture clause of null indicator variable?
If I have a view which is a join of two or more tables, can this view be updateable?
How do I add a column to an existing table in db2?
How many clustering indexes can be defined for a table?
How does coalesce work?
What are the two types of logging in the db2 database? Explain them.
wht steps we need will coding cobol and db2 pgm ?
COBOL 
