Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Getting WER486A Error while joining 2 files using syncsort
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2482
Location: @my desk

PostPosted: Thu Dec 18, 2008 1:34 pm    Post subject:
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19254
Location: Inside the Matrix

PostPosted: Thu Dec 18, 2008 2:23 pm    Post subject:
Reply with quote

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
View user's profile Send private message
kalyan.v

New User


Joined: 04 Feb 2008
Posts: 65
Location: Hyd

PostPosted: Thu Dec 18, 2008 4:56 pm    Post subject:
Reply with quote

Hi,

I solved the issue using syncsort.

Thanks to all for help.

Thanks,
Kalyan
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19254
Location: Inside the Matrix

PostPosted: Thu Dec 18, 2008 10:18 pm    Post subject: Reply to: Getting WER486A Error while joining 2 files using
Reply with quote

You're welcome - good to hear it is working icon_smile.gif

Thank you for letting us know,

d
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 -> JCL & VSAM All times are GMT + 6 Hours
Goto page Previous  1, 2
Page 2 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Trying to submit COBOL PGM - JCL ERRO... sandeep prajapati JCL & VSAM 5 Tue Mar 24, 2020 11:21 pm
No new posts Error Creating KSDS file, REASON CODE... sandeep prajapati JCL & VSAM 8 Tue Mar 24, 2020 12:05 pm
No new posts Blue zone error with an invalid exten... anslaan CICS 3 Wed Feb 12, 2020 9:21 am
No new posts Accumulating fields using syncsort Hemant L SYNCSORT 6 Fri Feb 07, 2020 2:55 am
No new posts Substring for 2 files in Sort JCL Shubhendu Chakraborty DFSORT/ICETOOL 1 Wed Nov 20, 2019 11:07 am

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