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
- 20363 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain dclgen.
Name the various locking levels available?
What is runstats utility in db2?
What is reorg and runstats in db2?
How can you do the explain of a dynamic sql statement?
What is db2 purescale?
What is explain plan in db2?
What is difference between alias and synonym in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the max length of sqlca?
What is image copy in db2?
define clustering index.
Is db2 relational database?
Is it possible using max on a char column?
