Interested to Buy Any Domain ? << Click Here >> for more details...
could you give me an example how, where i code CHECKPOINT
and restart...I need and example....thanks..
- 5 Answers
- 20362 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 |
Which isolation level provides maximum concurrency?
What is the use of dclgen in db2?
How do you select a row using indexes in db2?
pls explain the precompilation process of cobol-db2 pgm
What is dbrm?
What is the function of buffer manager?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What is view db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is db2 bind?
What is a trigger in the db2 database?
Q4. How will you get the count of record without using COUNT verb in query?
COBOL 
