Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

JOINKEYS Filling up SPOOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
vina2010

New User


Joined: 06 Sep 2010
Posts: 19
Location: Bangalore

PostPosted: Wed Aug 21, 2013 9:10 pm    Post subject: JOINKEYS Filling up SPOOL
Reply with quote

Hi All

We have been trying to run a JOINKEYS SORT Step for two files. But jobs are cancelled by operator saying it is occupying almost 100% SPOOL and they cancel it. They are not sure what is causing the SPOOL to fill from our job.

But when I looked into this spool below PARMS are listed in the spool

JESMSGLG
JESJCL
JESYSMSG
SYSPRINT
SYSOUT
JNF1JMSG
JNF2JMSG
CAIPRINT
ABENDAID
SORTSNAP

Only SORTSNAP is what I can see is increasing. is that causing the problem? How do I fix this? When I read about SORTSNAP in google it says its a dynamically allocated DD step from SORT and should not be specified. We have not specified it. Please help.

FILE2 has around 2 million records is that causing a problem.

JCL below

Code:

//S01SORT  EXEC PGM=SORT,COND=(8,LT)                         
//SORTJNF1 DD DSN=FILE1,DISP=SHR                             
//SORTJNF2 DD DSN=FILE2,DISP=SHR                             
//BOTH     DD DSN=OUTPUT,                                     
//            DISP=(,CATLG,DELETE),SPACE=(TRK,(75,30),RLSE), 
//            DCB=(RECFM=FB,LRECL=620)                       
//SORTOUT  DD  SYSOUT=*                                       
//SYSABEND DD  SYSOUT=A                                       
//SYSPRINT DD  SYSOUT=A                                       
//SYSUDUMP DD  SYSOUT=A                                       
//SYSOUT   DD  SYSOUT=A                                       
//SYSIN    DD  *                                             
  JOINKEYS FILE=F1,FIELDS=(1,7,A)                             
  JOINKEYS FILE=F2,FIELDS=(19,7,A)                           
  JOIN UNPAIRED,F1,F2                                         
  REFORMAT FIELDS=(F2:1,620,F1:1,7,?)                         
  OPTION COPY                                                 
  OUTFIL FNAMES=BOTH,INCLUDE=(628,1,CH,EQ,C'B'),             
  BUILD=(1,620)                                               
/*                                                           
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Wed Aug 21, 2013 9:33 pm    Post subject: Reply to: JOINKEYS Filling up SPOOL
Reply with quote

75 tracks primary space is not a lot for 2.5m 620-byte records.

Post these in full please, in the Code tags.
SYSOUT
JNF1JMSG
JNF2JMSG

And the first 20 of these
CAIPRINT
ABENDAID

First 10 and last 10 of this.
SORTSNAP

Why are you processing UNPAIRED,F1,F2, but have only one OUTFIL which only contains matched records?

Why include the F2 data in the REFORMAT if it is not used?

Do you have duplicate keys? Sounds like you might have a lot.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Thu Aug 22, 2013 11:41 pm    Post subject:
Reply with quote

Hello and welcome to the forum,

Suggest you change SORTOUT to a dataset . . .

The SORTOUT DD SYSOUT=* could fill the spool . . .

It will help when you provide the requested info.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7251

PostPosted: Thu Aug 22, 2013 11:51 pm    Post subject: Reply to: JOINKEYS Filling up SPOOL
Reply with quote

Good spot Dick.

With the SORTOUT DD and the OUTFIL, there are two copies of the data. One in the spool, and one fractured over however many packs.

Each record in the spool is going to take up five lines. That's a minimum of 12.5m. Some duplicates, and that goes way up.

Perhaps not noticed due to different class for the output?
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Joinkeys operation when key1 and key2... Susanta DFSORT/ICETOOL 5 Wed Nov 02, 2016 5:35 pm
No new posts Joinkeys operation betwen VB and FB file Susanta SYNCSORT 4 Sun Sep 25, 2016 9:49 pm
No new posts Joinkeys with duplicated keys juares castro SYNCSORT 19 Fri Sep 23, 2016 5:58 am
No new posts Icetool or Joinkeys example to compar... ishant chauhan DFSORT/ICETOOL 21 Sat Aug 20, 2016 2:40 am
No new posts JOINKEYs and Variable files migusd SYNCSORT 8 Fri Jun 17, 2016 3:16 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us