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
- 27428 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 |
Which components manage deadlocks in db2?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How to see the structure of db2 table??
Why use RUNSTAT Utility?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is access path in db2?
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?
What is the physical storage length of time data type?
Is there any advantage to denormalizing DB2 tables?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
COBOL 
