Re: Goodbye and thanks for all the fish

I'm really saddened to heat of his passing - my deep sympathies to you and your family. His contributions here were excellent and he will definitely be missed. My condolences to you and your family. -- For IBM-MAIN subscribe /

Re: Hsm for system dump volume

I migrate the individual dumps directly to ML2 for 30 days. I migrate them once they reach 3 days in age. If I need it longer than that then I just change the mgmtclas. Mostly, any problems are fixed within that time. If you have dumps that you don't want that get migrated, just HDEL them.

Re: 3420 conversion?

On Thu, 9 Feb 2023 at 22:00, Tony Thigpen wrote: > This is an ICCF backup from '82 that I have keep inside all these years. [...] > What state are you in? I am not sure I want to mail it and it get damaged. Even more reason not to send it to me - I'm in Toronto (Ontario), so you doubtless don't

Re: 3420 conversion?

Tony H., This is an ICCF backup from '82 that I have keep inside all these years. It is from my first job and that company is long gone. There is one specific program that I wrote then that I want to revive. While I would rewrite it in assembler (it's FCOBOL), the logic was complicated and I

Re: 3420 conversion?

On Thu, 9 Feb 2023 at 20:33, Tony Thigpen wrote: > I need a single 3420 tape converted. Anyone know of someone that can do it? Buncha questions... Where is the tape, how much of a rush are you in, what's the recording density/tracks, how old is the tape itself, how old is the recording, how bad

Re: 3420 conversion?

Found this link. https://datadesigninc.com/tape-conversions/ Mark Jacobs Sent from ProtonMail, Swiss-based encrypted email. GPG Public Key - https://api.protonmail.ch/pks/lookup?op=get=markjac...@protonmail.com --- Original Message --- On Thursday, February 9th, 2023 at 8:32 PM,

3420 conversion?

I need a single 3420 tape converted. Anyone know of someone that can do it? Tony Thigpen -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: I want to cry

From: IBM Mainframe Discussion List on behalf of Bob Bridges Sent: Thursday, February 9, 2023 6:08 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: I want to cry Some people indicate ":)" by "" or "" or the like.

Re: I want to cry

Some people indicate ":)" by "" or "" or the like. The nice thing about that is that you can put ~anything~ in there to make the meaning clear. and , for example; I know I'm not the only one to use that. --- Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313 /* Never pick a fight with

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

I have had management sign off on the risk after I estimated the effort it would take to remediate an issue. Being a security geek myself, sometimes I disagree with the risk; other times I think they're being reasonable. But I'm not the one entrusted with that decision, after all. But yeah,

Re: I want to cry

:-) I need emojis..text emojis make no sense to me. Hank -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: I want to cry

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

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

We have such requirements related to the necessary need to restore data for clients who have legal controls, old active archives for decades…, and keep tapes in vaults in case of. Next week we receive a client who needs to restore tapes created 10 years ago, never read since on I platform, we

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

Wouldn't you agree that ultimately, the CIO or CTO or highest Information Technology is responsible for any and all mishaps, including mistakes made by auditors? Hiring the correct auditor and giving them the correct scope of work which is the hiring companies responsibility. I also saw this

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

Bob, OK, most auditors don't shoot the survivors directly, but in many instances, the company's management simply takes the auditors at their words and shoot the survivors on behalf of the same auditors. In my career, I've been in both positions; that of having blind management and having

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

I think we might have missed this: tom.longfel...@courts.state.md.us... The Maryland State AG's office and the Maryland State Archives are the regulatory agencies involved. When working with other states, we called the Archives to get directions... https://msa.maryland.gov They might be

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

Steve Thompson's reply about lawyers got to me to look at this bit about auditors. Do auditors ~ever~ shoot the survivors? In my experience, both internal and external auditors report to management; it is management who decide whether to fix the problem or sign off on the risk. I don't think

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

Tom, this has been building up for a while: I've gotten to the point where I open up your posts, see that I don’t know what they're about, and close them without reading them. It's a shame, because I think you have information to add. But if you keep deleting ~all~ the previous text before

Re: INFO IBM-MAIN

On Thu, 9 Feb 2023 19:08:43 +, Larry Zhang wrote: > INFO IBM-MAIN > Follow the instructions at the bottom of each message. Or: -- gil

Hsm for system dump volume

Can anyone recommend how to set up HSM to manage my sys1.dump datasets? Currently they are dynamically allocated on one non sms device. Would auto migration suffice? Ideally keep on device for x days then migrate or backup with delete? Sorry not versed in HSM.

INFO IBM-MAIN

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

Re: New DB2 external Stored Procedure question - setting sqlcode/sqlstate

On Thu, 9 Feb 2023 18:01:24 + Sri h Kolusu wrote: :>>>2. How can I specify the SQLSTATE so that NOT FOUND will be the condition? I am writing the SP itself in COBOL and want to return an SQLCODE. :>Assuming that you are calling the Stored procedure from COBOL, here is an example of how

Re: New DB2 external Stored Procedure question - setting sqlcode/sqlstate

On Thu, 9 Feb 2023 13:01:00 -0500 "Lance D. Jackson" wrote: :>The -818 SQLCode is a timestamp disparity between the load module and the :>DBRM. Make sure that the WLM which the SP runs in has been properly :>refreshed since the SP was last built. When the SQL in the SP gets SQLCODE, the SP

Re: Goodbye and thanks for all the fish

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

Re: New DB2 external Stored Procedure question - setting sqlcode/sqlstate

>>2. How can I specify the SQLSTATE so that NOT FOUND will be the condition? Binyamin Dissen, Assuming that you are calling the Stored procedure from COBOL, here is an example of how the SQLCODES are handled.

Re: New DB2 external Stored Procedure question - setting sqlcode/sqlstate

