Re: SDSF ISFEXEC issue - help (please)

2022-08-29 Thread Horacio Luis Villa
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?

2022-08-23 Thread Horacio Luis Villa
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

2022-06-15 Thread Horacio Luis Villa
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

2022-06-03 Thread Horacio Luis Villa
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

2022-06-03 Thread Horacio Luis Villa
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

2022-06-03 Thread Horacio Luis Villa
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 .......

2022-05-17 Thread Horacio Luis Villa
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 .......

2022-05-16 Thread Horacio Luis Villa
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 .......

2022-05-16 Thread Horacio Luis Villa
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)

2022-03-23 Thread Horacio Luis Villa
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