Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Amr@Systemz]

 Are the apps and data moving to the cloud ? The production data needs to go 
somewhere for the business to function. Sqlite is a good option. On 
Wednesday, February 8, 2023, 11:45:10 AM PST, Tom Longfellow 
<03e29b607131-dmarc-requ...@listserv.ua.edu> wrote:  
 
 Not dumb at all.    I am between a rock and a hard place.

NO resources on any servers anywhere will be committed to the preservation of 
data.
The Mainframe will be powered off 6 months after the last primary application 
has left the building.

Usability of the exported data is not managements concern.  User requests are 
not important.  ALL DATA MUST GO

--
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: Goodbye and thanks for all the fish

[Wayne Bickerdike]

Condolences Rebecca on your loss.

On Thu, Feb 9, 2023 at 12:22 PM Jeremy Nicoll 
wrote:

> On Wed, 8 Feb 2023, at 20:15, Wayne Bickerdike wrote:
> > I retired in 2021 but I still maintain an interest here. Good for the
> brain
> > cells.
>
> I couldn't agree more.  It always saddens me to see people saying byebye
> here.
>
> Ill-health forced me to stop work in March 2000, but I was never given time
> at work to use groups like this - always did so in my own time, and I'm
> still
> here (and on many other computing mail lists, eg for OSes and products I
> have never used but their discussions interest me).
>
> Here, there's more and more discussions that I couldn't usefully contribute
> to, but it is still INTERESTING, so I'm staying.
>
> (I did a Computer Science degree in the early 1980s, then worked as an
> applications programmer in a VM/CMS site (& also with BBC micros), then
> became a trainee MVS sysprog, and in due course a more senior one, then
> moved sideways to run a small ops/systems-focussed programming team,
> at a UK bank.)
>
> --
> Jeremy Nicoll - my opinions are my own.
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


-- 
Wayne V. Bickerdike

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ISPF macro/script

[Paul Gilmartin]

On Thu, 9 Feb 2023 01:27:25 +, Jeremy Nicoll wrote:

>On Tue, 7 Feb 2023, at 16:40, Paul Gilmartin wrote:
>...
>> address ISREDIT "line_after .zl = (TemplateLine.L)"
>
>Yes, but the only fractionally different
>
>do L = 1 to TemplateLine.0
>newline = TemplateLine.L
>address ISREDIT "line_after .zl = (newline)"
>end L
> 
But why should that additional assignment be required, other than
the designers' contempt for other languages?

-- 
gil

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ISPF macro/script

[Jeremy Nicoll]

On Tue, 7 Feb 2023, at 16:40, Paul Gilmartin wrote:

> For some chores similar to this it's a crying shame that ISPF shuns
> compound symbols:
>
> /* Suppose the content to insert is in stem TemplateLine.  */
> do L = 1 to TemplateLine.0
> address ISREDIT "line_after .zl = (TemplateLine.L)"
> end L

Yes, but the only fractionally different 

do L = 1 to TemplateLine.0
newline = TemplateLine.L
address ISREDIT "line_after .zl = (newline)"
end L

will surely work?

-- 
Jeremy Nicoll - my opinions are my own.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Goodbye and thanks for all the fish

[Jeremy Nicoll]

On Wed, 8 Feb 2023, at 20:15, Wayne Bickerdike wrote:
> I retired in 2021 but I still maintain an interest here. Good for the brain
> cells.

I couldn't agree more.  It always saddens me to see people saying byebye
here.

Ill-health forced me to stop work in March 2000, but I was never given time
at work to use groups like this - always did so in my own time, and I'm still
here (and on many other computing mail lists, eg for OSes and products I
have never used but their discussions interest me).

Here, there's more and more discussions that I couldn't usefully contribute
to, but it is still INTERESTING, so I'm staying.

(I did a Computer Science degree in the early 1980s, then worked as an
applications programmer in a VM/CMS site (& also with BBC micros), then
became a trainee MVS sysprog, and in due course a more senior one, then
moved sideways to run a small ops/systems-focussed programming team,
at a UK bank.)

-- 
Jeremy Nicoll - my opinions are my own.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Goodbye and thanks for all the fish

[Seymour J Metz]

My condolences.


From: IBM Mainframe Discussion List  on behalf of 
Rebecca Richards <049eeae74309-dmarc-requ...@listserv.ua.edu>
Sent: Wednesday, February 8, 2023 6:51 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Goodbye and thanks for all the fish

Hi All,
This is Rebecca Richards. My husband Robert Richards has been an member of this 
list for many years.I just wanted let you know he died of bladder cancer this 
past Friday. I wanted to let everyone know
Rebecca Richards


Sent from Yahoo Mail for iPad


On Wednesday, February 8, 2023, 3:17 PM, Wayne Bickerdike  
wrote:

I retired in 2021 but I still maintain an interest here. Good for the brain
cells.

Managed to lose 3Kgs and reduce my blood pressure :)

On Thu, Feb 9, 2023 at 2:11 AM Steve Thompson  wrote:

> Sorry to see you go. And I too am not a very active member. I
> read a lot and learn stuff.
>
> Hope you enjoy your retirement. Or, un-retirement if that is what
> you wish.
>
> Regards,
> Steve Thompson
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


--
Wayne V. Bickerdike

--
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: Goodbye and thanks for all the fish

[August Carideo]

Very sorry for your loss

Get Outlook for iOS

From: IBM Mainframe Discussion List  on behalf of 
Rebecca Richards <049eeae74309-dmarc-requ...@listserv.ua.edu>
Sent: Wednesday, February 8, 2023 6:51:32 PM
To: IBM-MAIN@LISTSERV.UA.EDU 
Subject: Re: Goodbye and thanks for all the fish

Hi All,
This is Rebecca Richards. My husband Robert Richards has been an member of this 
list for many years.I just wanted let you know he died of bladder cancer this 
past Friday. I wanted to let everyone know
Rebecca Richards


Sent from Yahoo Mail for iPad


On Wednesday, February 8, 2023, 3:17 PM, Wayne Bickerdike  
wrote:

I retired in 2021 but I still maintain an interest here. Good for the brain
cells.

Managed to lose 3Kgs and reduce my blood pressure :)

On Thu, Feb 9, 2023 at 2:11 AM Steve Thompson  wrote:

> Sorry to see you go. And I too am not a very active member. I
> read a lot and learn stuff.
>
> Hope you enjoy your retirement. Or, un-retirement if that is what
> you wish.
>
> Regards,
> Steve Thompson
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


--
Wayne V. Bickerdike

--
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: Goodbye and thanks for all the fish

[Rebecca Richards]

Hi All,
This is Rebecca Richards. My husband Robert Richards has been an member of this 
list for many years.I just wanted let you know he died of bladder cancer this 
past Friday. I wanted to let everyone know 
Rebecca Richards


Sent from Yahoo Mail for iPad


On Wednesday, February 8, 2023, 3:17 PM, Wayne Bickerdike  
wrote:

I retired in 2021 but I still maintain an interest here. Good for the brain
cells.

Managed to lose 3Kgs and reduce my blood pressure :)

On Thu, Feb 9, 2023 at 2:11 AM Steve Thompson  wrote:

> Sorry to see you go. And I too am not a very active member. I
> read a lot and learn stuff.
>
> Hope you enjoy your retirement. Or, un-retirement if that is what
> you wish.
>
> Regards,
> Steve Thompson
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


-- 
Wayne V. Bickerdike

--
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: RACF - SDSF question

[Ed Jaffe]

On 2/8/2023 3:10 PM, Lennie Dymoke-Bradshaw wrote:

Ed,


We have NO discrete profiles, but we do have generic profiles with no wildcard 
characters in them.

You can do that with profiles in the DATASET class but I don't think you can do 
it with general classes.


Good point. I should have said we have NO discrete profiles in the 
DATASET class... :-[



--
Phoenix Software International
Edward E. Jaffe
831 Parkview Drive North
El Segundo, CA 90245
https://www.phoenixsoftware.com/



This e-mail message, including any attachments, appended messages and the
information contained therein, is for the sole use of the intended
recipient(s). If you are not an intended recipient or have otherwise
received this email message in error, any use, dissemination, distribution,
review, storage or copying of this e-mail message and the information
contained therein is strictly prohibited. If you are not an intended
recipient, please contact the sender by reply e-mail and destroy all copies
of this email message and do not otherwise utilize or retain this email
message or any or all of the information contained therein. Although this
email message and any attachments or appended messages are believed to be
free of any virus or other defect that might affect any computer system into
which it is received and opened, it is the responsibility of the recipient
to ensure that it is virus free and no responsibility is accepted by the
sender for any loss or damage arising in any way from its opening or use.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: RACF - SDSF question

[Lennie Dymoke-Bradshaw]

Ed,

> We have NO discrete profiles, but we do have generic profiles with no 
> wildcard characters in them.

You can do that with profiles in the DATASET class but I don't think you can do 
it with general classes. 
There is no GENERIC parameter on the RDEFINE command. 
Or do you use some local code to achieve this?

Lennie

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Ed 
Jaffe
Sent: 08 February 2023 02:32
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: RACF - SDSF question

On 2/7/2023 5:14 PM, Seymour J Metz wrote:
> Generic is usually more useful, but you can certainly use specific profiles.

Even discrete profiles can be made generic by specifying GENERIC when created.

That's what we do here. We have NO discrete profiles, but we do have generic 
profiles with no wildcard characters in them.


-- 
Phoenix Software International
Edward E. Jaffe
831 Parkview Drive North
El Segundo, CA 90245
https://www.phoenixsoftware.com/



This e-mail message, including any attachments, appended messages and the
information contained therein, is for the sole use of the intended
recipient(s). If you are not an intended recipient or have otherwise
received this email message in error, any use, dissemination, distribution,
review, storage or copying of this e-mail message and the information
contained therein is strictly prohibited. If you are not an intended
recipient, please contact the sender by reply e-mail and destroy all copies
of this email message and do not otherwise utilize or retain this email
message or any or all of the information contained therein. Although this
email message and any attachments or appended messages are believed to be
free of any virus or other defect that might affect any computer system into
which it is received and opened, it is the responsibility of the recipient
to ensure that it is virus free and no responsibility is accepted by the
sender for any loss or damage arising in any way from its opening or use.

--
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: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Marchant]

I would think that the auditors or the lawyers might not agree with management.

-- 
Tom Marchant

On Wed, 8 Feb 2023 13:44:58 -0600, Tom Longfellow 
 wrote:

>NO resources on any servers anywhere will be committed to the preservation of 
>data.
>The Mainframe will be powered off 6 months after the last primary application 
>has left the building.
>
>Usability of the exported data is not managements concern.  User requests are 
>not important.   ALL DATA MUST GO

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: JCL Procedure help

[Seymour J Metz]

My reading i that he wants to restrict JCL changes to the PROC.


From: IBM Mainframe Discussion List  on behalf of 
Paul Gilmartin <042bfe9c879d-dmarc-requ...@listserv.ua.edu>
Sent: Wednesday, February 8, 2023 3:31 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: JCL Procedure help

On Wed, 8 Feb 2023 14:14:47 +, Seymour J Metz  wrote:
>...
> 2. Make SYSIN in the swecond step a backwards reference to SYSIN in the first 
> step. I'm not sure whether that will work.
>
How about:
//JOBSTEP  EXEC  MYPROC
//STEP2.SYSIN  DD  *

(as in: 
)

But is this a case where the requestor wants "Make it work without making
the necessary changes"?

--
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: JES2 PURGEd output

[Pommier, Rex]

BTW, we don't have SDSF, we have a competitor called Automon from Macro4.

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Pommier, Rex
Sent: Wednesday, February 8, 2023 2:37 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: [EXTERNAL] JES2 PURGEd output

Greetings list,

I just had a strange one tossed at me and my first inclination is to tell the 
person "no, it isn't possible", but thought I'd check the combined expertise of 
the list first.  

We all know that a job's output in JES2 consists of multiple output groups.  If 
one output element for instance gets printed and the disposition of that 
element is purge after printing, it no longer shows up in the held or output 
queue.  It is however viewable using STatus, until the entire job output is 
purged, at which pint the job is finally deleted.  Is there a way of retrieving 
an output that has been sent to the purge queue with just a JES2 command or 
such?  I know I can pull up the piece of output in SDSF and "reprint" it to 
another job but I'm looking to change "queue=purge" to "queue=hold" for an 
output group.

TIA,
Rex

--
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

--
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

JES2 PURGEd output

[Pommier, Rex]

Greetings list,

I just had a strange one tossed at me and my first inclination is to tell the 
person "no, it isn't possible", but thought I'd check the combined expertise of 
the list first.  

We all know that a job's output in JES2 consists of multiple output groups.  If 
one output element for instance gets printed and the disposition of that 
element is purge after printing, it no longer shows up in the held or output 
queue.  It is however viewable using STatus, until the entire job output is 
purged, at which pint the job is finally deleted.  Is there a way of retrieving 
an output that has been sent to the purge queue with just a JES2 command or 
such?  I know I can pull up the piece of output in SDSF and "reprint" it to 
another job but I'm looking to change "queue=purge" to "queue=hold" for an 
output group.

TIA,
Rex

--
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

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Walt Farrell]

On Wed, 8 Feb 2023 14:31:02 -0600, Tom Longfellow 
 wrote:

