need help asap

Edie Richardson

need help asap

I have a db2 load job that has been hung up now for hours so I canceled the job and terminated the utility.  The utility has been terminating now for over 30 minutes which is highly unusual.  Why is it taking so long to terminate, what can I do to find out why it is taking so long and what should I do if it doesn't terminate soon, should I bounce db2?  we are in the middle of month end and so I don't want to do that unless I have to.

 

Any advice would be greatly appreciated.

 

Thanks,

 

Edie Richardson

Edward Vassie

Re: need help asap
(in response to Edie Richardson)
Is the load LOG YES or LOG NO? If it is LOG YES the termination is taking a
long time due to backout. Cancelling DB2 in this situation could result in
a very long restart time.


From Edward Vassie...



-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: 04 January 2001 14:50
To: [login to unmask email]
Subject: need help asap



I have a db2 load job that has been hung up now for hours so I canceled the
job and terminated the utility. The utility has been terminating now for
over 30 minutes which is highly unusual. Why is it taking so long to
terminate, what can I do to find out why it is taking so long and what
should I do if it doesn't terminate soon, should I bounce db2? we are in
the middle of month end and so I don't want to do that unless I have to.



Any advice would be greatly appreciated.



Thanks,



Edie Richardson



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



Tony Provenzola

Re: need help asap
(in response to Linda Billings)
Is it a LOAD LOG YES? If so, it's best to just let it back out. If you
bounce DB2, the whole subsystem could be unavailable until the backout is
complete. As a guesstimate, expect the backout time to be twice as long as
the run time prior to the cancel.


Tony Provenzola
Nike Database Services a
BEST Consulting
* Phone: 503-532-0772
* Fax: 503-532-2618
* Email: [login to unmask email]


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, January 04, 2001 6:50 AM
To: [login to unmask email]
Subject: need help asap



I have a db2 load job that has been hung up now for hours so I canceled the
job and terminated the utility. The utility has been terminating now for
over 30 minutes which is highly unusual. Why is it taking so long to
terminate, what can I do to find out why it is taking so long and what
should I do if it doesn't terminate soon, should I bounce db2? we are in
the middle of month end and so I don't want to do that unless I have to.



Any advice would be greatly appreciated.



Thanks,



Edie Richardson



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



Linda Billings

Re: need help asap
(in response to Edward Vassie)
Hi, Edie,

My first thought is that it is that your utility is still rolling back.
If the workload is very great right now rolling back could take some time.
Also, if your active logs have archived and those archives are on tape then
DB2 is constantly waiting for tape mounts. Bouncing DB2 will not help and
may even hurt your situation. DB2 is very stubborn where corrupted data is
concerned. It will not stop until it is satisfied that it has gotten your
tablespace back to a state of consistency. I think that your only option is
to wait patiently.

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

"The basis of optimism is sheer terror." - Oscar Wilde




-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, January 04, 2001 8:50 AM
To: [login to unmask email]
Subject: need help asap



I have a db2 load job that has been hung up now for hours so I canceled the
job and terminated the utility. The utility has been terminating now for
over 30 minutes which is highly unusual. Why is it taking so long to
terminate, what can I do to find out why it is taking so long and what
should I do if it doesn't terminate soon, should I bounce db2? we are in
the middle of month end and so I don't want to do that unless I have to.



Any advice would be greatly appreciated.



Thanks,



Edie Richardson



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



Ashish Mohan

Re: need help asap
(in response to truman.g.brown@VERIZON.COM)
Or bounce back and do a cold start (Only if it is TEST subsystem). And when
you try LOAD the next time, use LOG(NO).

Ashish.
/*std. Disclaimers*/

-----Original Message-----
From: Billings, Linda [SMTP:[login to unmask email]
Sent: Thursday, January 04, 2001 8:20 AM
To: [login to unmask email]
Subject: Re: need help asap

Hi, Edie,

My first thought is that it is that your utility is still
rolling back.
If the workload is very great right now rolling back could take some
time.
Also, if your active logs have archived and those archives are on
tape then
DB2 is constantly waiting for tape mounts. Bouncing DB2 will not
help and
may even hurt your situation. DB2 is very stubborn where corrupted
data is
concerned. It will not stop until it is satisfied that it has
gotten your
tablespace back to a state of consistency. I think that your only
option is
to wait patiently.

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

"The basis of optimism is sheer terror." - Oscar Wilde




-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, January 04, 2001 8:50 AM
To: [login to unmask email]
Subject: need help asap



I have a db2 load job that has been hung up now for hours so I
canceled the
job and terminated the utility. The utility has been terminating
now for
over 30 minutes which is highly unusual. Why is it taking so long
to
terminate, what can I do to find out why it is taking so long and
what
should I do if it doesn't terminate soon, should I bounce db2? we
are in
the middle of month end and so I don't want to do that unless I have
to.



Any advice would be greatly appreciated.



Thanks,



Edie Richardson

=======================To change your
subscription

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




can



[login to unmask email]

Re: need help asap
(in response to Tony Provenzola)
Is this a DB2/OS390 DB2 load, and did you use LOG YES? LOG YES will cause
a backout...