Binyamin, The -818 SQLCode is a timestamp disparity between the load module and the DBRM. Make sure that the WLM which the SP runs in has been properly refreshed since the SP was last built. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Binyamin Dissen Sent:

New DB2 external Stored Procedure question - setting sqlcode/sqlstate

I am trying to return a NOT FOUND condition, so I am setting the SQLSTATE parameter to '02000' However, the calling program is getting DSNT408I SQLCODE = -443, ERROR: ROUTINE SP01 (SPECIFIC NAME SP01) HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC TEXT DSNT418I SQLSTATE = 02000

Re: Calling a COBOL DB2 Stored Procedure

Found the problem: I needed to specify PACKAGE PATH in the CREATE PROCEDURE. On Tue, 7 Feb 2023 15:21:07 -0600 Mike Bell wrote: :>start from the basics - I assume the plan name is DSNREXX. you can :>1. bind the DSNREXX plan with your collection and it will find it in the :>search list :>2; SET

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

In case someone else will need such code, this is my rexx from 2012 to scan the db2 catalog for tables and table structures and build a csv file out of it. See the parse statement for the variables passed to the program. As this is a rexx, you can run multiple iterations under single tso batch

Re: Goodbye and thanks for all the fish

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

Re: zOSMF

IIRC that cgf file is built based on what's in the IZUPRMxx member plus any local_override.cfg files you provide Carmen On 2/9/2023 9:26 AM, Matthew Stitt wrote: There are two places it is specified. One is in the configuration directory, member "active_configuration.cfg". The other is in

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

You already have tools on zOS DB2 to do this ... SELECT LASTNAME, X'05', FIRSTNAME, X'05' DEPARTMENT, X'05' STATUSDATE using SPUFI Use multiple SPUFI jobs. One to list the columns of the tables you're interested in; REXX to reformat that output in to more SELECT

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

DBeaver looked like a really good chance at a solution. The problem I found is that it does not access to a license for DB2 Connect. Some JAVA file that allows the door to open. The chance of buying new licenses for migration of a system is virtually zero. Back to the drawing board

Re: zOSMF

There are two places it is specified. One is in the configuration directory, member "active_configuration.cfg". The other is in the IZUPRMxx member. It seems the directory member takes precedent, as I had a subsystem running without specifying JAVA_HOME in the IZUPRMxx and the subsystem

Re: zOSMF

got ya! I can't recall specifics but I do know I had some issues migrating due to the userdir location change I think others have suggested checking for Java 64 bit, the other error indicated the server could not locate the J8_64 environment in your IZUPRMxx member do you have JAVAHOME

Re: zOSMF

Sorry, forgot to mention we are at z/OS V2R5. Matthew On Thu, 9 Feb 2023 08:46:47 -0600, Matthew Stitt wrote: >I still use "/var/zosmf" My z/OS MF runs on one LPAR only, so that setting is >valid. "/global/zosmf" is good if you configure z/OS MF to run on multiple >LPARs and want to share

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

Preservation of data is a legal issue as much as a technical one. The rules are established by the legal entity and then implemented via a technical solution. I had one client in Europe that was faced with the same situation. The country's government wanted to be able to rapidly review the

Re: zOSMF

I still use "/var/zosmf" My z/OS MF runs on one LPAR only, so that setting is valid. "/global/zosmf" is good if you configure z/OS MF to run on multiple LPARs and want to share the "../user" information directory. Also if you have been successful in getting it to run distributed in a

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

I think I know what you are replying to, a posting by Tom Marchant who beat me to this point. I'm not an attorney, but I have had to work with and around many. If I remember correctly, there is a legal requirement to be able to go back and reproduce reports for some number of years. I think

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

ObSturgeonsLaw It is certainly true that there are a lot of bad auditors, but a good auditor can be a life saver. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Tom

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

VERY GOOD POINT. Interesting that the subjects of Lawyers has not been brought up here at all. It is a Judiciary agency and Everybody is a wanna-be Lawyer or Judge. And my opinion of Auditors is pretty low.They just come in. Rerun procedures and checks developed in the 70's and published

Re: Goodbye and thanks for all the fish

My condolences as well. Bob was well known on the list and will be missed. Rob On Thu, Feb 9, 2023, 08:25 Seymour J Metz wrote: > I never met him in person, but the news was still a shock. > > > -- > Shmuel (Seymour J.) Metz > http://mason.gmu.edu/~smetz3 > >

Re: Goodbye and thanks for all the fish

I never met him in person, but the news was still a shock. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Carmen Vitullo [petevi...@gmail.com] Sent: Thursday, February

Re: Goodbye and thanks for all the fish

Classification: Confidential He will be missed. Condolences to you Rebecca. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Rebecca Richards Sent: Wednesday, February 8, 2023 5:52 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Goodbye and thanks for all the fish

Re: Goodbye and thanks for all the fish

OMG - I"m so sorry Rebecca, I worked with Bob at Boeing, and reconnected to him here on this list, we talked some off list some about our past tenure at Boeing but mostly about family, he will truly be missed, again so sorry for your loss :( Carmen On 2/9/2023 2:40 AM, Rob Scott wrote:

Re: ISPF macro/script

It will work, that is how I usually do it. And so will this: "line_after .zl = 'this is a new line'" "line_after .zl = ' and so is this '" Though I prefer to assigh the value to a variable and then use that, mostly because it is easier to handle quotes and complex strings that way.

Re: Goodbye and thanks for all the fish

Rebecca I interacted with Bob many times over the years in IBM-Main and via e-mail and he was a true gentleman. He will be greatly missed. Rob Scott Rocket Software -Original Message- From: IBM Mainframe Discussion List On Behalf Of Rebecca Richards Sent: 08 February 2023 23:52 To: