View previous topic :: View next topic
|
Author |
Message |
Sandeep D. Patil
New User
Joined: 29 Jun 2008 Posts: 23 Location: mumbai
|
|
|
|
Hi,
I am trying to unload a table using ADUUMAIN utility.
Its is taking a lots of CPU time. Could some one please help me on the various parameters that are used in the ADUUMAIN and also that ADUUMAIN/BMC Unload which one is more efficient?
Ia there any other utility by which I can unload a DB2 table in more faster way? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
ADUUMAIN/BMC Unload which one is more efficient? |
AFAIK, ADUUMAIN is nothing but the unload program provided by BMC.
How big is your table?
How many rows do you have in it?
How long your unload job is taking? |
|
Back to top |
|
|
Sandeep D. Patil
New User
Joined: 29 Jun 2008 Posts: 23 Location: mumbai
|
|
|
|
Number of row that are around 8000
and its taking around 60 CPU mins |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
what happens when You try to process with a less efficient utility
( DSNTIAUL for example )
8000 rows is an insignificant table size,
60 minutes of cpu time are You sure |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Quote: |
and its taking around 60 CPU mins |
How do you conclude that? |
|
Back to top |
|
|
Sandeep D. Patil
New User
Joined: 29 Jun 2008 Posts: 23 Location: mumbai
|
|
|
|
Hi,
SOrry for that Info.
Its acutally its unload 137 million records and taking 29 CPU mins and I have seens the msg log for the CPU timing |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you run DSNTIAUL and compare this run to the ADUUMAIN run.
What control info did you provide for the unload? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
such approach to performance evaluation is just plain wrong
You expressed Your feeling that 29 min of cpu time for 137 million rows is high
how does the measurement compare to other unloads ???
( different utility for the same table size, same utility for different table sizes)
usually these products are well tuned/written for best resource utilization,
but, as I said before, until You report some comparative result
anything being said or written will be just pure useless speculation |
|
Back to top |
|
|
|