Re: Two things "missing" from DFSORT in a "perfect world"?
I agree with you, John. And also a conversion for IP addresses as they are stored in SMF in hex format to something like xxx.xxx.xxx.xxx. On Jan 28, 2008 2:36 PM, McKown, John <[EMAIL PROTECTED]> wrote: > I am looking at all the new, nifty, stuff in DFSORT. Wow, it is becoming > a very powerful data manipulation tool. I'm getting to the point where I > think it might even be able to replace SAS (at least around here), if > only it had an easy way to convert SMF and RMF date/time stamps into > character strings (according to a conversion template?). > > -- > John McKown > Senior Systems Programmer > HealthMarkets > Keeping the Promise of Affordable Coverage > Administrative Services Group > Information Technology > > The information contained in this e-mail message may be privileged > and/or confidential. It is for intended addressee(s) only. If you are > not the intended recipient, you are hereby notified that any disclosure, > reproduction, distribution or other use of this communication is > strictly prohibited and could, in certain circumstances, be a criminal > offense. If you have received this e-mail in error, please notify the > sender by reply and delete this message without copying or disclosing > it. > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- "I am as you, in you, for you. One as you in all, as all, forever. My call is your call." -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things 'missing' from DFSORT in a 'perfect world'?
Already done about two mimutes ago. ;) On Mon Jan 28 12:12 , Frank Yaeger <[EMAIL PROTECTED]> sent: >Gary Green wrote on 01/28/2008 11:14:41 AM: >> Unless something came out within the past month or so, there are >> still some, to me, shortcoming with the new capabilities of DFSort; >> mainly in its symbol processing area. > >Gary, > >I would appreciate it if you would send me a note offline with details >of the shortcomings you see in DFSORT's capabilities, so I can >add them to the candidates list if appropriate. > >Thanks. > >Frank Yaeger - DFSORT Development Team (IBM) - [EMAIL PROTECTED] >Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration > > => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ > >-- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things 'missing' from DFSORT in a 'perfect world'?
Gary Green wrote on 01/28/2008 11:14:41 AM: > Unless something came out within the past month or so, there are > still some, to me, shortcoming with the new capabilities of DFSort; > mainly in its symbol processing area. Gary, I would appreciate it if you would send me a note offline with details of the shortcomings you see in DFSORT's capabilities, so I can add them to the candidates list if appropriate. Thanks. Frank Yaeger - DFSORT Development Team (IBM) - [EMAIL PROTECTED] Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things "missing" from DFSORT in a "perfect world"?
John McKown wrote on 01/28/2008 10:36:22 AM: > I am looking at all the new, nifty, stuff in DFSORT. Wow, it is becoming > a very powerful data manipulation tool. I'm getting to the point where I > think it might even be able to replace SAS (at least around here), if > only it had an easy way to convert SMF and RMF date/time stamps into > character strings (according to a conversion template?). Glad you like DFSORT. :-) As for date/time conversions, have you looked at what DFSORT's DTn, DCn, DEn, TMn, TCn and TEn formats? They can be used with BUILD and OVERLAY to convert various types of date/time stamps (SMF, TOD, ETOD) to edited displayable forms. I'm not sure it can do everything you want to do, but I believe it can do some of it. If you need something you can't do, feel free to send me a note offline with more details so I can add it to the candidate list. Frank Yaeger - DFSORT Development Team (IBM) - [EMAIL PROTECTED] Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things 'missing' from DFSORT in a 'perfect world'?
Instead of the usual, BTDT, allow m to just say, OMWT, "On My Way There". Last year I started writing "copybooks" of all SMF records so I can include them in my various SMF/DFSort reports using symbol names rather than the usual offsets, etc... I even use DFSort for daily SMF processing including splitting off DB2, CICS, etc.. and it even supports a 7-day SPIN file. Works great. I have not received permission to drop the SMFUTIL process yet, but that's coming. Unless something came out within the past month or so, there are still some, to me, shortcoming with the new capabilities of DFSort; mainly in its symbol processing area. On Mon Jan 28 12:36 , 'McKown, John' <[EMAIL PROTECTED]> sent: >I am looking at all the new, nifty, stuff in DFSORT. Wow, it is becoming >a very powerful data manipulation tool. I'm getting to the point where I >think it might even be able to replace SAS (at least around here), if >only it had an easy way to convert SMF and RMF date/time stamps into >character strings (according to a conversion template?). > >-- >John McKown >Senior Systems Programmer >HealthMarkets >Keeping the Promise of Affordable Coverage >Administrative Services Group >Information Technology > >The information contained in this e-mail message may be privileged >and/or confidential. It is for intended addressee(s) only. If you are >not the intended recipient, you are hereby notified that any disclosure, >reproduction, distribution or other use of this communication is >strictly prohibited and could, in certain circumstances, be a criminal >offense. If you have received this e-mail in error, please notify the >sender by reply and delete this message without copying or disclosing >it. > >-- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things "missing" from DFSORT in a "perfect world"?
Roberto Halais wrote on 01/28/2008 11:54:59 AM: > also a conversion for IP addresses as they are > stored in SMF in hex format to something like xxx.xxx.xxx.xxx. You can already convert 4-byte hex values for IP addresses to displayable values with DFSORT. For example if you had input records with the following hex values in positions 1-4: 1 2 3 4 <- position 05E21308 8520E301 you could use this DFSORT job to convert them to ddd.ddd.ddd.ddd values: //S1EXEC PGM=ICEMAN //SYSOUTDD SYSOUT=* //SORTIN DD DSN=... input file //SORTOUT DD SYSOUT=* //SYSINDD* OPTION COPY INREC BUILD=(1,1,BI,TO=ZD,C'.',2,1,BI,TO=ZD,C'.', 3,1,BI,TO=ZD,C'.',4,1,BI,TO=ZD) /* For the example input, SORTOUT would have: 005.226.019.008 133.032.227.001 Frank Yaeger - DFSORT Development Team (IBM) - [EMAIL PROTECTED] Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things 'missing' from DFSORT in a 'perfect world'?
On Jan 28, 2008, at 1:14 PM, Gary Green wrote: Instead of the usual, BTDT, allow m to just say, OMWT, "On My Way There". Last year I started writing "copybooks" of all SMF records so I can include them in my various SMF/DFSort reports using symbol names rather than the usual offsets, etc... I even use DFSort for daily SMF processing including splitting off DB2, CICS, etc.. and it even supports a 7-day SPIN file. Works great. I have not received permission to drop the SMFUTIL process yet, but that's coming. Unless something came out within the past month or so, there are still some, to me, shortcoming with the new capabilities of DFSort; mainly in its symbol processing area. Gary, Congratulations that is an intensive (and probably boring job). Are you using the assembler labels(in the corresponding macro's) for names? Have you found any "neato" ways to get the COBOL Copybooks to generate partial labels? (ie SMF04jobnme or close to?) The IBM Assembler macros have a nice feature built-in way of putting labels on fields. I think (from what I have read on here) that there is not an easy way to do this. This might be a nice addition to the CBTTAPE as well when you finish. Ed -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things "missing" from DFSORT in a "perfect world"?
Frank Yaeger wrote: > Roberto Halais wrote on 01/28/2008 11:54:59 AM: > > also a conversion for IP addresses as they are > > stored in SMF in hex format to something like xxx.xxx.xxx.xxx. > > You can already convert 4-byte hex values for IP addresses to displayable > values with DFSORT. For example if you had input records with the > following hex values in positions 1-4: > > 1 2 3 4 <- position > 05E21308 > 8520E301 > > you could use this DFSORT job to convert them to ddd.ddd.ddd.ddd values: > > //S1EXEC PGM=ICEMAN > //SYSOUTDD SYSOUT=* > //SORTIN DD DSN=... input file > //SORTOUT DD SYSOUT=* > //SYSINDD* > OPTION COPY > INREC BUILD=(1,1,BI,TO=ZD,C'.',2,1,BI,TO=ZD,C'.', >3,1,BI,TO=ZD,C'.',4,1,BI,TO=ZD) > /* > > For the example input, SORTOUT would have: > > 005.226.019.008 > 133.032.227.001 > > Frank Yaeger - DFSORT Development Team (IBM) - [EMAIL PROTECTED] > Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration BTW, the dotted decimal representation of 8520E301 is 133.32.227.1. 133.032.227.001 is 851AE301. Leading zeros means octal. Henry -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things "missing" from DFSORT in a "perfect world"?
You can use the "od" command to read/convert to several formats one file. ascii,octal,unsigned decimal, float, hexadecimal, etc. Paul Gilmartin <[EMAIL PROTECTED]> escribió: On Mon, 28 Jan 2008 14:20:48 -0800, Frank Yaeger wrote: > >For the example input, SORTOUT would have: > >005.226.019.008 >133.032.227.001 > Be very careful! I tried something similar with some TCP/IP UNIX command a while back; just to get the columns to line up vertically. Ouch! The command assumed, after venerable UNIX tradition, that any number beginning with a '0' is Base 8! Terrible convention. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html Luis Miguel Martinez Chavez IT Specialist DB2 ZOS/LUW Solaris/Linux/AIX - ¡Capacidad ilimitada de almacenamiento en tu correo! No te preocupes más por el espacio de tu cuenta con Correo Yahoo!: http://correo.yahoo.com.mx/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things "missing" from DFSORT in a "perfect world"?
On Mon, 28 Jan 2008 14:20:48 -0800, Frank Yaeger wrote: > >For the example input, SORTOUT would have: > >005.226.019.008 >133.032.227.001 > Be very careful! I tried something similar with some TCP/IP UNIX command a while back; just to get the columns to line up vertically. Ouch! The command assumed, after venerable UNIX tradition, that any number beginning with a '0' is Base 8! Terrible convention. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things "missing" from DFSORT in a "perfect world"?
Paul Gilmartin wrote: On Mon, 28 Jan 2008 14:20:48 -0800, Frank Yaeger wrote: For the example input, SORTOUT would have: 005.226.019.008 133.032.227.001 Be very careful! I tried something similar with some TCP/IP UNIX command a while back; just to get the columns to line up vertically. Ouch! The command assumed, after venerable UNIX tradition, that any number beginning with a '0' is Base 8! Terrible convention. -- gil Hold it right there, buster! :-) Ain't you the fellar that gets on IBM's case when they don't follow "venerable UNIX traditions", even if they are not in the standard? Which way do ya' wanna' go? Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things "missing" from DFSORT in a "perfect world"?
Frank, in your example you probably want to throw in SQZ to get rid of the leading zeroes in the dotted address you're generating. Eg 5.226.19.8 rather than 005.226.019.008 Cheers, Martin Martin Packer Performance Consultant IBM United Kingdom Ltd +44-20-8832-5167 +44-7802-245-584 [EMAIL PROTECTED] Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Two things "missing" from DFSORT in a "perfect world"?
Henry Willard wrote on 01/28/2008 05:32:45 PM: > BTW, the dotted decimal representation of 8520E301 is 133.32.227.1. > 133.032.227.001 is 851AE301. Leading zeros means octal. The original poster asked for ddd.ddd.ddd.ddd output so that's what I showed the DFSORT statements for. You can suppress the leading zeros using DFSORT's SQZ function as follows: OPTION COPY INREC IFTHEN=(WHEN=INIT, BUILD=(1:1,1,BI,EDIT=(IIT),5:2,1,BI,EDIT=(IIT), 9:3,1,BI,EDIT=(IIT),13:4,1,BI,EDIT=(IIT))), IFTHEN=(WHEN=INIT,BUILD=(1,15,SQZ=(SHIFT=LEFT,MID=C'.'))) The output for the example input I showed would then be: 5.226.19.8 133.32.227.1 Frank Yaeger - DFSORT Development Team (IBM) - [EMAIL PROTECTED] Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
