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
 
BMC Unload Plus

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: BMC Unload Plus
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Mon Nov 14, 2011 2:31 pm    Post subject: Reply to: BMC Unload Plus
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    Post subject: Reply to: BMC Unload Plus
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Mon Nov 14, 2011 3:16 pm    Post subject: Reply to: BMC Unload Plus
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    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 unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm
No new posts DXT unload utility - DVRE0000 mistah kurtz DB2 1 Thu Jul 07, 2016 4:56 pm

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