>Excellent procedure and approach.   And a good path to maybe resurrecting the 
>application someday.
>
>I am still trying to sell the concept that a successful migration consists of 
>not only the data, But a least someway to CRUD (Create, Replace, Update, 
>Delete) data items.   PLUS in the relational case, the logical relationships 
>that link items that links things like invoices to users to addresses to 
>payments and who knows what else.   They are really going to miss their SQL 
>retrievals

If you can offload it to CSV (as instructed) and also to some kind of archival 
form that can be reloaded into SQLite (or other relational form) then when the 
users eventually revolt and management wakes up, you'll have something that can 
be restored to a usable form and satisfy the users (and the management that 
survives the revolt).

-- 
Walt

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: JCL Procedure help

[Gibney, Dave]

Add a new first step. Which reads the SYSIN and passes it to the function (now 
3rd) step

> -Original Message-
> From: IBM Mainframe Discussion List  On
> Behalf Of Gadi Ben-Avi
> Sent: Wednesday, February 8, 2023 4:45 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: JCL Procedure help
> 
> [EXTERNAL EMAIL]
> 
> Hi,
> I was asked to modify a procedure.
> Currently, the procedure has one step.
> This step receives input from SYSIN DD *
> 
> I was asked to add a step that would check that the JOB is running on the
> correct LPAR.
> I wrote a small REXX program that check the LPAR, and returns condition code
> 8 if it's not running on the correct LPAR.
> I then added an if statement that will run the original step if the previous
> condition code is 0, and if not will issue a message.
> 
> The problem is that now the SYSIN DD is allocated to the first step.
> I know I can code STEP.SYSIN to associate the SYSIN with correct step, but was
> wondering if there a way to code the procedure in a way so that I won't
> require changing the way the procedure is used.
> 
> We are running z/OS v2.3
> 
> Gadi
> 
> 
> --
> 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: JCL Procedure help

[Paul Gilmartin]

On Wed, 8 Feb 2023 14:14:47 +, Seymour J Metz  wrote:
>...
> 2. Make SYSIN in the swecond step a backwards reference to SYSIN in the first 
> step. I'm not sure whether that will work.
>
How about:
//JOBSTEP  EXEC  MYPROC
//STEP2.SYSIN  DD  *

(as in: )

But is this a case where the requestor wants "Make it work without making
the necessary changes"?

-- 
gil

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Longfellow]

Excellent procedure and approach.   And a good path to maybe resurrecting the 
application someday.

I am still trying to sell the concept that a successful migration consists of 
not only the data, But a least someway to CRUD (Create, Replace, Update, 
Delete) data items.   PLUS in the relational case, the logical relationships 
that link items that links things like invoices to users to addresses to 
payments and who knows what else.   They are really going to miss their SQL 
retrievals

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Goodbye and thanks for all the fish

[Wayne Bickerdike]

I retired in 2021 but I still maintain an interest here. Good for the brain
cells.

Managed to lose 3Kgs and reduce my blood pressure :)

On Thu, Feb 9, 2023 at 2:11 AM Steve Thompson  wrote:

> Sorry to see you go. And I too am not a very active member. I
> read a lot and learn stuff.
>
> Hope you enjoy your retirement. Or, un-retirement if that is what
> you wish.
>
> Regards,
> Steve Thompson
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


-- 
Wayne V. Bickerdike

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: TEAMS usage

[Rony G Flatscher]

Well, it is interesting to see how companies (actually the management) who have 
a need of secrecy and privacy shelter take it for granted that other companies 
become able to spy on them rather easily. 

Conference meetings allow at least for learning about who is meeting with whom 
how often abut what subjects, what messages (and information like urls) go via 
the conference-linked chats,  get exchanged in which context with whom and with 
what other companies. 

Add to that the great ability to automatically record what is spoken, use the 
great feature of automatically transcribing everything and you have arrived in 
a world which makes look Orwell‘s 1984 a stoneage tale, laughable.

Add to that having become able to store everything for decades, reanalyzing 
stored information with the latest anslysis tools, many AI based, over and over 
again.

Conference managing companies become able to arrive automatically at 
intelligence (better, faster than humans could come up with): no 
self-controlled, self-determined company or organisation, no goverment 
(administration) could have the slightest interest for such a catastrophic 
reality.

This is probably only possible because most companies are run by managers who 
have no clues with respect to IT, being dilettants who enjoy excercising power 
on IT issues believing that that makes them more competent with respect to 
their managing abilities, not realizing how much damage they may cause to the 
companies they run. 

For such managers it is sufficient that managers of other companies do rhe 
same, such that they can proof their professionality. If a problem shows up, it 
is not their individual fault, individual responsibility, but an „unforseeable“ 
 unfortunate event the entire industry faces. 

Just witness how IT-dilettant managers (in the 21st century!) take decisions 
against mainframes and infrastructures without being able to assess the impact 
cost-wise and organisation-wise. Just read about many of the wrong going 
migration attempts. 

Being able to operate a smartphone or pad does not make people, managers IT 
experts although many feel that to be the case. :)

Rant off.

Use non-surveilled conference software for your needs. Try with your 
(professional) friends or family something like the Jitsi conference software.

Try it out, go to https://meet.jit.si enter some string and share the resulting 
url and everyone is able to immediately join a meeting/conference.

It takes 10 seconds to set up plus a sms, message or email with the Jitsi link 
to join.

I do this with all meetings I control, with friends, colleagues, with students, 
with family (scattered literally over the goibe).

You as IT professionals should have tried Jitsi at least once! :)

Lookup Wikipedia about Jitsi or BigBlue Button and then reason why any 
management of a company with an IT department would use commercial and 
expensive conference companies when they can set up a fully and self-controlled 
conference system for free!

Jitsi and BigBlueButton are open-source, maintained, stable, powerful and best: 
totally transparent, not surveilled and free.

Try it out, go to: https://meet.jit.si and create your first self-controlled 
meeting in ten seconds! :)

—-rony

Rony G. Flatscher (mobil/e)

> Am 08.02.2023 um 19:55 schrieb Tony Harminc :
> 
> On Wed, 8 Feb 2023 at 13:34, Steve Thompson  wrote:
>> 
>> Kind of a rant, but more making a point.
>> 
>> Teams via browser means you have to have an M/S account because
>> your data is in someone else's data center (isn't that a Cloud?
>> ;-) ). Or to put this another way, someone has to have an account
>> so that you can get access via Teams in my experience.
> 
> You don't have to have an MS account to be a guest at a Teams meeting.
> To be sure I just now tried this myself using Firefox, and joined a
> Teams meeting I hosted using my work Teams account. It worked fine.
> The host may have rules that prohibit you from joining anonymously,
> and as always Microsft has all kinds of dark patterns to "encourage"
> you to hand over as much information as they can extract from you, but
> basically it works.
> 
> None of these services MS Teams, Google Meets, Zoom, or any of the
> second tier ones offer anonymity or true end-to-end encryption. All of
> them will collect as much personal data about you as they possibly
> can.
> 
> If you want a good degree of privacy on an audio/video call, use
> Signal. For that matter use Signal anyway. Yes you have to install an
> app, but it's open source and run by a charitable foundation rather
> than a for-profit company.
> 
> Tony H.
> 
> --
> 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 li

Re: TEAMS usage

[Wayne Bickerdike]

I opened Teams yesterday and saw a notice that MSFT are removing the free
version effective April.

I've just cancelled my auto renewal on Office 365, I don't really need it
as there are cheaper alternatives.

On Thu, Feb 9, 2023 at 6:31 AM Carmen Vitullo  wrote:

> +1  :)
>
> uselessness of the meeting.
> Carmen
>
> On 2/8/2023 1:21 PM, John McKown wrote:
> > I use Teams at work on Windows 10 a couple of times a week. No problems
> > beyond the uselessness of the meeting.
> >
> > On Wed, Feb 8, 2023, 11:53 Tony Harminc  wrote:
> >
> >> On Wed, 8 Feb 2023 at 10:07, Steve Thompson  wrote:
> >>> Not everyone runs Windows or a Mac.
> >>>
> >>> I installed Teams on my Linux desktop and did a reboot (since
> >>> this is M/S software). Upon starting Teams, it promptly crashed
> >>> KDE, requiring a reboot. Which resulted in me doing an immediate
> >>> uninstall.
> >>>
> >>> So I was forced to get a Windows laptop just to run the in vogue
> >>> software. Why? because I can't seem to acquire W10 so I can run
> >>> it under Virtual Box.
> >> [...]
> >>
> >> I'm unclear if you're looking for a "solution" or just want to rant
> >> (not unjustified). In my experience Teams runs OK in a browser,
> >> without requiring a Windows-based app to assist it. There were
> >> problems with Firefox but MS and Mozilla seem to have made it work in
> >> recent times. The same has been true of Google Meet. Certainly
> >> performance is better with the MS app, and they are forever trying to
> >> push you to use it, but most features do work directly in the browser.
> >>
> >> Did you try joining your meeting in FF, and refusing any attempts to
> >> get you to "upgrade" to an app?
> >>
> >> Tony H.
> >>
> >> --
> >> 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
> --
> Carmen
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


-- 
Wayne V. Bickerdike

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Wayne Bickerdike]

UNLOAD TABLESPACE with COLDEL to specify column delimiter.

You can perform UNLOAD from an image copy. I expect you will have access to
these.

Plenty of REXX code out there to read the DB2 catalog and build utility
statements.

On Thu, Feb 9, 2023 at 6:55 AM Lionel B. Dyck  wrote:

> Document your concerns so that a month after the shutdown when someone
> important wants the information you can produce it.
>
>
> 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
>
> -Original Message-
> From: IBM Mainframe Discussion List  On Behalf
> Of Tom Longfellow
> Sent: Wednesday, February 8, 2023 1:53 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: The Local death of DB2 z/OS --- what is the best way to
> preserve the data once the mainframe is gone
>
> Thanks to both you and Lionel.
>
> My barrier is that they are not looking to send or support any 'usable'
> target database (SQLliet or other relational models) They do not even
> understand that a "data dump"  in no way preserves the relationship between
> relational tables.
>
> It is all "Damn the torpedoes, Dead mainframe ahead"
>
> --
> 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
>


-- 
Wayne V. Bickerdike

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Longfellow]

Done and Done.   And my thoughts are well known during status and planning 
discussions.
The current attitude is to just have me shut up.
After all, the users think CSV files solve everything.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Gibney, Dave]

I recently shutdown our mainframe. We used various means to preserve the data. 
Most was exported using a SAG tool that we already had. Connx.
Don't forget your source code : ) We ftped to Windows files. For reference only
As a final, break glass in an emergency, we shipped some files to Windows via 
binary ftp. There are tools that can read EBCDIC : )

Our people even created OBIEE reports to access the exported data that 
resembled the previous green query screens.


> -Original Message-
> From: IBM Mainframe Discussion List  On
> Behalf Of Tom Longfellow
> Sent: Wednesday, February 8, 2023 11:56 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: The Local death of DB2 z/OS --- what is the best way to preserve
> the data once the mainframe is gone
> 
> [EXTERNAL EMAIL]
> 
> Thanks, but we are familiar enough with those tools and should not need a
> sample.
> 
> I am starting to believe that no matter how I create the "Flat File Swamp"  it
> will no longer be able to serve its original purpose ever again.
> 
> --
> 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: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Longfellow]

Not exactly.   When the mainframe dies  I will never see that data again.   It 
may go to the Heaven (or Hell) of server farms if I can find salvation for it.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[ITschak Mugzach]

Printing is what a client of us did in the last few month to save screens
to pdf. IMs was abending all time so we helped them to restore IMs state to
enable restart from last screen. It tol them six month.
The Rex I am offering for free will load the data anywhere you like,
including csv.

ITschak

בתאריך יום ד׳, 8 בפבר׳ 2023 ב-21:52 מאת Gibney, Dave's <
03b5261cfd78-dmarc-requ...@listserv.ua.edu>:

> Print it and be done :)
>
> > -Original Message-
> > From: IBM Mainframe Discussion List  On
> > Behalf Of Tom Longfellow
> > Sent: Wednesday, February 8, 2023 11:45 AM
> > To: IBM-MAIN@LISTSERV.UA.EDU
> > Subject: Re: The Local death of DB2 z/OS --- what is the best way to
> preserve
> > the data once the mainframe is gone
> >
> > [EXTERNAL EMAIL]
> >
> > Not dumb at all.I am between a rock and a hard place.
> >
> > NO resources on any servers anywhere will be committed to the
> preservation
> > of data.
> > The Mainframe will be powered off 6 months after the last primary
> application
> > has left the building.
> >
> > Usability of the exported data is not managements concern.  User
> requests are
> > not important.   ALL DATA MUST GO
> >
> > --
> > 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
>
-- 
ITschak Mugzach
*|** IronSphere Platform* *|* *Information Security Continuous Monitoring
for z/OS, x/Linux & IBM I **| z/VM coming soon  *

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Longfellow]

Thanks, but we are familiar enough with those tools and should not need a 
sample.

I am starting to believe that no matter how I create the "Flat File Swamp"  it 
will no longer be able to serve its original purpose ever again.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Lionel B. Dyck]

