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
 

 

A DFSORT problem on allocating space

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

New User


Joined: 05 Aug 2011
Posts: 17
Location: China

PostPosted: Fri Aug 05, 2011 7:31 am    Post subject: A DFSORT problem on allocating space
Reply with quote

There is a problem on allocating space. My job use 40 SORTEK01-SORTWK40 with 'UNIT=(SYSDA,40),SPACE=(CYL,(800,800),RLSE)'. It run ok in the past years, but today, it failed with below errors.
Code:
IEC030I B37-04,IFG0554A,K5100294,STEP01,RULEWK02,885B,PRM025,0427041D,SYS11215.T
+ICE097I 2 K5100294.STEP01   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET 
IEC030I B37-04,IFG0554A,K5100294,STEP01,RULEWK01,8625,PRM015,0427041D,SYS11215.T
+ICE097I 2 K5100294.STEP01   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET 
IEC030I B37-04,IFG0554A,K5100294,STEP01,RULEWK04,866F,PRM061,0427041D,SYS11215.T
+ICE097I 2 K5100294.STEP01   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET 
IEC030I B37-04,IFG0554A,K5100294,STEP01,RULEWK02,885B,PRM025,0427041D,SYS11215.T
+ICE097I 2 K5100294.STEP01   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET 
IEC030I B37-04,IFG0554A,K5100294,STEP01,RULEWK01,8625,PRM015,0427041D,SYS11215.T
+ICE097I 2 K5100294.STEP01   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET 
IEC030I B37-04,IFG0554A,K5100294,STEP01,RULEWK04,866F,PRM061,0427041D,SYS11215.T
+ICE097I 2 K5100294.STEP01   SORT RECOVERING FROM B37 ABEND ON SORTWK DATA SET 
IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR  696           
DATA SET SYS11215.T104022.RA000.K5100294.R0462170                               
JOBNAME (K5100294) STEPNAME (STEP01  )                                         
PROGNAME (ICETOOL ) DDNAME (RULEWK02)                                           
REQUESTED SPACE QUANTITY = 4628043 KB                                           
STORCLAS (BASE) MGMTCLAS (        ) DATACLAS (        )                     
STORGRPS (LARGE9  )                                                         
IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR  697       
DATA SET SYS11215.T104023.RA000.K5100294.R0462171                           
JOBNAME (K5100294) STEPNAME (STEP01  )                                       
PROGNAME (ICETOOL ) DDNAME (RULEWK01)                                       
REQUESTED SPACE QUANTITY = 4628043 KB                                       
STORCLAS (BASE) MGMTCLAS (        ) DATACLAS (        )                     
STORGRPS (LARGE9  )                                                         
IGD17272I VOLUME SELECTION HAS FAILED FOR INSUFFICIENT SPACE FOR  698       
DATA SET SYS11215.T104024.RA000.K5100294.R0462172                           
JOBNAME (K5100294) STEPNAME (STEP01  )                                       
PROGNAME (ICETOOL ) DDNAME (RULEWK04)                                       
REQUESTED SPACE QUANTITY = 4628043 KB                                       
STORCLAS (BASE) MGMTCLAS (        ) DATACLAS (        )                     
STORGRPS (LARGE9  )     


I try many times to decrease the space until SPACE=(CYL,(100,100),RLSE), and decrease the number of SORTWK to 15. Job failed with error below.

Code:
0 SORT CAPACITY EXCEEDED - RECORD COUNT 31819814             
0 RECORDS SORTED - PROCESSED: 31819814, EXPECTED: 33404904     

But when I expended number of SORTWK to 16, the job abend with the same error with the earliest.

Can any one help me to analyze if it is a stroage problem? How can I ajust my JCL?
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7909
Location: Bellevue, IA

PostPosted: Fri Aug 05, 2011 7:51 am    Post subject:
Reply with quote

Diid you talk this problem over with your site storage management group? If not, what do you expect us to be able to say? The problem is very obviously related to your site and its storage management policies / procedures so only someone AT YOUR SITE will be able to help you.
Back to top
View user's profile Send private message
Judy85

New User


Joined: 05 Aug 2011
Posts: 17
Location: China

PostPosted: Fri Aug 05, 2011 8:06 am    Post subject: Reply to: A DFSORT problem on allocating space
Reply with quote

Thank you for your confirmation, I had raised the problem to storage team.
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: Fri Aug 05, 2011 9:32 am    Post subject:
Reply with quote

Hello and welcome to the forum,

As Robert mentioned, you need to work with your storage management people. It may be that there is not enough "work dasd" on the system, so you may need to consider alternative approaches.

One might be to split the input, sort the pieces and then merge them back together.

