IBM DB2 Question:
Download Questions PDF

could you give me an example how, where i code CHECKPOINT
and restart. I need and example

Answer:

You should pass CHECKpoint frequency value from JCL to
cobol program.Intern cobol program will have the table of
retart logic.
Table contents(coloumns)be: 1.No of records ,2.No of
records + 1, 3.no of records processed etc.
Once the updattion or insertion got stucked while
processing ,All the relative data will be stored the above
mentioned table.

So check the record from table .Fix the abend and restart
your job for the failed step.

This is mainly production support work .manually u have to
check the record .and get the records info from the table
and restart the job from the failed step

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext Question
If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
Can you search give an array in the WHERE clause of a db2
query?