Re: Forget: Sorting CSV data that begins with an IP address
No developer would be arrogant enough :-) to consider themselves faultless. And knowing Sri Hari as I do I doubt he'd want you to keep the solution to yourself. And we all learn by building on each others' solutions and ideas. Which is why *I* for one have been socialising my answers for almost 30 years. Others likewise and some even longer. However what we have here is a discussion that has little structure now. :-( Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com To: IBM-MAIN@listserv.ua.edu Date: 18/04/2014 00:40 Subject:Re: Forget: Sorting CSV data that begins with an IP address Sent by:IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Ok .. Just a thought though .. when I get a solution from a DFSORT developer himself, I can blindly believe that it will work; as long as I had made my requirements clear, which I had. But yes, I do see your point. - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gibney, Dave Sent: 17 April 2014 22:16 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Don't reply off list and deprive others from knowing the solution(s). Also, keeps the archives more useful. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 12:35 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Sorry Kolusu, thought I replied to your email off the list. Your solution works, thank you. And from cursory looks, and trial runs, it looks like other suggested solutions work too. So my or original problem has been solved, thanks to you guys. Now I'm just mulling about cutting the execution time. - Vignesh Mainframe admin On Apr 17, 2014 8:32:12 PM, Sri h Kolusu skol...@us.ibm.com wrote: Sankaranarayanan Vignesh You keep asking questions but never let us know the outcome of the proposed solutions. You started the topic for DFSORT about Sorting the csv file and a couple of solutions were provided to you. If the proposed solution did not work then may be should have shown us a sample and then may be we could have fixed that issue. Did you try out the solution posted by me earlier? If so what is the outcome of that? Did you get the desired results? Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 04/17/2014 12:26:17 PM: From: Sankaranarayanan, Vignesh Vignesh.V.Sankaranarayanan@MARKS- AND-SPENCER.COM To: IBM-MAIN@listserv.ua.edu, Date: 04/17/2014 12:26 PM Subject: Re: Forget: Sorting CSV data that begins with an IP address Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? - Vignesh Mainframe admin On Apr 17, 2014 8:16:45 PM, Farley, Peter x23353 peter.far...@broadridge.com wrote: TSO Rexx does not support multiple tasks executing simultaneously. The ATTACH* functions do attach a new task, but your attaching Rexx waits synchronously for the attached task to complete. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU ] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 2:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby
Re: Forget: Sorting CSV data that begins with an IP address
Vig , I have briefly looked at this thread , it sounds like your ‘almost pinging’ printers … Can you provide a bit more information ? Like these are IP ? Application owned ? Why manage from OMVS ( I have nothing against it ), curious why ? Regards, Scott From: Martin Packer Sent: Friday, April 18, 2014 5:37 AM To: IBM Mainframe Discussion List No developer would be arrogant enough :-) to consider themselves faultless. And knowing Sri Hari as I do I doubt he'd want you to keep the solution to yourself. And we all learn by building on each others' solutions and ideas. Which is why *I* for one have been socialising my answers for almost 30 years. Others likewise and some even longer. However what we have here is a discussion that has little structure now. :-( Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com To: IBM-MAIN@listserv.ua.edu Date: 18/04/2014 00:40 Subject:Re: Forget: Sorting CSV data that begins with an IP address Sent by:IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Ok .. Just a thought though .. when I get a solution from a DFSORT developer himself, I can blindly believe that it will work; as long as I had made my requirements clear, which I had. But yes, I do see your point. - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gibney, Dave Sent: 17 April 2014 22:16 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Don't reply off list and deprive others from knowing the solution(s). Also, keeps the archives more useful. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 12:35 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Sorry Kolusu, thought I replied to your email off the list. Your solution works, thank you. And from cursory looks, and trial runs, it looks like other suggested solutions work too. So my or original problem has been solved, thanks to you guys. Now I'm just mulling about cutting the execution time. - Vignesh Mainframe admin On Apr 17, 2014 8:32:12 PM, Sri h Kolusu skol...@us.ibm.com wrote: Sankaranarayanan Vignesh You keep asking questions but never let us know the outcome of the proposed solutions. You started the topic for DFSORT about Sorting the csv file and a couple of solutions were provided to you. If the proposed solution did not work then may be should have shown us a sample and then may be we could have fixed that issue. Did you try out the solution posted by me earlier? If so what is the outcome of that? Did you get the desired results? Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 04/17/2014 12:26:17 PM: From: Sankaranarayanan, Vignesh Vignesh.V.Sankaranarayanan@MARKS- AND-SPENCER.COM To: IBM-MAIN@listserv.ua.edu, Date: 04/17/2014 12:26 PM Subject: Re: Forget: Sorting CSV data that begins with an IP address Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? - Vignesh Mainframe admin On Apr 17, 2014 8:16:45 PM, Farley, Peter x23353 peter.far...@broadridge.com wrote: TSO Rexx does not support multiple tasks executing simultaneously. The ATTACH* functions do attach a new task, but your attaching Rexx waits synchronously for the attached task to complete. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU ] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 2:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging
FW: Forget: Sorting CSV data that begins with an IP address
First off.. apologies for prolonging this topic further. Hello Scott, Guess you're referring to The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Though this topic has been going on for a while, I'm not 100% sure that the purpose mail has came across. They are IP’s and the printing software is VPS. I’m considering moving the “ping” and “snmp get” to OMVS because I want to make the process concurrent, as opposed to doing the functions (tests) sequentially, one printer after another. We’re managing a few thousand printers via VPS, DRS, and VPSX and as the headings would explain, they belong to different places. Meaning, different naming conventions, different VLAN’s, different VPS groups, different VPS configurations. We used to maintain Spreadsheets for each location separately, but often, it would go out of date (not updated with modifications when they’re done). So I’m obtaining my VPS printer startup list (reading NetView global variables)and running health check (SNMP ping, getting status/MAC) on each item, and then populating the below CSV. The other columns come from NetView global variables which are pretty much constant, except when there’s a new warehouse or something. (The entire REXX runs under NetView to enable easy use of SNMP bits). The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Since there’s different VLAN’s for each location, I’m trying to get the data sorted so that when there’s a need for a new printer in any of the locations, I can just go to the bottom of that VLAN and pick an IP to assign to the printer. IP MAC Make-Model SEPINFO Type Ping Status Printer GRPNAME Warehouse # Warehouse Name Warehouse Terminal Warehouse Code Warehouse CICS 10.19.137.200 Unknown Unknown Not Defined Report NOT Ok Unknown R680 WHLIFFEY Partial data - SATO_CL412e SATO Barcode Ok Online PSHBDC0E WHKINGS The whole exercise is to make managing these printers easy and to have a fair indication of the status of the printers, available outisde the mainframe.” - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 16:32 To: IBM-MAIN@LISTSERV.UA.EDUmailto:IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig , I have briefly looked at this thread , it sounds like your ‘almost pinging’ printers … Can you provide a bit more information ? Like these are IP ? Application owned ? Why manage from OMVS ( I have nothing against it ), curious why ? Regards, Scott From: Martin Packer Sent: Friday, April 18, 2014 5:37 AM To: IBM Mainframe Discussion List No developer would be arrogant enough :-) to consider themselves faultless. And knowing Sri Hari as I do I doubt he'd want you to keep the solution to yourself. And we all learn by building on each others' solutions and ideas. Which is why *I* for one have been socialising my answers for almost 30 years. Others likewise and some even longer. However what we have here is a discussion that has little structure now. :-( Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.commailto:martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.commailto:vignesh.v.sankaranaraya...@marks-and-spencer.com To: IBM-MAIN@listserv.ua.edumailto:IBM-MAIN@listserv.ua.edu Date: 18/04/2014 00:40 Subject:Re: Forget: Sorting CSV data that begins with an IP address Sent by:IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edumailto:IBM-MAIN@listserv.ua.edu Ok .. Just a thought though .. when I get a solution from a DFSORT developer himself, I can blindly believe that it will work; as long as I had made my requirements clear, which I had. But yes, I do see your point. - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gibney, Dave Sent: 17 April 2014 22:16 To: IBM-MAIN@LISTSERV.UA.EDUmailto:IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Don't reply off list and deprive others from knowing
Re: Forget: Sorting CSV data that begins with an IP address
Vig, No apology necessary, I was in a similar situation with 2500 printers on JES2 using IBM's VPS product. We used Netview, the downside unless you put a lot of effort in design is the concurrency ..OMVS is better I agree, you need a daemon that runs doing the queries, etc. Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 12:14 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: First off.. apologies for prolonging this topic further. Hello Scott, Guess you're referring to The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Though this topic has been going on for a while, I'm not 100% sure that the purpose mail has came across. They are IP’s and the printing software is VPS. I’m considering moving the “ping” and “snmp get” to OMVS because I want to make the process concurrent, as opposed to doing the functions (tests) sequentially, one printer after another. We’re managing a few thousand printers via VPS, DRS, and VPSX and as the headings would explain, they belong to different places. Meaning, different naming conventions, different VLAN’s, different VPS groups, different VPS configurations. We used to maintain Spreadsheets for each location separately, but often, it would go out of date (not updated with modifications when they’re done). So I’m obtaining my VPS printer startup list (reading NetView global variables)and running health check (SNMP ping, getting status/MAC) on each item, and then populating the below CSV. The other columns come from NetView global variables which are pretty much constant, except when there’s a new warehouse or something. (The entire REXX runs under NetView to enable easy use of SNMP bits). The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Since there’s different VLAN’s for each location, I’m trying to get the data sorted so that when there’s a need for a new printer in any of the locations, I can just go to the bottom of that VLAN and pick an IP to assign to the printer. IP MAC Make-Model SEPINFO Type Ping Status Printer GRPNAME Warehouse # Warehouse Name Warehouse Terminal Warehouse Code Warehouse CICS 10.19.137.200 Unknown Unknown Not Defined Report NOT Ok Unknown R680 WHLIFFEY Partial data - SATO_CL412e SATO Barcode Ok Online PSHBDC0E WHKINGS The whole exercise is to make managing these printers easy and to have a fair indication of the status of the printers, available outisde the mainframe.” - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 16:32 To: IBM-MAIN@LISTSERV.UA.EDUmailto:IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig , I have briefly looked at this thread , it sounds like your ‘almost pinging’ printers … Can you provide a bit more information ? Like these are IP ? Application owned ? Why manage from OMVS ( I have nothing against it ), curious why ? Regards, Scott From: Martin Packer Sent: Friday, April 18, 2014 5:37 AM To: IBM Mainframe Discussion List No developer would be arrogant enough :-) to consider themselves faultless. And knowing Sri Hari as I do I doubt he'd want you to keep the solution to yourself. And we all learn by building on each others' solutions and ideas. Which is why *I* for one have been socialising my answers for almost 30 years. Others likewise and some even longer. However what we have here is a discussion that has little structure now. :-( Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.commailto:martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.commailto:vignesh.v.sankaranaraya...@marks-and-spencer.com To: IBM-MAIN@listserv.ua.edumailto:IBM-MAIN@listserv.ua.edu Date: 18/04/2014 00:40 Subject:Re: Forget: Sorting CSV data that begins with an IP address Sent by:IBM
Re: Forget: Sorting CSV data that begins with an IP address
Okay .. what was the solution you came to use, and could you please share some pointers on how to do the parts in OMVS. I know I am to use bpxwunix to issue commands and get the result back. Would like to know what I must read to get concurrency working. Currently, I am doing this in NetView but it takes 20 minutes to go through the entire lot of printers. I know I can do better :) - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 17:26 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig, No apology necessary, I was in a similar situation with 2500 printers on JES2 using IBM's VPS product. We used Netview, the downside unless you put a lot of effort in design is the concurrency ..OMVS is better I agree, you need a daemon that runs doing the queries, etc. Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 12:14 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: First off.. apologies for prolonging this topic further. Hello Scott, Guess you're referring to The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Though this topic has been going on for a while, I'm not 100% sure that the purpose mail has came across. They are IP’s and the printing software is VPS. I’m considering moving the “ping” and “snmp get” to OMVS because I want to make the process concurrent, as opposed to doing the functions (tests) sequentially, one printer after another. We’re managing a few thousand printers via VPS, DRS, and VPSX and as the headings would explain, they belong to different places. Meaning, different naming conventions, different VLAN’s, different VPS groups, different VPS configurations. We used to maintain Spreadsheets for each location separately, but often, it would go out of date (not updated with modifications when they’re done). So I’m obtaining my VPS printer startup list (reading NetView global variables)and running health check (SNMP ping, getting status/MAC) on each item, and then populating the below CSV. The other columns come from NetView global variables which are pretty much constant, except when there’s a new warehouse or something. (The entire REXX runs under NetView to enable easy use of SNMP bits). The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Since there’s different VLAN’s for each location, I’m trying to get the data sorted so that when there’s a need for a new printer in any of the locations, I can just go to the bottom of that VLAN and pick an IP to assign to the printer. IP MAC Make-Model SEPINFO Type Ping Status Printer GRPNAME Warehouse # Warehouse Name Warehouse Terminal Warehouse Code Warehouse CICS 10.19.137.200 Unknown Unknown Not Defined Report NOT Ok Unknown R680 WHLIFFEY Partial data - SATO_CL412e SATO Barcode Ok Online PSHBDC0E WHKINGS The whole exercise is to make managing these printers easy and to have a fair indication of the status of the printers, available outisde the mainframe.” - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 16:32 To: IBM-MAIN@LISTSERV.UA.EDUmailto:IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig , I have briefly looked at this thread , it sounds like your ‘almost pinging’ printers … Can you provide a bit more information ? Like these are IP ? Application owned ? Why manage from OMVS ( I have nothing against it ), curious why ? Regards, Scott From: Martin Packer Sent: Friday, April 18, 2014 5:37 AM To: IBM Mainframe Discussion List No developer would be arrogant enough :-) to consider themselves faultless. And knowing Sri Hari as I do I doubt he'd want you to keep the solution to yourself. And we all learn by building on each others' solutions and ideas. Which is why *I* for one have been socialising my answers for almost 30 years. Others likewise and some even longer. However what we have here is a discussion that has little structure now. :-( Cheers, Martin Martin Packer
Re: Forget: Sorting CSV data that begins with an IP address
Vig, Your case if you could read the VPS control file with the printer names/IP addresses/host names would be a starting point. They have the daemon store the names and query and turn a flag on indicating there or not or up / down and either a report or a file. You could also query defined running printers at the same time and come up with a delta list from the base giving you all new printers. Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 12:33 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: Okay .. what was the solution you came to use, and could you please share some pointers on how to do the parts in OMVS. I know I am to use bpxwunix to issue commands and get the result back. Would like to know what I must read to get concurrency working. Currently, I am doing this in NetView but it takes 20 minutes to go through the entire lot of printers. I know I can do better :) - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 17:26 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig, No apology necessary, I was in a similar situation with 2500 printers on JES2 using IBM's VPS product. We used Netview, the downside unless you put a lot of effort in design is the concurrency ..OMVS is better I agree, you need a daemon that runs doing the queries, etc. Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 12:14 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: First off.. apologies for prolonging this topic further. Hello Scott, Guess you're referring to The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Though this topic has been going on for a while, I'm not 100% sure that the purpose mail has came across. They are IP’s and the printing software is VPS. I’m considering moving the “ping” and “snmp get” to OMVS because I want to make the process concurrent, as opposed to doing the functions (tests) sequentially, one printer after another. We’re managing a few thousand printers via VPS, DRS, and VPSX and as the headings would explain, they belong to different places. Meaning, different naming conventions, different VLAN’s, different VPS groups, different VPS configurations. We used to maintain Spreadsheets for each location separately, but often, it would go out of date (not updated with modifications when they’re done). So I’m obtaining my VPS printer startup list (reading NetView global variables)and running health check (SNMP ping, getting status/MAC) on each item, and then populating the below CSV. The other columns come from NetView global variables which are pretty much constant, except when there’s a new warehouse or something. (The entire REXX runs under NetView to enable easy use of SNMP bits). The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Since there’s different VLAN’s for each location, I’m trying to get the data sorted so that when there’s a need for a new printer in any of the locations, I can just go to the bottom of that VLAN and pick an IP to assign to the printer. IP MAC Make-Model SEPINFO Type Ping Status Printer GRPNAME Warehouse # Warehouse Name Warehouse Terminal Warehouse Code Warehouse CICS 10.19.137.200 Unknown Unknown Not Defined Report NOT Ok Unknown R680 WHLIFFEY Partial data - SATO_CL412e SATO Barcode Ok Online PSHBDC0E WHKINGS The whole exercise is to make managing these printers easy and to have a fair indication of the status of the printers, available outisde the mainframe.” - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 16:32 To: IBM-MAIN@LISTSERV.UA.EDUmailto:IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig , I have briefly looked at this thread , it sounds like your ‘almost pinging’ printers … Can you provide a bit more information ? Like these are IP ? Application owned ? Why manage from OMVS ( I have nothing against it ), curious why ? Regards, Scott From: Martin Packer Sent
Re: Forget: Sorting CSV data that begins with an IP address
Scott, That's what I've done now. I read the control file for each printer to get the IP, VPS GRPNAME, and based on the printer name (PSTBGC43 = P - printer, ST - warehouse code, B - barcode, GC43 - CICS ID), I pull other parameters from NetView global variables. Any simple examples for implementing the daemon, please? - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 19:41 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig, Your case if you could read the VPS control file with the printer names/IP addresses/host names would be a starting point. They have the daemon store the names and query and turn a flag on indicating there or not or up / down and either a report or a file. You could also query defined running printers at the same time and come up with a delta list from the base giving you all new printers. Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 12:33 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: Okay .. what was the solution you came to use, and could you please share some pointers on how to do the parts in OMVS. I know I am to use bpxwunix to issue commands and get the result back. Would like to know what I must read to get concurrency working. Currently, I am doing this in NetView but it takes 20 minutes to go through the entire lot of printers. I know I can do better :) - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 17:26 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig, No apology necessary, I was in a similar situation with 2500 printers on JES2 using IBM's VPS product. We used Netview, the downside unless you put a lot of effort in design is the concurrency ..OMVS is better I agree, you need a daemon that runs doing the queries, etc. Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 12:14 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: First off.. apologies for prolonging this topic further. Hello Scott, Guess you're referring to The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Though this topic has been going on for a while, I'm not 100% sure that the purpose mail has came across. They are IP’s and the printing software is VPS. I’m considering moving the “ping” and “snmp get” to OMVS because I want to make the process concurrent, as opposed to doing the functions (tests) sequentially, one printer after another. We’re managing a few thousand printers via VPS, DRS, and VPSX and as the headings would explain, they belong to different places. Meaning, different naming conventions, different VLAN’s, different VPS groups, different VPS configurations. We used to maintain Spreadsheets for each location separately, but often, it would go out of date (not updated with modifications when they’re done). So I’m obtaining my VPS printer startup list (reading NetView global variables)and running health check (SNMP ping, getting status/MAC) on each item, and then populating the below CSV. The other columns come from NetView global variables which are pretty much constant, except when there’s a new warehouse or something. (The entire REXX runs under NetView to enable easy use of SNMP bits). The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Since there’s different VLAN’s for each location, I’m trying to get the data sorted so that when there’s a need for a new printer in any of the locations, I can just go to the bottom of that VLAN and pick an IP to assign to the printer. IP MAC Make-Model SEPINFO Type Ping Status Printer GRPNAME Warehouse # Warehouse Name Warehouse Terminal Warehouse Code Warehouse CICS 10.19.137.200 Unknown Unknown Not Defined Report NOT Ok Unknown R680 WHLIFFEY Partial data - SATO_CL412e SATO Barcode Ok Online PSHBDC0E WHKINGS The whole exercise is to make managing these printers easy and to have a fair indication of the status of the printers, available outisde the mainframe.” - Vignesh Mainframe Admin -Original Message- From
Re: Forget: Sorting CSV data that begins with an IP address
Vig, Have you looked at Open Object RExx, it has a socket server piece, contact me offline... Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 2:54 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: Scott, That's what I've done now. I read the control file for each printer to get the IP, VPS GRPNAME, and based on the printer name (PSTBGC43 = P - printer, ST - warehouse code, B - barcode, GC43 - CICS ID), I pull other parameters from NetView global variables. Any simple examples for implementing the daemon, please? - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 19:41 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig, Your case if you could read the VPS control file with the printer names/IP addresses/host names would be a starting point. They have the daemon store the names and query and turn a flag on indicating there or not or up / down and either a report or a file. You could also query defined running printers at the same time and come up with a delta list from the base giving you all new printers. Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 12:33 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: Okay .. what was the solution you came to use, and could you please share some pointers on how to do the parts in OMVS. I know I am to use bpxwunix to issue commands and get the result back. Would like to know what I must read to get concurrency working. Currently, I am doing this in NetView but it takes 20 minutes to go through the entire lot of printers. I know I can do better :) - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Ford Sent: 18 April 2014 17:26 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Vig, No apology necessary, I was in a similar situation with 2500 printers on JES2 using IBM's VPS product. We used Netview, the downside unless you put a lot of effort in design is the concurrency ..OMVS is better I agree, you need a daemon that runs doing the queries, etc. Scott ford www.identityforge.com from my IPAD On Apr 18, 2014, at 12:14 PM, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: First off.. apologies for prolonging this topic further. Hello Scott, Guess you're referring to The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Though this topic has been going on for a while, I'm not 100% sure that the purpose mail has came across. They are IP’s and the printing software is VPS. I’m considering moving the “ping” and “snmp get” to OMVS because I want to make the process concurrent, as opposed to doing the functions (tests) sequentially, one printer after another. We’re managing a few thousand printers via VPS, DRS, and VPSX and as the headings would explain, they belong to different places. Meaning, different naming conventions, different VLAN’s, different VPS groups, different VPS configurations. We used to maintain Spreadsheets for each location separately, but often, it would go out of date (not updated with modifications when they’re done). So I’m obtaining my VPS printer startup list (reading NetView global variables)and running health check (SNMP ping, getting status/MAC) on each item, and then populating the below CSV. The other columns come from NetView global variables which are pretty much constant, except when there’s a new warehouse or something. (The entire REXX runs under NetView to enable easy use of SNMP bits). The whole process takes about 20 minutes, and I’m trying to cut down functions wherever possible (such as – I don’t have to SNMP for printer data when I know I can’t ping it). Since there’s different VLAN’s for each location, I’m trying to get the data sorted so that when there’s a need for a new printer in any of the locations, I can just go to the bottom of that VLAN and pick an IP to assign to the printer. IP MAC Make-Model SEPINFO Type Ping Status Printer GRPNAME Warehouse # Warehouse Name Warehouse Terminal Warehouse Code Warehouse CICS 10.19.137.200 Unknown Unknown Not Defined Report NOT Ok Unknown R680 WHLIFFEY Partial data - SATO_CL412e SATO Barcode Ok Online
Re: Forget: Sorting CSV data that begins with an IP address
Paul Gilmartin wrote: On Wed, 16 Apr 2014 16:47:47 +, Sankaranarayanan, Vignesh wrote: Sankaranarayanan, Vignesh would like to recall the message, Sorting CSV data that begins with an IP address. Paul Gilmartin would like to forget the message, Sorting CSV data that begins with an IP address. Absolutely UNFORGETABLE and priceless. ;-) Oh, if you use the IBM-MAIN's web server, you will quickly see all and every posts including those recall and OOO posts are listed and frozen solid in the archives. Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. - Vignesh Mainframe admin On Apr 17, 2014 7:52:11 AM, Elardus Engelbrecht elardus.engelbre...@sita.co.za wrote: Paul Gilmartin wrote: On Wed, 16 Apr 2014 16:47:47 +, Sankaranarayanan, Vignesh wrote: Sankaranarayanan, Vignesh would like to recall the message, Sorting CSV data that begins with an IP address. Paul Gilmartin would like to forget the message, Sorting CSV data that begins with an IP address. Absolutely UNFORGETABLE and priceless. ;-) Oh, if you use the IBM-MAIN's web server, you will quickly see all and every posts including those recall and OOO posts are listed and frozen solid in the archives. Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
TSO Rexx does not support multiple tasks executing simultaneously. The ATTACH* functions do attach a new task, but your attaching Rexx waits synchronously for the attached task to complete. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 2:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? - Vignesh Mainframe admin On Apr 17, 2014 8:16:45 PM, Farley, Peter x23353 peter.far...@broadridge.com wrote: TSO Rexx does not support multiple tasks executing simultaneously. The ATTACH* functions do attach a new task, but your attaching Rexx waits synchronously for the attached task to complete. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 2:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
Sankaranarayanan Vignesh You keep asking questions but never let us know the outcome of the proposed solutions. You started the topic for DFSORT about Sorting the csv file and a couple of solutions were provided to you. If the proposed solution did not work then may be should have shown us a sample and then may be we could have fixed that issue. Did you try out the solution posted by me earlier? If so what is the outcome of that? Did you get the desired results? Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 04/17/2014 12:26:17 PM: From: Sankaranarayanan, Vignesh Vignesh.V.Sankaranarayanan@MARKS- AND-SPENCER.COM To: IBM-MAIN@listserv.ua.edu, Date: 04/17/2014 12:26 PM Subject: Re: Forget: Sorting CSV data that begins with an IP address Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? - Vignesh Mainframe admin On Apr 17, 2014 8:16:45 PM, Farley, Peter x23353 peter.far...@broadridge.com wrote: TSO Rexx does not support multiple tasks executing simultaneously. The ATTACH* functions do attach a new task, but your attaching Rexx waits synchronously for the attached task to complete. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU ] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 2:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
Sorry Kolusu, thought I replied to your email off the list. Your solution works, thank you. And from cursory looks, and trial runs, it looks like other suggested solutions work too. So my or original problem has been solved, thanks to you guys. Now I'm just mulling about cutting the execution time. - Vignesh Mainframe admin On Apr 17, 2014 8:32:12 PM, Sri h Kolusu skol...@us.ibm.com wrote: Sankaranarayanan Vignesh You keep asking questions but never let us know the outcome of the proposed solutions. You started the topic for DFSORT about Sorting the csv file and a couple of solutions were provided to you. If the proposed solution did not work then may be should have shown us a sample and then may be we could have fixed that issue. Did you try out the solution posted by me earlier? If so what is the outcome of that? Did you get the desired results? Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 04/17/2014 12:26:17 PM: From: Sankaranarayanan, Vignesh Vignesh.V.Sankaranarayanan@MARKS- AND-SPENCER.COM To: IBM-MAIN@listserv.ua.edu, Date: 04/17/2014 12:26 PM Subject: Re: Forget: Sorting CSV data that begins with an IP address Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? - Vignesh Mainframe admin On Apr 17, 2014 8:16:45 PM, Farley, Peter x23353 peter.far...@broadridge.com wrote: TSO Rexx does not support multiple tasks executing simultaneously. The ATTACH* functions do attach a new task, but your attaching Rexx waits synchronously for the attached task to complete. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU ] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 2:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
On Thu, 17 Apr 2014 19:26:17 +, Sankaranarayanan, Vignesh wrote: Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? Submit batch jobs (PGM=IKJEFT01,PARM='%rxsub?? p1 p2 p3) from the main? Norbert Friemel -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
Hmm. Interesting ... If I adopted this approach, then I would have to write to separate files and then use DFSORT to get it all back together, sorted. - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Norbert Friemel Sent: 17 April 2014 23:41 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address On Thu, 17 Apr 2014 19:26:17 +, Sankaranarayanan, Vignesh wrote: Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? Submit batch jobs (PGM=IKJEFT01,PARM='%rxsub?? p1 p2 p3) from the main? Norbert Friemel -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
The other fork in the road(Slawson cutoff) is what's the purpose? Most printer vendors have monitors available or downloadable. For availability whats_up _www.ipswitch.com_ (http://www.ipswitch.com) is pretty flexible. In a message dated 4/17/2014 2:32:16 P.M. Central Daylight Time, skol...@us.ibm.com writes: may be we could have fixed that issue. Did you try out the solution posted by me earlier? If so what is the outcome of that? Did you get the desired results? Thanks, -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
On 17 April 2014 14:58, Sankaranarayanan, Vignesh vignesh.v.sankaranaraya...@marks-and-spencer.com wrote: I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. When you say NetView ping, SNMP walk, etc, are these canned programs you have to run, or functions you have written in your REXX using the sockets interface? I assume the former, but if the latter, the REXX sockets API does support nonblocking mode, so in theory you could have multiple connections on the go at once without multitasking/threading. Tony H. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
Don't reply off list and deprive others from knowing the solution(s). Also, keeps the archives more useful. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 12:35 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Sorry Kolusu, thought I replied to your email off the list. Your solution works, thank you. And from cursory looks, and trial runs, it looks like other suggested solutions work too. So my or original problem has been solved, thanks to you guys. Now I'm just mulling about cutting the execution time. - Vignesh Mainframe admin On Apr 17, 2014 8:32:12 PM, Sri h Kolusu skol...@us.ibm.com wrote: Sankaranarayanan Vignesh You keep asking questions but never let us know the outcome of the proposed solutions. You started the topic for DFSORT about Sorting the csv file and a couple of solutions were provided to you. If the proposed solution did not work then may be should have shown us a sample and then may be we could have fixed that issue. Did you try out the solution posted by me earlier? If so what is the outcome of that? Did you get the desired results? Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 04/17/2014 12:26:17 PM: From: Sankaranarayanan, Vignesh Vignesh.V.Sankaranarayanan@MARKS- AND-SPENCER.COM To: IBM-MAIN@listserv.ua.edu, Date: 04/17/2014 12:26 PM Subject: Re: Forget: Sorting CSV data that begins with an IP address Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? - Vignesh Mainframe admin On Apr 17, 2014 8:16:45 PM, Farley, Peter x23353 peter.far...@broadridge.com wrote: TSO Rexx does not support multiple tasks executing simultaneously. The ATTACH* functions do attach a new task, but your attaching Rexx waits synchronously for the attached task to complete. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU ] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 2:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message
Re: Forget: Sorting CSV data that begins with an IP address
Ok .. Just a thought though .. when I get a solution from a DFSORT developer himself, I can blindly believe that it will work; as long as I had made my requirements clear, which I had. But yes, I do see your point. - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Gibney, Dave Sent: 17 April 2014 22:16 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Don't reply off list and deprive others from knowing the solution(s). Also, keeps the archives more useful. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 12:35 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Sorry Kolusu, thought I replied to your email off the list. Your solution works, thank you. And from cursory looks, and trial runs, it looks like other suggested solutions work too. So my or original problem has been solved, thanks to you guys. Now I'm just mulling about cutting the execution time. - Vignesh Mainframe admin On Apr 17, 2014 8:32:12 PM, Sri h Kolusu skol...@us.ibm.com wrote: Sankaranarayanan Vignesh You keep asking questions but never let us know the outcome of the proposed solutions. You started the topic for DFSORT about Sorting the csv file and a couple of solutions were provided to you. If the proposed solution did not work then may be should have shown us a sample and then may be we could have fixed that issue. Did you try out the solution posted by me earlier? If so what is the outcome of that? Did you get the desired results? Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 04/17/2014 12:26:17 PM: From: Sankaranarayanan, Vignesh Vignesh.V.Sankaranarayanan@MARKS- AND-SPENCER.COM To: IBM-MAIN@listserv.ua.edu, Date: 04/17/2014 12:26 PM Subject: Re: Forget: Sorting CSV data that begins with an IP address Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Ok.. Is it possible to fire off other REXXes repetitively (let's say 2 or 3, each doing one function) that will not RETURN to the main, but write their output to a dataset once done? - Vignesh Mainframe admin On Apr 17, 2014 8:16:45 PM, Farley, Peter x23353 peter.far...@broadridge.com wrote: TSO Rexx does not support multiple tasks executing simultaneously. The ATTACH* functions do attach a new task, but your attaching Rexx waits synchronously for the attached task to complete. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU ] On Behalf Of Sankaranarayanan, Vignesh Sent: Thursday, April 17, 2014 2:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address Another question. I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP walk, etc) sequentially. They don't necessarily need to be sequential. I'm just going through a list of printers and I want to test them. So.. Is it possible that I make the first run a data run - reading parameters from files for each printer (reading PDS member) - and the second run as a thread creator of sorts. Each thread going off to test one printer. The first run should be almost instantaneous. My thinking is.. Is it possible to parallelly do the pinging and SNMP connection bits. It would cut 20 minutes runtime to just a couple. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose
Re: Forget: Sorting CSV data that begins with an IP address
This is my ping -
tcphost is a variable that has the IP address.
IF CNMEPING('-q' tcphost) THEN
ping_ok = 1
ELSE
ping_ok = 0
And my apologies, they're SNMP GET's, not walk.
'PIPE NETV snmp get -Os -c public -h 'tcphost ifPhysAddress.1,
'| VAR macaddr'
'PIPE NETV snmp get -Os -c public -h 'tcphost gdStatusId.0,
'| VAR printid'
'PIPE NETV snmp get -Os -c public -h 'tcphost gdStatusInitialize.0,
'| VAR status'
- Vignesh
Mainframe Admin
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Tony Harminc
Sent: 18 April 2014 00:24
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Forget: Sorting CSV data that begins with an IP address
On 17 April 2014 14:58, Sankaranarayanan, Vignesh
vignesh.v.sankaranaraya...@marks-and-spencer.com wrote:
I'm looping some 5000 times in REXX and doing functions (NetView ping, SNMP
walk, etc) sequentially. They don't necessarily need to be sequential. I'm
just going through a list of printers and I want to test them.
So.. Is it possible that I make the first run a data run - reading parameters
from files for each printer (reading PDS member) - and the second run as a
thread creator of sorts. Each thread going off to test one printer.
The first run should be almost instantaneous. My thinking is.. Is it possible
to parallelly do the pinging and SNMP connection bits. It would cut 20
minutes runtime to just a couple.
When you say NetView ping, SNMP walk, etc, are these canned programs you have
to run, or functions you have written in your REXX using the sockets interface?
I assume the former, but if the latter, the REXX sockets API does support
nonblocking mode, so in theory you could have multiple connections on the go at
once without multitasking/threading.
Tony H.
--
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
MARKSANDSPENCER.COM
Unless otherwise stated above:
Marks and Spencer plc
Registered Office:
Waterside House
35 North Wharf Road
London
W2 1NW
Registered No. 214436 in England and Wales.
Telephone (020) 7935 4422
Facsimile (020) 7487 2670
www.marksandspencer.com
Please note that electronic mail may be monitored.
This e-mail is confidential. If you received it by mistake, please let us know
and then delete it from your system; you should not copy, disclose, or
distribute its contents to anyone nor act in reliance on this e-mail, as this
is prohibited and may be unlawful.
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
Thanks Ed. The purpose is to get a live view of the statuses of a couple of thousand VPS printers, their MAC addresses, and additional information as to where they're used. The last bit is stored in NetView global variables. - Vignesh Mainframe Admin -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ed Finnell Sent: 17 April 2014 22:06 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Forget: Sorting CSV data that begins with an IP address The other fork in the road(Slawson cutoff) is what's the purpose? Most printer vendors have monitors available or downloadable. For availability whats_up _www.ipswitch.com_ (http://www.ipswitch.com) is pretty flexible. In a message dated 4/17/2014 2:32:16 P.M. Central Daylight Time, skol...@us.ibm.com writes: may be we could have fixed that issue. Did you try out the solution posted by me earlier? If so what is the outcome of that? Did you get the desired results? Thanks, -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
At 22:46 + on 04/17/2014, Sankaranarayanan, Vignesh wrote about Re: Forget: Sorting CSV data that begins with an IP address: Hmm. Interesting ... If I adopted this approach, then I would have to write to separate files and then use DFSORT to get it all back together, sorted. - Vignesh Mainframe Admin Or you can write the results to a PDSE and then just read the members in sequential order. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Forget: Sorting CSV data that begins with an IP address
At 17:05 -0400 on 04/17/2014, Ed Finnell wrote about Re: Forget: Sorting CSV data that begins with an IP address: The other fork in the road(Slawson cutoff) That brings back memories of the Johnny Carson Art Fern/Tea Time Movie Routine g. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Forget: Sorting CSV data that begins with an IP address
On Wed, 16 Apr 2014 16:47:47 +, Sankaranarayanan, Vignesh wrote: Sankaranarayanan, Vignesh would like to recall the message, Sorting CSV data that begins with an IP address. Paul Gilmartin would like to forget the message, Sorting CSV data that begins with an IP address. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
