Re: [EXTERNAL] Re: I knew Cobol 6.3 takes more resources to compile than 4.2 but should I be concerned about how much?

2022-04-18 Thread Feller, Paul
On an lpar with 25g of memory we run the COBOL 6.2 compiles with a region of 512M. This is from a program that has well over 25,000 lines of code. Had OPT(0) set plus lots of debug stuff turned on. IEF373I STEP/COB6/START 2022109.0219 IEF032I STEP/COB6

Re: DB2: Combining result sets

2022-04-18 Thread Bob Bridges
Ah, thank you! I got to the point where I thought I was pretty comfortable with SQL, but clearly I've been away longer than I realized. --- Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313 /* Error saving file. Format drive now (Y/y)? */ -Original Message- From: IBM Mainframe

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Charles Mills
Except when they don't: https://www.ibm.com/docs/en/zos/2.3.0?topic=functions-ffs-find-first-set-bit -in-integer Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Seymour J Metz Sent: Monday, April 18, 2022 3:35 PM To:

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Seymour J Metz
Some IBM documentation gives bit numbers 0-7 and other documentation gives the masks for those bits: bit 0 is mask 80, bit 1 is mask 40 ... bit 7 is mask 01. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Seymour J Metz
No, IBM numbers bits from the left. In an 8-bit field, bit 0 corresponds to a mask of '80'x and bit 7 to a maskm of '01'x. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf

Re: [EXTERNAL] Re: I knew Cobol 6.3 takes more resources to compile than 4.2 but should I be concerned about how much?

2022-04-18 Thread Farley, Peter x23353
It will be interesting to see what IBM responds to your ticket. Please share if you can when it is closed. I wonder if using the pre-processor vs the co-processor for the CICS compile would affect the total time, if you are able to set up JCL to allow that. We don't use the co-processor here

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Charles Mills
You're right of course. Other systems count bits the other direction. You can make an argument for either approach. - 0 as the high bit corresponds to how we generally represent binary integers, with the high order bit on the left. - 0 as the low bit gives you consistency across 8, 16, 32 and 64

Re: DB2: Combining result sets

2022-04-18 Thread Bernd Oppolzer
If the results in col1, col2 and col3 may be different for the same "something" condition in tables table1 thru table3, my solution is not correct. In this case, you need some sort of "select from table1 ... union all ... select from table2 where not exists (result from table1)" etc. etc. But

Re: [EXTERNAL] Re: I knew Cobol 6.3 takes more resources to compile than 4.2 but should I be concerned about how much?

2022-04-18 Thread Pommier, Rex
Hi Peter, I agree that IBM has warned of significantly higher CPU and memory requirements, and we've seen increases, but to go from .3 CPU seconds to over 500 - a 1500 fold increase seems more than a bit excessive to me. We're using the CICS coprocessor. Rex -Original Message-

Re: SYSLOG port usage

2022-04-18 Thread Pew, Curtis G
On Apr 18, 2022, at 12:48 PM, Tom Longfellow <03e29b607131-dmarc-requ...@listserv.ua.edu> wrote: > > I have been wandering in the wilderness of unix syslogs under z/OS and have > been unable to find a definitive answer to the following question. > > Does z/OS SYSLOGD daemon support TCP

Re: DB2: Combining result sets

2022-04-18 Thread Bernd Oppolzer
select col1, col2, col3, min (wherefound) from (select col1, col2, col3, 'source 1' as wherefound from table1 where something union ALL select col1, col2, col3, 'source 2' as wherefound from table2 where something union ALL

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Michael Oujesky
My reading of Principals of Operation indicates register documentation has bit 0 as the high order bit, not lower order bit. Michael At 11:20 AM 4/18/2022, Charles Mills wrote: Sorry. Bit 0 is usually the X'01' bit in mainframe doc (other than UNIX). So is my interpretation correct?

Re: I knew Cobol 6.3 takes more resources to compile than 4.2 but should I be concerned about how much?

2022-04-18 Thread Charles Mills
In my research for a client we saw dramatically increased compile times, both CPU and elapsed, for COBOL 6.2 as opposed to 4.2. It was particularly dramatic for larger programs, and with OPT(1) and OPT(2). Charles -Original Message- From: IBM Mainframe Discussion List

Re: I knew Cobol 6.3 takes more resources to compile than 4.2 but should I be concerned about how much?

2022-04-18 Thread Farley, Peter x23353
Memory usage is much higher in the COBOL V5/6.x versions than in any earlier version. IBM tells you this explicitly in all its migration advice that I have seen. In our shop we use the max locally allowed memory per programmer batch job (IEFUTL00 limit) for every compile step, 640M. IBM also

I knew Cobol 6.3 takes more resources to compile than 4.2 but should I be concerned about how much?

2022-04-18 Thread Pommier, Rex
Hi list, Should I be concerned about the amount of resources Cobol 6.3 is occasionally using as compared to 4.2? I have one particular example that was brought to our attention due to the fact that we ran out of page space in our small shop. I finally got it to compile after tripling my page

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Charles Mills
Thanks but it is pretty clear that the bits are X'80' and so forth. The client was seeing 1, 2 and 3 because they were looking at the wrong byte (SMF30MES). Displaying the correct byte they are seeing 128's, which is good -- says audit is on but no usage. Charles -Original Message-

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Tony Harminc
On Mon, 18 Apr 2022 at 12:20, Charles Mills wrote: > > Sorry. Bit 0 is usually the X'01' bit in mainframe doc (other than UNIX). I think you were right the first time. Tony H. > So is my interpretation correct? > > SMF30_USERKEYCSAUSAGE is x'02'? > > Charles > > > -Original Message- >

Re: DB2: Combining result sets

2022-04-18 Thread Binyamin Dissen
I should have mentioned that this is a cursor. On Mon, 18 Apr 2022 14:32:11 -0400 Bob Bridges wrote: :>Are col1, col2 and col3 going to be identical in all three tables? You :>don't need to know which table they came from? :> :>Offhand it seems to me you want a subquery, something like this:

Re: DB2: Combining result sets

2022-04-18 Thread Bob Bridges
Are col1, col2 and col3 going to be identical in all three tables? You don't need to know which table they came from? Offhand it seems to me you want a subquery, something like this: Select first col1 col2 col3, src From ( select col1, col2 col3, 'source 1' from table1 where

SYSLOG port usage

2022-04-18 Thread Tom Longfellow
I have been wandering in the wilderness of unix syslogs under z/OS and have been unable to find a definitive answer to the following question. Does z/OS SYSLOGD daemon support TCP protocol connections for incoming messages from other hosts?? -- Here are the gory details. 1. A DS8884 -

DB2: Combining result sets

2022-04-18 Thread Binyamin Dissen
Seems that I have been knocked off of the DB2-L listserv. I am doing a union of three queries where it is possible that the critical columns are in more than one of the queries. For example: select col1, col2 col3, 'source 1' from table1

Re: HS student with question about small mainframe DASD

2022-04-18 Thread Mike Schwab
Or " I bought a z114, now what? " Share presentation? On Mon, Apr 18, 2022 at 9:55 AM Seymour J Metz wrote: > > If he gets it up, might IBM ask him to write up the experience for a redbook? > > > -- > Shmuel (Seymour J.) Metz > http://mason.gmu.edu/~smetz3 > >

FW: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Barry Merrill
MXG decodes these raxflags: SMF30_RAXFLAGS='AUDIT*USERKEY*CSA*FLAGS' SMF30_RAXFLAG0='RAX0*USERKEY*COMMON*AUDIT*ENABLED?' SMF30_RAXFLAG1='RAX1*USERKEY*COMMON*AUDIT*USAGE?' SMF30_RAXFLAG2='RAX2*USERKEY*CADS*USAGE?' SMF30_RAXFLAG3='RAX3*USERKEY*CHANGE*KEY*USAGE?'

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Charles Mills
Thanks. The customer is reporting 1's, 2's and 3's, so there must be some program logic confusion. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Dave Jousma Sent: Monday, April 18, 2022 9:32 AM To:

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Barry Merrill
MXG decodes as: SMF30_RAXFLAGS='AUDIT*USERKEY*CSA*FLAGS' SMF30_RAXFLAG0='RAX0*USERKEY*COMMON*AUDIT*ENABLED?' SMF30_RAXFLAG1='RAX1*USERKEY*COMMON*AUDIT*USAGE?' SMF30_RAXFLAG2='RAX2*USERKEY*CADS*USAGE?' SMF30_RAXFLAG3='RAX3*USERKEY*CHANGE*KEY*USAGE?'

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Dave Jousma
On Mon, 18 Apr 2022 08:32:53 -0700, Charles Mills wrote: >We have a client who is trying to report on user key CSA usage. He is having >trouble understanding the IBM doc, as am I. > >The SMF doc I am familiar with documents bits as X'80', X'40', etc. But the >SMF30_RAXFLAGS doc (both the APAR

Re: Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Charles Mills
Sorry. Bit 0 is usually the X'01' bit in mainframe doc (other than UNIX). So is my interpretation correct? SMF30_USERKEYCSAUSAGE is x'02'? Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Charles Mills Sent: Monday, April

Trying to understand SMF30_RAXFLAGS

2022-04-18 Thread Charles Mills
We have a client who is trying to report on user key CSA usage. He is having trouble understanding the IBM doc, as am I. The SMF doc I am familiar with documents bits as X'80', X'40', etc. But the SMF30_RAXFLAGS doc (both the APAR and the new manual) documents the bits as Bit 0, Bit 1, etc.

Re: HS student with question about small mainframe DASD

2022-04-18 Thread Grant Taylor
On 4/18/22 12:08 AM, David Crayford wrote: Hardware geeks like to buy hardware. It's a bit like asking me why I want to own a Sinclair Spectrum or a BBC Micro when I can run ZX Spectrum emulator in a browser or install RetroPie on one of my Raspberry Pi's! Emulation is just not the same

Re: HS student with question about small mainframe DASD

2022-04-18 Thread Enzo D'Amato
>>5. A tape drive and controller > >Not required. Are you thinking of initial startup/OS installation? On this >vintage >machine there should be non-tape IPL (startup/“bootstrap”) options, notably >HMC DVD. >Such options were standard well before the z114. Assuming Enzo gets a working >HMC

Re: HS student with question about small mainframe DASD

2022-04-18 Thread Seymour J Metz
Yes, Linux should run on it. "DEASD" is a typo and should be DASD. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Joe Monk [joemon...@gmail.com] Sent: Sunday, April

Re: HS student with question about small mainframe DASD

2022-04-18 Thread Seymour J Metz
Now there's an antique! -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Paul Gilmartin [000433f07816-dmarc-requ...@listserv.ua.edu] Sent: Sunday, April 17, 2022

Re: Reliable source for OCO?

2022-04-18 Thread Seymour J Metz
I believe that the grammar is corrrect, but the duplication is a typo. Yes, I meant to include z/OS. I did not know whther OCO applied to z/TPF. The {{dubious}} template was at the end of a string of footnotes, so I may have misinterpreted its scope. The logic manuals that I cited are not for

Re: HS student with question about small mainframe DASD

2022-04-18 Thread Seymour J Metz
If he gets it up, might IBM ask him to write up the experience for a redbook? -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Timothy Sipples [sipp...@sg.ibm.com] Sent:

Re: HS student with question about small mainframe DASD

2022-04-18 Thread Seymour J Metz
I had forgotten when the DVD option was available. You can run z/OS from the HMC, if you're a masochist; I'm not sure about other systems. I would consider OSAA-ICC to be a cluster controller. As a point of curiosity, what are his licensing options if he decides to look at z/OS or z/VM? --

Re: HS student with question about small mainframe DASD

2022-04-18 Thread David Crayford
On 16/4/22 06:58, Grant Taylor wrote: Hi, I am a US high school student who is seriously considering acquiring a z114 mainframe. I hope that I don't come off too wrong when I ask, but why do you want a z114?  --  I completely get wanting a mainframe.  --  But why a z114? Hardware geeks

Re: HS student with question about small mainframe DASD

2022-04-18 Thread Timothy Sipples
Shmuel Metz wrote: >There are several issues that you will need to deal with in order to >get a running system. >[] >2. Licensed internal code for the CEC, which may or may not >need an upgrade I’d say this part doesn’t matter. Whatever level(s) of LIC firmware are on the machine are