IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error Msg - INVALID DATA SET ATTRIBUTES: SORTOUT BLKSIZE


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srikanth_cts

New User


Joined: 27 Feb 2008
Posts: 25
Location: Phoenix, AZ,USA

PostPosted: Sat Sep 25, 2010 4:26 pm
Reply with quote

Hi Friends,
I am trying to do a join on 2 VB files and the output is an FB file. All the 3 files are of the same LRECL 133:

This is my sortcard:
Code:

JOINKEYS F1=IN1,FIELDS=(20,8,A),SORTED,NOSEQCK                 
JOINKEYS F2=IN2,FIELDS=(20,8,A),SORTED,NOSEQCK                 
REFORMAT FIELDS=(F1:7,23,F2:40,35)                             
OPTION COPY                                                   
OUTFIL FNAMES=OUT,VTOF,BUILD=(1:SEQNUM,2,ZD,3X,1,23,27,35,70X)


But I was not successful and I am getting the below error:
ICE043A 8 INVALID DATA SET ATTRIBUTES: SORTOUT BLKSIZE - REASON CODE IS 06

Code:

ICE143I 0 BLOCKSET     COPY  TECHNIQUE SELECTED                                 
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R10 - 12:50 ON SAT SE
           JOINKEYS F1=IN1,FIELDS=(20,8,A),SORTED,NOSEQCK                       
           JOINKEYS F2=IN2,FIELDS=(20,8,A),SORTED,NOSEQCK                       
           REFORMAT FIELDS=(F1:7,23,F2:40,35)                                   
           OPTION COPY                                                         
           OUTFIL FNAMES=OUT,VTOF,BUILD=(1:SEQNUM,2,ZD,3X,1,23,27,35,70X)       
ICE411I 0 THIS IS THE JOINKEYS MAIN TASK FOR JOINING F1 AND F2                 
ICE416I 0 JOINKEYS IS USING THE F1 SUBTASK FOR IN1      - SEE JNF1JMSG MESSAGES
ICE416I 1 JOINKEYS IS USING THE F2 SUBTASK FOR IN2      - SEE JNF2JMSG MESSAGES
ICE419I 0 JOINED RECORDS: TYPE=F, LENGTH=58                                     
ICE201I G RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE043A 8 INVALID DATA SET ATTRIBUTES: SORTOUT  BLKSIZE - REASON CODE IS 06     
ICE751I 0 C5-K51707 C6-K51707 C7-K51707 C8-K51707 E7-K51707                     
ICE052I 3 END OF DFSORT                                                         


Any thoughts on where I might have gone wrong.

Please help

Thanks
Srikanth
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Sat Sep 25, 2010 7:31 pm
Reply with quote

Quote:
Any thoughts on where I might have gone wrong.
Any thoughts on why you did not post the most critical data of all -- the JCL you used?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Sat Sep 25, 2010 10:51 pm
Reply with quote

Or read about the ICE043A message with a reason code 6. . .

Quote:
6. The record format is fixed length and the block
size is smaller than the record length or is not a
multiple of the record length. Example: The
reformatted fixed record length is 1200 from
OUTREC BUILD=(11,1200) and the SORTOUT data
set has BLKSIZE=25000.


Found here:
publibz.boulder.ibm.com/epubs/pdf/ice1cm50.pdf
Back to top
View user's profile Send private message
srikanth_cts

New User


Joined: 27 Feb 2008
Posts: 25
Location: Phoenix, AZ,USA

PostPosted: Mon Sep 27, 2010 12:37 pm
Reply with quote

Hi,
Welcome back after the weekend.

Here is the REXX code that I had used to to invoke the sort card:

Code:

ADDRESS TSO                                                             
"FREE FI(SYSIN)"                                                       
"ALLOC FI(SYSOUT) DA('"||SYSOUT3||"') NEW CATALOG",                     
" REUSE SPACE(2 1) CYLINDERS RECFM(V B) LRECL(133)"                     
"ALLOC FI(IN1) DA('"||SOUT1||"') SHR REUSE"                             
"ALLOC FI(IN2) DA('"||SOUT2||"') SHR REUSE"                             
"ALLOC FI(OUT) DA('"||SOUTF||"') NEW CATALOG",                         
" REUSE SPACE(2 1) CYLINDERS RECFM(F B A) LRECL(133)"                   
"ALLOC FI(SYSIN)   NEW TRACKS SPACE(3 3)   RECFM(F B) LRECL(80)"       
PUSH " OPTION COPY"                                                     
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " OUTFIL FNAMES=OUT,REMOVECC,"                                     
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " HEADER1=(2/,"                                                   
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " 2:'SI.#',10:'JOBNUMBER',23:'JOBNAME',47:'SEC',63:'MICRO SEC',/,"
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " 2:'-----',9:'----------',22:'--------',"                         
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " 46:'--------',62:'-------'),"                                   
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " TRAILER1=(1/,"                                                   
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " 20:'-----------------END OF REPORT-------------------')"         
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " JOINKEYS F1=IN1,FIELDS=(20,8,A),NOSEQCK"                         
"EXECIO 1 DISKW SYSIN"                                                 
PUSH " JOINKEYS F2=IN2,FIELDS=(20,8,A),NOSEQCK"             
"EXECIO 1 DISKW SYSIN"                                       
PUSH " REFORMAT FIELDS=(F1:7,26,F2:40,35)"                   
"EXECIO 1 DISKW SYSIN"                                       
PUSH " SORT FIELDS=(27,15,ZD,D,43,15,ZD,D)"                 
"EXECIO 1 DISKW SYSIN"                                       
PUSH " OUTREC BUILD=(5:SEQNUM,2,ZD,3X,1,26,27,35,63X)"       
"EXECIO 1 DISKW SYSIN   ( FINIS"                             
"CALL 'SYS1.SICELINK(SORT)'"                                 


Since it gave the that the error is in blksize I tried to explicitly give the blksize:

Code:

"ALLOC FI(OUT) DA('"||SOUTF||"') NEW CATALOG",                       
" REUSE SPACE(2 1) CYLINDERS RECFM(F B A) LRECL(133) BLKSIZE(13300)"


But still the same error is being displayed in the sysout that :

Code:

ICE043A 8 INVALID DATA SET ATTRIBUTES: SORTOUT  BLKSIZE - REASON CODE IS 06


Please help me figure out what I am missing..

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

Moderator Emeritus


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

PostPosted: Mon Sep 27, 2010 7:07 pm
Reply with quote

Hello,

Your "code" and your jcl do not match.

Also, for some reason, the lrecl chaged between posts. . .
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Mon Sep 27, 2010 11:41 pm
Reply with quote

Srikanth,

Something doesn't match up here.

You are using output attributes of FBA/133/13300, but you don't show an OUTFIL FTOV statement in your REXX code, so the output LRECL would be VB, not FB.

In the earlier job where you show the OUTFIL FTOV statement, you have 27,35 which is beyond the end of the 58 byte joined record.

So your two "jobs" aren't consistent and both have errors.

You need to show what you actually ran and the DFSORT messages you actually received before anyone can help you.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Store the data for fixed length COBOL Programming 1
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
Search our Forums:

Back to Top