MVSFORUMS.com

kingo · Posted: Tue Feb 13, 2007 2:20 am Post subject: Restart a job

Hi,

Can anyone tell me how to restart a job in DB2

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

blitz2 · Beginner Joined: 23 Jan 2007 Posts: 84 Topics: 14

http://www.mvsforums.com/helpboards/viewtopic.php?t=7299&highlight=checkpoint+restart
http://mvsforums.com/helpboards/viewtopic.php?t=1318&highlight=checkpoint

so many links available if you do a simple search on 'checkpoint restart' in this forum.
________
vaporite solo

kingo · Posted: Tue Feb 13, 2007 4:24 am Post subject:

No no My doubt is Restart in JCL is different from restart in DB2.
Whats the difference?

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

hareshh · Beginner Joined: 13 Dec 2006 Posts: 16 Topics: 0

Hi Kingo,

Restart in JCL

http://www.mvsforums.com/helpboards/viewtopic.php?t=4770&view=next

Restart in DB2

http://www.mvsforums.com/helpboards/viewtopic.php?t=7435&view=next

Regards,
Haresh. Mr. Green

Nic Clouston · Posted: Tue Feb 13, 2007 5:35 am Post subject:

Try getting yourself on a mainframe fundamentals course
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

kingo · Posted: Tue Feb 13, 2007 5:46 am Post subject:

_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

Hello Kingo,

the difference is, that a restart via JCL means, that you code
RESTART=stepname in your job card.

Restart in DB2 means, that you change your program, so that it reads from a file or another DB2 table the needed restart information and uses this to reposition it's old cursor position or the row in a sequential output dataset.

That means: DB2-restart has to be coded in your program, JCL-restart just skips some of the steps in your JCL.

regards
Christian

dbzTHEdinosauer · Posted: Tue Feb 13, 2007 7:10 am Post subject:

good answer Christian
_________________
Dick Brenholtz
American living in Varel, Germany

kingo · Posted: Tue Feb 13, 2007 7:14 am Post subject:

I am not going into the files itself.See suppose If my LOAD utility job fails in the sort phase and then i need to fix it by building up of the index.So now I need to restart.So there is something called as RESTART(PHASE) ,RESTART(CURRENT).So where will i give these options.As i have checked We wont give them in utility card neither in JCL I suppose.So how would we RESTART or what are the other options we got to provide.Hope I got my question clear this time? Crying or Very sad

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.

kolusu · Posted: Tue Feb 13, 2007 7:30 am Post subject:

kingo · Posted: Tue Feb 13, 2007 11:42 pm Post subject:

Thanks a lot Kolusu.

Regds,
Kingo
_________________
IF YOU ARE NOT FOCUSSED ON GOAL ALL YOU SEE IS OBSTACLE.