|
View previous topic :: View next topic
|
| Author |
Message |
Mahi_e
New User
Joined: 10 Dec 2010
Posts: 43
Location: hyderabad
|
|
|
|
Hi All,
I have a Question? Hope this will be resolve surely. Scenario is as follows........
I submitted a Job where " I am updating Records of a Table(DB2) after 100 th Record, my job got abend, now my question is how to start my job where i got abend "
Thanks in Advance  |
|
| Back to top |
|
 |
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1314
Location: Vilnius, Lithuania
|
|
|
|
| Mahi_e wrote: |
I have a Question? Hope this will be resolve surely. Scenario is as follows........
I submitted a Job where " I am updating Records of a Table(DB2) after 100 th Record, my job got abend, now my question is how to start my job where i got abend " |
If your program has not issued a commit, DB2 will rollback the changes, if not, you are up to your nostrils in the brown stuff.
Restartability is something you should have thought of in advance, not as an afterthought. |
|
| Back to top |
|
|
Mahi_e
New User
Joined: 10 Dec 2010
Posts: 43
Location: hyderabad
|
|
|
|
Thanks for ur answer.
suppose in my logic , i will use commit for every 60 records for success running of job.
in that case if i would face job abend, then ? what should i do............?
i dont know at what record should i get abend. |
|
| Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1314
Location: Vilnius, Lithuania
|
|
|
|
| Mahi_e wrote: |
| Thanks for ur answer. |
Cn y tll m wht th wrd "ur" mns?
| Mahi_e wrote: |
suppose in my logic , i will use commit for every 60 records for success running of job.
in that case if i would face job abend, then ? what should i do............?
i dont know at what record should i get abend. |
Lrn t rd dmps! |
|
| Back to top |
|
|
Mahi_e
New User
Joined: 10 Dec 2010
Posts: 43
Location: hyderabad
|
|
|
|
okkk..
Thanks, |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
at minimum , just before your commit, you would save/display a restart-key.
the actual record/row which fails (like in the dump) is irrelevant for restartability because all previous updates since last commit will be rollbacked. |
|
| Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1314
Location: Vilnius, Lithuania
|
|
|
|
| GuyC wrote: |
| the actual record/row which fails (like in the dump) is irrelevant for restartability because all previous updates since last commit will be rollbacked. |
Sr, bt f y dnt knw wht rcrd css th bnd, rstrtng dsn't mk mch sns.
('m bgnnng t lk ths SMS stff  ) |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| Mahi_e wrote: |
| suppose in my logic , i will use commit for every 60 records for success running of job. |
Check-point/restart and DB2 COMMIT are different animals. If the COMMIT frequency is 60, that does not necessitates a check-point just before you commit. Read the indication from GuyC.
Chek-point/restart logics are specifc to sites and must be deployed in advance in your program, as Robert has mentioned also. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| LOL - Good one Prino. |
|
| Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1787
Location: Bloomington, IL
|
|
|
|
| prino wrote: |
| Mahi_e wrote: |
| Thanks for ur answer. |
Cn y tll m wht th wrd "ur" mns? |
"If u cn rd ths, u cn mk bg bx n IT ndstry." |
|
| Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1314
Location: Vilnius, Lithuania
|
|
|
|
| Akatsukami wrote: |
| prino wrote: |
| Mahi_e wrote: |
| Thanks for ur answer. |
Cn y tll m wht th wrd "ur" mns? |
"If u cn rd ths, u cn mk bg bx n IT ndstry." |
Sprclfrglstcxpldcs!  |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| Quote: |
| Sprclfrglstcxpldcs! |
Super Caley Fragile Celtic Are Atrocious!
Headline in a Scottish newspaper after little Inverness Caledonian Thistle (Caley) knocked mighty Glasgow Celtic out of the Scottish Football Association Cup a few years back. |
|
| Back to top |
|
|
Mahi_e
New User
Joined: 10 Dec 2010
Posts: 43
Location: hyderabad
|
|
|
|
| Thanks for all Suggestions |
|
| Back to top |
|
|
|
|
