View previous topic :: View next topic
|
Author |
Message |
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Kalyan,
The real problem is not with the JOIN. I would suggest you to go back to the JOIN as it offers more performance than the SPLICE you used above which involves multiple passes of data.
Quote: |
WER162B 0 PREALLOCATED SORTWORK TRACKS, 0 DYNAMICALLY ALLOCATED,
WER162B 0 ACQUIRED IN SECONDARY EXTENTS, 0 RELEASED, TOTAL OF 0 TRACKS USED
WER407I UNUSABLE SORTWORK DEVICE ALLOCATED, UNIT=VIO
WER046A SORT CAPACITY EXCEEDED |
You are tying to use an unusable UNIT parameter and you have ZERO tracks available for sorting. Correct this and try again. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I didn't solved the issue using sync sort.
So i used ICETOOL. |
Your system uses the Syncproducts, so that is what you will use. In your environment, ICETOOL actually invokes Synctool (*it is done with alias).
Suggest you make the modifications Arun posted and we can proceed from there if there are any problems/surprises. |
|
Back to top |
|
|
kalyan.v
New User
Joined: 04 Feb 2008 Posts: 65 Location: Hyd
|
|
|
|
Hi,
I solved the issue using syncsort.
Thanks to all for help.
Thanks,
Kalyan |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome - good to hear it is working
Thank you for letting us know,
d |
|
Back to top |
|
|
|