View previous topic :: View next topic
|
Author |
Message |
pramod prasad
New User
Joined: 20 May 2007 Posts: 6 Location: hyderabad
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
pramod prasad
New User
Joined: 20 May 2007 Posts: 6 Location: hyderabad
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|