Document your concerns so that a month after the shutdown when someone 
important wants the information you can produce it.


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

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Tom 
Longfellow
Sent: Wednesday, February 8, 2023 1:53 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: The Local death of DB2 z/OS --- what is the best way to preserve 
the data once the mainframe is gone

Thanks to both you and Lionel.

My barrier is that they are not looking to send or support any 'usable' target 
database (SQLliet or other relational models) They do not even understand that 
a "data dump"  in no way preserves the relationship between relational tables.

It is all "Damn the torpedoes, Dead mainframe ahead"

--
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: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Carmen Vitullo]

:) - you'll always have the data

Carmen

On 2/8/2023 1:52 PM, Gibney, Dave wrote:

Print it and be done :)


-Original Message-
From: IBM Mainframe Discussion List  On
Behalf Of Tom Longfellow
Sent: Wednesday, February 8, 2023 11:45 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: The Local death of DB2 z/OS --- what is the best way to preserve
the data once the mainframe is gone

[EXTERNAL EMAIL]

Not dumb at all.I am between a rock and a hard place.

NO resources on any servers anywhere will be committed to the preservation
of data.
The Mainframe will be powered off 6 months after the last primary application
has left the building.

Usability of the exported data is not managements concern.  User requests are
not important.   ALL DATA MUST GO

--
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

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Longfellow]

Thanks to both you and Lionel.

My barrier is that they are not looking to send or support any 'usable' target 
database (SQLliet or other relational models)
They do not even understand that a "data dump"  in no way preserves the 
relationship between relational tables.

It is all "Damn the torpedoes, Dead mainframe ahead"

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Gibney, Dave]

Print it and be done :)

> -Original Message-
> From: IBM Mainframe Discussion List  On
> Behalf Of Tom Longfellow
> Sent: Wednesday, February 8, 2023 11:45 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: The Local death of DB2 z/OS --- what is the best way to preserve
> the data once the mainframe is gone
> 
> [EXTERNAL EMAIL]
> 
> Not dumb at all.I am between a rock and a hard place.
> 
> NO resources on any servers anywhere will be committed to the preservation
> of data.
> The Mainframe will be powered off 6 months after the last primary application
> has left the building.
> 
> Usability of the exported data is not managements concern.  User requests are
> not important.   ALL DATA MUST GO
> 
> --
> 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: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Lionel B. Dyck]

What about 
https://www.ibm.com/docs/en/db2/10.5?topic=overviews-db2-database-linux-unix-windows


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

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Tom 
Longfellow
Sent: Wednesday, February 8, 2023 1:48 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: The Local death of DB2 z/OS --- what is the best way to preserve 
the data once the mainframe is gone

Long time user of Data Capture here.   It is the core engine used during the 
extremely slow transition from evil IMS/CICS environment to the Holy land of 
"any where else"

That would be a good idea if you want to preserve access.The major DB2 
application has been officially migrated to another platform...   But the 30 
users of the existing system still want to do what they have always done, the 
way they have always done it

--
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: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Longfellow]

Long time user of Data Capture here.   It is the core engine used during the 
extremely slow transition from evil IMS/CICS environment to the Holy land of 
"any where else"

That would be a good idea if you want to preserve access.The major DB2 
application has been officially migrated to another platform...   But the 30 
users of the existing system still want to do what they have always done, the 
way they have always done it

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Joe Monk]

1. Right click on Table, select Data > Return all Rows..

2. Result will be displayed in 'SQL Results' view, in the Result1 tab

3. Right click on data (not column heading) any where and select Export >
All Results

4. Select the CSV file format in the wizard and then save the file

5. You will have Column Names / Headings in the result

Joe

On Wed, Feb 8, 2023 at 1:45 PM Tom Longfellow <
03e29b607131-dmarc-requ...@listserv.ua.edu> wrote:

> Not dumb at all.I am between a rock and a hard place.
>
> NO resources on any servers anywhere will be committed to the preservation
> of data.
> The Mainframe will be powered off 6 months after the last primary
> application has left the building.
>
> Usability of the exported data is not managements concern.  User requests
> are not important.   ALL DATA MUST GO
>
> --
> 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: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Longfellow]

Not dumb at all.I am between a rock and a hard place.

NO resources on any servers anywhere will be committed to the preservation of 
data.
The Mainframe will be powered off 6 months after the last primary application 
has left the building.

Usability of the exported data is not managements concern.  User requests are 
not important.   ALL DATA MUST GO

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Lance D. Jackson]

Tom,

The problem w/ using Data Studio to extract data into a CSV is that you have to 
do it on a table-by-table basis, which is impractical for what you need to do.

DBeaver, on the other hand, allows you to export multiple tables at a time (per 
schema).  I hope this helps.

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Tom 
Longfellow
Sent: Wednesday, February 8, 2023 12:12
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: The Local death of DB2 z/OS --- what is the best way to preserve the 
data once the mainframe is gone

The death warrant on our DB2 for z/OS has been issued.

The people with decades of data stored in the tables are asking the obvious 
questions.How do we see into our ancient history as we have always done?   
My answer is simple: you can't.

The all knowledgeable planners have come up with the idea of  Extract it into 
CSV files and walk away.   I have many concerns about this process that I will 
not go into now.

As a good little worker Bee, I am trying to do what I am told.   Here is where 
the fun begins.  My good friend Google (and IBM) says 'Use IBM Data Studio to 
perform the Extract to CSV utility function.  My installed version of IBM Data 
Studio (V4.1.3)  does NOT have that option in the menus displayed by the 
documentation.

Does anyone have a workable way to Extract DB2 Tables to CSV files?

--
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: TEAMS usage

[Carmen Vitullo]

+1  :)

uselessness of the meeting.
Carmen

On 2/8/2023 1:21 PM, John McKown wrote:

I use Teams at work on Windows 10 a couple of times a week. No problems
beyond the uselessness of the meeting.

On Wed, Feb 8, 2023, 11:53 Tony Harminc  wrote:


On Wed, 8 Feb 2023 at 10:07, Steve Thompson  wrote:

Not everyone runs Windows or a Mac.

I installed Teams on my Linux desktop and did a reboot (since
this is M/S software). Upon starting Teams, it promptly crashed
KDE, requiring a reboot. Which resulted in me doing an immediate
uninstall.

So I was forced to get a Windows laptop just to run the in vogue
software. Why? because I can't seem to acquire W10 so I can run
it under Virtual Box.

[...]

I'm unclear if you're looking for a "solution" or just want to rant
(not unjustified). In my experience Teams runs OK in a browser,
without requiring a Windows-based app to assist it. There were
problems with Firefox but MS and Mozilla seem to have made it work in
recent times. The same has been true of Google Meet. Certainly
performance is better with the MS app, and they are forever trying to
push you to use it, but most features do work directly in the browser.

Did you try joining your meeting in FF, and refusing any attempts to
get you to "upgrade" to an app?

Tony H.

--
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

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Carmen Vitullo]

I can't remember, when I worked for the State and they were moving some 
DB2 data to a SQL server somewhere, I worked with the DBA's and setup a 
Unix process (on Z) and a migration directory for them to unload the 
data using a DB2 utility - IIRC they use a secure FTP process on a 
server to pick up the data, if I can find the procedure I setup I can 
provide this if interested.


Carmen

On 2/8/2023 1:25 PM, Bob Bridges wrote:

That'd be my thought.  DB2 to flat file, then through (probably) REXX to CSV 
format, then download to the PC.  Or get a REXX to read the DB2 tables 
directly, though that's probably slower; I'd think QMF would be faster for the 
first extract, assuming you have a lot of data to process.  If you're not a 
REXXer but do know VBA or VBS, you can convert to CSV after you download the 
flat files, though that may be a little harder.

(So it can't possibly be a dumb answer, Lionel, if both you and I like it.)

CSV...that might be a lot of data.  Is Access an option, instead?  More trouble 
to access (no pun intended) but it does a better job when the bytes are many.

---
Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313

/* We see that many articulate secularists are well-meaning and law-abiding 
menSo we conclude...that their philosophies are just as good guides to 
action as Christianity.  What we don't see is that they are not acting on their 
philosophies.  They are acting, out of habit or sentiment, on an inherited 
Christian ethic which they still take for granted though they have rejected the 
creed from which it sprang.  Their children will inherit somewhat less of it.  
-Joy Davidman, _Smoke on the Mountain_ (1955) */

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Lionel B. Dyck
Sent: Wednesday, February 8, 2023 12:23

May be a dumb answer but can't you migrate the data into a distributed database 
of some sort?

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Tom 
Longfellow
Sent: Wednesday, February 8, 2023 11:12 AM

The death warrant on our DB2 for z/OS has been issued.

The people with decades of data stored in the tables are asking the obvious 
questions.How do we see into our ancient history as we have always done?   
My answer is simple: you can't.

The all knowledgeable planners have come up with the idea of  Extract it into 
CSV files and walk away.   I have many concerns about this process that I will 
not go into now.

As a good little worker Bee, I am trying to do what I am told.   Here is where 
the fun begins.  My good friend Google (and IBM) says 'Use IBM Data Studio to 
perform the Extract to CSV utility function.  My installed version of IBM Data 
Studio (V4.1.3)  does NOT have that option in the menus displayed by the 
documentation.

Does anyone have a workable way to Extract DB2 Tables to CSV files?

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Bob Bridges]

That'd be my thought.  DB2 to flat file, then through (probably) REXX to CSV 
format, then download to the PC.  Or get a REXX to read the DB2 tables 
directly, though that's probably slower; I'd think QMF would be faster for the 
first extract, assuming you have a lot of data to process.  If you're not a 
REXXer but do know VBA or VBS, you can convert to CSV after you download the 
flat files, though that may be a little harder.

(So it can't possibly be a dumb answer, Lionel, if both you and I like it.)

CSV...that might be a lot of data.  Is Access an option, instead?  More trouble 
to access (no pun intended) but it does a better job when the bytes are many.

---
Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313

/* We see that many articulate secularists are well-meaning and law-abiding 
menSo we conclude...that their philosophies are just as good guides to 
action as Christianity.  What we don't see is that they are not acting on their 
philosophies.  They are acting, out of habit or sentiment, on an inherited 
Christian ethic which they still take for granted though they have rejected the 
creed from which it sprang.  Their children will inherit somewhat less of it.  
-Joy Davidman, _Smoke on the Mountain_ (1955) */

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Lionel B. Dyck
Sent: Wednesday, February 8, 2023 12:23

May be a dumb answer but can't you migrate the data into a distributed database 
of some sort?

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Tom 
Longfellow
Sent: Wednesday, February 8, 2023 11:12 AM

The death warrant on our DB2 for z/OS has been issued.

The people with decades of data stored in the tables are asking the obvious 
questions.How do we see into our ancient history as we have always done?   
My answer is simple: you can't.

The all knowledgeable planners have come up with the idea of  Extract it into 
CSV files and walk away.   I have many concerns about this process that I will 
not go into now.

As a good little worker Bee, I am trying to do what I am told.   Here is where 
the fun begins.  My good friend Google (and IBM) says 'Use IBM Data Studio to 
perform the Extract to CSV utility function.  My installed version of IBM Data 
Studio (V4.1.3)  does NOT have that option in the menus displayed by the 
documentation.

Does anyone have a workable way to Extract DB2 Tables to CSV files?

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: TEAMS usage

[John McKown]

I use Teams at work on Windows 10 a couple of times a week. No problems
beyond the uselessness of the meeting.

On Wed, Feb 8, 2023, 11:53 Tony Harminc  wrote:

> On Wed, 8 Feb 2023 at 10:07, Steve Thompson  wrote:
> >
> > Not everyone runs Windows or a Mac.
> >
> > I installed Teams on my Linux desktop and did a reboot (since
> > this is M/S software). Upon starting Teams, it promptly crashed
> > KDE, requiring a reboot. Which resulted in me doing an immediate
> > uninstall.
> >
> > So I was forced to get a Windows laptop just to run the in vogue
> > software. Why? because I can't seem to acquire W10 so I can run
> > it under Virtual Box.
> [...]
>
> I'm unclear if you're looking for a "solution" or just want to rant
> (not unjustified). In my experience Teams runs OK in a browser,
> without requiring a Windows-based app to assist it. There were
> problems with Firefox but MS and Mozilla seem to have made it work in
> recent times. The same has been true of Google Meet. Certainly
> performance is better with the MS app, and they are forever trying to
> push you to use it, but most features do work directly in the browser.
>
> Did you try joining your meeting in FF, and refusing any attempts to
> get you to "upgrade" to an app?
>
> Tony H.
>
> --
> 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: TEAMS usage

[Tony Harminc]

On Wed, 8 Feb 2023 at 13:34, Steve Thompson  wrote:
>
> Kind of a rant, but more making a point.
>
> Teams via browser means you have to have an M/S account because
> your data is in someone else's data center (isn't that a Cloud?
> ;-) ). Or to put this another way, someone has to have an account
> so that you can get access via Teams in my experience.

You don't have to have an MS account to be a guest at a Teams meeting.
To be sure I just now tried this myself using Firefox, and joined a
Teams meeting I hosted using my work Teams account. It worked fine.
The host may have rules that prohibit you from joining anonymously,
and as always Microsft has all kinds of dark patterns to "encourage"
you to hand over as much information as they can extract from you, but
basically it works.

