Re: SDSF ISFEXEC issue - help (please)
You may try /SEND 'test message';Save De: IBM Mainframe Discussion List en nombre de Lionel B. Dyck Enviado: lunes, 29 de agosto de 2022 13:03 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] SDSF ISFEXEC issue - help (please) I'm trying to issue the operator SEND command via ISFEXEC and it is failing and yet it works when done manually under SDSF ULOG The command: /SEND 'test message',Save The error messages: ISF302E "," was seen in command position 29 where one of the following was expected: (, END-OF-STMT, QUOTED-STRING, UNQUOTED-STRING. ISF767I Request completed. Yet I can issue /D IPLINFO and it works. Any advice welcome Lionel B. Dyck <>< Website: https://www.lbdsoftware.com Github: https://github.com/lbdyck “Worry more about your character than your reputation. Character is what you are, reputation merely what others think you are.” - - - John Wooden -- 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: Is there a mathematician in the house?
Hi, (m,n) is the great common divisor between m and n. Can't tell what phi(26)=12 is, but I would say is something like "there are 12 coprimes among the 26 first natural numbers". Horacio De: IBM Mainframe Discussion List en nombre de Bob Bridges Enviado: martes, 23 de agosto de 2022 17:50 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Is there a mathematician in the house? I got to talking with a church friend about encryption, and at lunch yesterday he lent me a book on number theory that has a chapter on asymmetric encryption. Cryptography has long been a hobby of mine, but it's only recently that I came to understand a little of how asymmetric encryption can work. The chapter I'm perusing will get into asymmetric encryption eventually, but it's starting with simple rotational ciphers. Expanding on the simple rotation, it then talks about something it calls "affine transformations", which introduce an additional term into the formula used to encrypt or decrypt the text: C ≡ P+ (mod 26) 0 ≤ C ≤ 25 ...where, it specifies, "(a, 26) = 1". Here's where I pause: What operation is indicated by "(m, n)"? It goes on to say that for 26 letters in the cipher, "there are ф(26) = 12 choices for ". I can see that and 26 must have no factors in common for this to work, and without actually working out how many choices there are I can easily believe the answer is 12, but what function is implied by phi? Someone here probably knows, wouldn't you think? --- Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313 /* The national budget must be balanced. The public debt must be reduced; the arrogance of the authorities must be moderated and controled. Payments to foreign governments must be reduced, if the nation is not to go bankrupt. People must again learn to work, instead of living on public assistance. -Marcus Tullius Cicero, 55 BC */ -- 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: DB2 and RACF entities
You should query Sysibm.Sysuserauth De: IBM Mainframe Discussion List en nombre de Bob Bridges Enviado: miércoles, 15 de junio de 2022 20:14 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Re: DB2 and RACF entities I used to be a member of the DB2 listserv - maybe I still am - but they fell silent a while ago and I quit expecting it to change. But yeah, you should be able to find out from a DBA. As I tried to say in the last post (but I don't think I was very clear), DB2 saves all its GRANTs in a table, or maybe in more than one table. You should be able to write a query to look at that table (if you have the right authorization) for any GRANTs for the ID that is the group you deleted and restored - or, of course, any other GRANTs that interest you. You just have to find out the name of the table(s), which would be some standard documented table name. If I run across it I'll let you know, but I'm sure it'll be in the DB2 documentation. --- Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313 /* We must picture Hell as a state where everyone is perpetually concerned about his own dignity and advancement, where everyone has a grievance, and where eveyone lives the deadly serious passions of envy, self-importance, and resentment. -C S Lewis, preface to _The Screwtape Letters_ */ -Original Message- From: IBM Mainframe Discussion List On Behalf Of Radoslaw Skorupka Sent: Wednesday, June 15, 2022 16:59 It's the opposite: I deleted the group from RACF and some job failed. I quickly re-created the group and connect and restarted job ended OK. However I want to check out what GRANT or other was issued against the group. Or more generally - I want to find out the groupname in DB2 catalog. Not for this group, but for other groups and environments. Yeah, I should ask DB2 admin... ;-) --- W dniu 13.06.2022 o 23:07, Bob Bridges pisze: > RACF doesn't know, so once you've deleted the GRANT from DB2 I don’t know of > a way to find out what you lost (unless you can get it from a backup). But > there are tables in DB2 that list all GRANTs, so you can export those to, > say, Excel and do some sorting and other munging to get a sensible list. > It's been a while, but I did that as part of a project to convert DB2 > security to RACF. > > When I say "it's been a while", what I mean is that I don't remember what > that table or those tables were called. But I was able to find them back > then, so I'm sure it's documented in DB2 somewhere. > > -Original Message- > From: IBM Mainframe Discussion List On Behalf Of > Radoslaw Skorupka > Sent: Monday, June 13, 2022 16:09 > > The following scenario: DB2 v12 using pre-RACF (GRANT/REVOKE) security. Of > course userids and groupids are taken from RACF. There are several groups > which are candidates to delete as they look as not needed. However some of > them have DB2 GRANTs, so those groups should not be deleted. > > So far, so good. Unfortunately some group was deleted, despite it was used by > DB2. I don't know details, but AFAIK probably it was something related to SET > SQL ID or so. > > Q: is there any method to find out *all* RACF users and groups used for any > authorisation in DB2? -- 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: New IBM Community Blog - ISPF List/Log Viewing
OK, thanks! Now I've got the page. De: IBM Mainframe Discussion List en nombre de Eric D Rossman Enviado: viernes, 3 de junio de 2022 18:55 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Re: New IBM Community Blog - ISPF List/Log Viewing That's only the first half of the link. I'm splitting it across 3 lines to make it clearer (in case your mail program is trying to rewrite URLs. https:// community.ibm.com/community/user/ibmz-and-linuxone/blogs/lionel-dyck 2/2022/06/02/ispf-list-and-log-improved-access Eric Rossman, CISSP ICSF Cryptographic Security Development z/OS Enabling Technologies edros...@us.ibm.com -Original Message- From: IBM Mainframe Discussion List On Behalf Of Horacio Luis Villa Sent: Friday, June 3, 2022 5:32 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: New IBM Community Blog - ISPF List/Log Viewing I did that. It leads me to this page: https://community.ibm.com/community/user/blogs/lionel-dyck and I get "page not found" De: IBM Mainframe Discussion List en nombre de Eric D Rossman Enviado: viernes, 3 de junio de 2022 14:48 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Re: New IBM Community Blog - ISPF List/Log Viewing It was split across lines. Join the two lines and it works. Eric Rossman, CISSP ICSF Cryptographic Security Development z/OS Enabling Technologies edros...@us.ibm.com -Original Message- From: IBM Mainframe Discussion List On Behalf Of Horacio Luis Villa Sent: Friday, June 3, 2022 1:47 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: New IBM Community Blog - ISPF List/Log Viewing The link gives me Page not found. De: IBM Mainframe Discussion List en nombre de Lionel B. Dyck Enviado: viernes, 3 de junio de 2022 08:20 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] New IBM Community Blog - ISPF List/Log Viewing I think y'all will enjoy this new blog https://community.ibm.com/community/user/ibmz-and-linuxone/blogs/lionel-dyck 2/2022/06/02/ispf-list-and-log-improved-access Lionel B. Dyck <>< Website: https://www.lbdsoftware.com Github: https://github.com/lbdyck "Worry more about your character than your reputation. Character is what you are, reputation merely what others think you are." - - - John Wooden -- 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 -- 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: New IBM Community Blog - ISPF List/Log Viewing
I did that. It leads me to this page: https://community.ibm.com/community/user/blogs/lionel-dyck and I get "page not found" De: IBM Mainframe Discussion List en nombre de Eric D Rossman Enviado: viernes, 3 de junio de 2022 14:48 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Re: New IBM Community Blog - ISPF List/Log Viewing It was split across lines. Join the two lines and it works. Eric Rossman, CISSP ICSF Cryptographic Security Development z/OS Enabling Technologies edros...@us.ibm.com -Original Message- From: IBM Mainframe Discussion List On Behalf Of Horacio Luis Villa Sent: Friday, June 3, 2022 1:47 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: New IBM Community Blog - ISPF List/Log Viewing The link gives me Page not found. De: IBM Mainframe Discussion List en nombre de Lionel B. Dyck Enviado: viernes, 3 de junio de 2022 08:20 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] New IBM Community Blog - ISPF List/Log Viewing I think y'all will enjoy this new blog https://community.ibm.com/community/user/ibmz-and-linuxone/blogs/lionel-dyck 2/2022/06/02/ispf-list-and-log-improved-access Lionel B. Dyck <>< Website: https://www.lbdsoftware.com Github: https://github.com/lbdyck "Worry more about your character than your reputation. Character is what you are, reputation merely what others think you are." - - - John Wooden -- 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: New IBM Community Blog - ISPF List/Log Viewing
The link gives me Page not found. De: IBM Mainframe Discussion List en nombre de Lionel B. Dyck Enviado: viernes, 3 de junio de 2022 08:20 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] New IBM Community Blog - ISPF List/Log Viewing I think y'all will enjoy this new blog https://community.ibm.com/community/user/ibmz-and-linuxone/blogs/lionel-dyck 2/2022/06/02/ispf-list-and-log-improved-access Lionel B. Dyck <>< Website: https://www.lbdsoftware.com Github: https://github.com/lbdyck "Worry more about your character than your reputation. Character is what you are, reputation merely what others think you are." - - - John Wooden -- 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: Do you have an example of .......
Hi Willy, yes! that was the trick, I tried with ADDRESS SDSF but wasn't aware of ISFSLASH. I used '/D SMS, STORGRP(ALL)' and got the error, Thanks to you and Kolusu, Horacio De: IBM Mainframe Discussion List en nombre de Willy Jensen Enviado: martes, 17 de mayo de 2022 06:46 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Re: Do you have an example of ... Try this REXX using the SDSF API: zz=isfcalls('ON') Address SDSF ISFSLASH "'D SMS,STORGRP(ALL)' (WAIT)" cc=rc zz=isfcalls('OFF') if rc<>0 then say 'Console failed rc' cc else do n=1 to isfulog.0 say '->'isfulog.n end -- 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: Do you have an example of .......
Kolusu, thanks for you replay. I can execute the comand from SDSF, but have no console authority. Is there any other way? Horacio De: IBM Mainframe Discussion List en nombre de Sri h Kolusu Enviado: lunes, 16 de mayo de 2022 18:33 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Re: Do you have an example of ... >> I'd like to catch the output of an SMS command, like 'DISPLAY SMS, >> STORGRP(ALL), from REXX. Is that possible? Horacio, Try this /* rexx */ cmd='d sms,storgrp(all)' "console activate" "console syscmd("cmd")" mcode=getmsg('conmsg1.','sol',,,60) if conmsg1.0 = 0 then do say 'no message returned' return end else do i=1 to conmsg1.0 say conmsg1.i end conmsg1.0=0 "console deactivate" exit Thanks, Kolusu -- 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
Do you have an example of .......
Hi, I'd like to catch the output of an SMS command, like 'DISPLAY SMS, STORGRP(ALL), from REXX. Is that possible? I've tried some ideas with no luck. Thanks, Horacio De: IBM Mainframe Discussion List en nombre de Pommier, Rex Enviado: lunes, 16 de mayo de 2022 16:51 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: Re: [EXTERNAL] Re: IBM BLSR subsystem Thanks, all responders. Michael, so I'm not stuck in the mid '90s, just the BLSR documentation is. :-) "First Edition, June 1994" I have seen the references to BLSR in other documents, like a crypto manual and some SMP/E references to it, but until I found the 1994 document, I couldn't find anything that actually explained it. That's where I was getting confused. I'll also need to check the AMP parm to see if that does the same thing. The DEFERW=YES option looks interesting (again). Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Michael Oujesky Sent: Monday, May 16, 2022 2:23 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: IBM BLSR subsystem PDF - http://publibz.boulder.ibm.com/epubs/pdf/iea5j600.pdf BLSR will help principally if the access is random and the locality of reference of the data component is good. Otherwise, just increasing the BUFNI and/or BUFND will suffice. Note that for sequential access a BUFND of twice the CIs per CA plus two and just a few BUFNI five or so) usually provides about the best you can get (incudes over-lapping read I/O to the data component). I still see BLSR in the 2.5 IEFSSN00 member. Michael At 09:36 AM 5/16/2022, Pommier, Rex wrote: >Hi list, > >Is the BLSR subsystem (batch local shared resources) still a >viable/valuable thing or has it been replaced by something >bigger/better/faster? I seem to be stuck in the mid-90s because the >most current documentation I can find on it is from MVS/ESA 5.1 dated >1994. Is there more current documentation on how to use it and how it >works? Has it been replaced and deprecated? I just had a developer >use it last week and experienced a 40+ reduction in I/Os but I wanted >to read up on its limitations - especially around using it on a shared >VSAM dataset. However I can't find anything newer >than 25+ years old. I did multiple internet searches which is >where I found the ESA manual. I checked the knowledge center and my >own z/OS 2.2 and 2.4 collections all to no avail. > >Thanks, > >Rex -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- 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: Using SORT to add quotes around CHAR fields? (Listserv)
Hi, the last 3 columns are CHAR but you don't want them quoted? Don't know how to do it using SORT. I'd do it with Rexx. De: IBM Mainframe Discussion List en nombre de Don Johnson <02ee771a0785-dmarc-requ...@listserv.ua.edu> Enviado: miércoles, 23 de marzo de 2022 17:46 Para: IBM-MAIN@LISTSERV.UA.EDU Asunto: [EXTERNAL] Using SORT to add quotes around CHAR fields? (Listserv) This is a post now to the listserv, instead of the Google group. Sorry for the duplication! Hi, I have a comma-delimited extract from a file that has numeric and character fields, and I would like to turn it into a true CSV file by making the character fields quoted. I have a 2-line header (column names, and column types) which indicates which are CHAR fields, but cannot figure out how to capture the information from the header to apply to the actual data lines. For example, I have this in my file: ITM_ID,DESC,SHORT_DESC,U_M,UNIT_PRICE,ON_HAND,COMMIT,INV_HOLD,DISC_QTY,DISC_PCT,B_O_QTY,ON_ORD,ACT_YR,ACT_MO,ACT_DAY CHAR(10) N.N.,CHAR(30) NOT NULL,CHAR(8) N.N.,CHAR(4) N.N.,DEC(7,2) N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(1) N.N.,DEC(7,0) N.N.,DEC(3,1) N.N.,DEC(7,0) N.N.,DEC(7,0) N.N.,CHAR(2) N.N.,CHAR(2) N.N.,CHAR(2) N.N. A1,CARPETED RUBBER MATS-FRONT-RED,FLOORMAT,PAIR,22.99,135,205,Y,5000,1.5,0,0,87,02,02 A10001,CARPETED RUBBER MATS-REAR(RED),FLOORMAT,PAIR,12.99,277,14,N,250,1.5,0,0,86,02,20 A10002,PERSONALIZED VINYL MATS(BEIGE),FLOORMAT,PAIR,19.99,296,7,N,250,1.5,0,0,87,02,03 A10003,4-PIECE CARPET MAT SET (BLUE),MAT SET,SET,19.99,275,2,N,250,1.5,0,0,87,02,03 A10004,SPLASH GUARDS-ALUMINUM,SPLSHGRD,PAIR,8.99,523,55,N,500,1.5,0,0,87,02,03 A10005,SPLASH GUARDS-VINYL,SPLSHGRD,PAIR,8.99,550,25,N,500,1.5,0,0,87,02,03 A10006,MONOGRAMMED SPLASH GUARDS,SPLSHGRD,PAIR,11.99,300,0,N,250,1.5,0,0,86,02,20 and want the output to look like this: "A1","CARPETED RUBBER MATS-FRONT-RED","FLOORMAT","PAIR",22.99,135,205,"Y",5000,1.5,0,0,87,02,02 "A10001","CARPETED RUBBER MATS-REAR(RED)","FLOORMAT","PAIR",12.99,277,14,"N",250,1.5,0,0,86,02,20 "A10002","PERSONALIZED VINYL MATS(BEIGE)","FLOORMAT","PAIR",19.99,296,7,"N",250,1.5,0,0,87,02,03 "A10003","4-PIECE CARPET MAT SET (BLUE)","MAT SET","SET",19.99,275,2,"N",250,1.5,0,0,87,02,03 "A10004","SPLASH GUARDS-ALUMINUM","SPLSHGRD","PAIR",8.99,523,55,"N",500,1.5,0,0,87,02,03 "A10005","SPLASH GUARDS-VINYL","SPLSHGRD","PAIR",8.99,550,25,"N",500,1.5,0,0,87,02,03 "A10006","MONOGRAMMED SPLASH GUARDS","SPLSHGRD","PAIR",11.99,300,0,"N",250,1.5,0,0,86,02,20 Is there a way to see which column type contains CHAR( -- each of the types is column separated -- and then be able to apply quotes to that particular output field? I am not sure about this, but hope there is an answer here. Thank you for your help! Don Johnson Sr. Principal Support Engineer | MSD - Datacom product family Broadcom Software -- 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