Re: FTP

2023-02-08 Thread 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 >

Re: RACF - SDSF question

2023-02-08 Thread 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.

JCL Procedure help

2023-02-08 Thread 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 no

Goodbye and thanks for all the fish

2023-02-08 Thread 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 mayb

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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

Re: RACF - SDSF question

2023-02-08 Thread 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 jobnam

Re: JCL Procedure help

2023-02-08 Thread 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

Re: RACF - SDSF question

2023-02-08 Thread 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

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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:

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 alterna

Re: JCL Procedure help

2023-02-08 Thread 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 / si

Re: RACF - SDSF question

2023-02-08 Thread 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 Sup

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 _

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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? > >

Re: JCL Procedure help

2023-02-08 Thread 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

Re: JCL Procedure help

2023-02-08 Thread 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 tempo

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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-MA

Re: JCL Procedure help

2023-02-08 Thread 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@lis

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 Mainf

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 a

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 organi

TEAMS usage

2023-02-08 Thread 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 th

Re: TEAMS usage

2023-02-08 Thread 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

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 / signof

Re: TEAMS usage

2023-02-08 Thread 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 c

Re: TEAMS usage

2023-02-08 Thread 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 ne

Shopz

2023-02-08 Thread 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

2023-02-08 Thread 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

Re: JCL Procedure help

2023-02-08 Thread 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 deter

Re: Shopz

2023-02-08 Thread 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

Re: JCL Procedure help

2023-02-08 Thread 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

Re: Shopz

2023-02-08 Thread 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

Re: JCL Procedure help

2023-02-08 Thread 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 sy

Re: Having a little difficulty with a REXX command LMOPEN

2023-02-08 Thread 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

Re: Having a little difficulty with a REXX command LMOPEN

2023-02-08 Thread 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

Re: Shopz

2023-02-08 Thread 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,

GIM56401S

2023-02-08 Thread 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

Re: Shopz

2023-02-08 Thread 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 firewal

Re: GIM56401S

2023-02-08 Thread 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

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

2023-02-08 Thread 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

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

2023-02-08 Thread 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 other

Re: TEAMS usage

2023-02-08 Thread 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 > uninst

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

2023-02-08 Thread 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 w

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

2023-02-08 Thread 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 ca

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

2023-02-08 Thread 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 Longf

zOSMF

2023-02-08 Thread 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: /ZOSV2

Re: TEAMS usage

2023-02-08 Thread 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

Re: zOSMF

2023-02-08 Thread 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 s

Re: zOSMF

2023-02-08 Thread 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

Re: TEAMS usage

2023-02-08 Thread 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

Re: TEAMS usage

2023-02-08 Thread 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 de

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

2023-02-08 Thread 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

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

2023-02-08 Thread 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

Re: TEAMS usage

2023-02-08 Thread 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:

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

2023-02-08 Thread 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

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

2023-02-08 Thread 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 co

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

2023-02-08 Thread 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 hav

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

2023-02-08 Thread 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 anoth

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

2023-02-08 Thread 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 oth

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

2023-02-08 Thread 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

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

2023-02-08 Thread 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 torpedo

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

2023-02-08 Thread 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 d

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

2023-02-08 Thread 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,

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

2023-02-08 Thread 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. -

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

2023-02-08 Thread 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

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

2023-02-08 Thread 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

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

2023-02-08 Thread 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 vi

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

2023-02-08 Thread 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 /

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

2023-02-08 Thread 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

Re: TEAMS usage

2023-02-08 Thread 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 me

Re: TEAMS usage

2023-02-08 Thread 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

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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

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

2023-02-08 Thread 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

Re: JCL Procedure help

2023-02-08 Thread 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:

Re: JCL Procedure help

2023-02-08 Thread 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 > > [E

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

2023-02-08 Thread 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

JES2 PURGEd output

2023-02-08 Thread 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

Re: JES2 PURGEd output

2023-02-08 Thread 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 jus

Re: JCL Procedure help

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

2023-02-08 Thread 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

Re: RACF - SDSF question

2023-02-08 Thread 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 co

Re: RACF - SDSF question

2023-02-08 Thread 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

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 Subje

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 a

Re: ISPF macro/script

2023-02-08 Thread 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 = (Template

Re: ISPF macro/script

2023-02-08 Thread 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 >

Re: Goodbye and thanks for all the fish

2023-02-08 Thread 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 peop

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

2023-02-08 Thread 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