None of these services MS Teams, Google Meets, Zoom, or any of the
second tier ones offer anonymity or true end-to-end encryption. All of
them will collect as much personal data about you as they possibly
can.

If you want a good degree of privacy on an audio/video call, use
Signal. For that matter use Signal anyway. Yes you have to install an
app, but it's open source and run by a charitable foundation rather
than a for-profit company.

Tony H.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: zOSMF

[Darrold Usher]

Try pointing to your 64-bit java runtime

On Wed, Feb 8, 2023 at 12:21 PM Steve Beaver  wrote:

> I will be at the front of the line that says "I have no idea what is
> wrong?"
>
>
>
> EZZ8342I gethostbyname(MVS1): Unknown host
>
> IZUG300I: The z/OSMF Configuration Utility has started at Wed Feb  8
> 12:21:15 ES
>
> IZUG084W: Invalid number of arguments:  3 ; expected 4.
>
> WARNING: Arguments received: /ZOSV2R4/usr/lpp/zosmf /MVS1/var/zosmf N
>
> WARNING: Some arguments may be ignored and/or defaults used.
>
> IZUG015I: Arguments in effect:
>
> : CODE_ROOT = /ZOSV2R4/usr/lpp/zosmf
>
> : USER_DIR  = /MVS1/var/zosmf
>
> : TRACE = N
>
> : KCINDEX   = Y
>
> IZUG348I: Processing of your request has started. This process might
>
> : require several minutes or more to complete.
>
> IZUG059I: Configuration operation exists as the configuration parameters
> are
> not
>
> IZUG349I: The z/OSMF  Server home page can be accessed at
>
> : https:///zosmf
>
> : after the z/OSMF server is started on your system.
>
>
>
> CWWKB0215E Failed to open /usr/lpp/java/J8.0_64/bin/classic/libjvm.so :
> CEE3587S A call was made to a function in the AMODE 31 DLL
> /usr/lpp/java/J8.0_64/bin/classic/libjvm.so from an AMODE 64 caller.
>
>
>
> HOSTNAME('10.10.70.48')
>
>
>
> HTTP_SSL_PORT(32217)
>
>
> --
> 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: zOSMF

[Carmen Vitullo]

a couple of things I see in your configuration, but without seeing your 
parms for the task and the IZUPRM member I cannot really diagnose.


1) at zos2.3 the userdir was moved to /global/zosmf/    from /var/

I think that's what the IZUG084W: message may be stating -

make sure you are using the supplied proc for IZUSVR1, I had a similar 
issue moving from z/OS 2.1 or 2.2 that proc pointed to /var/zosmf


unless you're started a local knowledge base server I'd specify KCINDEX=NO


Carmen

On 2/8/2023 12:21 PM, Steve Beaver wrote:

I will be at the front of the line that says "I have no idea what is wrong?"

  


EZZ8342I gethostbyname(MVS1): Unknown host

IZUG300I: The z/OSMF Configuration Utility has started at Wed Feb  8
12:21:15 ES

IZUG084W: Invalid number of arguments:  3 ; expected 4.

WARNING: Arguments received: /ZOSV2R4/usr/lpp/zosmf /MVS1/var/zosmf N

WARNING: Some arguments may be ignored and/or defaults used.

IZUG015I: Arguments in effect:

 : CODE_ROOT = /ZOSV2R4/usr/lpp/zosmf

 : USER_DIR  = /MVS1/var/zosmf

 : TRACE = N

 : KCINDEX   = Y

IZUG348I: Processing of your request has started. This process might

 : require several minutes or more to complete.

IZUG059I: Configuration operation exists as the configuration parameters are
not

IZUG349I: The z/OSMF  Server home page can be accessed at

 : https:///zosmf

 : after the z/OSMF server is started on your system.

  


CWWKB0215E Failed to open /usr/lpp/java/J8.0_64/bin/classic/libjvm.so :
CEE3587S A call was made to a function in the AMODE 31 DLL
/usr/lpp/java/J8.0_64/bin/classic/libjvm.so from an AMODE 64 caller.

  


HOSTNAME('10.10.70.48')

  


HTTP_SSL_PORT(32217)


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: TEAMS usage

[Steve Thompson]

Kind of a rant, but more making a point.

Teams via browser means you have to have an M/S account because 
your data is in someone else's data center (isn't that a Cloud? 
;-) ). Or to put this another way, someone has to have an account 
so that you can get access via Teams in my experience.


OH and for those who have yet to use it -- REMEMBER|Understand, 
if you used your phone for audio, to physically hang it up when 
you leave a Teams session. Unlike Web Ex, Zoom, and others, Teams 
doesn't disconnect from your phone. This was my experience 
through the end of November of 2022 with Teams.


And TEAMS on my iPhone had me having to plug my phone in to 
charge several times a day. It was amazing to me how much battery 
was used for a Teams conference.


Regards,
Steve Thompson


On 2/8/2023 12:52 PM, Tony Harminc wrote:

On Wed, 8 Feb 2023 at 10:07, Steve Thompson  wrote:

Not everyone runs Windows or a Mac.

I installed Teams on my Linux desktop and did a reboot (since
this is M/S software). Upon starting Teams, it promptly crashed
KDE, requiring a reboot. Which resulted in me doing an immediate
uninstall.

So I was forced to get a Windows laptop just to run the in vogue
software. Why? because I can't seem to acquire W10 so I can run
it under Virtual Box.

[...]

I'm unclear if you're looking for a "solution" or just want to rant
(not unjustified). In my experience Teams runs OK in a browser,
without requiring a Windows-based app to assist it. There were
problems with Firefox but MS and Mozilla seem to have made it work in
recent times. The same has been true of Google Meet. Certainly
performance is better with the MS app, and they are forever trying to
push you to use it, but most features do work directly in the browser.

Did you try joining your meeting in FF, and refusing any attempts to
get you to "upgrade" to an app?

Tony H.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


--
Regards, Steve Thompson

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

zOSMF

[Steve Beaver]

I will be at the front of the line that says "I have no idea what is wrong?"

 

EZZ8342I gethostbyname(MVS1): Unknown host

IZUG300I: The z/OSMF Configuration Utility has started at Wed Feb  8
12:21:15 ES

IZUG084W: Invalid number of arguments:  3 ; expected 4.

WARNING: Arguments received: /ZOSV2R4/usr/lpp/zosmf /MVS1/var/zosmf N

WARNING: Some arguments may be ignored and/or defaults used.

IZUG015I: Arguments in effect:

: CODE_ROOT = /ZOSV2R4/usr/lpp/zosmf

: USER_DIR  = /MVS1/var/zosmf

: TRACE = N

: KCINDEX   = Y

IZUG348I: Processing of your request has started. This process might

: require several minutes or more to complete.

IZUG059I: Configuration operation exists as the configuration parameters are
not

IZUG349I: The z/OSMF  Server home page can be accessed at

: https:///zosmf

: after the z/OSMF server is started on your system.

 

CWWKB0215E Failed to open /usr/lpp/java/J8.0_64/bin/classic/libjvm.so :
CEE3587S A call was made to a function in the AMODE 31 DLL
/usr/lpp/java/J8.0_64/bin/classic/libjvm.so from an AMODE 64 caller.

 

HOSTNAME('10.10.70.48')

 

HTTP_SSL_PORT(32217)


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[ITschak Mugzach]

Tom, please share your email here. I have a Rex program that we developed
ten years ago that will scan db2 catalog and generate the code to define
and load the unloaded data to any sql db.

Best
ITschak
בתאריך יום ד׳, 8 בפבר׳ 2023 ב-20:14 מאת Tony Harminc :

> On Wed, 8 Feb 2023 at 12:11, Tom Longfellow
> <03e29b607131-dmarc-requ...@listserv.ua.edu> wrote:
> >
> > The death warrant on our DB2 for z/OS has been issued.
> >
> > The people with decades of data stored in the tables are asking the
> obvious questions.How do we see into our ancient history as we have
> always done?   My answer is simple: you can't.
> >
> > The all knowledgeable planners have come up with the idea of  Extract it
> into CSV files and walk away.   I have many concerns about this process
> that I will not go into now.
> >
> > As a good little worker Bee, I am trying to do what I am told.   Here is
> where the fun begins.  My good friend Google (and IBM) says 'Use IBM Data
> Studio to perform the Extract to CSV utility function.  My installed
> version of IBM Data Studio (V4.1.3)  does NOT have that option in the menus
> displayed by the documentation.
> >
> > Does anyone have a workable way to Extract DB2 Tables to CSV files?
>
> Surely SQLite would be a better match to DB2 than would CSV files. The
> price is right (same as CSV files), you don't need to set up a server
> in the usual sense, and it's probably the most used SQL database on
> the planet. I'd think you should be able to pretty much copy entire
> tables from DB2 to SQLite without fancy tools.
>
> Tony H.
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>
-- 
ITschak Mugzach
*|** IronSphere Platform* *|* *Information Security Continuous Monitoring
for z/OS, x/Linux & IBM I **| z/VM coming soon  *

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Carmen Vitullo]

a couple of processes come to mind, 2 companies I worked for use Change 
Data Capture, once a 3rd party product now part of IBM's WebSphere 
suite, this product can replicate DB2 data to DB2 or SQL sever, the 
other process I saw was a product from Oracle, I don't recall the 
product name but it can also move , replicate data to DB2 in any other 
platform IIRC, SQL or an Oracle DB


Carmen

On 2/8/2023 11:23 AM, Lionel B. Dyck wrote:

May be a dumb answer but can't you migrate the data into a distributed database 
of some sort?


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

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Tom 
Longfellow
Sent: Wednesday, February 8, 2023 11:12 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: The Local death of DB2 z/OS --- what is the best way to preserve the 
data once the mainframe is gone

The death warrant on our DB2 for z/OS has been issued.

The people with decades of data stored in the tables are asking the obvious 
questions.How do we see into our ancient history as we have always done?   
My answer is simple: you can't.

The all knowledgeable planners have come up with the idea of  Extract it into 
CSV files and walk away.   I have many concerns about this process that I will 
not go into now.

As a good little worker Bee, I am trying to do what I am told.   Here is where 
the fun begins.  My good friend Google (and IBM) says 'Use IBM Data Studio to 
perform the Extract to CSV utility function.  My installed version of IBM Data 
Studio (V4.1.3)  does NOT have that option in the menus displayed by the 
documentation.

Does anyone have a workable way to Extract DB2 Tables to CSV files?

--
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

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tony Harminc]

On Wed, 8 Feb 2023 at 12:11, Tom Longfellow
<03e29b607131-dmarc-requ...@listserv.ua.edu> wrote:
>
> The death warrant on our DB2 for z/OS has been issued.
>
> The people with decades of data stored in the tables are asking the obvious 
> questions.How do we see into our ancient history as we have always done?  
>  My answer is simple: you can't.
>
> The all knowledgeable planners have come up with the idea of  Extract it into 
> CSV files and walk away.   I have many concerns about this process that I 
> will not go into now.
>
> As a good little worker Bee, I am trying to do what I am told.   Here is 
> where the fun begins.  My good friend Google (and IBM) says 'Use IBM Data 
> Studio to perform the Extract to CSV utility function.  My installed version 
> of IBM Data Studio (V4.1.3)  does NOT have that option in the menus displayed 
> by the documentation.
>
> Does anyone have a workable way to Extract DB2 Tables to CSV files?

Surely SQLite would be a better match to DB2 than would CSV files. The
price is right (same as CSV files), you don't need to set up a server
in the usual sense, and it's probably the most used SQL database on
the planet. I'd think you should be able to pretty much copy entire
tables from DB2 to SQLite without fancy tools.

Tony H.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: TEAMS usage

[Tony Harminc]

On Wed, 8 Feb 2023 at 10:07, Steve Thompson  wrote:
>
> Not everyone runs Windows or a Mac.
>
> I installed Teams on my Linux desktop and did a reboot (since
> this is M/S software). Upon starting Teams, it promptly crashed
> KDE, requiring a reboot. Which resulted in me doing an immediate
> uninstall.
>
> So I was forced to get a Windows laptop just to run the in vogue
> software. Why? because I can't seem to acquire W10 so I can run
> it under Virtual Box.
[...]

I'm unclear if you're looking for a "solution" or just want to rant
(not unjustified). In my experience Teams runs OK in a browser,
without requiring a Windows-based app to assist it. There were
problems with Firefox but MS and Mozilla seem to have made it work in
recent times. The same has been true of Google Meet. Certainly
performance is better with the MS app, and they are forever trying to
push you to use it, but most features do work directly in the browser.

Did you try joining your meeting in FF, and refusing any attempts to
get you to "upgrade" to an app?

Tony H.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Lionel B. Dyck]

May be a dumb answer but can't you migrate the data into a distributed database 
of some sort?


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

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Tom 
Longfellow
Sent: Wednesday, February 8, 2023 11:12 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: The Local death of DB2 z/OS --- what is the best way to preserve the 
data once the mainframe is gone

The death warrant on our DB2 for z/OS has been issued.

The people with decades of data stored in the tables are asking the obvious 
questions.How do we see into our ancient history as we have always done?   
My answer is simple: you can't.

The all knowledgeable planners have come up with the idea of  Extract it into 
CSV files and walk away.   I have many concerns about this process that I will 
not go into now.

