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

What is database manager in db2?

1064

---

How many types of page locks can be held in db2?

1088

---

What is meant by dclgen?

1173

---

What are the 2 sqlcodes that are returned?

1233

---

What do you mean by storage group (stogroup)?

1080

---

Is ibm db2 free?

1066

---

Is db2 a programming language?

1101

---

What is db2 instance?

1165

---

What are iseries servers?

1132

---

What is ibm db2 database?

1066

---

What is bind package and plan in db2?

1108

---

Is the primary key a clustered index?

1203

---

What is commit in db2?

1105

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2387

---

What is nvl in db2?

1148

---