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

can any one expalin me what is UTPRINT DD?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vardhan0007

New User


Joined: 05 Jun 2006
Posts: 51
Location: Bangalore,India

PostPosted: Fri Mar 09, 2007 4:50 pm
Reply with quote

Hi ,
Can anybody expalin me what is UTPRINT DD statement and what it will do?
and where i have to code it in JCL.

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

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Fri Mar 09, 2007 7:53 pm
Reply with quote

It is something to do with utilites. This comes into picture when the key words SORTDATA,SORTDEVT SYSDA,SORTNUM key words. These are a kind of performance things.

For ex SORTKEYS while during LAOD would eliminate the need of supplied SYSUTI & SORTOUT datasets. It saves lot of I/O since it passes the key thru buffer. In manual you can find the concepts of subtasks which will be processed parallely there by improving performance. You can assign all the subtasks to a single UTPINT or you can have separate for each subtasks. Basically it says which kind of SORT technology was used. I couldn't address this in detail sorry. I'm sure you can find a very good stuff on this in IBM manual.
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Sat Mar 10, 2007 12:08 am
Reply with quote

This contains messages from DFSORT. DFSORT is invoked internally by many DB2 utilities. You can code the DD like any other DD in JCL and provide an output file for it or direct it to sysout.
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Sat Mar 10, 2007 1:52 pm
Reply with quote

Exactly. The message would look some thing like this.

********************************* TOP OF DATA **********************************
ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED
ICE250I 0 VISIT www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 07:16 ON FRI MAR
SORT FIELDS=(00019.0,00002.0,A,00005.0,00007.0,A),FORMAT=BI,FILSZ=E000
00000002112,DYNALLOC=(SYSDA,04)
RECORD TYPE=V,LENGTH=(01124,01124,01124)
OPTION MSGPRT=ALL,MSGDDN=UTPRINT,AVGRLEN=01124,MAINSIZE=065536K
ICE201I 0 RECORD TYPE IS V - DATA STARTS IN POSITION 5
ICE751I 0 C5-K05352 C6-Q95214 C7-K90000 C8-K05352 E4-K06751 C9-BASE E5-K10929
ICE193I 0 ICEAM2 ENVIRONMENT IN EFFECT - ICEAM2 INSTALLATION MODULE SELECTED
ICE089I 6 REORGJOB.REORG1 .DSNUPROC, INPUT LRECL = 1124, TYPE = V
ICE092I 0 MAIN STORAGE = (67108864,67108864,67108864)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (67003420,67003420)
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,
ICE128I 0 OPTIONS: SIZE=67108864,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ER
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=
ICE130I 0 OPTIONS: RESALL=0,RESINV=0,SVC=109 ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,S
F1=HELP F2=SPLIT F3=END F4=RETURN F5=IFIND F6=BOOK
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 -> DB2

 


Search our Forums:

Back to Top