need help asap - a few more questions -Reply

Jeff Schade

need help asap - a few more questions -Reply
Simply follow the directions posted at the end of every message:




>>> [login to unmask email] 01/04/01 03:54pm >>>
Hi --

How to take out my e-mail address form this list. because i am getting lots
of mail. i am not a DB2 Admin.... i am a Java Programmer...


Thanks Much --

>From: "Provenzola, Tony" <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: need help asap - a few more questions
>Date: Thu, 4 Jan 2001 11:12:18 -0800
>
>We're still working in the dark here. Is the load LOG YES (it must be, but
>confirmation helps)? Is the load RESUME or REPLACE? You said, "hung up
>...
>for hours so I canceled the job and terminated the utility". I take that
>to
>mean that it ran for hours BEFORE you cancelled it. How long did it run
>before it was cancelled? How long has it been since? Does "hung up" mean
>that it was not processing or that it was just taking a long time to load?
>Was the row count increasing? How many rows were you trying to load? What
>was the row count when you cancelled it? If it was RESUME, how many rows
>were in it originally? Is the workload in your shop at this time such that
>recovering from hours of processing should need one log or many? DASD or
>TAPE?
>
>My guess for the reason you're not seeing any activity against your utility
>is that it's DB2 that processes the backout, not the program, so your
>xxxxMSTR is getting credit for the CPU. If it's asking for log tapes,
>that's one way you can gauge the process of the backout. If you dump the
>BSDS, you can get an idea of how many log files have been created since the
>job started.
>
>
>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 9:29 AM
>To: [login to unmask email]
>Subject: Re: need help asap - a few more questions
>
>
>
>I was assuming the same thing I just wanted some reassurance. I do have a
>few more questions though.
>1) is there any way I can tell if it is actually doing anything? I can't
>really tell if the whole thing is just hung or if it is really doing
>something. I do a dis on utility and database and don't really see
>anything
>but when I use db2 pm and display thread activity I see the following:
>
> Program
>Connection
>------- Elapsed -------
> Primauth Planname name ID
>Status
>Class 1 Class 2
> xxxxx PTDDP512 PTADRVAC DB2CALL APPL 14:13.9917
>0.046890
> xxxxx DSNUTIL N/P UTILITY EOT
>10:47:10.6 10:47:10.5
> xxxxx DSNUTIL N/P UTILITY EOT
>9:21:20.42 9:21:20.34
>
>When I look at the individual dsnutil plans the elasped time increases but
>the cpu time doesn't. Also, they have like 5 commits and 0 rollbacks.
>They
>just appear to be stuck. HELP!!!!
>
>2) if I really don't care about the data that was loaded into that table
>and can recreate it really quick, is there anyway I can force the utility
>to
>stop?
>
>Thanks all for the info so far!
>
>Edie
>
>
>
> "Vassie, Edward" <[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>
>
>
>
>01/04/01 11:10 AM
>Please respond to DB2 Data Base Discussion List
>
>
>
> To: "Edith W. Richardson" <[login to unmask email]>
> cc:
> Subject: Re: need help asap
>
>
>
>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]
>
>
>
>the
>
>
>
>
>
>
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com






Mohammed Nayeem

Re: need help asap - a few more questions -Reply
(in response to Jeff Schade)
SOUNDS bitter



Richard Mitchell

Re: need help asap - a few more questions
(in response to Mohammed Nayeem)



