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,,,

List out the data types available.

1155

---

What is the clustering index in the db2 database?

1004

---

How do I connect my db2 database to ibm?

1051

---

What is the use of dclgen in db2?

1085

---

What is an instance in db2?

1039

---

What is the information associated with sysibm.syslinks table?

1126

---

What happens in bind step in a db2 program?

977

---

What is scrollable cursor in db2?

1059

---

What do you mean by cursor?

991

---

How do I import a csv file into db2?

994

---

When reorg is used?

1134

---

What is alias in db2?

1067

---

What is host variable in db2 cobol?

1082

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1072

---

Highlight all the advantages that are attached to a package.

1120

---