As a good little worker Bee, I am trying to do what I am told.   Here is where 
the fun begins.  My good friend Google (and IBM) says 'Use IBM Data Studio to 
perform the Extract to CSV utility function.  My installed version of IBM Data 
Studio (V4.1.3)  does NOT have that option in the menus displayed by the 
documentation.

Does anyone have a workable way to Extract DB2 Tables to CSV files?

--
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

The Local death of DB2 z/OS --- what is the best way to preserve the data once the mainframe is gone

[Tom Longfellow]

The death warrant on our DB2 for z/OS has been issued.

The people with decades of data stored in the tables are asking the obvious 
questions.How do we see into our ancient history as we have always done?   
My answer is simple: you can't.

The all knowledgeable planners have come up with the idea of  Extract it into 
CSV files and walk away.   I have many concerns about this process that I will 
not go into now.

As a good little worker Bee, I am trying to do what I am told.   Here is where 
the fun begins.  My good friend Google (and IBM) says 'Use IBM Data Studio to 
perform the Extract to CSV utility function.  My installed version of IBM Data 
Studio (V4.1.3)  does NOT have that option in the menus displayed by the 
documentation.

Does anyone have a workable way to Extract DB2 Tables to CSV files?

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: GIM56401S

[Carmen Vitullo]

I agree

GIM56401W IMHO wold be more appropriate

Carmen

On 2/8/2023 10:27 AM, Mark Jacobs wrote:

One of my SMP/e pet peeves. Why does this rate a severe level error message? 
Just issue a warning and get on with your job.

GIM56401S ** XXX HAS ALREADY BEEN SPECIFIED ON EITHER THE SELECT OR EXCLUDE 
OPERAND.

Mark Jacobs

