IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to increase performance in parrallel unload


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Apr 30, 2008 5:14 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Increase the number of columns in the... IBM Tools 3
No new posts changing defaults in db2 admin - Unlo... DB2 0
Search our Forums:

Back to Top