One might be to only sort the data needed for the "next" processing (rather than every byte in every record.

Something that may get useful replies is posting the actual jcl and sort control statements that were submitted (use the Code tag to improve readability).
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Fri Aug 05, 2011 12:58 pm    Post subject: Reply to: A DFSORT problem on allocating space
Reply with quote

red the manuals for the meaning of the messages received
talk/work with your storage support group in order to provide/make available the space needed !
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Fri Aug 05, 2011 2:44 pm    Post subject: Reply to: A DFSORT problem on allocating space
Reply with quote

This similar topic might provide some insight:

http://www.ibmmainframes.com/viewtopic.php?t=24296
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Fri Aug 05, 2011 7:40 pm    Post subject:
Reply with quote

Judy85,
Out of curiosity, could you please post the sort card(s) for the step you getting this abend for?

Thanks,
Back to top
View user's profile Send private message
Judy85

New User


Joined: 05 Aug 2011
Posts: 17
Location: China

PostPosted: Fri Aug 05, 2011 7:45 pm    Post subject: Reply to: A DFSORT problem on allocating space
Reply with quote

Code:
//SORTWK01 DD UNIT=(SYSDA,40),SPACE=(CYL,(800,800),RLSE)
//SORTWK02 DD UNIT=(SYSDA,40),SPACE=(CYL,(800,800),RLSE)
.
.
.
.
//SORTWK40 DD UNIT=(SYSDA,40),SPACE=(CYL,(800,800),RLSE)
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Fri Aug 05, 2011 7:51 pm    Post subject:
Reply with quote

Judy85,
Well if this was a response to my question, I asked for actual Sort card that is control card(s) with sort statements in it. Not the SORTWK files.

Thanks,
Back to top
View user's profile Send private message
Judy85

New User


Joined: 05 Aug 2011
Posts: 17
Location: China

PostPosted: Fri Aug 05, 2011 8:49 pm    Post subject: Reply to: A DFSORT problem on allocating space
Reply with quote

sqlcode1
Code:
//TOOLIN   DD *                                                     
  COPY FROM(INPUT) USING(DATA)                                       
  SELECT FROM(VALID) TO(FIRSTF) ON(12,10,CH) ON(145,7,CH) -         
                                            FIRST DISCARD(DUPS)     
  SORT FROM(FIRSTF) USING(RULE)                                     
//DATACNTL DD *                                                     
  OUTFIL FNAMES=VALID,INCLUDE=(1,2,CH,EQ,X'0000') => Data Only       
  OUTFIL FNAMES=DISCARDF,SAVE                     => Discarded Data 
//RULECNTL DD *                                                     
  SORT FIELDS=(12,10,A,145,7,A,56,4,A,62,7,A),FORMAT=CH             
  OUTFIL FNAMES=OK                 => Unique field is TRANDATE + ASN
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Fri Aug 05, 2011 10:01 pm    Post subject:
Reply with quote

Judy85,
Try DYNAMIC ALLOCATION of DFSort. You are sorting about 1.3+ GB of data ,so if you have 16 volumes with approximately 80 MB free space then DYNALLOC=(SYSDA,16) should work. So add below to your JCL as well. If 16 doesn't work, I would try with (SYSDA,32) as well. Keep in mind some shops, using DFSort installation options,ignore dynamic allocation if you have SORTWK files codes in your JCL. So remember to remove SORTWK statement from your JCL when you use DYNALLOC.
Code:
//DFSPARM  DD  *             
  OPTION DYNALLOC=(SYSDA,16)       
//                           


Also add SORTDIAG to your JCL and see how dynamic allocation is performed and utilized.
Code:
//SORTDIAG DD  DUMMY


If DFSort dynamic allocation doesn't work then,See if below mentioned modified version works. Since I don't know what your input LRECL is, I coded XXX to represent your input LRECL. Replace XXX and XXX+17,XXX-1 with appropriate numbers. I am assuming your input is FB.
Code:

OPTION EQUALS
INCLUDE COND=(1,2,CH,EQ,X'0000')
INREC IFTHEN=(WHEN=INIT,OVERLAY=(XXX:12,10,145,7)),
      IFTHEN=(WHEN=GROUP,KEYBEGIN=(XXX,17),PUSH=(XXX+17:SEQ=8))
SORT FIELDS=(12,10,A,145,7,A,56,4,A,62,7,A),FORMAT=CH
OUTFIL FNAMES=OK,INCLUDE=(XXX+17,ZD,EQ,1),BUILD=(1,XXX-1)
OUTFIL FNAMES=DUPS,SAVE,BUILD=(1,XXX-1)

If you really care for DISCARDF, write a separate step as below.
Code:
OPTION COPY
OMIT COND=(1,2,CH,EQ,X'0000')

Thanks,
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Aug 05, 2011 11:06 pm    Post subject:
Reply with quote

Code:

//SORTWK01 DD UNIT=(SYSDA,40),SPACE=(CYL,(800,800),RLSE)
//SORTWK02 DD UNIT=(SYSDA,40),SPACE=(CYL,(800,800),RLSE)
.
.
.
.
//SORTWK40 DD UNIT=(SYSDA,40),SPACE=(CYL,(800,800),RLSE)


You are trying to use multivolume work data set (SYSDA,40), but DFSORT only uses single volume work data sets. So instead of 40 volumes for each work data set, you're using one. If you want to use SORTWK DD statements instead of dynamic allocation, you will need to use enough single volume work data sets. The maximum number of SORTWK DD statements is 255.
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 Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm


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