Sent from [ProtonMail](https://protonmail.com), Swiss-based encrypted email.

GPG Public Key - 
https://api.protonmail.ch/pks/lookup?op=get&search=markjac...@protonmail.com

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Shopz

[Carmen Vitullo]

I agree and I've used the ftp route before, my issue is my company will 
not allow ftp period, and using HTTPS from Z needs to be authenticated 
to the firewall so 2 things for me, I have to get authority to tunnel 
thru the firewall to get to IBM, then in the  section I need to 
specify my firewall server I/P and my LAN ID and password.


ftp, so much easier as you've pointed out


Carmen

On 2/8/2023 10:26 AM, Ed Jaffe wrote:

On 2/8/2023 7:23 AM, Steve Beaver wrote:

I feel like an idiot asking this question however - How do I pull the
HOLDDATA from Shopz


Typically, if you choose not to use RECEIVE ORDER, you would use 
anonymous FTP to retrieve it from service.boulder.ibm.com. For example:


//HOLDDATA JOB 1,BEAVER,CLASS=A,MSGCLASS=T,NOTIFY=&SYSUID
//HOLDDATA EXEC PGM=FTP
//SYSPRINT  DD SYSOUT=*
//SYSIN DD *
 service.boulder.ibm.com
 anonymous
 st...@stevebeaver.com
 cd s390/holddata
 locsite recfm=fb lrecl=80
 locsite primary=1 secondary=1 cylinders
 get full.txt holddata.full.txt (REPLACE
 quit
//


--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

GIM56401S

[Mark Jacobs]

One of my SMP/e pet peeves. Why does this rate a severe level error message? 
Just issue a warning and get on with your job.

GIM56401S ** XXX HAS ALREADY BEEN SPECIFIED ON EITHER THE SELECT OR EXCLUDE 
OPERAND.

Mark Jacobs

Sent from [ProtonMail](https://protonmail.com), Swiss-based encrypted email.

GPG Public Key - 
https://api.protonmail.ch/pks/lookup?op=get&search=markjac...@protonmail.com

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Shopz

[Ed Jaffe]

On 2/8/2023 7:23 AM, Steve Beaver wrote:

I feel like an idiot asking this question however - How do I pull the
HOLDDATA from Shopz


Typically, if you choose not to use RECEIVE ORDER, you would use 
anonymous FTP to retrieve it from service.boulder.ibm.com. For example:


//HOLDDATA JOB 1,BEAVER,CLASS=A,MSGCLASS=T,NOTIFY=&SYSUID
//HOLDDATA EXEC PGM=FTP
//SYSPRINT  DD SYSOUT=*
//SYSIN DD *
 service.boulder.ibm.com
 anonymous
 st...@stevebeaver.com
 cd s390/holddata
 locsite recfm=fb lrecl=80
 locsite primary=1 secondary=1 cylinders
 get full.txt holddata.full.txt (REPLACE
 quit
//

--
Phoenix Software International
Edward E. Jaffe
831 Parkview Drive North
El Segundo, CA 90245
https://www.phoenixsoftware.com/



This e-mail message, including any attachments, appended messages and the
information contained therein, is for the sole use of the intended
recipient(s). If you are not an intended recipient or have otherwise
received this email message in error, any use, dissemination, distribution,
review, storage or copying of this e-mail message and the information
contained therein is strictly prohibited. If you are not an intended
recipient, please contact the sender by reply e-mail and destroy all copies
of this email message and do not otherwise utilize or retain this email
message or any or all of the information contained therein. Although this
email message and any attachments or appended messages are believed to be
free of any virus or other defect that might affect any computer system into
which it is received and opened, it is the responsibility of the recipient
to ensure that it is virus free and no responsibility is accepted by the
sender for any loss or damage arising in any way from its opening or use.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Having a little difficulty with a REXX command LMOPEN

[Paul Gorlinsky]

Calling system programs from COBOL is doable provided you use the correct 
calling conventions. 

I OS we have two different ways of passing parms ... Generally see 
https://www.ibm.com/docs/en/cobol-zos/6.3?topic=statements-call-statement

by Reference, content or value...


Check out 
https://www-40.ibm.com/servers/resourcelink/svc00100.nsf/pages/zOSV2R4sa380684/$file/ceea400_v2r4.pdf
 
z/OS Language Environment Writing Interlanguage Communications Applications 
SA38-0684

For Additional Help

Also : See 
https://www.ibm.com/docs/en/zos/2.1.0?topic=program-writing-jcl-command-execution
 

There are three different ways to run under the TSO TMP...
IKJEFT01, IKJEFT1A and IKJEFT1B

Usually IKJEFT01 will result in a return code of ZERO ( 0 ) provide SYSTSIN and 
SYSTSPRT DD statements exist and are valid

IKJEFT1A will return S04C if a system abend occurs in a program or command be 
executed ... 

IKJEFT1B will return the return code of the last command's return code...
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Having a little difficulty with a REXX command LMOPEN

[Steve Thompson]

I am doing some utility routines for a product I'm working on.

I have used ISPQRY in REXX code but that was under IKJEFT* (I 
have tried it with various combinations).


So I thought I'd just stick a dynamic call to ISPQRY into a COBOL 
program and have it spit out what it got back.


So, if the LOAD failed, I'd probably get a S806 -- But as someone 
noted, if it was in a "global" library(s) (I didn't go run it 
down to see if it was specifically in "LPA"). And so I got RC=20 
from it.


Now, this is in preparation for that same COBOL program to do 
BPXWDY2 (entry into BPXWDYN), and ISPF/PDF LM* code to find 
members in the passed in DSN.


The next test will be after putting in the requisite ISPF DDs and 
see how that functions.


But the point is, ISPQRY did function and tell me that the 
environment was not there.


I'm hoping that I can do this without having to use IKJEFT* .

Regards,
Steve Thompson

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: JCL Procedure help

[Paul Gorlinsky]

There are static and dynamic System Symbols ... 
There is a JOBCLASS parm SysSym that ALLOWs or DISALLOWs the use of either of 
them.. if DISALLOW, none of these are available to the jobs with a class marked 
as such..

There is also a PARMLIB IEASYMxx that system programmers may add additional 
symbols...



Typical Statics:
 &SYSALVL.  2   
 &SYSCLONE. I1  
 &SYSNAME.  LPR1
 &SYSOSLVL. Z1020400
 &SYSPLEX.  LOCAL   
 &SYSR1.SYSRES  

Typical Dynamics
&DAY.  08 
&HHMMSS.   154214 
&HR.   15 
&JDAY. 039
&JOBNAME.  USER001
&LDAY. 08 
&LHHMMSS.  104214 
&LHR.  10 
&LJDAY.039
&LMIN. 42 
&LMON. 02 
&LSEC. 14 
&LWDAY.WED
&LYR2. 23 
&LYR4. 2023   
&LYYMMDD.  230208 
&MIN.  42 
&MON.  02 
&SEC.  14 
&WDAY. WED   
&YR2.  23
&YR4.  2023  
&YYMMDD.   230208

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Shopz

[Carmen Vitullo]

that's correct, I schedule weekly a job that receives hold data directly 
to my test LPAR, (z/OS global zone), you need to download a cert from 
shopz first, IIRC there's doc on the site on how to add the cert to your 
security system and some sample JCL.


need a sample?

I have a sample if needed


Carmen

On 2/8/2023 9:31 AM, Seymour J Metz wrote:

I believe that you can do it directly from SMP, firewall permitting.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Steve Beaver [st...@stevebeaver.com]
Sent: Wednesday, February 8, 2023 10:23 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Shopz

I feel like an idiot asking this question however - How do I pull the
HOLDDATA from Shopz


--
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

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: JCL Procedure help

[Steve Smith]

I think that is the best idea, if changing the job JCL is an option.  But
it may be that it's more feasible to change one proc instead of who knows
how many jobs.  That's one of the reasons to have procs.

Also, I believe your "plexname" should be "systemname".

sas

On Wed, Feb 8, 2023 at 10:28 AM Sri h Kolusu  wrote:

> >> I was asked to add a step that would check that the JOB is running on
> the correct LPAR.
>
> Gadi,
>
> I agree with Mikael of using SYSAFF parm to route the JOB to that LPAR it
> needs to run. This will not only eliminate making any changes to the PROC
> and you don't need to add a rexx exec to determine the Lpar it is running
> in.
>
> So, change the Job in question to have the SYSAFF in either of these 2
> different ways
>
> //SAMPJCRD JOB (,,,),&SYSUID,SYSAFF=plexname,
> // MSGCLASS=H,MSGLEVEL=(1,1),CLASS=A,NOTIFY=&SYSUID
> /*
>
> Or
>
> /*JOBPARM SYSAFF=plexname
>
> 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

Re: Shopz

[Seymour J Metz]

I believe that you can do it directly from SMP, firewall permitting.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Steve Beaver [st...@stevebeaver.com]
Sent: Wednesday, February 8, 2023 10:23 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Shopz

I feel like an idiot asking this question however - How do I pull the
HOLDDATA from Shopz


--
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: JCL Procedure help

[Sri h Kolusu]

>> I was asked to add a step that would check that the JOB is running on the 
>> correct LPAR.

Gadi,

I agree with Mikael of using SYSAFF parm to route the JOB to that LPAR it needs 
to run. This will not only eliminate making any changes to the PROC and you 
don't need to add a rexx exec to determine the Lpar it is running in.

So, change the Job in question to have the SYSAFF in either of these 2 
different ways

//SAMPJCRD JOB (,,,),&SYSUID,SYSAFF=plexname,
// MSGCLASS=H,MSGLEVEL=(1,1),CLASS=A,NOTIFY=&SYSUID
/*

Or

/*JOBPARM SYSAFF=plexname

Thanks,
Kolusu


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: TEAMS usage

[Steve Smith]

On Wed, Feb 8, 2023 at 10:19 AM Lionel B. Dyck  wrote:

> You may need to uninstall Teams. and then go to the Microsoft App Store
> and install it cleanly. MS has been moving many applications into the App
> Store lately (as have other ISVs).
>
>
> Fixed it for you.


> 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

Shopz

[Steve Beaver]

I feel like an idiot asking this question however - How do I pull the
HOLDDATA from Shopz


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: TEAMS usage

[Carmen Vitullo]

for me personally this is a work laptop issue - my systems team had all 
admin rights taken away so we cannot install anything and the MS store 
is not available.


for my personal PC, I really have no need for teams right now.

thanks

Carmen

On 2/8/2023 9:19 AM, Lionel B. Dyck wrote:

You may need to uninstall Teams and then go to the Microsoft App Store and 
install it cleanly. MS has been moving many applications into the App Store 
lately (as have other ISVs).


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

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Carmen Vitullo
Sent: Wednesday, February 8, 2023 9:11 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: TEAMS usage

that stinks, but even with a company manged laptop W10, teams crashes, does not 
start, will not shutdown... name it teams is not so stable, IMHO not has stable 
as Skype or Sametime was

Carmen

On 2/8/2023 9:06 AM, Steve Thompson wrote:

Not everyone runs Windows or a Mac.

I installed Teams on my Linux desktop and did a reboot (since this is
M/S software). Upon starting Teams, it promptly crashed KDE, requiring
a reboot. Which resulted in me doing an immediate uninstall.

So I was forced to get a Windows laptop just to run the in vogue
software. Why? because I can't seem to acquire W10 so I can run it
under Virtual Box.

Oh, and NO, I was not running as ROOT. I only run as root when doing
installs and certain types of maint.

Regards,
Steve Thompson

On 2/8/2023 9:21 AM, Joseph Reichman wrote:

That’s how we communicate quick messages used to be Skype should be
on your laptop

On Wed, Feb 8, 2023 at 9:20 AM Seymour J Metz  wrote:


I'm not familiar with teams.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3



--
For IBM-MAIN subscribe / signoff / archive access instructions, send
email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
Carmen

--
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

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: TEAMS usage

[Lionel B. Dyck]

You may need to uninstall Teams and then go to the Microsoft App Store and 
install it cleanly. MS has been moving many applications into the App Store 
lately (as have other ISVs).


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

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Carmen Vitullo
Sent: Wednesday, February 8, 2023 9:11 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: TEAMS usage

that stinks, but even with a company manged laptop W10, teams crashes, does not 
start, will not shutdown... name it teams is not so stable, IMHO not has stable 
as Skype or Sametime was

Carmen

On 2/8/2023 9:06 AM, Steve Thompson wrote:
> Not everyone runs Windows or a Mac.
>
> I installed Teams on my Linux desktop and did a reboot (since this is 
> M/S software). Upon starting Teams, it promptly crashed KDE, requiring 
> a reboot. Which resulted in me doing an immediate uninstall.
>
> So I was forced to get a Windows laptop just to run the in vogue 
> software. Why? because I can't seem to acquire W10 so I can run it 
> under Virtual Box.
>
> Oh, and NO, I was not running as ROOT. I only run as root when doing 
> installs and certain types of maint.
>
> Regards,
> Steve Thompson
>
> On 2/8/2023 9:21 AM, Joseph Reichman wrote:
>> That’s how we communicate quick messages used to be Skype should be 
>> on your laptop
>>
>> On Wed, Feb 8, 2023 at 9:20 AM Seymour J Metz  wrote:
>>
>>> I'm not familiar with teams.
>>>
>>>
>>> --
>>> Shmuel (Seymour J.) Metz
>>> http://mason.gmu.edu/~smetz3
>>>
>>> 
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions, send 
> email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
--
Carmen

--
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: Goodbye and thanks for all the fish

[Steve Thompson]

Sorry to see you go. And I too am not a very active member. I 
read a lot and learn stuff.


Hope you enjoy your retirement. Or, un-retirement if that is what 
you wish.


Regards,
Steve Thompson

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: TEAMS usage

[Carmen Vitullo]

that stinks, but even with a company manged laptop W10, teams crashes, 
does not start, will not shutdown... name it teams is not so stable, 
IMHO not has stable as Skype or Sametime was


Carmen

On 2/8/2023 9:06 AM, Steve Thompson wrote:

Not everyone runs Windows or a Mac.

I installed Teams on my Linux desktop and did a reboot (since this is 
M/S software). Upon starting Teams, it promptly crashed KDE, requiring 
a reboot. Which resulted in me doing an immediate uninstall.


So I was forced to get a Windows laptop just to run the in vogue 
software. Why? because I can't seem to acquire W10 so I can run it 
under Virtual Box.


Oh, and NO, I was not running as ROOT. I only run as root when doing 
installs and certain types of maint.


Regards,
Steve Thompson

On 2/8/2023 9:21 AM, Joseph Reichman wrote:
That’s how we communicate quick messages used to be Skype should be 
on your

laptop

On Wed, Feb 8, 2023 at 9:20 AM Seymour J Metz  wrote:


I'm not familiar with teams.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3




--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

TEAMS usage

[Steve Thompson]

Not everyone runs Windows or a Mac.

I installed Teams on my Linux desktop and did a reboot (since 
this is M/S software). Upon starting Teams, it promptly crashed 
KDE, requiring a reboot. Which resulted in me doing an immediate 
uninstall.


So I was forced to get a Windows laptop just to run the in vogue 
software. Why? because I can't seem to acquire W10 so I can run 
it under Virtual Box.


Oh, and NO, I was not running as ROOT. I only run as root when 
doing installs and certain types of maint.


Regards,
Steve Thompson

On 2/8/2023 9:21 AM, Joseph Reichman wrote:

That’s how we communicate quick messages used to be Skype should be on your
laptop

On Wed, Feb 8, 2023 at 9:20 AM Seymour J Metz  wrote:


I'm not familiar with teams.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3




--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Goodbye and thanks for all the fish

[Michael Watkins]

It's a Microsoft communication product that includes video calling, instant 
messaging and bulletin board features. And who knows what else.

But don't you have to be using the same Microsoft server to communicate with 
someone else on Teams? My employer uses it for communication within the 
organization.

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Joseph Reichman
Sent: Wednesday, February 8, 2023 8:22 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Goodbye and thanks for all the fish

CAUTION: This email originated from outside of the Texas Comptroller's email 
system.
DO NOT click links or open attachments unless you expect them from the sender 
and know the content is safe.

That's how we communicate quick messages used to be Skype should be on your 
laptop

On Wed, Feb 8, 2023 at 9:20 AM Seymour J Metz  wrote:

> I'm not familiar with teams.
>
>
> --
> Shmuel (Seymour J.) Metz
> https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmason
> .gmu.edu%2F~smetz3&data=05%7C01%7Cmichael.watkins%40CPA.TEXAS.GOV%7C5e
> c7d46360ec4cf88cb108db09dfdb67%7C2055feba299d4d0daa5a73b8b42fef08%7C0%
> 7C0%7C638114629285910596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiL
> CJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=2g
> 9%2FTLskXsblDHUVhB31N67%2BURXonQeMIBc2wYtBYQY%3D&reserved=0
>
> 
> From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on 
> behalf of Joseph Reichman [reichman...@gmail.com]
> Sent: Wednesday, February 8, 2023 9:11 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Goodbye and thanks for all the fish
>
> Seymour I dont see you on teams
>
> On Wed, Feb 8, 2023 at 9:09 AM Seymour J Metz  wrote:
>
> > Good luck in your retirement.
> >
> > FWIW, I got a lot of queries since I accepted my new job, so if you
> decide
> > to go back to the workplace this might be a good time. Are you on 
> > DICE, linkedIn or Monster?
> >
> > 42.
> >
> >
> > --
> > Shmuel (Seymour J.) Metz
> > https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmas
> > on.gmu.edu%2F~smetz3&data=05%7C01%7Cmichael.watkins%40CPA.TEXAS.GOV%
> > 7C5ec7d46360ec4cf88cb108db09dfdb67%7C2055feba299d4d0daa5a73b8b42fef0
> > 8%7C0%7C0%7C638114629285910596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wL
> > jAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7
> > C&sdata=2g9%2FTLskXsblDHUVhB31N67%2BURXonQeMIBc2wYtBYQY%3D&reserved=
> > 0
> >
> > 
> > From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on 
> > behalf of carl swanson 
> > [0252c152a1b5-dmarc-requ...@listserv.ua.edu]
> > Sent: Wednesday, February 8, 2023 7:46 AM
> > To: IBM-MAIN@LISTSERV.UA.EDU
> > Subject: Goodbye and thanks for all the fish
> >
> > While I have not been a very active member, I have 
> > been a very active lurker for years. My 45+ year journey is coming 
> > to an end
> again
> > as my employer has picked my retirement date for me. I hope this 
> > time to
> do
> > retirement correctly and make it work, previous attempts have failed
> maybe
> > this time I can get it right.
> >
> >
> >
> > It has been a pleasure for me to work with 
> > Mainframes and in my case Mainframe Virtual tape, that last part for 
> > most of my last 30 years.
> > I have learned many things from this group, including many that I 
> > would never use but were interesting.
> >
> >
> >
> > Good luck to all and show the world that Mainframes 
> > are here to stay
> >
> >
> >
> > Carl Swanson
> >
> > 215-688-1459
> >
> > carl.swans...@verizon.net
> >
> >
> >
> >
> > 
> > -- 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
> >
> --
> Joe Reichman
>
> --
> 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
>
--
Joe Reichman

--
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-M

Re: Goodbye and thanks for all the fish

[Carmen Vitullo]

we use teams also, but I think it's part of the office 360 suite ?

for personal meetings I use, sometimes  'meet now' I think it's called

Carmen

On 2/8/2023 8:21 AM, Joseph Reichman wrote:

That’s how we communicate quick messages used to be Skype should be on your
laptop

On Wed, Feb 8, 2023 at 9:20 AM Seymour J Metz  wrote:


I'm not familiar with teams.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf
of Joseph Reichman [reichman...@gmail.com]
Sent: Wednesday, February 8, 2023 9:11 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Goodbye and thanks for all the fish

Seymour I dont see you on teams

On Wed, Feb 8, 2023 at 9:09 AM Seymour J Metz  wrote:


Good luck in your retirement.

FWIW, I got a lot of queries since I accepted my new job, so if you

decide

to go back to the workplace this might be a good time. Are you on DICE,
linkedIn or Monster?

42.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf
of carl swanson [0252c152a1b5-dmarc-requ...@listserv.ua.edu]
Sent: Wednesday, February 8, 2023 7:46 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Goodbye and thanks for all the fish

 While I have not been a very active member, I have been a
very active lurker for years. My 45+ year journey is coming to an end

again

as my employer has picked my retirement date for me. I hope this time to

do

retirement correctly and make it work, previous attempts have failed

maybe

this time I can get it right.



 It has been a pleasure for me to work with Mainframes and
in
my case Mainframe Virtual tape, that last part for most of my last 30
years.
I have learned many things from this group, including many that I would
never use but were interesting.



 Good luck to all and show the world that Mainframes are
here
to stay



Carl Swanson

215-688-1459

carl.swans...@verizon.net




--
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


--
Joe Reichman

--
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


--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Goodbye and thanks for all the fish

[Joseph Reichman]

That’s how we communicate quick messages used to be Skype should be on your
laptop

On Wed, Feb 8, 2023 at 9:20 AM Seymour J Metz  wrote:

> I'm not familiar with teams.
>
>
> --
> Shmuel (Seymour J.) Metz
> http://mason.gmu.edu/~smetz3
>
> 
> From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf
> of Joseph Reichman [reichman...@gmail.com]
> Sent: Wednesday, February 8, 2023 9:11 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: Goodbye and thanks for all the fish
>
> Seymour I dont see you on teams
>
> On Wed, Feb 8, 2023 at 9:09 AM Seymour J Metz  wrote:
>
> > Good luck in your retirement.
> >
> > FWIW, I got a lot of queries since I accepted my new job, so if you
> decide
> > to go back to the workplace this might be a good time. Are you on DICE,
> > linkedIn or Monster?
> >
> > 42.
> >
> >
> > --
> > Shmuel (Seymour J.) Metz
> > http://mason.gmu.edu/~smetz3
> >
> > 
> > From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf
> > of carl swanson [0252c152a1b5-dmarc-requ...@listserv.ua.edu]
> > Sent: Wednesday, February 8, 2023 7:46 AM
> > To: IBM-MAIN@LISTSERV.UA.EDU
> > Subject: Goodbye and thanks for all the fish
> >
> > While I have not been a very active member, I have been a
> > very active lurker for years. My 45+ year journey is coming to an end
> again
> > as my employer has picked my retirement date for me. I hope this time to
> do
> > retirement correctly and make it work, previous attempts have failed
> maybe
> > this time I can get it right.
> >
> >
> >
> > It has been a pleasure for me to work with Mainframes and
> > in
> > my case Mainframe Virtual tape, that last part for most of my last 30
> > years.
> > I have learned many things from this group, including many that I would
> > never use but were interesting.
> >
> >
> >
> > Good luck to all and show the world that Mainframes are
> > here
> > to stay
> >
> >
> >
> > Carl Swanson
> >
> > 215-688-1459
> >
> > carl.swans...@verizon.net
> >
> >
> >
> >
> > --
> > 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
> >
> --
> Joe Reichman
>
> --
> 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
>
-- 
Joe Reichman

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: JCL Procedure help

[Billy Ashton]

I agree with Steve's approach...since you want the job to be on a 
certain system, le the check be in the job. This keeps the proc 
concentrated on the work it needs and less cluttered.


Thank you and best regards,
Billy Ashton


-- Original Message --

From "Steve Smith" 

To IBM-MAIN@listserv.ua.edu
Date 2/8/2023 9:17:22 AM
Subject Re: JCL Procedure help


You can probably just invoke the original program in your REXX (ADDRESS
LINKMVS, etc.) when it's on the correct system.  Then your proc is still
one step.

sas

On Wed, Feb 8, 2023 at 8:56 AM Willy Jensen 
wrote:


 Since you are running a REXX anyway, that REXX could copy DDname SYSIN to
 a temporary dataset, which is then used for SYSIN in the 2nd step, A simple
 REPRO INFILE(SYSIN) OUTFILE(TEMP) should do it.




--
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: Goodbye and thanks for all the fish

[Seymour J Metz]

I'm not familiar with teams.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Joseph Reichman [reichman...@gmail.com]
Sent: Wednesday, February 8, 2023 9:11 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Goodbye and thanks for all the fish

Seymour I dont see you on teams

On Wed, Feb 8, 2023 at 9:09 AM Seymour J Metz  wrote:

> Good luck in your retirement.
>
> FWIW, I got a lot of queries since I accepted my new job, so if you decide
> to go back to the workplace this might be a good time. Are you on DICE,
> linkedIn or Monster?
>
> 42.
>
>
> --
> Shmuel (Seymour J.) Metz
> http://mason.gmu.edu/~smetz3
>
> 
> From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf
> of carl swanson [0252c152a1b5-dmarc-requ...@listserv.ua.edu]
> Sent: Wednesday, February 8, 2023 7:46 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Goodbye and thanks for all the fish
>
> While I have not been a very active member, I have been a
> very active lurker for years. My 45+ year journey is coming to an end again
> as my employer has picked my retirement date for me. I hope this time to do
> retirement correctly and make it work, previous attempts have failed maybe
> this time I can get it right.
>
>
>
> It has been a pleasure for me to work with Mainframes and
> in
> my case Mainframe Virtual tape, that last part for most of my last 30
> years.
> I have learned many things from this group, including many that I would
> never use but were interesting.
>
>
>
> Good luck to all and show the world that Mainframes are
> here
> to stay
>
>
>
> Carl Swanson
>
> 215-688-1459
>
> carl.swans...@verizon.net
>
>
>
>
> --
> 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
>
--
Joe Reichman

--
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: JCL Procedure help

[Steve Smith]

You can probably just invoke the original program in your REXX (ADDRESS
LINKMVS, etc.) when it's on the correct system.  Then your proc is still
one step.

sas

On Wed, Feb 8, 2023 at 8:56 AM Willy Jensen 
wrote:

> Since you are running a REXX anyway, that REXX could copy DDname SYSIN to
> a temporary dataset, which is then used for SYSIN in the 2nd step, A simple
> REPRO INFILE(SYSIN) OUTFILE(TEMP) should do it.
>
>

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: JCL Procedure help

[Seymour J Metz]

In addition to copying SYSIN, as a previous poster suggested, there are other 
options.

1. Let your REXX code call the application. As long as it doesn't need 
authorization or program control, that should work fine.

 2. Make SYSIN in the swecond step a backwards reference to SYSIN in the first 
step. I'm not sure whether that will work.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Gadi Ben-Avi [gad...@malam.com]
Sent: Wednesday, February 8, 2023 7:44 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: JCL Procedure help

Hi,
I was asked to modify a procedure.
Currently, the procedure has one step.
This step receives input from SYSIN DD *

I was asked to add a step that would check that the JOB is running on the 
correct LPAR.
I wrote a small REXX program that check the LPAR, and returns condition code 8 
if it's not running on the correct LPAR.
I then added an if statement that will run the original step if the previous 
condition code is 0, and if not will issue a message.

The problem is that now the SYSIN DD is allocated to the first step.
I know I can code STEP.SYSIN to associate the SYSIN with correct step, but was 
wondering if there a way to code the procedure in a way so that I won't require 
changing the way the procedure is used.

We are running z/OS v2.3

Gadi


--
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: Goodbye and thanks for all the fish

[Joseph Reichman]

Seymour I dont see you on teams

On Wed, Feb 8, 2023 at 9:09 AM Seymour J Metz  wrote:

> Good luck in your retirement.
>
> FWIW, I got a lot of queries since I accepted my new job, so if you decide
> to go back to the workplace this might be a good time. Are you on DICE,
> linkedIn or Monster?
>
> 42.
>
>
> --
> Shmuel (Seymour J.) Metz
> http://mason.gmu.edu/~smetz3
>
> 
> From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf
> of carl swanson [0252c152a1b5-dmarc-requ...@listserv.ua.edu]
> Sent: Wednesday, February 8, 2023 7:46 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Goodbye and thanks for all the fish
>
> While I have not been a very active member, I have been a
> very active lurker for years. My 45+ year journey is coming to an end again
> as my employer has picked my retirement date for me. I hope this time to do
> retirement correctly and make it work, previous attempts have failed maybe
> this time I can get it right.
>
>
>
> It has been a pleasure for me to work with Mainframes and
> in
> my case Mainframe Virtual tape, that last part for most of my last 30
> years.
> I have learned many things from this group, including many that I would
> never use but were interesting.
>
>
>
> Good luck to all and show the world that Mainframes are
> here
> to stay
>
>
>
> Carl Swanson
>
> 215-688-1459
>
> carl.swans...@verizon.net
>
>
>
>
> --
> 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
>
-- 
Joe Reichman

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Goodbye and thanks for all the fish

[Seymour J Metz]

Good luck in your retirement.

FWIW, I got a lot of queries since I accepted my new job, so if you decide to 
go back to the workplace this might be a good time. Are you on DICE, linkedIn 
or Monster?

42.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
carl swanson [0252c152a1b5-dmarc-requ...@listserv.ua.edu]
Sent: Wednesday, February 8, 2023 7:46 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Goodbye and thanks for all the fish

While I have not been a very active member, I have been a
very active lurker for years. My 45+ year journey is coming to an end again
as my employer has picked my retirement date for me. I hope this time to do
retirement correctly and make it work, previous attempts have failed maybe
this time I can get it right.



It has been a pleasure for me to work with Mainframes and in
my case Mainframe Virtual tape, that last part for most of my last 30 years.
I have learned many things from this group, including many that I would
never use but were interesting.



Good luck to all and show the world that Mainframes are here
to stay



Carl Swanson

215-688-1459

carl.swans...@verizon.net




--
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: RACF - SDSF question

[Shaffer, Terri]

Thank you, with your input and Robs, I now know the order of the checks, which 
was the piece I didn't fully understand.

I have now cleaned up my extra rules and added rules under jesspool and they 
are now stopped.

Rob, thanks for the slides!

Ms Terri E Shaffer
Senior Systems Engineer,
z/OS Support:
ACIWorldwide - Telecommuter
H(412-766-2697) C(412-519-2592)
terri.shaf...@aciworldwide.com

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Robert S. Hansel (RSH)
Sent: Wednesday, February 8, 2023 8:00 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: RACF - SDSF question

EXTERNAL EMAIL: Do not click links or open attachments unless you know the 
content is safe.


Hi Terri,

Here are a couple of thoughts to add to what others have mentioned.

Since SDSF is issuing a JES2 cancel job $CJ command, the name of the OPERCMDS 
resource being checked is JES2.CANCEL.BAT. Profile JES2.CANCEL.BAT.C30TCI* is 
superfluous since the resource name never includes the jobname, so you can 
delete it. Profile JES2.CANCEL.BAT.** is guarding JES2.CANCEL.BAT because the 
.** generic suffix applies to zero or more qualifiers, and in this case it is 
zero qualifiers. The suggestions to lock down MVS cancel job commands won't 
help in this situation because SDSF is issuing JES2 commands instead of MVS 
commands, so the OPERCMDS MVS.CANCEL.JOB.jobname resources won't be checked.

As was mentioned, to cancel a job typically also requires ALTER access to the 
JESSPOOL resource guarding the job. Look into setting up appropriate JESSPOOL 
profiles to isolate and restrict ALTER access to these jobs. Also consider 
whether users have been (inadvertently) set up as Destination Operators. If 
they have READ access to SDSF resource ISFOPER.DEST.JES2 and ALTER access to 
SDSF resources prefixed ISFAUTH.DEST., they can cancel jobs while bypassing 
JESSPOOL profile checks.

If the CONSOLE class is active, you can permit ID(*) UPDATE access to 
JES2.CANCEL.BAT.** conditionally by adding operand WHEN(CONSOLE(SDSF)) to the 
PERMIT command so that users can only issue JES2 cancel job commands from 
within SDSF panels. This would prevent them from cancelling jobs outside of 
SDSF, to include when using the SDSF / command. You would need to remove 
UACC(UPDATE) or ID(*) UPDATE permission, whichever applies, for the conditional 
permission to take effect. Operations and Tech Support staff will need 
'regular' UPDATE access permission. (CONSOLE is a Default Return Code 8 class, 
so don't activate it without first creating a ** profile with UACC(READ).)

To see exactly what resource names are being checked that are allowing the 
unwanted job cancellations, issue the SDSF command SET SECTRACE ON, cancel the 
job, and then issue the SDSF command ULOG. ULOG will show you all the access 
checks SDSF is making along with the results of each of these checks. SECTRACE 
is a phenomenal diagnostic tool that we use often.

Regards, Bob

Robert S. Hansel
Lead RACF Specialist
RSH Consulting, Inc.  *** Celebrating our 30th Anniversary ***
617-969-8211
https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.linkedin.com%2Fin%2Froberthansel&data=05%7C01%7Cterri.shaffer%40ACIWORLDWIDE.COM%7Ca4b8cc465d9d4ac4987c08db09d46b79%7Cd1b7f1185cb24d4e85a382e07efb07e9%7C1%7C0%7C638114580161994985%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Em%2B3BnJ2qLn7XTrRRvmVtmo5gWOhCx2xDk%2FCAaEkZUg%3D&reserved=0
https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rshconsulting.com%2F&data=05%7C01%7Cterri.shaffer%40ACIWORLDWIDE.COM%7Ca4b8cc465d9d4ac4987c08db09d46b79%7Cd1b7f1185cb24d4e85a382e07efb07e9%7C1%7C0%7C638114580161994985%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=NHrWwR8EBpDn81MjpoubOzpQSJr1NGjmwVVmlYYzMjg%3D&reserved=0

-Original Message-
Date:Tue, 7 Feb 2023 13:31:41 +
From:"Shaffer, Terri" 
Subject: RACF - SDSF question

Hi,
 I know there is a RACF group, but hopefully this is simple and I am just 
missing something I have done 100 times over with no issues.

We run our CICS regions as batch jobs, and I just found out a user instead of 
them issuing a CEMT PERF SHUT command, they are canceling it.

Which then causing a 100 vsam messages on startup with all the verifies, and if 
something goes wrong they call me...

So I tried to stop this habit, I know they are putting a C beside the CICS and 
a $CJ(x) command

So I have 2 rules in RACF under OPERCMDS

JES2.CANCEL.BAT.C30TCI* (G)
JES2.CANCEL.BAT.** (G)

If I restrict the BAT.**  then they cant cancel even their own batch jobs, So I 
always thought more specific is looked at first?

One of my previous co-workers implemented SDSF-RACF rules converted from 
ISFPARMS.

Lastly, I understand this doesn't stop them from canceling any other jobs, but 
since this is a development shop we allow more access than most.

Re: JCL Procedure help

[Willy Jensen]

Since you are running a REXX anyway, that REXX could copy DDname SYSIN to a 
temporary dataset, which is then used for SYSIN in the 2nd step, A simple REPRO 
INFILE(SYSIN) OUTFILE(TEMP) should do it.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Goodbye and thanks for all the fish

[Michael Watkins]

It was an honor and a pleasure to work with you during the install of the 
Dell/EMC Data Domain (DD9800) & Disk Library for the mainframe (DLm2100).
Your technical expertise and clear explanations were invaluable to the success 
of the project, despite my clear preference for the IBM TS7700 alternative.
Your humor and positive attitude were appreciated and you will be missed as my 
employer now looks to refresh this solution.

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
carl swanson
Sent: Wednesday, February 8, 2023 6:46 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Goodbye and thanks for all the fish

While I have not been a very active member, I have been a very active lurker 
for years. My 45+ year journey is coming to an end again as my employer has 
picked my retirement date for me. I hope this time to do retirement correctly 
and make it work, previous attempts have failed maybe this time I can get it 
right.

It has been a pleasure for me to work with Mainframes and in my case Mainframe 
Virtual tape, that last part for most of my last 30 years.
I have learned many things from this group, including many that I would never 
use but were interesting.

Good luck to all and show the world that Mainframes are here to stay

Carl Swanson
215-688-1459
carl.swans...@verizon.net


--
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: Goodbye and thanks for all the fish

[Carmen Vitullo]

I will be joining you this Friday, been an on and off the list myself, 
I'm sorry that your company decided to retire you before you were ready, 
been there :( -  best of luck to you and enjoy the time you'll get back 
to do whatever you want


Carmen

On 2/8/2023 6:46 AM, carl swanson wrote:

 While I have not been a very active member, I have been a
very active lurker for years. My 45+ year journey is coming to an end again
as my employer has picked my retirement date for me. I hope this time to do
retirement correctly and make it work, previous attempts have failed maybe
this time I can get it right.

  


 It has been a pleasure for me to work with Mainframes and in
my case Mainframe Virtual tape, that last part for most of my last 30 years.
I have learned many things from this group, including many that I would
never use but were interesting.

  


 Good luck to all and show the world that Mainframes are here
to stay

  


Carl Swanson

215-688-1459

carl.swans...@verizon.net

  



--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
Carmen

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: RACF - SDSF question

[Rob Scott]

Bob makes some very good points here, however a small addition :

“The suggestions to lock down MVS cancel job commands won't help in this 
situation because SDSF is issuing JES2 commands instead of MVS commands, so the 
OPERCMDS MVS.CANCEL.JOB.jobname resources won't be checked.”

This is true for the action character in question, however be aware that SDSF 
also has actions like “K” from DA that generate MVS CANCEL commands rather than 
JES2.

Rob Scott
Rocket Software


From: IBM Mainframe Discussion List  On Behalf Of 
Robert S. Hansel (RSH)
Sent: 08 February 2023 13:00
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: RACF - SDSF question

EXTERNAL EMAIL



Hi Terri,

Here are a couple of thoughts to add to what others have mentioned.

Since SDSF is issuing a JES2 cancel job $CJ command, the name of the OPERCMDS 
resource being checked is JES2.CANCEL.BAT. Profile JES2.CANCEL.BAT.C30TCI* is 
superfluous since the resource name never includes the jobname, so you can 
delete it. Profile JES2.CANCEL.BAT.** is guarding JES2.CANCEL.BAT because the 
.** generic suffix applies to zero or more qualifiers, and in this case it is 
zero qualifiers. The suggestions to lock down MVS cancel job commands won't 
help in this situation because SDSF is issuing JES2 commands instead of MVS 
commands, so the OPERCMDS MVS.CANCEL.JOB.jobname resources won't be checked.

As was mentioned, to cancel a job typically also requires ALTER access to the 
JESSPOOL resource guarding the job. Look into setting up appropriate JESSPOOL 
profiles to isolate and restrict ALTER access to these jobs. Also consider 
whether users have been (inadvertently) set up as Destination Operators. If 
they have READ access to SDSF resource ISFOPER.DEST.JES2 and ALTER access to 
SDSF resources prefixed ISFAUTH.DEST., they can cancel jobs while bypassing 
JESSPOOL profile checks.

If the CONSOLE class is active, you can permit ID(*) UPDATE access to 
JES2.CANCEL.BAT.** conditionally by adding operand WHEN(CONSOLE(SDSF)) to the 
PERMIT command so that users can only issue JES2 cancel job commands from 
within SDSF panels. This would prevent them from cancelling jobs outside of 
SDSF, to include when using the SDSF / command. You would need to remove 
UACC(UPDATE) or ID(*) UPDATE permission, whichever applies, for the conditional 
permission to take effect. Operations and Tech Support staff will need 
'regular' UPDATE access permission. (CONSOLE is a Default Return Code 8 class, 
so don't activate it without first creating a ** profile with UACC(READ).)

To see exactly what resource names are being checked that are allowing the 
unwanted job cancellations, issue the SDSF command SET SECTRACE ON, cancel the 
job, and then issue the SDSF command ULOG. ULOG will show you all the access 
checks SDSF is making along with the results of each of these checks. SECTRACE 
is a phenomenal diagnostic tool that we use often.

Regards, Bob

Robert S. Hansel
Lead RACF Specialist
RSH Consulting, Inc. *** Celebrating our 30th Anniversary ***
617-969-8211
www.linkedin.com/in/roberthansel
www.rshconsulting.com

-Original Message-
Date: Tue, 7 Feb 2023 13:31:41 +
From: "Shaffer, Terri" 
mailto:terri.shaf...@aciworldwide.com>>
Subject: RACF - SDSF question

Hi,
I know there is a RACF group, but hopefully this is simple and I am just 
missing something I have done 100 times over with no issues.

We run our CICS regions as batch jobs, and I just found out a user instead of 
them issuing a CEMT PERF SHUT command, they are canceling it.

Which then causing a 100 vsam messages on startup with all the verifies, and if 
something goes wrong they call me...

So I tried to stop this habit, I know they are putting a C beside the CICS and 
a $CJ(x) command

So I have 2 rules in RACF under OPERCMDS

JES2.CANCEL.BAT.C30TCI* (G)
JES2.CANCEL.BAT.** (G)

If I restrict the BAT.** then they cant cancel even their own batch jobs, So I 
always thought more specific is looked at first?

One of my previous co-workers implemented SDSF-RACF rules converted from 
ISFPARMS.

Lastly, I understand this doesn’t stop them from canceling any other jobs, but 
since this is a development shop we allow more access than most.

But I don’t want users canceling a CICS or DB2 etc.

Any ideas how they are getting the access and not stopped with the more 
specific rule??


Ms Terri E Shaffer
Senior Systems Engineer,
z/OS Support:
ACIWorldwide – Telecommuter
H(412-766-2697) C(412-519-2592)
terri.shaf...@aciworldwide.com

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with 
the message: INFO IBM-MAIN


Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ 
Main Office Toll Free Number: +1

Re: JCL Procedure help

[Mikael Nystrom]

Not an answer to your question, but have you looked at the JCL statements 
SYSTEM, SYSAFF or SCHENV?

//Mikael

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Gadi Ben-Avi
Sent: den 8 februari 2023 13:45
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: JCL Procedure help

Hi,
I was asked to modify a procedure.
Currently, the procedure has one step.
This step receives input from SYSIN DD *

I was asked to add a step that would check that the JOB is running on the 
correct LPAR.
I wrote a small REXX program that check the LPAR, and returns condition code 8 
if it's not running on the correct LPAR.
I then added an if statement that will run the original step if the previous 
condition code is 0, and if not will issue a message.

The problem is that now the SYSIN DD is allocated to the first step.
I know I can code STEP.SYSIN to associate the SYSIN with correct step, but was 
wondering if there a way to code the procedure in a way so that I won't require 
changing the way the procedure is used.

We are running z/OS v2.3

Gadi


--
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: RACF - SDSF question

[Robert S. Hansel (RSH)]

Hi Terri,

Here are a couple of thoughts to add to what others have mentioned.

Since SDSF is issuing a JES2 cancel job $CJ command, the name of the OPERCMDS 
resource being checked is JES2.CANCEL.BAT. Profile JES2.CANCEL.BAT.C30TCI* is 
superfluous since the resource name never includes the jobname, so you can 
delete it. Profile JES2.CANCEL.BAT.** is guarding JES2.CANCEL.BAT because the 
.** generic suffix applies to zero or more qualifiers, and in this case it is 
zero qualifiers. The suggestions to lock down MVS cancel job commands won't 
help in this situation because SDSF is issuing JES2 commands instead of MVS 
commands, so the OPERCMDS MVS.CANCEL.JOB.jobname resources won't be checked.

As was mentioned, to cancel a job typically also requires ALTER access to the 
JESSPOOL resource guarding the job. Look into setting up appropriate JESSPOOL 
profiles to isolate and restrict ALTER access to these jobs. Also consider 
whether users have been (inadvertently) set up as Destination Operators. If 
they have READ access to SDSF resource ISFOPER.DEST.JES2 and ALTER access to 
SDSF resources prefixed ISFAUTH.DEST., they can cancel jobs while bypassing 
JESSPOOL profile checks.

If the CONSOLE class is active, you can permit ID(*) UPDATE access to 
JES2.CANCEL.BAT.** conditionally by adding operand WHEN(CONSOLE(SDSF)) to the 
PERMIT command so that users can only issue JES2 cancel job commands from 
within SDSF panels. This would prevent them from cancelling jobs outside of 
SDSF, to include when using the SDSF / command. You would need to remove 
UACC(UPDATE) or ID(*) UPDATE permission, whichever applies, for the conditional 
permission to take effect. Operations and Tech Support staff will need 
'regular' UPDATE access permission. (CONSOLE is a Default Return Code 8 class, 
so don't activate it without first creating a ** profile with UACC(READ).)

To see exactly what resource names are being checked that are allowing the 
unwanted job cancellations, issue the SDSF command SET SECTRACE ON, cancel the 
job, and then issue the SDSF command ULOG. ULOG will show you all the access 
checks SDSF is making along with the results of each of these checks. SECTRACE 
is a phenomenal diagnostic tool that we use often.

Regards, Bob

Robert S. Hansel
Lead RACF Specialist
RSH Consulting, Inc.  *** Celebrating our 30th Anniversary ***
617-969-8211
www.linkedin.com/in/roberthansel
www.rshconsulting.com

-Original Message-
Date:Tue, 7 Feb 2023 13:31:41 +
From:"Shaffer, Terri" 
Subject: RACF - SDSF question

Hi,
 I know there is a RACF group, but hopefully this is simple and I am just 
missing something I have done 100 times over with no issues.

We run our CICS regions as batch jobs, and I just found out a user instead of 
them issuing a CEMT PERF SHUT command, they are canceling it.

Which then causing a 100 vsam messages on startup with all the verifies, and if 
something goes wrong they call me...

So I tried to stop this habit, I know they are putting a C beside the CICS and 
a $CJ(x) command

So I have 2 rules in RACF under OPERCMDS

JES2.CANCEL.BAT.C30TCI* (G)
JES2.CANCEL.BAT.** (G)

If I restrict the BAT.**  then they cant cancel even their own batch jobs, So I 
always thought more specific is looked at first?

One of my previous co-workers implemented SDSF-RACF rules converted from 
ISFPARMS.

Lastly, I understand this doesn’t stop them from canceling any other jobs, but 
since this is a development shop we allow more access than most.

But I don’t want users canceling a CICS or DB2 etc.

Any ideas how they are getting the access and not stopped with the more 
specific rule??


Ms Terri E Shaffer
Senior Systems Engineer,
z/OS Support:
ACIWorldwide – Telecommuter
H(412-766-2697) C(412-519-2592)
terri.shaf...@aciworldwide.com

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Goodbye and thanks for all the fish

[Lionel B. Dyck]

May your retirement be long and enjoyable.


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

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of
carl swanson
Sent: Wednesday, February 8, 2023 6:46 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Goodbye and thanks for all the fish

While I have not been a very active member, I have been a
very active lurker for years. My 45+ year journey is coming to an end again
as my employer has picked my retirement date for me. I hope this time to do
retirement correctly and make it work, previous attempts have failed maybe
this time I can get it right.

 

It has been a pleasure for me to work with Mainframes and in
my case Mainframe Virtual tape, that last part for most of my last 30 years.
I have learned many things from this group, including many that I would
never use but were interesting. 

 

Good luck to all and show the world that Mainframes are here
to stay

 

Carl Swanson

215-688-1459

carl.swans...@verizon.net

 


--
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

Goodbye and thanks for all the fish

[carl swanson]

While I have not been a very active member, I have been a
very active lurker for years. My 45+ year journey is coming to an end again
as my employer has picked my retirement date for me. I hope this time to do
retirement correctly and make it work, previous attempts have failed maybe
this time I can get it right.

 

It has been a pleasure for me to work with Mainframes and in
my case Mainframe Virtual tape, that last part for most of my last 30 years.
I have learned many things from this group, including many that I would
never use but were interesting. 

 

Good luck to all and show the world that Mainframes are here
to stay

 

Carl Swanson

215-688-1459

carl.swans...@verizon.net

 


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

JCL Procedure help

[Gadi Ben-Avi]

Hi,
I was asked to modify a procedure.
Currently, the procedure has one step.
This step receives input from SYSIN DD *

I was asked to add a step that would check that the JOB is running on the 
correct LPAR.
I wrote a small REXX program that check the LPAR, and returns condition code 8 
if it's not running on the correct LPAR.
I then added an if statement that will run the original step if the previous 
condition code is 0, and if not will issue a message.

The problem is that now the SYSIN DD is allocated to the first step.
I know I can code STEP.SYSIN to associate the SYSIN with correct step, but was 
wondering if there a way to code the procedure in a way so that I won't require 
changing the way the procedure is used.

We are running z/OS v2.3

Gadi


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: RACF - SDSF question

[Robert S. Hansel (RSH)]

Ed,

What you suggest only applies to DATASET profiles. With General Resource 
profiles such as those for OPERCMDS, the profile is always Discrete if fully 
spelled out and Generic only if it has masking characters.

Regards, Bob

Robert S. Hansel
Lead RACF Specialist
RSH Consulting, Inc.  *** Celebrating our 30th Anniversary ***
617-969-8211
www.linkedin.com/in/roberthansel
www.rshconsulting.com

-Original Message-
Date:Tue, 7 Feb 2023 18:31:46 -0800
From:Ed Jaffe 
Subject: Re: RACF - SDSF question

On 2/7/2023 5:14 PM, Seymour J Metz wrote:
> Generic is usually more useful, but you can certainly use specific profiles.

Even discrete profiles can be made generic by specifying GENERIC when 
created.

That's what we do here. We have NO discrete profiles, but we do have 
generic profiles with no wildcard characters in them.


-- 
Phoenix Software International
Edward E. Jaffe
831 Parkview Drive North
El Segundo, CA 90245
https://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: FTP

[John McKown]

Silly question of me, but does your z box have access to the Internet? Ours
doesn't. I must stage everything through a Windows desktop.

Can you use the TSO PING command on that URL?

On Tue, Feb 7, 2023 at 12:09 PM Steve Beaver  wrote:

> What am I missing or is the URL incorrect?  It times out
>
>
>
> //A819822A JOB (CISHRA,),FTPIBMHOLD,MSGCLASS=X,PRTY=14,
>
> //  CLASS=S,NOTIFY=&SYSUID
>
> //*
>
> //S1 EXEC PGM=FTP,REGION=4M,PARM='service.boulder.ibm.com'
>
> //SYSPRINT DD SYSOUT=*
>
> //SYSMDUMP DD SYSOUT=*
>
> //SYSTSPRT DD SYSOUT=*
>
> //OUTPUT   DD SYSOUT=*
>
> //INPUTDD *
>
> ANONYMOUS
>
> steve.beaver@
>
> cd /s390/holddata
>
> ls
>
> locsite cy pri=01 sec=01 rec=fb lr=80 blk=8000
>
> get full.txt 'A819822.HOLDDATA' (replace
>
> quit
>
> //
>
> get year.txt 'A819822.HOLDDATA' (replace
>
> quit
>
> //
>
>
> --
> 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