Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Trying to unload a table using ADUUMAIN utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Sandeep D. Patil

New User


Joined: 29 Jun 2008
Posts: 23
Location: mumbai

PostPosted: Thu Jun 11, 2009 4:20 pm    Post subject: Trying to unload a table using ADUUMAIN utility
Reply with quote

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
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2285
Location: @my desk

PostPosted: Thu Jun 11, 2009 5:36 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Sandeep D. Patil

New User


Joined: 29 Jun 2008
Posts: 23
Location: mumbai

PostPosted: Fri Jun 12, 2009 12:29 pm    Post subject:
Reply with quote

Number of row that are around 8000
and its taking around 60 CPU mins
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Fri Jun 12, 2009 12:32 pm    Post subject: Reply to: Trying to unload a table using ADUUMAIN utility
Reply with quote

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 icon_question.gif are You sure icon_rolleyes.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Jun 12, 2009 2:20 pm    Post subject:
Reply with quote

Quote:
and its taking around 60 CPU mins
How do you conclude that?
Back to top
View user's profile Send private message
Sandeep D. Patil

New User


Joined: 29 Jun 2008
Posts: 23
Location: mumbai

PostPosted: Fri Jun 12, 2009 2:27 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jun 13, 2009 5:03 am    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Sat Jun 13, 2009 12:03 pm    Post subject: Reply to: Trying to unload a table using ADUUMAIN utility
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us