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

Size problem with DF/SORT V1R12 and DB2 V9


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

New User


Joined: 08 Aug 2006
Posts: 10
Location: FRANCE

PostPosted: Tue Apr 03, 2012 9:47 pm
Reply with quote

Did someone experience a problem with the size when DB2 calling dfsort?
I have customized ICEAM2 with the parameters SIZE and TMAXLIM at 16777216. But at execution time the SIZE is t 6291456 and the TMAXLIM
in the same way.

Code:

ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE                               
ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 17:55 ON TUE APR 03, 2012 -                         
          SORT FIELDS=(00012.0,00011.0,A,00001.0,00005.0,A),FORMAT=BI,FILSZ=E0000*                                   
                         00000024927,DYNALLOC=(PUBL,24)                                                             
          RECORD TYPE=F,LENGTH=(0022,0022,0022)                                                                     
          OPTION MSGPRT=ALL,SORTDD=SW03,MSGDDN=UTPRIN03,MAINSIZE=MAX                                                 
ICE201I H RECORD TYPE IS F - DATA STARTS IN POSITION 1                                                               
ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E4-K58148 C9-BASE   E5-K72040 E6-K58148 E7-K70685                 
ICE193I 0 ICEAM2 INVOCATION ENVIRONMENT IN EFFECT - ICEAM2 ENVIRONMENT SELECTED                                     
ICE089I 1 LOADOCO .LOADCTR .DSNUPROC, INPUT LRECL = 22, TYPE = F                                                     
ICE093I 0 MAIN STORAGE = (MAX,6291456,6291456)                                                                       
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6591088,6191088)                                                               
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=256         
ICE128I 0 OPTIONS: SIZE=6291456,MAXLIM=1048576,MINLIM=400000,EQUALS=N,LIST=Y,ERET=ABEND,MSGDDN=UTPRIN03             
ICE129I 0 OPTIONS: VIO=N,RESDNT=NONE,SMF=NO   ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(PUBL    ,024),ABCODE=016 
ICE130I 0 OPTIONS: RESALL=200000,RESINV=200000,SVC=204 ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB1               
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=200000,ARESINV=200000,OVERRGN=16384,CINV=Y,CFW=Y,DSA=0                   
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE    ,EXITCK=S,PARMDDN=SORTPARM,FSZEST=Y       
ICE133I 0 OPTIONS: HIPRMAX=0      ,DSPSIZE=64  ,ODMAXBF=0,SOLRF=N,VLLONG=N,VSAMIO=N,MOSIZE=64                       
ICE235I 0 OPTIONS: NULLOUT=RC0                                                                                       
ICE236I 0 OPTIONS: DYNAPCT=OLD,MOWRK=Y                                                                               
ICE750I 0 DC 0 TC 0 CS DSVVV KSZ 16 VSZ 16
ICE752I 0 FSZ=24927 RE  IGN=0 C  AVG=24 0  WSP=778 E  DYN=0 0       
ICE751I 1 DE-K61787 D5-K58148 D9-K61787 E8-K70685                   
ICE091I 0 OUTPUT LRECL = 22, TYPE = F                               
ICE080I 0 IN MAIN STORAGE SORT                                     
ICE055I 0 INSERT 24431, DELETE 24431                               
ICE054I 0 RECORDS - IN: 0, OUT: 0                                   
ICE134I 0 NUMBER OF BYTES SORTED: 537482                           
ICE253I 0 RECORDS SORTED - PROCESSED: 24431, EXPECTED: 24927       
ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 0 , TRACKS USED: 0 
ICE199I 0 MEMORY OBJECT USED AS MAIN STORAGE = 0M BYTES             
ICE299I 0 MEMORY OBJECT USED AS WORK STORAGE = 0M BYTES             
ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES                       
ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES                       
ICE052I 0 END OF DFSORT                                                                                                                       
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Apr 03, 2012 10:21 pm
Reply with quote

do not post attachments, not everybody can see them.
attachment inlined with the code tags.
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: Tue Apr 03, 2012 11:30 pm
Reply with quote

DB2 Utilities has the ability to override various parameters when it calls DFSORT. That may be the case here. Alternatively, you might not have the INV (AM2) environment set up correctly. To find out for sure, you can run an ICETOOL COPY and check the SIZE/TMAXLIM values in DFSMSG (ICETOOL uses the INV environment) to see if the values are overridden in the non-DB2 utilities case.
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 Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top