need help asap - a few more questions

Edie Richardson

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


Colin Fay

Re: need help asap - a few more questions
(in response to Edie Richardson)
Hi Edie,

It may be something else going on.

Look in the MVS system log. Is the job waiting for anything else?
Perhaps a mount of a non-existent volume/pack. If Db2 is waiting on
MVS and it requires operator intervention for example, It just waits



Colin



Martin Wolff

Re: need help asap - a few more questions
(in response to Michael Murley)
Do a -DIS UTIL(*) and tell us what it says for your utility.

Martin Wolff,
Global Crossing.

[login to unmask email] wrote:

>
> 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]> To: "Edith W.
Sent by: DB2 Data Base Richardson"
Discussion List <[login to unmask email]>
<[login to unmask email]> cc:
Subject: Re: need help
01/04/01 11:10 AM asap
Please respond to DB2 Data
Base Discussion List

>
> 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
>
>



Michael Murley

Re: need help asap - a few more questions
(in response to Colin Fay)
A failed LOAD REPLACE LOG YES doesn't do a rollback in the traditional
sense. Instead, it deletes the rows in SYSLGRNX that represent the updates
from the load and then leaves the space in RECP status. Since the log
records from the load are not represented in SYSLGRNX, a subsequent recovery
does not find them, and the effect of the load is logically backed out.

It works this way because the deleted rows are not really logged; only the
reset of the data set. Since there is no old image of the row, the updates
can't really be backed out directly.

I think backout of a failed LOAD RESUME LOG YES probably works the same way,
but I'm not certain.

So, I don't know what's taking your job so long to end. Are there any
messages in ssidMSTR that might give a clue ?

Michael



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








Tony Provenzola

Re: need help asap - a few more questions
(in response to Martin Wolff)
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]








Basheer Shaik

need help asap - a few more questions
(in response to Tony Provenzola)
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
(in response to Basheer Shaik)
Assalam alaikum Basheer

Who said u r JAVA programmer.
go to http://[login to unmask email]/db2-l/ and proceed to

' Join or leave the DB2-L list Web page ' for requesting these ppl to
remove u from their list.


Eid Mubarak
And wish you happy and prosperous year 2001


Thx
Nayeem
DB2 DBA



Mohammed Nayeem

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

LOAD DATA LOG NO INDDN SYSREC00 REPLACE SORTKEYS
SORTDEVT SYSDA SORTNUM 4 INTO TABLE TABLE_XYZ
.........