Hi All,
I am using Parallel Extender 7. I am extracting data from DB2 and the number of records is 5500000000 (550M). I am putting this data into DB2. Now my job aborts at 250M (250000000) the record. Now when doing a reload I want to start it from 2500000001 th record. Kindly let me know how to achieve this.
Job Restart from the abort point
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'd be more concerned with finding out why it aborts, and correcting that situation. How do you know that all of the 250M records were successfully loaded?
That said, the approach is basically to determine the row counts - there are many ways to do that - and to use the appropriate one as the start point for your next run.
That said, the approach is basically to determine the row counts - there are many ways to do that - and to use the appropriate one as the start point for your next run.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact: