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

BMC Unload Plus


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pramod prasad

New User


Joined: 20 May 2007
Posts: 6
Location: hyderabad

PostPosted: Mon Nov 14, 2011 2:24 pm
Reply with quote

Hi, I have one table having 9 partitions(based on account number range) and I need to unload them. I read in BMC unload plus document that we can unload all these partitions parallely to increase the unload performance.
I googled but didn't find any syntax for this.
Currently I have below syntax but wanted to modify it for parallel unload using BMC UNLOAD PLUS.
UNLOAD
DIRECT NO
SHRLEVEL CHANGE
UNLOADDN SYSREC
SELECT * from x.y where..

Please help me with the syntax.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Mon Nov 14, 2011 2:31 pm
Reply with quote

the full set of BMC manuals are available ONLY to licensed user
BMC has a stricter policy for manuals than IBM

You should search inside Your organization for the BMC manuals
where You will find the exact syntax for all the functions You might want to perform
Back to top
View user's profile Send private message
pramod prasad

New User


Joined: 20 May 2007
Posts: 6
Location: hyderabad

PostPosted: Mon Nov 14, 2011 3:09 pm
Reply with quote

Thanks enrico, I searched again and its working.
We need to use CURRENTDEGREE ANY when DIRECT NO is used to take advantage of parallelism.

It reduced elpased time from 4:30 Mins to 1:30 Mins
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Nov 14, 2011 3:16 pm
Reply with quote

Thanks for letting us know the resolution, it may help others.

Plan well what you are going to do with those three minutes, it would be a pity to blow them all at once :-)

Much more impressive to say "a 66% reduction in elapsed time". Although elapsed time is a fickle thing. On an empty machine, there is much less elapsing...
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 changing defaults in db2 admin - Unlo... DB2 0
No new posts DB2 Table - Image copy unload IBM Tools 2
Search our Forums:

Back to Top