Trying to unload a table using ADUUMAIN utility

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?

Arun Raj · Posted: Thu Jun 11, 2009 5:36 pm

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

enrico-sorichetti · Posted: Fri Jun 12, 2009 12:32 pm

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

Anuj Dhawan · Posted: Fri Jun 12, 2009 2:20 pm

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

dick scherrer · Posted: Sat Jun 13, 2009 5:03 am

Hello,

Suggest you run DSNTIAUL and compare this run to the ADUUMAIN run.

What control info did you provide for the unload?

enrico-sorichetti · Posted: Sat Jun 13, 2009 12:03 pm

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