R: ddf stopping hung

Elena Campidoglio

R: ddf stopping hung
Thank you to all who replied to my question.
Last night, we decided to stop db2 (as a matter of fact we had to cancel it)
and then restart it. Everything went on ok .
Probably there is some maintenance we need to put on, now I'll check it
better.

My best regards

Elena



Tina Hilton

Re: ddf stopping hung
(in response to Elena Campidoglio)
How about doing a stop db2 mode(force) before cancelling IRLM? That would
be less destructive.

Tina

> -----Original Message-----
> From: Bourgoine, Peter A [SMTP:[login to unmask email]
> Sent: Monday, June 19, 2000 10:24 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
> I don't know of any other way to do it. It's hard on DB2 but we have been
> successful (lucky) bringing DB2 down when were in the DDF/dis thread/stop
> DB2 quandary. The best thing, of course, is to be sure you have no dist
> threads when you issue the stop.
>
> Question 1:
> Anyone got a better solution?
> Question 2:
> I'm new to the listserv. Where are the archives?
>
> Thanks
> Pete
>
> Peter Bourgoine - DBA
> Data Resource Management
> Jefferson Pilot Financial
> 1 Granite Place
> Concord, NH 03301
> 603-226-5906
> 603-226-4212 (fax)
> [login to unmask email]
>
> -----Original Message-----
> From: Peter, Georg [mailto:[login to unmask email]
> Sent: Monday, June 19, 2000 10:55 AM
> To: [login to unmask email]
> Subject: AW: ddf stopping hung
>
>
> >>>> cancel the IRLM. That will bring DB2 down.
>
> Sounds a little bit the hard way, or ???? Is there no other way in such a
> situation ?
>
> With kind regards - mit freundlichen Grüssen,
> G e o r g H . P e t e r
>
> -----Ursprüngliche Nachricht-----
> Von: Bourgoine, Peter A [mailto:[login to unmask email]
> Gesendet am: Montag, 19. Juni 2000 15:13
> An: [login to unmask email]
> Betreff: Re: ddf stopping hung
>
> We have had situations where "someone" issued a stop DB2 without canceling
> the dist threads first. DB2 will sit and wait. If you try to canc the
> threads after the stop command, DB2 says it's stopping and doesn't act on
> the canc thread command... and DB2 will sit and wait. In situations where
> this occurs we have had to cancel the IRLM. That will bring DB2 down.
> Not
> graceful, not nice but better than an IPL.
>
> Pete
>
> Peter Bourgoine - DBA
> Data Resource Management
> Jefferson Pilot Financial
> 1 Granite Place
> Concord, NH 03301
> 603-226-5906
> 603-226-4212 (fax)
> [login to unmask email]
>
> -----Original Message-----
> From: Elmer Valenzuela [mailto:[login to unmask email]
> Sent: Monday, June 19, 2000 2:51 PM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
>
> This occurred to me twice before. Unfortunately, we had to
> do an IPL in both occassions. In our case, we tried to do an inact on the
> major
> node which had the ddf lu but to no avail. Even doing a stop ddf
> mode(force)
> did not work. There was a suggestion posted here before that cancelling
> IRLM
> might help. Although I haven't tried that. You may want to check the
> archive
> as there were a couple of suggestions given.
>
>
>
> >Hi everybody,
> >we have our production ddf (db2 5.1) that hung on saturday afternoon
> >following a stop command (during our weekly saving chain)without any
> error
>
> >message.
> >Until that moment on, any start/stop ddf command replies ddf is stopping,
> >but we think is hung.
> >
> >Any suggestion ?????
> >
> >My thanks and best regards
> >
> >Elena
> >
> >
> > visit
> the
>
> reached
> at [login to unmask email]
> >
> >
> This mail is launched from a new service at http://www.kfupm.edu.sa
>
>
> visit
> the
>
>
>
>
> visit
> the
>
>
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]



Peter A Bourgoine

Re: ddf stopping hung
(in response to Tina Hilton)
Hi Tina,
Canceling the IRLM is done when we have issued a stop and, for some reason
like we didn't kill dist threads, DB2 is not coming down. At that point
it's too late. If you issue a stop/force DB2 will respond with stop already
in process. If DB2 appears to be hung and you haven't issued a stop,
stop/force could be an option.

-----Original Message-----
From: Tina Hilton [mailto:[login to unmask email]
Sent: Tuesday, June 20, 2000 8:05 AM
To: [login to unmask email]
Subject: Re: ddf stopping hung


How about doing a stop db2 mode(force) before cancelling IRLM? That would
be less destructive.

Tina

> -----Original Message-----
> From: Bourgoine, Peter A [SMTP:[login to unmask email]
> Sent: Monday, June 19, 2000 10:24 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
> I don't know of any other way to do it. It's hard on DB2 but we have been
> successful (lucky) bringing DB2 down when were in the DDF/dis thread/stop
> DB2 quandary. The best thing, of course, is to be sure you have no dist
> threads when you issue the stop.
>
> Question 1:
> Anyone got a better solution?
> Question 2:
> I'm new to the listserv. Where are the archives?
>
> Thanks
> Pete
>
> Peter Bourgoine - DBA
> Data Resource Management
> Jefferson Pilot Financial
> 1 Granite Place
> Concord, NH 03301
> 603-226-5906
> 603-226-4212 (fax)
> [login to unmask email]
>
> -----Original Message-----
> From: Peter, Georg [mailto:[login to unmask email]
> Sent: Monday, June 19, 2000 10:55 AM
> To: [login to unmask email]
> Subject: AW: ddf stopping hung
>
>
> >>>> cancel the IRLM. That will bring DB2 down.
>
> Sounds a little bit the hard way, or ???? Is there no other way in such a
> situation ?
>
> With kind regards - mit freundlichen Grüssen,
> G e o r g H . P e t e r
>
> -----Ursprüngliche Nachricht-----
> Von: Bourgoine, Peter A [mailto:[login to unmask email]
> Gesendet am: Montag, 19. Juni 2000 15:13
> An: [login to unmask email]
> Betreff: Re: ddf stopping hung
>
> We have had situations where "someone" issued a stop DB2 without canceling
> the dist threads first. DB2 will sit and wait. If you try to canc the
> threads after the stop command, DB2 says it's stopping and doesn't act on
> the canc thread command... and DB2 will sit and wait. In situations where
> this occurs we have had to cancel the IRLM. That will bring DB2 down.
> Not
> graceful, not nice but better than an IPL.
>
> Pete
>
> Peter Bourgoine - DBA
> Data Resource Management
> Jefferson Pilot Financial
> 1 Granite Place
> Concord, NH 03301
> 603-226-5906
> 603-226-4212 (fax)
> [login to unmask email]
>
> -----Original Message-----
> From: Elmer Valenzuela [mailto:[login to unmask email]
> Sent: Monday, June 19, 2000 2:51 PM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
>
> This occurred to me twice before. Unfortunately, we had to
> do an IPL in both occassions. In our case, we tried to do an inact on the
> major
> node which had the ddf lu but to no avail. Even doing a stop ddf
> mode(force)
> did not work. There was a suggestion posted here before that cancelling
> IRLM
> might help. Although I haven't tried that. You may want to check the
> archive
> as there were a couple of suggestions given.
>
>
>
> >Hi everybody,
> >we have our production ddf (db2 5.1) that hung on saturday afternoon
> >following a stop command (during our weekly saving chain)without any
> error
>
> >message.
> >Until that moment on, any start/stop ddf command replies ddf is stopping,
> >but we think is hung.
> >
> >Any suggestion ?????
> >
> >My thanks and best regards
> >
> >Elena
> >
> >
> > visit
> the
>
> reached
> at [login to unmask email]
> >
> >
> This mail is launched from a new service at http://www.kfupm.edu.sa
>
>
> visit
> the
>
>
>
>
> visit
> the
>
>
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]



http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]



Tina Hilton

Re: ddf stopping hung
(in response to Peter A Bourgoine)
There was a similar thread back in March, and it was mentioned that a STOP
DB2 MODE(FORCE) is accepted after a normal stop. Look for the subject "DB2
hangs at shutdown" in early March.

> -----Original Message-----
> From: Bourgoine, Peter A [SMTP:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:49 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
> Hi Tina,
> Canceling the IRLM is done when we have issued a stop and, for some reason
> like we didn't kill dist threads, DB2 is not coming down. At that point
> it's too late. If you issue a stop/force DB2 will respond with stop
> already
> in process. If DB2 appears to be hung and you haven't issued a stop,
> stop/force could be an option.
>
> -----Original Message-----
> From: Tina Hilton [mailto:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:05 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
>
> How about doing a stop db2 mode(force) before cancelling IRLM? That would
> be less destructive.
>
> Tina
>
> > -----Original Message-----
> > From: Bourgoine, Peter A [SMTP:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:24 AM
> > To: [login to unmask email]
> > Subject: Re: ddf stopping hung
> >
> > I don't know of any other way to do it. It's hard on DB2 but we have
> been
> > successful (lucky) bringing DB2 down when were in the DDF/dis
> thread/stop
> > DB2 quandary. The best thing, of course, is to be sure you have no dist
> > threads when you issue the stop.
> >
> > Question 1:
> > Anyone got a better solution?
> > Question 2:
> > I'm new to the listserv. Where are the archives?
> >
> > Thanks
> > Pete
> >
> > Peter Bourgoine - DBA
> > Data Resource Management
> > Jefferson Pilot Financial
> > 1 Granite Place
> > Concord, NH 03301
> > 603-226-5906
> > 603-226-4212 (fax)
> > [login to unmask email]
> >
> > -----Original Message-----
> > From: Peter, Georg [mailto:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:55 AM
> > To: [login to unmask email]
> > Subject: AW: ddf stopping hung
> >
> >
> > >>>> cancel the IRLM. That will bring DB2 down.
> >
> > Sounds a little bit the hard way, or ???? Is there no other way in such
> a
> > situation ?
> >
> > With kind regards - mit freundlichen Grüssen,
> > G e o r g H . P e t e r
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Bourgoine, Peter A [mailto:[login to unmask email]
> > Gesendet am: Montag, 19. Juni 2000 15:13
> > An: [login to unmask email]
> > Betreff: Re: ddf stopping hung
> >
> > We have had situations where "someone" issued a stop DB2 without
> canceling
> > the dist threads first. DB2 will sit and wait. If you try to canc the
> > threads after the stop command, DB2 says it's stopping and doesn't act
> on
> > the canc thread command... and DB2 will sit and wait. In situations
> where
> > this occurs we have had to cancel the IRLM. That will bring DB2 down.
> > Not
> > graceful, not nice but better than an IPL.
> >
> > Pete
> >
> > Peter Bourgoine - DBA
> > Data Resource Management
> > Jefferson Pilot Financial
> > 1 Granite Place
> > Concord, NH 03301
> > 603-226-5906
> > 603-226-4212 (fax)
> > [login to unmask email]
> >
> > -----Original Message-----
> > From: Elmer Valenzuela [mailto:[login to unmask email]
> > Sent: Monday, June 19, 2000 2:51 PM
> > To: [login to unmask email]
> > Subject: Re: ddf stopping hung
> >
> >
> > This occurred to me twice before. Unfortunately, we had to
> > do an IPL in both occassions. In our case, we tried to do an inact on
> the
> > major
> > node which had the ddf lu but to no avail. Even doing a stop ddf
> > mode(force)
> > did not work. There was a suggestion posted here before that cancelling
> > IRLM
> > might help. Although I haven't tried that. You may want to check the
> > archive
> > as there were a couple of suggestions given.
> >
> >
> >
> > >Hi everybody,
> > >we have our production ddf (db2 5.1) that hung on saturday afternoon
> > >following a stop command (during our weekly saving chain)without any
> > error
> >
> > >message.
> > >Until that moment on, any start/stop ddf command replies ddf is
> stopping,
> > >but we think is hung.
> > >
> > >Any suggestion ?????
> > >
> > >My thanks and best regards
> > >
> > >Elena
> > >
> > >
> > >
> visit
> > the
> > DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
> be
> > reached
> > at [login to unmask email]
> > >
> > >
> > This mail is launched from a new service at http://www.kfupm.edu.sa
> >
> >
> > visit
> > the
> > DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
> be
> >
> >
> >
> > visit
> > the
> > DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
> be
> >
> >
> > =======================To change your
> subscription
> >
> > http://www.ryci.com/db2-l. The owners of the list can be reached at
> > [login to unmask email]
> >
> > =======================To change your
> subscription
> >
> > http://www.ryci.com/db2-l. The owners of the list can be reached at
> > [login to unmask email]
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]



Kirk Hampton

Re: ddf stopping hung
(in response to Tina Hilton)


To everyone who says they "cancel IRLM" :
Do you actually use an MVS Cancel command on it, or do you use
the modify as recommended in the manual:

F ssssIRLM,ABEND,NODUMP





Tina Hilton <[login to unmask email]> on 06/21/2000 07:55:26 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Kirk Hampton/Texas Utilities)
Subject: Re: ddf stopping hung



There was a similar thread back in March, and it was mentioned that a STOP
DB2 MODE(FORCE) is accepted after a normal stop. Look for the subject "DB2
hangs at shutdown" in early March.

> -----Original Message-----
> From: Bourgoine, Peter A [SMTP:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:49 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
> Hi Tina,
> Canceling the IRLM is done when we have issued a stop and, for some reason
> like we didn't kill dist threads, DB2 is not coming down. At that point
> it's too late. If you issue a stop/force DB2 will respond with stop
> already
> in process. If DB2 appears to be hung and you haven't issued a stop,
> stop/force could be an option.
>
> -----Original Message-----
> From: Tina Hilton [mailto:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:05 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
>
> How about doing a stop db2 mode(force) before cancelling IRLM? That would
> be less destructive.
>
> Tina
>
> > -----Original Message-----
> > From: Bourgoine, Peter A [SMTP:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:24 AM
> > To: [login to unmask email]
> > Subject: Re: ddf stopping hung
> >
> > I don't know of any other way to do it. It's hard on DB2 but we have
> been
> > successful (lucky) bringing DB2 down when were in the DDF/dis
> thread/stop
> > DB2 quandary. The best thing, of course, is to be sure you have no dist
> > threads when you issue the stop.
> >
> > Question 1:
> > Anyone got a better solution?
> > Question 2:
> > I'm new to the listserv. Where are the archives?
> >
> > Thanks
> > Pete
> >
> > Peter Bourgoine - DBA
> > Data Resource Management
> > Jefferson Pilot Financial
> > 1 Granite Place
> > Concord, NH 03301
> > 603-226-5906
> > 603-226-4212 (fax)
> > [login to unmask email]
> >
> > -----Original Message-----
> > From: Peter, Georg [mailto:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:55 AM
> > To: [login to unmask email]
> > Subject: AW: ddf stopping hung
> >
> >
> > >>>> cancel the IRLM. That will bring DB2 down.
> >
> > Sounds a little bit the hard way, or ???? Is there no other way in such
> a
> > situation ?
> >
> > With kind regards - mit freundlichen Gr

RICK (SWBT) DAVIS

Re: ddf stopping hung
(in response to Kirk Hampton)
Hi Tina,
Before I realized there was a modify (F) command available (and
there might not have been yrs ago), I first did an MVS end (P), which
usually didn't work, and then a cancel (C). I think I remember reading long
ago that a cancel command should always be preceded by an end command; might
not be true any longer.
Regards,
Rick Davis

"This e-mail and any files transmitted with it are the property of SBC,
are confidential, and are intended solely for the use of the individual
or entity to whom this e-mail is addressed. If you are not one of the
named recipient(s) or otherwise have reason to believe that you have
received this message in error, please notify the sender at 314-235-6854
and delete this message immediately from your computer. Any other use,
retention, dissemination, forwarding, printing, or copying of this
e-mail is strictly prohibited."



-----Original Message-----
From: Kirk Hampton [mailto:[login to unmask email]
Sent: Wednesday, June 21, 2000 8:16 AM
To: [login to unmask email]
Subject: Re: ddf stopping hung




To everyone who says they "cancel IRLM" :
Do you actually use an MVS Cancel command on it, or do you use
the modify as recommended in the manual:

F ssssIRLM,ABEND,NODUMP





Tina Hilton <[login to unmask email]> on 06/21/2000 07:55:26 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Kirk Hampton/Texas Utilities)
Subject: Re: ddf stopping hung



There was a similar thread back in March, and it was mentioned that a STOP
DB2 MODE(FORCE) is accepted after a normal stop. Look for the subject "DB2
hangs at shutdown" in early March.

> -----Original Message-----
> From: Bourgoine, Peter A [SMTP:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:49 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
> Hi Tina,
> Canceling the IRLM is done when we have issued a stop and, for some reason
> like we didn't kill dist threads, DB2 is not coming down. At that point
> it's too late. If you issue a stop/force DB2 will respond with stop
> already
> in process. If DB2 appears to be hung and you haven't issued a stop,
> stop/force could be an option.
>
> -----Original Message-----
> From: Tina Hilton [mailto:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:05 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
>
> How about doing a stop db2 mode(force) before cancelling IRLM? That would
> be less destructive.
>
> Tina
>
> > -----Original Message-----
> > From: Bourgoine, Peter A [SMTP:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:24 AM
> > To: [login to unmask email]
> > Subject: Re: ddf stopping hung
> >
> > I don't know of any other way to do it. It's hard on DB2 but we have
> been
> > successful (lucky) bringing DB2 down when were in the DDF/dis
> thread/stop
> > DB2 quandary. The best thing, of course, is to be sure you have no dist
> > threads when you issue the stop.
> >
> > Question 1:
> > Anyone got a better solution?
> > Question 2:
> > I'm new to the listserv. Where are the archives?
> >
> > Thanks
> > Pete
> >
> > Peter Bourgoine - DBA
> > Data Resource Management
> > Jefferson Pilot Financial
> > 1 Granite Place
> > Concord, NH 03301
> > 603-226-5906
> > 603-226-4212 (fax)
> > [login to unmask email]
> >
> > -----Original Message-----
> > From: Peter, Georg [mailto:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:55 AM
> > To: [login to unmask email]
> > Subject: AW: ddf stopping hung
> >
> >
> > >>>> cancel the IRLM. That will bring DB2 down.
> >
> > Sounds a little bit the hard way, or ???? Is there no other way in such
> a
> > situation ?
> >
> > With kind regards - mit freundlichen Gr



Peter A Bourgoine

Re: ddf stopping hung
(in response to RICK (SWBT) DAVIS)
We have CA-SYSVIEW. We issue a line command "C" cancel the STC.

-----Original Message-----
From: Kirk Hampton [mailto:[login to unmask email]
Sent: Wednesday, June 21, 2000 9:16 AM
To: [login to unmask email]
Subject: Re: ddf stopping hung




To everyone who says they "cancel IRLM" :
Do you actually use an MVS Cancel command on it, or do you use
the modify as recommended in the manual:

F ssssIRLM,ABEND,NODUMP





Tina Hilton <[login to unmask email]> on 06/21/2000 07:55:26 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Kirk Hampton/Texas Utilities)
Subject: Re: ddf stopping hung



There was a similar thread back in March, and it was mentioned that a STOP
DB2 MODE(FORCE) is accepted after a normal stop. Look for the subject "DB2
hangs at shutdown" in early March.

> -----Original Message-----
> From: Bourgoine, Peter A [SMTP:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:49 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
> Hi Tina,
> Canceling the IRLM is done when we have issued a stop and, for some reason
> like we didn't kill dist threads, DB2 is not coming down. At that point
> it's too late. If you issue a stop/force DB2 will respond with stop
> already
> in process. If DB2 appears to be hung and you haven't issued a stop,
> stop/force could be an option.
>
> -----Original Message-----
> From: Tina Hilton [mailto:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:05 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
>
> How about doing a stop db2 mode(force) before cancelling IRLM? That would
> be less destructive.
>
> Tina
>
> > -----Original Message-----
> > From: Bourgoine, Peter A [SMTP:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:24 AM
> > To: [login to unmask email]
> > Subject: Re: ddf stopping hung
> >
> > I don't know of any other way to do it. It's hard on DB2 but we have
> been
> > successful (lucky) bringing DB2 down when were in the DDF/dis
> thread/stop
> > DB2 quandary. The best thing, of course, is to be sure you have no dist
> > threads when you issue the stop.
> >
> > Question 1:
> > Anyone got a better solution?
> > Question 2:
> > I'm new to the listserv. Where are the archives?
> >
> > Thanks
> > Pete
> >
> > Peter Bourgoine - DBA
> > Data Resource Management
> > Jefferson Pilot Financial
> > 1 Granite Place
> > Concord, NH 03301
> > 603-226-5906
> > 603-226-4212 (fax)
> > [login to unmask email]
> >
> > -----Original Message-----
> > From: Peter, Georg [mailto:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:55 AM
> > To: [login to unmask email]
> > Subject: AW: ddf stopping hung
> >
> >
> > >>>> cancel the IRLM. That will bring DB2 down.
> >
> > Sounds a little bit the hard way, or ???? Is there no other way in such
> a
> > situation ?
> >
> > With kind regards - mit freundlichen Gr



Brian Triptow

Re: ddf stopping hung
(in response to Peter A Bourgoine)
For years I issued the MVS cancel command then began using the F ssssIRLM,ABEND command with the same result. Both work OK.

>>> "Bourgoine, Peter A" <[login to unmask email]> June 21, 2000 9:47:41 AM >>>
We have CA-SYSVIEW. We issue a line command "C" cancel the STC.

-----Original Message-----
From: Kirk Hampton [mailto:[login to unmask email]
Sent: Wednesday, June 21, 2000 9:16 AM
To: [login to unmask email]
Subject: Re: ddf stopping hung




To everyone who says they "cancel IRLM" :
Do you actually use an MVS Cancel command on it, or do you use
the modify as recommended in the manual:

F ssssIRLM,ABEND,NODUMP





Tina Hilton <[login to unmask email]> on 06/21/2000 07:55:26 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Kirk Hampton/Texas Utilities)
Subject: Re: ddf stopping hung



There was a similar thread back in March, and it was mentioned that a STOP
DB2 MODE(FORCE) is accepted after a normal stop. Look for the subject "DB2
hangs at shutdown" in early March.

> -----Original Message-----
> From: Bourgoine, Peter A [SMTP:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:49 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
> Hi Tina,
> Canceling the IRLM is done when we have issued a stop and, for some reason
> like we didn't kill dist threads, DB2 is not coming down. At that point
> it's too late. If you issue a stop/force DB2 will respond with stop
> already
> in process. If DB2 appears to be hung and you haven't issued a stop,
> stop/force could be an option.
>
> -----Original Message-----
> From: Tina Hilton [mailto:[login to unmask email]
> Sent: Tuesday, June 20, 2000 8:05 AM
> To: [login to unmask email]
> Subject: Re: ddf stopping hung
>
>
> How about doing a stop db2 mode(force) before cancelling IRLM? That would
> be less destructive.
>
> Tina
>
> > -----Original Message-----
> > From: Bourgoine, Peter A [SMTP:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:24 AM
> > To: [login to unmask email]
> > Subject: Re: ddf stopping hung
> >
> > I don't know of any other way to do it. It's hard on DB2 but we have
> been
> > successful (lucky) bringing DB2 down when were in the DDF/dis
> thread/stop
> > DB2 quandary. The best thing, of course, is to be sure you have no dist
> > threads when you issue the stop.
> >
> > Question 1:
> > Anyone got a better solution?
> > Question 2:
> > I'm new to the listserv. Where are the archives?
> >
> > Thanks
> > Pete
> >
> > Peter Bourgoine - DBA
> > Data Resource Management
> > Jefferson Pilot Financial
> > 1 Granite Place
> > Concord, NH 03301
> > 603-226-5906
> > 603-226-4212 (fax)
> > [login to unmask email]
> >
> > -----Original Message-----
> > From: Peter, Georg [mailto:[login to unmask email]
> > Sent: Monday, June 19, 2000 10:55 AM
> > To: [login to unmask email]
> > Subject: AW: ddf stopping hung
> >
> >
> > >>>> cancel the IRLM. That will bring DB2 down.
> >
> > Sounds a little bit the hard way, or ???? Is there no other way in such
> a
> > situation ?
> >
> > With kind regards - mit freundlichen Gr






Colin Fay

DDF hung
(in response to Brian Triptow)
Hi,

Re: OS/390 Db2 V 5.1

Situation:

- STO DDF MODE(FORCE) followed by -STA DDF completed sucessfully.

Db2mstr shows

DSNL006I -DB2P DDF STOP COMPLETE
DSNL003I -DB2P DDF IS STARTING
DSNL519I -DB2P DSNLILNR TCP/IP SERVICES AVAILABLE
FOR DOMAIN ip3270.biw.com AND PORT 446
DSNL519I -DB2P DSNLIRSY TCP/IP SERVICES AVAILABLE
FOR DOMAIN ip3270.biw.com AND PORT 5020

The second time around the STO command hung and will not complete.

DSNL005I -DB2P DDF IS STOPPING only



Solution?

Is there a way to free up this command without bringing down DB2?

Is it possible to recycle DB2DIST gracefuly without pulling down the
other regions?


Colin



Linda Billings

Re: DDF hung
(in response to Colin Fay)
Hi, Colin,

Perhaps you didn't allow DDF enough time to complete its startup.
Did you see this message anywhere?

DSNL004I @xxxx DDF START COMPLETE

Perhaps it is confused? You should be able to start and stop DDF
without affecting the other STCs.

Linda Billings
Enterprise Systems Programmer
Info-Tech Services
Department of Administration
State of Wisconsin

"The problem is not that there are problems. The problem is expecting
otherwise and thinking that having problems is a problem." - Theodore
Rubin


-----Original Message-----
From: Colin Fay [mailto:[login to unmask email]
Sent: Wednesday, December 20, 2000 1:37 PM
To: [login to unmask email]
Subject: DDF hung


Hi,

Re: OS/390 Db2 V 5.1

Situation:

- STO DDF MODE(FORCE) followed by -STA DDF completed sucessfully.

Db2mstr shows

DSNL006I -DB2P DDF STOP COMPLETE
DSNL003I -DB2P DDF IS STARTING
DSNL519I -DB2P DSNLILNR TCP/IP SERVICES AVAILABLE
FOR DOMAIN ip3270.biw.com AND PORT 446
DSNL519I -DB2P DSNLIRSY TCP/IP SERVICES AVAILABLE
FOR DOMAIN ip3270.biw.com AND PORT 5020

The second time around the STO command hung and will not complete.

DSNL005I -DB2P DDF IS STOPPING only



Solution?

Is there a way to free up this command without bringing down DB2?

Is it possible to recycle DB2DIST gracefuly without pulling down the
other regions?


Colin








Linda Billings

Re: DDF hung
(in response to Linda Billings)
After a little more research, it seems that DDF takes longer to restart
after a STOP FORCE because it must resolve any indoubt threads. Also,
another method to stop DDF is below:

"Stopping DDF using VTAM commands: Another way to force DDF to stop is to
issue the VTAM VARY NET,INACT command. This command makes VTAM
unavailable and terminates DDF. VTAM forces the completion of any
outstanding VTAM requests immediately.

The syntax for the command is as follows:

VARY NET,INACT,ID=db2lu,FORCE

where db2lu is the VTAM LU name for the local DB2 system.

When DDF has stopped, the following command must be issued before -START
DDF can be attempted:

VARY NET,ACT,ID=db2lu ...."

This is from the DB2 Administration Guide, chapter 4.

I hope this helps,

Linda

-----Original Message-----
From: Colin Fay [mailto:[login to unmask email]
Sent: Wednesday, December 20, 2000 1:37 PM
To: [login to unmask email]
Subject: DDF hung


Hi,

Re: OS/390 Db2 V 5.1

Situation:

- STO DDF MODE(FORCE) followed by -STA DDF completed sucessfully.

Db2mstr shows

DSNL006I -DB2P DDF STOP COMPLETE
DSNL003I -DB2P DDF IS STARTING
DSNL519I -DB2P DSNLILNR TCP/IP SERVICES AVAILABLE
FOR DOMAIN ip3270.biw.com AND PORT 446
DSNL519I -DB2P DSNLIRSY TCP/IP SERVICES AVAILABLE
FOR DOMAIN ip3270.biw.com AND PORT 5020

The second time around the STO command hung and will not complete.

DSNL005I -DB2P DDF IS STOPPING only



Solution?

Is there a way to free up this command without bringing down DB2?

Is it possible to recycle DB2DIST gracefuly without pulling down the
other regions?


Colin








tim malamphy

Re: DDF hung
(in response to Linda Billings)
You didn't show a "DDF has started" message before
stopping it the second time.

Tim
--- Colin Fay <[login to unmask email]> wrote:
> Hi,
>
> Re: OS/390 Db2 V 5.1
>
> Situation:
>
> - STO DDF MODE(FORCE) followed by -STA DDF
> completed sucessfully.
>
> Db2mstr shows
>
> DSNL006I -DB2P DDF STOP COMPLETE
> DSNL003I -DB2P DDF IS STARTING
> DSNL519I -DB2P DSNLILNR TCP/IP SERVICES
> AVAILABLE
> FOR DOMAIN ip3270.biw.com AND
> PORT 446
> DSNL519I -DB2P DSNLIRSY TCP/IP SERVICES
> AVAILABLE
> FOR DOMAIN ip3270.biw.com AND
> PORT 5020
>
> The second time around the STO command hung and
> will not complete.
>
> DSNL005I -DB2P DDF IS STOPPING only
>
>
>
> Solution?
>
> Is there a way to free up this command without
> bringing down DB2?
>
> Is it possible to recycle DB2DIST gracefuly
> without pulling down the
> other regions?
>
>
>
> Colin
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/



Max Scarpa

Re: DDF hung
(in response to tim malamphy)
Hi Colin

Take a look at (if not yet done)

http://techsupport.services.ibm.com/390/psd-adv.html

and search for 'DDF hung', there are some interesting entries.

HTH

Max Scarpa



Colin Fay

Re: DDF hung
(in response to Max Scarpa)
Hi,

Linda, Tim,Phillip,Max , thaks for your suggestions

Max, there are indeed a lot of related apars.

The one most closly resemeblling what happened here is

PQ14382: DSNL511I RC140 AND RSN12EE0291 DB2/MVS SERVER NO LONGER
LISTEN TO THE CLIENT CONNECT.


This inability to re-recycle DDF occurred in conjunction with this
message in MSTR

DSNL511I -DB2P DSNLIENO TCP/IP CONVERSATION FAILED
TO LOCATION 167.150.57.226
IPADDR=167.150.57.226 PORT=1104
SOCKET=WRITEV RETURN CODE=140 REASON CODE=745A7242

Basically the TCP/IP pipe is broken.

Further attempts to cionnect fail on 'waiting for a connection'

In the past starting and stopping DDF has cleared this up but you only
have one shot at it and if the same
user who broke the connect signs on again it fails. This has happened here
several times and always we had DDF hung on the second try. The above APAR
suggests that a 2 minute timeout may be involved.

There are several references to reason code 745A7242 in the List but
no definitive solutions

This all re-occured this morning. Apparently a user running a DB2
connect query abended with 'out of temp disk space on his PC' and this
broke the connection.

Today we were able to clear this out with the follwoing procedure:

-Dis thread(*) - there were no remote connections.

VARY NET,INACT,ID=db2lu,FORCE in the log
VARY NET,ACT,ID=db2lu in the log

-STA DDF in the comand processor

In addition the PC user remoted his PC ( I dont know if this is
necessary it comes in with the same TCP/IP address )

there was also about a ten minute delay in all of this

Once again thanks for your suggestions!!!

Colin



Max Scarpa

Re: DDF hung
(in response to Colin Fay)
You're welcome !!!

Merry XMAS !!!

Max Scarpa