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
 

 

Size problem with DF/SORT V1R12 and DB2 V9

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Size problem with DF/SORT V1R12 and DB2 V9
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Tue Apr 03, 2012 10:21 pm    Post subject: Reply to: Size problem with DF/SORT V1R12 and DB2 V9
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 Moderator


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

PostPosted: Tue Apr 03, 2012 11:30 pm    Post subject:
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    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 How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm


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