the From: Basheer Shaik Reply-To: DB2 Data Base Discussion List To: [login to unmask email] Subject: need help asap - a few more questions Date: Thu, 4 Jan 2001 20:54:31 -0000 MIME-Version: 1.0 X-Originating-IP: [63.44.43.127] Received: from [207.200.4.42] by hotmail.com (3.2) with ESMTP id MHotMailBC1E2E10006640042A10CFC8042A0A9B1; Thu Jan 04 12:54:44 2001 Received: from jupiter (www.ryci.com) by ryci.com (LSMTP for Windows NT v1.1b) with SMTP id <[login to unmask email]>; Thu, 4 Jan 2001 14:48:55 -0600 Received: from RYCI.COM by RYCI.COM (LISTSERV-TCP/IP release 1.8d) with spool id 112231 for [login to unmask email]; Thu, 4 Jan 2001 14:48:54 -0600 Received: from hotmail.com (f61.law11.hotmail.com) by ryci.com (LSMTP for Windows NT v1.1b) with SMTP id <[login to unmask email]>; Thu, 4 Jan 2001 14:48:54 -0600 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 4 Jan 2001 12:54:31 -0800 Received: from 63.44.43.127 by lw11fd.law11.hotmail.msn.com with HTTP; Thu, 04 Jan 2001 20:54:31 GMT From [login to unmask email] Thu Jan 04 12:55:35 2001 X-OriginalArrivalTime: 04 Jan 2001 20:54:31.0499 (UTC) FILETIME=[892A41B0:01C07690] Message-ID: Newsgroups: bit.listserv.db2-l Sender: DB2 Data Base Discussion List Hi -- How to take out my e-mail address form this list. because i am getting lots of mail. i am not a DB2 Admin.... i am a Java Programmer... Thanks Much -- >From: "Provenzola, Tony" >Reply-To: DB2 Data Base Discussion List >To: [login to unmask email] >Subject: Re: need help asap - a few more questions >Date: Thu, 4 Jan 2001 11:12:18 -0800 > >We're still working in the dark here. Is the load LOG YES (it must >be, but >confirmation helps)? Is the load RESUME or REPLACE? You said, >"hung up >... >for hours so I canceled the job and terminated the utility". I take >that >to >mean that it ran for hours BEFORE you cancelled it. How long did it >run >before it was cancelled? How long has it been since? Does "hung >up" mean >that it was not processing or that it was just taking a long time to >load? >Was the row count increasing? How many rows were you trying to >load? What >was the row count when you cancelled it? If it was RESUME, how many >rows >were in it originally? Is the workload in your shop at this time >such that >recovering from hours of processing should need one log or many? >DASD or >TAPE? > >My guess for the reason you're not seeing any activity against your >utility >is that it's DB2 that processes the backout, not the program, so >your >xxxxMSTR is getting credit for the CPU. If it's asking for log >tapes, >that's one way you can gauge the process of the backout. If you >dump the >BSDS, you can get an idea of how many log files have been created >since the >job started. > > >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 9:29 AM >To: [login to unmask email] >Subject: Re: need help asap - a few more questions > > > >I was assuming the same thing I just wanted some reassurance. I do >have a >few more questions though. >1) is there any way I can tell if it is actually doing anything? I >can't >really tell if the whole thing is just hung or if it is really doing >something. I do a dis on utility and database and don't really see >anything >but when I use db2 pm and display thread activity I see the >following: > > Program >Connection >------- Elapsed ------- > Primauth Planname name ID >Status >Class 1 Class 2 > xxxxx PTDDP512 PTADRVAC DB2CALL APPL >14:13.9917 >0.046890 > xxxxx DSNUTIL N/P UTILITY > EOT >10:47:10.6 10:47:10.5 > xxxxx DSNUTIL N/P UTILITY > EOT >9:21:20.42 9:21:20.34 > >When I look at the individual dsnutil plans the elasped time >increases but >the cpu time doesn't. Also, they have like 5 commits and 0 >rollbacks. >They >just appear to be stuck. HELP!!!! > >2) if I really don't care about the data that was loaded into that >table >and can recreate it really quick, is there anyway I can force the >utility >to >stop? > >Thanks all for the info so far! > >Edie > > > > "Vassie, Edward" >Sent by: DB2 Data Base Discussion List > > > > >01/04/01 11:10 AM >Please respond to DB2 Data Base Discussion List > > > > To: "Edith W. Richardson" > > cc: > Subject: Re: need help asap > > > >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 > >=======================To change your >subscription > >http://www.ryci.com/db2-l. The owners of the list can be reached at >[login to unmask email] > > > >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 > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com
Get your FREE download of MSN Explorer at http://explorer.msn.com

[login to unmask email]

Re: need help asap
(in response to Richard Mitchell)
Hi,

If you are on v6 you can see if it is using an archive tape to back out by
running a -DIS LOG command.

Jim.

-----Original Message-----
From: Billings, Linda [mailto:[login to unmask email]
Sent: 04 January 2001 16:20
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



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







***************************************************************
The contents of this Email and any files transmitted with it
are confidential and intended solely for the use of the
individual or entity to whom it is addressed. The views stated
herein do not necessarily represent the view of the company.
If you are not the intended recipient of this Email you may not
copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this mail in
error please Email the sender.
***************************************************************



Ron Davis

Re: need help asap
(in response to Jim.Leask@RS-COMPONENTS.COM)


Edie, has this been resolved? I would be interested in knowing what
hung your job up and how you guys finally resolved it.



-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, January 04, 2001 9: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]