Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.
John,
Here are some more suggestions, in no particular order:
1. IBM InfoSphere Classic Federation Server for z/OS provides JDBC, ODBC,
and DRDA access to VSAM data (and other types of data):
https://www.ibm.com/us-en/marketplace/infosphere-classic-federation-server
Microsoft Excel understands how to connect via ODBC.
2. You can install the IBM z/OS Platform for Apache Spark, then connect
Microsoft Excel to Spark (using various methods):
https://www.ibm.com/us-en/marketplace/real-time-analysis-on-z-systems
Spark provides a lot of features that data scientists and actuaries are
bound to like and even prefer, beyond Microsoft Excel. Apache Spark runs
almost entirely on zIIP engines, if you have one or more of them. I think
it's orderable from IBM Shopz at no additional charge. (Optional IBM
support is chargeable, and there are bigger/larger function sets that are
chargeable.)
3. Query Management Facility (QMF):
https://www.ibm.com/us-en/marketplace/db2-qmf
Despite its name ("DB2 QMF"), QMF also supports VSAM and other data
sources.
Timothy Sipples
IT Architect Executive, Industry Solutions, IBM z Systems, AP/GCG/MEA
E-Mail: sipp...@sg.ibm.com
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SPF Panels for TCP/IP (was HSM Query command)
Edward Finnell wrote: >Dave Alcock heard you 17 yrs ago! >http://planetmvs.com/ I'm familiar with these nice and useful site. And I see a new photo with a car with the number plate: BR 14 (with a very cool statement: 'No Statements flagged in this Assembly') I also like this new quote: 'What... is the paging velocity of an unladen MVS system?' ;-D ... and lastly this last tip: "Ask your doctor if Planet MVS is right for you." Bye Is it now Friday after that eclipse over america two days ago? 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: permissions to /bin/sh
W dniu 2017-08-22 o 16:30, Robert Hansel pisze: Itschak and Radoslaw, I believe the permissions for /bin/sh should be 1755, displayed as rwxr-xr-t. Note the 1 for the attribute, displayed as 't', activates the Sticky Bit. This causes Unix to execute an MVS program by the name of SH instead of trying to execute file sh in the /bin directory. SH exists in SYS1.LPALIB as an alias for FSUMUSSH. I've never seen the permission bits set to anything else. Admittedly, I have not tried turning off the Sticky Bit in order to execute file sh in the /bin directory, so perhaps it would still function properly. Is there a compelling reason to turn off the Sticky Bit? A little bit of explanations. I asked the question, because I found discrepancy in the permissions. Who, how, when, and why changed the permissions - I don't know, that's another story. However the system seemed to work properly with r-x on /bin/sh. The problem occured during installation of some IBM product, part of IDz (former RDz - Rational Developer for System z). Change to r-t fixed the problem. Thank anyone who helped me with this issue. -- Radoslaw Skorupka Lodz, Poland == -- Treść tej wiadomości może zawierać informacje prawnie chronione Banku przeznaczone wyłącznie do użytku służbowego adresata. Odbiorcą może być jedynie jej adresat z wyłączeniem dostępu osób trzecich. Jeżeli nie jesteś adresatem niniejszej wiadomości lub pracownikiem upoważnionym do jej przekazania adresatowi, informujemy, że jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne działanie o podobnym charakterze jest prawnie zabronione i może być karalne. Jeżeli otrzymałeś tę wiadomość omyłkowo, prosimy niezwłocznie zawiadomić nadawcę wysyłając odpowiedź oraz trwale usunąć tę wiadomość włączając w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorized to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. mBank S.A. z siedzibą w Warszawie, ul. Senatorska 18, 00-950 Warszawa, www.mBank.pl, e-mail: kont...@mbank.plsąd Rejonowy dla m. st. Warszawy XII Wydział Gospodarczy Krajowego Rejestru Sądowego, nr rejestru przedsiębiorców KRS 025237, NIP: 526-021-50-88. Według stanu na dzień 01.01.2016 r. kapitał zakładowy mBanku S.A. (w całości wpłacony) wynosi 168.955.696 złotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SPF Panels for TCP/IP (was HSM Query command) - EZANS RFE
This is my RFE. Currently 75 votes supporting it but only uncommitted candidate. Can we get it to over a hundred votes? Headline: Support EZANS as part of z/OS Communications Server ID: 59073 Mike Wawiorko -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Cieri, Anthony Sent: 22 August 2017 20:47 To: IBM-MAIN@LISTSERV.UA.EDU Subject: SPF Panels for TCP/IP (was HSM Query command) This mail originated from outside our organisation - aci...@seic.com Sorry for the segue into a new thread, but. There is a SPF Utility that basically provides a full screen ISPF interface to the NETSTAT command. It can be found at the following url: http://www-01.ibm.com/support/docview.wss?uid=swg24029203 It is called the IBM z/OS Communications Server Network Utility Assistant. It is a pretty neat little tool. I am not sure of the support status for it. I believe that "as is", it stopped working around z/OS V1.13. However, the changes necessary to make it functional again, are only required in the Rexx code that determine the z/OS System level and are relatively minor. I also believe that there is an RFE that is requesting formal support from IBM. I don't know the status or the RFE number. I am currently running z/OS V2.1 and have this operating sufficiently in our environment. Hth Tony -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Elardus Engelbrecht Sent: Tuesday, August 22, 2017 7:41 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: HSM Query command Radoslaw Skorupka wrote: >That remains me a fundamental question: WHY DFHSM DOES NOT HAVE ISPF PANELS? HSM is more of a background thing. Perhaps you should say what functions (status of MCDS, BCDS, active processes, hold/release HSM actions, etc.) you want to see in ISPF panels (or I prefer, in ISMF)? >Wouldn't it be nice to have some entry in ISMF like RMM has? It would be really nice, I agree. >There are two components which lack panels: VTAM and HSM. Netview (separate product of course) has panels which you can use to manage your VTAM network. I would also prefer to see some panels (or webpages) doing the same for TCP/IP. I can dream about such gems,... ;-) Perhaps if you can submit a good reason/excuse, big blue may listen to you... 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this e-mail or its attachments. Internet communications are not guaranteed to be secure or virus-free. The Barclays Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this e-mail may be monitored by the Barclays Group for operational or business reasons. Any opinion or other information in this e-mail or its attachments that does not relate to the business of the Barclays Group is personal to the sender and is not given or endorsed by the Barclays Group. Barclays Bank PLC. Registered in England and Wales (registered no. 1026167). Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom. Barclays Bank PLC is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority (Financial Services Register No. 122702). -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z14 and zBX
W dniu 2017-08-22 o 16:33, Phil Smith III pisze: R.S. wrote: IMHO it was a mistake from the begining. Whenever I asked the question: "what is the difference between zBX and regular 19" rack with blade servers" I heard about Ensemble, OSX, OSM, etc. Customers do not need ensembles. From customer point of view zBX is just rack with servers, but less flexible, vendor locked and more expensive. Even IBM did not use zBX for its appliance like IDAA. The disadvantages you cite are real, for sure, and may have been sufficient to kill the concept right there. But the *idea* was that high-impact processing could be easily/seamlessly offloaded. The "too late" part is that the folks who needed to do that had already bitten the bullet and done so. Fifteen years ago, not so much. Now I understand your point. Yes, obviously you're right with the offload and IDAA is excellent example of such offload, but it does not exploit any of zBX-specific features. Some other offload examples could be zEDC or even CryptoExpress. It's a kind of "internal offload" - the offload is being done. but the appliance reside inside the CEC as a card. BTW: It's a pity the IDAA is not under HMC management. It would significantly simplify microcode management and possibly remote access of service folks. Current procedures for that are horrible. Regards -- Radoslaw Skorupka Lodz, Poland == -- Treść tej wiadomości może zawierać informacje prawnie chronione Banku przeznaczone wyłącznie do użytku służbowego adresata. Odbiorcą może być jedynie jej adresat z wyłączeniem dostępu osób trzecich. Jeżeli nie jesteś adresatem niniejszej wiadomości lub pracownikiem upoważnionym do jej przekazania adresatowi, informujemy, że jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne działanie o podobnym charakterze jest prawnie zabronione i może być karalne. Jeżeli otrzymałeś tę wiadomość omyłkowo, prosimy niezwłocznie zawiadomić nadawcę wysyłając odpowiedź oraz trwale usunąć tę wiadomość włączając w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorized to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. mBank S.A. z siedzibą w Warszawie, ul. Senatorska 18, 00-950 Warszawa, www.mBank.pl, e-mail: kont...@mbank.plsąd Rejonowy dla m. st. Warszawy XII Wydział Gospodarczy Krajowego Rejestru Sądowego, nr rejestru przedsiębiorców KRS 025237, NIP: 526-021-50-88. Według stanu na dzień 01.01.2016 r. kapitał zakładowy mBanku S.A. (w całości wpłacony) wynosi 168.955.696 złotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SPF Panels for TCP/IP (was HSM Query command)
He's still maintaining the unofficial IBM-Main FAQ too. In a message dated 8/23/2017 3:19:04 A.M. Central Daylight Time, elardus.engelbre...@sita.co.za writes: I'm familiar with these nice and useful site. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: OSA-ICC MAC Address
Thanks! I did not try View port parameters. Regards, Jim -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
SSL with WebSphere and CICS
Cross posted between RACF-L and IBM-MAIN: Good day to all, Before we submit a PMR to IBM, I wish to ask for help on these 2 discussion lists. My colleague successfully used WebSphere on LPAR A to access CICS on LPAR B using HTTP Server using Non-SSL connection. But when we enable SSL using the Certificate setup in RACF as per IBM's manuals like these redbook 'Securing CICS Web Services', 'Implementing CICS Web Services' and other books for WebSphere and CICS, ... we got a 'HTTP 403 'Forbidden' when we try to use https://<>:3103/cics/... Same address with https changed to http is working 100% fine, fast and no problem at all. Note - CICS by itself is working 100% fine with the same certicates in RACF. It is only when we try to use WebSphere to connect CICS via HTTPS, we get problems. Scenario: CICS TS 4.2 on z/OS v2.1, WebSphere IBM HTTP Server V5R3M0 on z/OS v1.3 (Yes, I know it is out of support.) with WebSphere HTTP Plug-in for z/OS and OS/390 Version 6.0 build level 6.1.0.22. Question: Where can we see what is causing the message 'HTTP 403 Forbidden'? SYSLOG and STCs output scanning, RACF SMF scanning and looking in OMVS files and folders yielded nothing. Many thanks in advance. 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
AW: Re: permissions to /bin/sh
>A little bit of explanations. I asked the question, because I found discrepancy in the permissions. Who, how, when, and why changed the permissions - I don't know, that's another story. However the system seemed to work properly with r-x on /bin/sh. The problem occured during installation of some IBM product, part of IDz (former RDz - Rational Developer for System z). Change to r-t fixed the problem. Not sure what the problem was that you encountered. However, it seems to me that some part of your installation had not been done properly or completely. The shell is installed into LPA *and* into the /bin path of your version root file system. without the sticky bit, the version from the /bin directory is always used. The LPA version is not relevant. With the sticky bit, the LPA version is always used, and the version in /bin is not relevant. Except when the shell is not found in LPA, then the loader goes back and loads it from the /bin directory. I cannot say how a version discrepancy could cause troubles, but the same issue might exist with other sticky bit UNIX binaries, and the corresponding load module. As a side note: Other permission r-x is exactly the same as r-t from a permission point of view. The lower case t means x permission and sticky bit is set. Its kind of as overpunching on punch cards. The sticky bit is show in the same position as the execute permission. Sticky and no execute permission is shown as T, sticky and execute permission is shown as t. No sticky bit but execute permission is shown as x. Similarly, the Set-UID-bit and Set-Gid-bit are "overpunched" over the x position in the Owner, and Groups parts, resp. Shown as S or s, depending on whether execute permission is also present or not. -- Peter Hunkeler -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SSL with WebSphere and CICS
Elardus Engelbrecht wrote: >... WebSphere IBM HTTP Server V5R3M0 on z/OS v1.3 (Yes, I know it is out of >support.) Sorry, I mean z/OS v1.13. I hate typos! 8-[ 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
How to Remove trailing space in SFTP Transfer
Hello, We are in the process of converting FTP jobs in to SFTP on mainframe system. So, we are sending text data from mainframe to AIX system for further processing. My observation is, when we use FTP process of transferring the file, by default we dont get any trailing spaces in file after ftp to target system. But when we use SFTP process for transferring the file, we get trailing spaces added in the file after sftp process completion. For controlling trailing space, in ftp we have command locsite trail and notrail but I am unable to find command to control trailing space during sftp transfer from Mainframe to AIX system . Can you please help on this issue. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.
On Tue, 22 Aug 2017 07:38:59 -0500, John McKown wrote: >is familiar with MS VBA. So what he wants to do is to have a VBA >program which can use the Windows MQSeries dll to communicate with a >CICS transaction. This transaction would read or write the data on Maybe have your programmer consider http://www.mqgem.com/qload.html I'am sure a VBA wizard can easily drive this program to get and put the messages on the Excel end. Cheers, Jantje. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: AW: Re: permissions to /bin/sh
W dniu 2017-08-23 o 12:52, Peter Hunkeler pisze: A little bit of explanations. I asked the question, because I found discrepancy in the permissions. Who, how, when, and why changed the permissions - I don't know, that's another story. However the system seemed to work properly with r-x on /bin/sh. The problem occured during installation of some IBM product, part of IDz (former RDz - Rational Developer for System z). Change to r-t fixed the problem. Not sure what the problem was that you encountered. However, it seems to me that some part of your installation had not been done properly or completely. The shell is installed into LPA *and* into the /bin path of your version root file system. without the sticky bit, the version from the /bin directory is always used. The LPA version is not relevant. With the sticky bit, the LPA version is always used, and the version in /bin is not relevant. Except when the shell is not found in LPA, then the loader goes back and loads it from the /bin directory. I cannot say how a version discrepancy could cause troubles, but the same issue might exist with other sticky bit UNIX binaries, and the corresponding load module. As a side note: Other permission r-x is exactly the same as r-t from a permission point of view. The lower case t means x permission and sticky bit is set. Its kind of as overpunching on punch cards. The sticky bit is show in the same position as the execute permission. Sticky and no execute permission is shown as T, sticky and execute permission is shown as t. No sticky bit but execute permission is shown as x. Similarly, the Set-UID-bit and Set-Gid-bit are "overpunched" over the x position in the Owner, and Groups parts, resp. Shown as S or s, depending on whether execute permission is also present or not. Peter, 1. The problem with IDz was real and solved by change the permissions. The system originally was created properly, including permissions to /bin/sh - that's I'm sure, because I have an access to the "source image" of cloned system having the problem. 2. Do not take "permissions" word so literally. We're aware the "t" is just kind of brevity, an equivalent of "x + sticky". It's better visible in octal form, but 4-digit. From the other hand octal "5" is not intuitive as "r-x". Regards -- Radoslaw Skorupka Lodz, Poland == -- Treść tej wiadomości może zawierać informacje prawnie chronione Banku przeznaczone wyłącznie do użytku służbowego adresata. Odbiorcą może być jedynie jej adresat z wyłączeniem dostępu osób trzecich. Jeżeli nie jesteś adresatem niniejszej wiadomości lub pracownikiem upoważnionym do jej przekazania adresatowi, informujemy, że jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne działanie o podobnym charakterze jest prawnie zabronione i może być karalne. Jeżeli otrzymałeś tę wiadomość omyłkowo, prosimy niezwłocznie zawiadomić nadawcę wysyłając odpowiedź oraz trwale usunąć tę wiadomość włączając w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorized to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. mBank S.A. z siedzibą w Warszawie, ul. Senatorska 18, 00-950 Warszawa, www.mBank.pl, e-mail: kont...@mbank.plsąd Rejonowy dla m. st. Warszawy XII Wydział Gospodarczy Krajowego Rejestru Sądowego, nr rejestru przedsiębiorców KRS 025237, NIP: 526-021-50-88. Według stanu na dzień 01.01.2016 r. kapitał zakładowy mBanku S.A. (w całości wpłacony) wynosi 168.955.696 złotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: How to Remove trailing space in SFTP Transfer
venkat kulkarni wrote: >But when we use SFTP process for transferring the file, we get trailing spaces >added in the file after sftp process completion. It depends. What SFTP client and server software are you using? Also, can you show the effective settings during SFTP process? 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: How to Remove trailing space in SFTP Transfer
Thanks for reply. I think by default SFTP mode of transfer is binary and add trailing space at end of every records, which eventually increases the file of file compare to ftp transfer. I am using omvs and batch job to transfer file from Mainframe to AIX using SFTP command . Are you looking for any specific file. But for FTP process, we have input parameter file under TCPIP.TCPPARMS(FTPSDATA1) On Wed, Aug 23, 2017 at 2:59 PM, Elardus Engelbrecht < elardus.engelbre...@sita.co.za> wrote: > venkat kulkarni wrote: > > >But when we use SFTP process for transferring the file, we get trailing > spaces added in the file after sftp process completion. > > It depends. What SFTP client and server software are you using? > > Also, can you show the effective settings during SFTP process? > > 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 > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: How to Remove trailing space in SFTP Transfer
BARCLAYS CLASSIFICATION: Internal Only Hold on a bit. TCPIP.TCPPARMS(FTPSDATA1) looks suspiciously like an FTP(S) //SYSFTPD or FTP DATA file. Please confirm if you are using FTPS (FTP with TLS encryption) or sftp (ftp within an ssh connection). These are two entirely unrelated methods of file transfer that have nothing in common apart from being anagrams. Mike Wawiorko -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of venkat kulkarni Sent: 23 August 2017 13:10 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: How to Remove trailing space in SFTP Transfer This message originated from outside our organisation and is from web based email - venkatkulkarn...@gmail.com Thanks for reply. I think by default SFTP mode of transfer is binary and add trailing space at end of every records, which eventually increases the file of file compare to ftp transfer. I am using omvs and batch job to transfer file from Mainframe to AIX using SFTP command . Are you looking for any specific file. But for FTP process, we have input parameter file under TCPIP.TCPPARMS(FTPSDATA1) On Wed, Aug 23, 2017 at 2:59 PM, Elardus Engelbrecht < elardus.engelbre...@sita.co.za> wrote: > venkat kulkarni wrote: > > >But when we use SFTP process for transferring the file, we get > >trailing > spaces added in the file after sftp process completion. > > It depends. What SFTP client and server software are you using? > > Also, can you show the effective settings during SFTP process? > > 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 > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this e-mail or its attachments. Internet communications are not guaranteed to be secure or virus-free. The Barclays Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this e-mail may be monitored by the Barclays Group for operational or business reasons. Any opinion or other information in this e-mail or its attachments that does not relate to the business of the Barclays Group is personal to the sender and is not given or endorsed by the Barclays Group. Barclays Bank PLC. Registered in England and Wales (registered no. 1026167). Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom. Barclays Bank PLC is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority (Financial Services Register No. 122702). -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: OT I5 Server
On Tue, Aug 22, 2017 at 11:09 PM, W Mainframe <01304632a58d-dmarc-requ...@listserv.ua.edu> wrote: > Guys,Is there any AS400 Hardware Support available for a question?Thank youDan Try here: http://lists.midrange.com/mailman/listinfo/midrange-l It's a mailing list. Back a few years ago, we were looking at replacing the z with an IBMi. The people on this list were simply _FANTASTIC_. One even sent me, free, some basic books on the system that he didn't need. Oh, since you're asking here, I ASSuMEd that you weren't asking about official IBM support. -- If you look around the poker table & don't see an obvious sucker, it's you. Maranatha! <>< John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: How to Remove trailing space in SFTP Transfer
venkat kulkarni wrote: >I think by default SFTP mode of transfer is binary and add trailing space at >end of every records, which eventually increases the file of file compare to >ftp transfer. Not really. It depends on what software you're using and how they are configured in the first place as well what options you are using during the transfers. >I am using omvs and batch job to transfer file from Mainframe to AIX using >SFTP command . It does not answer my questions I asked earlier. Please reread my first reply for details. >Are you looking for any specific file. But for FTP process, we have input >parameter file under TCPIP.TCPPARMS(FTPSDATA1) I am not looking for any file, but since you mentioned FTPSDATA1, please look at Mike Wawiorko urgent reply. 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: SSL with WebSphere and CICS
You can run a GSKSRVR SSL trace. There was a discussion on this list earlier about it. And you can go here: http://www-01.ibm.com/support/docview.wss?uid=swg21394697 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Elardus Engelbrecht Sent: Wednesday, August 23, 2017 5:09 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SSL with WebSphere and CICS Cross posted between RACF-L and IBM-MAIN: Good day to all, Before we submit a PMR to IBM, I wish to ask for help on these 2 discussion lists. My colleague successfully used WebSphere on LPAR A to access CICS on LPAR B using HTTP Server using Non-SSL connection. But when we enable SSL using the Certificate setup in RACF as per IBM's manuals like these redbook 'Securing CICS Web Services', 'Implementing CICS Web Services' and other books for WebSphere and CICS, ... we got a 'HTTP 403 'Forbidden' when we try to use https://<>:3103/cics/... Same address with https changed to http is working 100% fine, fast and no problem at all. Note - CICS by itself is working 100% fine with the same certicates in RACF. It is only when we try to use WebSphere to connect CICS via HTTPS, we get problems. Scenario: CICS TS 4.2 on z/OS v2.1, WebSphere IBM HTTP Server V5R3M0 on z/OS v1.3 (Yes, I know it is out of support.) with WebSphere HTTP Plug-in for z/OS and OS/390 Version 6.0 build level 6.1.0.22. Question: Where can we see what is causing the message 'HTTP 403 Forbidden'? SYSLOG and STCs output scanning, RACF SMF scanning and looking in OMVS files and folders yielded nothing. Many thanks in advance. 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 == This email, and any files transmitted with it, is confidential and intended solely for the use of the individual or entity to which it is addressed. If you have received this email in error, please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this message by mistake and delete this e-mail from your system. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SSL with WebSphere and CICS
We had a similar issue sometime back when upgrading to 2.1, the TLS support needed was never order, we're were running AT-TLS 2.0 I belive, been a while, so make sure TLS is installed, as someone already suggest the SSL trace should show you exactly what your region is needing and what's available for the handshake Carmen - Original Message - From: "Elardus Engelbrecht" To: IBM-MAIN@LISTSERV.UA.EDU Sent: Wednesday, August 23, 2017 5:09:26 AM Subject: SSL with WebSphere and CICS Cross posted between RACF-L and IBM-MAIN: Good day to all, Before we submit a PMR to IBM, I wish to ask for help on these 2 discussion lists. My colleague successfully used WebSphere on LPAR A to access CICS on LPAR B using HTTP Server using Non-SSL connection. But when we enable SSL using the Certificate setup in RACF as per IBM's manuals like these redbook 'Securing CICS Web Services', 'Implementing CICS Web Services' and other books for WebSphere and CICS, ... we got a 'HTTP 403 'Forbidden' when we try to use https://<>:3103/cics/... Same address with https changed to http is working 100% fine, fast and no problem at all. Note - CICS by itself is working 100% fine with the same certicates in RACF. It is only when we try to use WebSphere to connect CICS via HTTPS, we get problems. Scenario: CICS TS 4.2 on z/OS v2.1, WebSphere IBM HTTP Server V5R3M0 on z/OS v1.3 (Yes, I know it is out of support.) with WebSphere HTTP Plug-in for z/OS and OS/390 Version 6.0 build level 6.1.0.22. Question: Where can we see what is causing the message 'HTTP 403 Forbidden'? SYSLOG and STCs output scanning, RACF SMF scanning and looking in OMVS files and folders yielded nothing. Many thanks in advance. 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.
Jantje & Timothy, Those look very interesting. But I forgot a critical part in my initial post. The solution must be FREE of any cost or obligation. The z/OS system is being "revitalized", but that doesn't mean that we're going to actually spend any more money on it. Most especially if we already have a "solution" (what we're doing now) and the "new solution" is not a user request, but just a programmer who has too much to do already and wants to eliminate an "irritation". I guess what we want is an ETL (Extract, Transform, Load) process between z/OS VSAM and Excel which is free & we can con...vince the user into using instead of making a "friendly request" (not a formal one) of the programmer on an "ad hoc" basis. -- If you look around the poker table & don't see an obvious sucker, it's you. Maranatha! <>< John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: OT I5 Server
I do IBM i as one of my *other* responsibilities. I5 is a little dated (we have all P7 and P8's) but I'll help if I can. Feel free to PM me as the rest of this list probably doesn't care about such boxen. Dana On Wed, 23 Aug 2017 07:34:27 -0500, John McKown wrote: >On Tue, Aug 22, 2017 at 11:09 PM, W Mainframe ><01304632a58d-dmarc-requ...@listserv.ua.edu> wrote: >> Guys,Is there any AS400 Hardware Support available for a question?Thank >> youDan > >Try here: http://lists.midrange.com/mailman/listinfo/midrange-l > >It's a mailing list. Back a few years ago, we were looking at >replacing the z with an IBMi. The people on this list were simply >_FANTASTIC_. One even sent me, free, some basic books on the system >that he didn't need. > >Oh, since you're asking here, I ASSuMEd that you weren't asking about >official IBM support. > > >-- >If you look around the poker table & don't see an obvious sucker, it's you. > >Maranatha! <>< >John McKown > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: How to Remove trailing space in SFTP Transfer
we use sftp command for transferring the file. On Wed, Aug 23, 2017 at 3:28 PM, Mike Wawiorko < 014ab5cdfb21-dmarc-requ...@listserv.ua.edu> wrote: > BARCLAYS CLASSIFICATION: Internal Only > > Hold on a bit. > > TCPIP.TCPPARMS(FTPSDATA1) looks suspiciously like an FTP(S) //SYSFTPD or > FTP DATA file. > > Please confirm if you are using FTPS (FTP with TLS encryption) or sftp > (ftp within an ssh connection). > > These are two entirely unrelated methods of file transfer that have > nothing in common apart from being anagrams. > > Mike Wawiorko > > > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of venkat kulkarni > Sent: 23 August 2017 13:10 > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: How to Remove trailing space in SFTP Transfer > > > This message originated from outside our organisation and is from web > based email - venkatkulkarn...@gmail.com > > Thanks for reply. I think by default SFTP mode of transfer is binary and > add trailing space at end of every records, which eventually increases the > file of file compare to ftp transfer. > > I am using omvs and batch job to transfer file from Mainframe to AIX using > SFTP command . > > Are you looking for any specific file. But for FTP process, we have > input parameter file under TCPIP.TCPPARMS(FTPSDATA1) > > > > > On Wed, Aug 23, 2017 at 2:59 PM, Elardus Engelbrecht < > elardus.engelbre...@sita.co.za> wrote: > > > venkat kulkarni wrote: > > > > >But when we use SFTP process for transferring the file, we get > > >trailing > > spaces added in the file after sftp process completion. > > > > It depends. What SFTP client and server software are you using? > > > > Also, can you show the effective settings during SFTP process? > > > > 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 > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, send email > to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > This e-mail and any attachments are confidential and intended solely for > the addressee and may also be privileged or exempt from disclosure under > applicable law. If you are not the addressee, or have received this e-mail > in error, please notify the sender immediately, delete it from your system > and do not copy, disclose or otherwise act upon any part of this e-mail or > its attachments. > > Internet communications are not guaranteed to be secure or virus-free. The > Barclays Group does not accept responsibility for any loss arising from > unauthorised access to, or interference with, any Internet communications > by any third party, or from the transmission of any viruses. Replies to > this e-mail may be monitored by the Barclays Group for operational or > business reasons. > > Any opinion or other information in this e-mail or its attachments that > does not relate to the business of the Barclays Group is personal to the > sender and is not given or endorsed by the Barclays Group. > > Barclays Bank PLC. Registered in England and Wales (registered no. > 1026167). Registered Office: 1 Churchill Place, London, E14 5HP, United > Kingdom. > > Barclays Bank PLC is authorised by the Prudential Regulation Authority and > regulated by the Financial Conduct Authority and the Prudential Regulation > Authority (Financial Services Register No. 122702). > > -- > 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
SMS dataset woes
I would appreciate some advice on a problem that I'm having on a development system. We copied some volumes from an old machine, where the data sets where SMS managed to a new system where SMS is really not set up and we would prefer to keep it that way. We exported the old usercat that had the datasets on these volumes and then imported it to a new usercat on the new system, which worked fine. But the problem is that we can't delete any of the old datasets, since they still have the old SMS "storclass" in the VVDS (I think). - ISPF delete just says "Deallocation failed" - TSO/IDCAMS delete does this: delete ftp.data IDC0550I ENTRY (A) LISA.FTP.DATA DELETED IDC3014I CATALOG ERROR+ IDC3009I VSAM CATALOG RETURN CODE IS 50 - REASON CODE IS IGG0CLFO-88 IDC0551I ENTRY LISA.FTP.DATA NOT DELETED IDC0014I LASTCC=8 RC(8) So the data set is uncataloged, but remains on the volume and the VVDS. This error is documented here: https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.ieam600/bb3009i.htm *88* *Explanation:* A VVR or NVR with the correct component name was found, but the catalog name did not match. On a delete request, the BCS record will be deleted, but the VVR or NVR and the format 1 DSCB will not be scratched. There is no SFI data. *Programmer Response:* No action is required because this code is for information only. Does anyone have any suggestions other than to try to migrate the missing SMS definitions? We have crap for skills and that area, so an alternative would be appreciated. One workaround would be something that would scratch an uncataloged SMS dataset (and remove from the VVDS). Will IEHPROGM do this? It doesn't seem like it: SCRATCH DSNAME=LISA.JOB.LOG,VOL=3390=(VPWRKB),PURGE IEH207I STATUS OF USERS REQUEST TO SCRATCH DATA SET LISA.JOB.LOG VOLUME I.D. ACTION TAKEN REASON FOR TAKING THIS ACTION ERROR VPWRKB NONE CORRECT PASSWORD NOT AVAILABLE *** Thanks for any help... Kirk Wolf Dovetailed Technologies http://dovetail.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: permissions to /bin/sh
NTAC:3NS-20 Good question. Reminds me of the age-old Auditor 101 question: "What do you do to restrict AMASPZAP?" Explaining that it's just a tool like any other and that the real issue is properly securing the entities it might update is the real solution always fell on deaf ears. They believed there was something magical about Zap. > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > On Behalf Of Paul Gilmartin > Sent: Tuesday, August 22, 2017 11:15 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: [EXT] Re: permissions to /bin/sh > > On Wed, 23 Aug 2017 07:08:39 +0300, ITschak Mugzach wrote: > > > >There are users associated with tasks. Disallowing shell is much like > >tbe protected attribute in racf. > > > Shouldn't the better practice be to protect the resources rather than restrict > the tool? > > >בתאריך 22 באוג 2017 23:00, "Paul Gilmartin" כתב: > >> > >> >0755 or less > >> > > >> Why would *anyone* *ever* choose to restrict the permissions of sh!? > > -- gil > > -- > 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: SMS dataset woes
Your issue is the new (different) usercat name. I am not sure if the vvds captures the SMS but I know it captures the usercat. Mike On Wed, Aug 23, 2017 at 11:24 AM, Kirk Wolf wrote: > I would appreciate some advice on a problem that I'm having on a > development system. > We copied some volumes from an old machine, where the data sets where SMS > managed to a new system where SMS is really not set up and we would prefer > to keep it that way. > > We exported the old usercat that had the datasets on these volumes and then > imported it to a new usercat on the new system, which worked fine. > > But the problem is that we can't delete any of the old datasets, since they > still have the old SMS "storclass" in the VVDS (I think). > > - ISPF delete just says "Deallocation failed" > > - TSO/IDCAMS delete does this: > > delete ftp.data > > IDC0550I ENTRY (A) LISA.FTP.DATA DELETED > IDC3014I CATALOG ERROR+ > IDC3009I VSAM CATALOG RETURN CODE IS 50 - REASON CODE IS IGG0CLFO-88 > IDC0551I ENTRY LISA.FTP.DATA NOT DELETED > IDC0014I LASTCC=8 > RC(8) > > So the data set is uncataloged, but remains on the volume and the VVDS. > > This error is documented here: > > https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1. > 0/com.ibm.zos.v2r1.ieam600/bb3009i.htm > > > *88* *Explanation:* A VVR or NVR with the correct component name was found, > but the catalog name did not match. On a delete request, the BCS record > will be deleted, but the VVR or NVR and the format 1 DSCB will not be > scratched. There is no SFI data. > > *Programmer Response:* No action is required because this code is for > information only. > Does anyone have any suggestions other than to try to migrate the missing > SMS definitions? We have crap for skills and that area, so an alternative > would be appreciated. > > One workaround would be something that would scratch an uncataloged SMS > dataset (and remove from the VVDS). Will IEHPROGM do this? It doesn't > seem like it: > >SCRATCH DSNAME=LISA.JOB.LOG,VOL=3390=(VPWRKB),PURGE > > IEH207I STATUS OF USERS REQUEST TO SCRATCH DATA SET LISA.JOB.LOG > > VOLUME I.D. ACTION TAKEN REASON FOR TAKING THIS ACTION > ERROR > VPWRKB NONE CORRECT PASSWORD NOT AVAILABLE > *** > > > Thanks for any help... > > > Kirk Wolf > Dovetailed Technologies > http://dovetail.com > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Mike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMS dataset woes
Does ISMF work on your system? I haven't had to use it lately, but ISMF used to be able to delete uncatalogged SMF datasets and such Dana On Wed, 23 Aug 2017 11:24:02 -0500, Kirk Wolf wrote: > >But the problem is that we can't delete any of the old datasets, since they >still have the old SMS "storclass" in the VVDS (I think). > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMS dataset woes
This may be a "big hammer" approach, but why not just move the datasets you want to keep off of each volume to another volume and then initialize each volume? -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Mike Bell Sent: Wednesday, August 23, 2017 12:33 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMS dataset woes Your issue is the new (different) usercat name. I am not sure if the vvds captures the SMS but I know it captures the usercat. Mike On Wed, Aug 23, 2017 at 11:24 AM, Kirk Wolf wrote: > I would appreciate some advice on a problem that I'm having on a > development system. > We copied some volumes from an old machine, where the data sets where > SMS managed to a new system where SMS is really not set up and we > would prefer to keep it that way. > > We exported the old usercat that had the datasets on these volumes and > then imported it to a new usercat on the new system, which worked fine. > > But the problem is that we can't delete any of the old datasets, since > they still have the old SMS "storclass" in the VVDS (I think). > > - ISPF delete just says "Deallocation failed" > > - TSO/IDCAMS delete does this: > > delete ftp.data > > IDC0550I ENTRY (A) LISA.FTP.DATA DELETED IDC3014I CATALOG ERROR+ > IDC3009I VSAM CATALOG RETURN CODE IS 50 - REASON CODE IS IGG0CLFO-88 > IDC0551I ENTRY LISA.FTP.DATA NOT DELETED IDC0014I LASTCC=8 > RC(8) > > So the data set is uncataloged, but remains on the volume and the VVDS. > > This error is documented here: > > https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1. > 0/com.ibm.zos.v2r1.ieam600/bb3009i.htm > > > *88* *Explanation:* A VVR or NVR with the correct component name was > found, but the catalog name did not match. On a delete request, the > BCS record will be deleted, but the VVR or NVR and the format 1 DSCB > will not be scratched. There is no SFI data. > > *Programmer Response:* No action is required because this code is for > information only. > Does anyone have any suggestions other than to try to migrate the > missing SMS definitions? We have crap for skills and that area, so an > alternative would be appreciated. > > One workaround would be something that would scratch an uncataloged SMS > dataset (and remove from the VVDS). Will IEHPROGM do this? It doesn't > seem like it: > >SCRATCH DSNAME=LISA.JOB.LOG,VOL=3390=(VPWRKB),PURGE > > IEH207I STATUS OF USERS REQUEST TO SCRATCH DATA SET LISA.JOB.LOG > > VOLUME I.D. ACTION TAKEN REASON FOR TAKING THIS ACTION > ERROR > VPWRKB NONE CORRECT PASSWORD NOT AVAILABLE > *** > > > Thanks for any help... > > > Kirk Wolf > Dovetailed Technologies > http://dovetail.com > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Mike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN This email transmission and any accompanying attachments may contain CSX privileged and confidential information intended only for the use of the intended addressee. Any dissemination, distribution, copying or action taken in reliance on the contents of this email by anyone other than the intended recipient is strictly prohibited. If you have received this email in error please immediately delete it and notify sender at the above CSX email address. Sender and CSX accept no liability for any damage caused directly or indirectly by receipt of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: How to Remove trailing space in SFTP Transfer
On Wed, 23 Aug 2017 14:04:13 +0300, venkat kulkarni wrote: > >So, we are sending text data from mainframe to AIX system for further >processing. >... >But when we use SFTP process for transferring the file, we get trailing >spaces added in the file after sftp process completion. > I'm astonished. I trust sftp to do no data munging. Are you certain the spaces don't exist in the original file before transfer? Try the command od -tx1 file-name on the file before and after transfer. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: How to Remove trailing space in SFTP Transfer
On Wed, Aug 23, 2017 at 11:39 AM, Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> wrote: > On Wed, 23 Aug 2017 14:04:13 +0300, venkat kulkarni wrote: >> >>So, we are sending text data from mainframe to AIX system for further >>processing. >>... >>But when we use SFTP process for transferring the file, we get trailing >>spaces added in the file after sftp process completion. >> > I'm astonished. I trust sftp to do no data munging. Are you certain the > spaces don't exist in the original file before transfer? Try the command > od -tx1 file-name > on the file before and after transfer. I'd bet that the old FTP transfer had a site default of NOTRAILINGBLANKS. This automatically truncates the transferred line after the last non-blank character. There is no such option, that I know of, for sftp transfers. The "sed" command could be used before transferring to remove trailing blanks from the input file. Something like: sed -E 's/ *$//;' real-input-file.txt >no-trailing-blanks-file.txt Then transfer no-trailing-blanks-file.txt, like: sftp no-trailing-blanks-file user@remote:/dir/ectory/real-input.file.txt > > -- gil > -- If you look around the poker table & don't see an obvious sucker, it's you. Maranatha! <>< John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMS dataset woes
I tried the ISMF panels, and the "DELETE" operator command returns the same error. Kirk Wolf Dovetailed Technologies http://dovetail.com On Wed, Aug 23, 2017 at 11:35 AM, Dana Mitchell wrote: > Does ISMF work on your system? I haven't had to use it lately, but ISMF > used to be able to delete uncatalogged SMF datasets and such > > Dana > > On Wed, 23 Aug 2017 11:24:02 -0500, Kirk Wolf wrote: > > > >But the problem is that we can't delete any of the old datasets, since > they > >still have the old SMS "storclass" in the VVDS (I think). > > > > -- > 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
Bit Bucket x'36'
The intrepid "Bit Bucketeers" closing out another great SHARE conference event in Providence, Rhode Island. https://youtu.be/uNSKKcxGwk8 https://share.confex.com/data/handout/share/129/Session_20844_handout_10972_0.pdf -- Phoenix Software International Edward E. Jaffe 831 Parkview Drive North El Segundo, CA 90245 http://www.phoenixsoftware.com/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMS dataset woes
If you don't have a tool like Trex to either correct the VVDS to BCS entries or
delete the entries you can always try IDCAMS DELETE NVR for non vsam and DELETE
VVR for VSAM (SMS)
//L EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//INVOL0 DD DISP=OLD,UNIT=3390,VOL=SER=xx
//SYSIN DD *
DEL 'HLQ.MLQ.LLQ' -
FILE(INVOL0) VVR
or
//DELETE EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//DD1 DD DSN=HLQ.MLQ.LLQ,
// DISP=SHR,UNIT=3390,VOL=SER=XX
//SYSIN DD *
DELETE FILE(DD1) -
CATALOG('CATALOG.NAME') NVR
many some iteration of this may help
Carmen
- Original Message -
From: "Kirk Wolf"
To: IBM-MAIN@LISTSERV.UA.EDU
Sent: Wednesday, August 23, 2017 11:24:02 AM
Subject: SMS dataset woes
I would appreciate some advice on a problem that I'm having on a
development system.
We copied some volumes from an old machine, where the data sets where SMS
managed to a new system where SMS is really not set up and we would prefer
to keep it that way.
We exported the old usercat that had the datasets on these volumes and then
imported it to a new usercat on the new system, which worked fine.
But the problem is that we can't delete any of the old datasets, since they
still have the old SMS "storclass" in the VVDS (I think).
- ISPF delete just says "Deallocation failed"
- TSO/IDCAMS delete does this:
delete ftp.data
IDC0550I ENTRY (A) LISA.FTP.DATA DELETED
IDC3014I CATALOG ERROR+
IDC3009I VSAM CATALOG RETURN CODE IS 50 - REASON CODE IS IGG0CLFO-88
IDC0551I ENTRY LISA.FTP.DATA NOT DELETED
IDC0014I LASTCC=8
RC(8)
So the data set is uncataloged, but remains on the volume and the VVDS.
This error is documented here:
https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.ieam600/bb3009i.htm
*88* *Explanation:* A VVR or NVR with the correct component name was found,
but the catalog name did not match. On a delete request, the BCS record
will be deleted, but the VVR or NVR and the format 1 DSCB will not be
scratched. There is no SFI data.
*Programmer Response:* No action is required because this code is for
information only.
Does anyone have any suggestions other than to try to migrate the missing
SMS definitions? We have crap for skills and that area, so an alternative
would be appreciated.
One workaround would be something that would scratch an uncataloged SMS
dataset (and remove from the VVDS). Will IEHPROGM do this? It doesn't
seem like it:
SCRATCH DSNAME=LISA.JOB.LOG,VOL=3390=(VPWRKB),PURGE
IEH207I STATUS OF USERS REQUEST TO SCRATCH DATA SET LISA.JOB.LOG
VOLUME I.D. ACTION TAKEN REASON FOR TAKING THIS ACTION
ERROR
VPWRKB NONE CORRECT PASSWORD NOT AVAILABLE
***
Thanks for any help...
Kirk Wolf
Dovetailed Technologies
http://dovetail.com
--
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: SPF Panels for TCP/IP (was HSM Query command) - EZANS RFE
Thanks for the RFE # Up to 77 votes!!! Tony -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Mike Wawiorko Sent: Wednesday, August 23, 2017 4:28 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SPF Panels for TCP/IP (was HSM Query command) - EZANS RFE This is my RFE. Currently 75 votes supporting it but only uncommitted candidate. Can we get it to over a hundred votes? Headline: Support EZANS as part of z/OS Communications Server ID: 59073 Mike Wawiorko -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Cieri, Anthony Sent: 22 August 2017 20:47 To: IBM-MAIN@LISTSERV.UA.EDU Subject: SPF Panels for TCP/IP (was HSM Query command) This mail originated from outside our organisation - aci...@seic.com Sorry for the segue into a new thread, but. There is a SPF Utility that basically provides a full screen ISPF interface to the NETSTAT command. It can be found at the following url: http://www-01.ibm.com/support/docview.wss?uid=swg24029203 It is called the IBM z/OS Communications Server Network Utility Assistant. It is a pretty neat little tool. I am not sure of the support status for it. I believe that "as is", it stopped working around z/OS V1.13. However, the changes necessary to make it functional again, are only required in the Rexx code that determine the z/OS System level and are relatively minor. I also believe that there is an RFE that is requesting formal support from IBM. I don't know the status or the RFE number. I am currently running z/OS V2.1 and have this operating sufficiently in our environment. Hth Tony -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Elardus Engelbrecht Sent: Tuesday, August 22, 2017 7:41 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: HSM Query command Radoslaw Skorupka wrote: >That remains me a fundamental question: WHY DFHSM DOES NOT HAVE ISPF PANELS? HSM is more of a background thing. Perhaps you should say what functions (status of MCDS, BCDS, active processes, hold/release HSM actions, etc.) you want to see in ISPF panels (or I prefer, in ISMF)? >Wouldn't it be nice to have some entry in ISMF like RMM has? It would be really nice, I agree. >There are two components which lack panels: VTAM and HSM. Netview (separate product of course) has panels which you can use to manage your VTAM network. I would also prefer to see some panels (or webpages) doing the same for TCP/IP. I can dream about such gems,... ;-) Perhaps if you can submit a good reason/excuse, big blue may listen to you... 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this e-mail or its attachments. Internet communications are not guaranteed to be secure or virus-free. The Barclays Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this e-mail may be monitored by the Barclays Group for operational or business reasons. Any opinion or other information in this e-mail or its attachments that does not relate to the business of the Barclays Group is personal to the sender and is not given or endorsed by the Barclays Group. Barclays Bank PLC. Registered in England and Wales (registered no. 1026167). Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom. Barclays Bank PLC is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority (Financial Services Register No. 122702). -- 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: SMS dataset woes
Thanks Carmen, that was the tip that I needed. This combination works: /* FIRST UNCATALOG, THEN DELETE NON-VSAM VOLUME RECORD */ DELETE LISA.XXX.YYY NOSCRATCH DELETE LISA.XXX.YYY FILE(VPWRKB) CATALOG(CATALOGV.MASTER) NVR Kirk Wolf Dovetailed Technologies http://dovetail.com > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMS dataset woes
are > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Kirk Wolf > Sent: Wednesday, August 23, 2017 10:36 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: SMS dataset woes > > I tried the ISMF panels, and the "DELETE" operator command returns the same > error. > > Kirk Wolf > Dovetailed Technologies > http://dovetail.com > > On Wed, Aug 23, 2017 at 11:35 AM, Dana Mitchell wrote: > > > Does ISMF work on your system? I haven't had to use it lately, but > > ISMF used to be able to delete uncatalogged SMF datasets and such > > > > Dana > > > > On Wed, 23 Aug 2017 11:24:02 -0500, Kirk Wolf wrote: > > > > > >But the problem is that we can't delete any of the old datasets, > > >since > > they > > >still have the old SMS "storclass" in the VVDS (I think). > > > > > > > -- > > 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: SMS dataset woes
Excellent! Glad I could help Carmen - Original Message - From: "Kirk Wolf" To: IBM-MAIN@LISTSERV.UA.EDU Sent: Wednesday, August 23, 2017 1:23:13 PM Subject: Re: SMS dataset woes Thanks Carmen, that was the tip that I needed. This combination works: /* FIRST UNCATALOG, THEN DELETE NON-VSAM VOLUME RECORD */ DELETE LISA.XXX.YYY NOSCRATCH DELETE LISA.XXX.YYY FILE(VPWRKB) CATALOG(CATALOGV.MASTER) NVR Kirk Wolf Dovetailed Technologies http://dovetail.com > -- 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: SMS dataset woes
Sorry about that. It was a trailing thought that got lost. Never mind Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Lizette Koehler > Sent: Wednesday, August 23, 2017 11:24 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: SMS dataset woes > > are > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On Behalf Of Kirk Wolf > > Sent: Wednesday, August 23, 2017 10:36 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: Re: SMS dataset woes > > > > I tried the ISMF panels, and the "DELETE" operator command returns the > > same error. > > > > Kirk Wolf > > Dovetailed Technologies > > http://dovetail.com > > > > On Wed, Aug 23, 2017 at 11:35 AM, Dana Mitchell > wrote: > > > > > Does ISMF work on your system? I haven't had to use it lately, but > > > ISMF used to be able to delete uncatalogged SMF datasets and such > > > > > > Dana > > > > > > On Wed, 23 Aug 2017 11:24:02 -0500, Kirk Wolf wrote: > > > > > > > >But the problem is that we can't delete any of the old datasets, > > > >since > > > they > > > >still have the old SMS "storclass" in the VVDS (I think). > > > > > > > > > > > > > -- 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: How to Remove trailing space in SFTP Transfer
On Wed, 23 Aug 2017 11:52:06 -0500, John McKown wrote: > >I'd bet that the old FTP transfer had a site default of >NOTRAILINGBLANKS. This automatically truncates the transferred line >after the last non-blank character. There is no such option, that I >know of, for sftp transfers. The "sed" command could be used before >transferring to remove trailing blanks from the input file. Something >like: > >sed -E 's/ *$//;' real-input-file.txt >no-trailing-blanks-file.txt > >Then transfer no-trailing-blanks-file.txt, like: sftp >no-trailing-blanks-file user@remote:/dir/ectory/real-input.file.txt > Or, in a single command: ssh user@remote: " sed 's/ *$//' >/dir/ectory/real-input.file.txt "
Re: ICH13005I
Smith III, Phil , HPE Data Security Voltage wrote: John Eells wrote: Phil, there are plenty of people left on the RACF team in POK to read whatever you send in. Good. But may I ask what the POSIT was? There could be a relevant APAR or two. 019. P.S. Lizette, thanks - I meant to post to RACF-L as well originally, forgot! Have done so now. OK, not related to the problem for which we took the APARs. Was the POSIT shared with another class? Weird Things Happen when you do that. -- John Eells IBM Poughkeepsie ee...@us.ibm.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: ICH13005I
John Eells wrote: >OK, not related to the problem for which we took the APARs. >Was the POSIT shared with another class? Weird Things Happen when you do that. That was my guess, and what led me to suggest they change it. But I don't know. Still seems like a bug, or at least a doc error, no? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: ICH13005I
On 8/23/2017 7:10 PM, John Eells wrote: Smith III, Phil , HPE Data Security Voltage wrote: John Eells wrote: Phil, there are plenty of people left on the RACF team in POK to read whatever you send in. Good. But may I ask what the POSIT was? There could be a relevant APAR or two. 019. P.S. Lizette, thanks - I meant to post to RACF-L as well originally, forgot! Have done so now. OK, not related to the problem for which we took the APARs. Was the POSIT shared with another class? Weird Things Happen when you do that. John, There's no way to know without tearing apart ICHCRCDE. RACF, in its infinite wisdom, provides no report showing POSIT. Regards, Tom Conley -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: thought on data integration: Using MS Excel & MQSeries to get data from z/OS.
John, The IBM z/OS Platform for Apache Spark should be available through your Shopz account at no additional charge. Look for 5655-AAB. Only IBM support (5655-AAC) is chargeable, and it's optional. IBM intends to replace the 5655-AAB program number with 5655-OD1 (IBM Open Data Analytics for z/OS), but for now I believe 5655-AAB is still available. Timothy Sipples IT Architect Executive, Industry Solutions, IBM z Systems, AP/GCG/MEA E-Mail: sipp...@sg.ibm.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
AW: Re: How to Remove trailing space in SFTP Transfer
>Yet, I wonder why the OP may want trailing blanks on z/OS and not on AIX. Just guessing here: Its not that they want trailing blanks, they have it because the data set is RECFM=FB. The FTP truncate option removed them and that is why they are used to not have trailing blanks after the transfer. If it is an option, change the data set on z/OS to RECFM=VB. But this may require a change of the application writing the data set in the first place. -- Peter Hunkeler -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
AW: Re: AW: Re: permissions to /bin/sh
>1. The problem with IDz was real and solved by change the permissions. To me this is not a solution rather a circumvention to the real problem. No process should recognize the difference in calling, i.e. fork()/exec() or spawn(), a UNIX binary having or not having the sticky bit set. If iDZ is having problems with the shell when the sticky bit is not set, there is something wrong in the iDZ code. It is not using the proper calls / funtions() in some way or the other. -- Peter Hunkeler -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: ICH13005I
Have you checked out the LISTCDT utility - https://www-03.ibm.com/systems/z/os/zos/features/racf/downloads/listcdt.html Haven't run it for sometime but I am sure the report it produces lists off the POSIT values Roger -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
