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
 

 

How to increase performance in parrallel unload

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

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Wed Apr 30, 2008 5:06 pm    Post subject: How to increase performance in parrallel unload
Reply with quote

A table has huge number of data. I want to unload it in a file.

In the table unload I am getting CPU time as 6 mins and Clock time 30 mins. To get better performance I planned to do parallel unload.

Select * from XXXXXXXX.YYYY

When I do parallel unload for all partitions in the tablespace CPU time is so high(~15 mins) and Clock time (3 mins) only.

TEMPLATE UNLDDS DSN &USERID..SMPLUNLD.&TS..T&PART.
UNIT SYSDA DISP (NEW,CATLG,CATLG) SPACE (5000,500) TRK
UNLOAD TABLESPACE DBXXXXX.TSMYYYY
UNLDDN UNLDDS
FROM TABLE XXXXXXX.YYYY

I want to improve its performance(by reducing both CPU and Clock). Please help me out in this.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Wed Apr 30, 2008 5:14 pm    Post subject: Reply to: How to increase performance in parrallel unload
Reply with quote

Quote:
Please help me out in this.


we cannot do it...
most of the time optimizing elapsed has negative effects on the CPU utilization

( parallelism, buffering, .... )
Back to top
View user's profile Send private message
kalaikala

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Wed Apr 30, 2008 5:18 pm    Post subject:
Reply with quote

So the table unload will be better than the tablespace unload. Because its performance is good in CPU and Clock time too.

Am i correct?.
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 BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Increase the screen size after split mistah kurtz TSO/ISPF 2 Fri Sep 02, 2016 6:39 pm


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