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:[email protected]] On Behalf Of Scott Ford Sent: 18 April 2014 17:26 To: [email protected] 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" > <[email protected]> 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:[email protected]] > On Behalf Of Scott Ford > Sent: 18 April 2014 16:32 > To: [email protected]<mailto:[email protected]> > 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: [email protected]<mailto:[email protected]> > > > > Twitter / Facebook IDs: MartinPacker > > Blog: > > https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker > > > > > > > > From: "Sankaranarayanan, Vignesh" > > <[email protected]<mailto:Vignesh.V.San > [email protected]>> > > To: [email protected]<mailto:[email protected]> > > Date: 18/04/2014 00:40 > > Subject: Re: Forget: Sorting CSV data that begins with an IP > > address > > Sent by: IBM Mainframe Discussion List > <[email protected]<mailto:[email protected]>> > > > > > > > > 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:[email protected]] > On Behalf Of Gibney, Dave > > Sent: 17 April 2014 22:16 > > To: [email protected]<mailto:[email protected]> > > 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:[email protected]] > >> On Behalf Of Sankaranarayanan, Vignesh > >> Sent: Thursday, April 17, 2014 12:35 PM > >> To: [email protected]<mailto:[email protected]> > >> 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 >>> <[email protected]<mailto:[email protected]>> 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 >> <[email protected]<mailto:[email protected]>> wrote on > >> 04/17/2014 12:26:17 PM: > > >>> From: "Sankaranarayanan, Vignesh" > >> <Vignesh.V.Sankaranarayanan@MARKS- > >>> AND-SPENCER.COM> > >>> To: [email protected]<mailto:[email protected]>, > >>> 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 >>> <[email protected]<mailto:[email protected]>> > > >>> 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" > >>> <[email protected]<mailto:[email protected]>> 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:[email protected] > >> ] > >>> On Behalf Of Sankaranarayanan, Vignesh > >>> Sent: Thursday, April 17, 2014 2:58 PM > >>> To: [email protected]<mailto:[email protected]> > >>> 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 >>> [email protected]<mailto:[email protected]> 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<http://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 >>> [email protected]<mailto:[email protected]> with the >>> message: INFO > >>> IBM-MAIN > > > >> --------------------------------------------------------------------- >> - > >> For IBM-MAIN subscribe / signoff / archive access instructions, send > >> email to [email protected]<mailto:[email protected]> >> with the message: INFO IBM-MAIN > > >> --------------------------------------------------------------------- >> - > >> For IBM-MAIN subscribe / signoff / archive access instructions, send > >> email to [email protected]<mailto:[email protected]> >> with the message: INFO IBM-MAIN > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to [email protected]<mailto:[email protected]> > with the message: INFO IBM-MAIN > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to [email protected]<mailto:[email protected]> > with the message: INFO IBM-MAIN > > > > > > > > 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]<mailto:[email protected]> > with the message: INFO IBM-MAIN > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to [email protected]<mailto:[email protected]> > with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
