could you give me an example how, where i code CHECKPOINT
and restart...I need and example....thanks..
- 5 Answers
- 18812 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 |
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Can you Average the Characters ?
What is filter factor?
Is there any advantage to denormalizing DB2 tables?
Define sqlca.
Explain about open switch business continuity software?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is precompiler in db2?
how to resolve -818 error. how to see timestamp token in load module and plan
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 .....
What do you mean by rollback?
COBOL 
