could you give me an example how, where i code CHECKPOINT
and restart...I need and example....thanks..
- 5 Answers
- 18814 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lu
Hi Rameshkumar.h.k,
Honestly, i don't understand.... when u say :
1)You should pass CHECKpoint frequency value from JCL to
cobol program. what's it....give me an example please in
cobol program, and in JCL....
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vicky
Since I cannot type in all details...just letting u know some of them----
we need to make some changes to the JCL and also the cobol pgm.
In JCL-
Firstly, we need to include a library for smart restart.
Secondly, define a DSN for the chkpoint restart file, that shall store the information about the chkpoint created and with the number of records committed till the abend occurred ,so that when Job is restarted chkpoint can be checked.
Thirdly,the SYSIN for the RAINPUT step will consist of all the other parameter.Eg- frequency, chkpoint, sql code, etc
JCL will look like-
//EXAMPLE JOB
//STEP1 EXEC PGM=EXAMPLE
//define libaries
//OUTFILE DD DSN=file PS ,DISP=OLD
//
//RAINPUT DD * <-- Optional Smart/RESTART parameter file
CKPT_PACE(50)
//
Coming to the cobol pgm-
we need to code a switch whose value can be chked in case of abend, based on negative SQLCODE returned.
the value returned can be
0 = (Intial start)
1, +2001 = (Restart)
Later Commit para can be called.
If value 1 and +2001 , the pgm can be restarted for a same sqlcode returned , that number of times defined in
parameter of RAINPUT
Hope u could be somewht clear to this,,,
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rameshkumar.h.k
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
Hope You clread
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vicky
CHECKpoint frequency value from JCL to
cobol program. This means, number of records after which the data should be commited, and chkpoint fixed.
If chkpoint frequency is 10 , then after every 10 records, data will be committed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / laxmikanth
restart will give in job card in jcl when ever u got any
abends then we have to give give particular step name
there.........like
Restart=step5.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is check constraint. Explain with example.
What is read-only cursor?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is collection in db2 bind?
Before you give the explain statement, what are the prerogatives?
How to resolve deadlock issue
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Mention the downsides of page level lock.
what is a corelated subquerry?
What is an asychronous write?
COBOL 
