Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 2284
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: 10274
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: 10274
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 Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us