Re: Transferring hebrew data from Db2 Z/OS to PC

[David Crayford]

On 9/01/2018 1:51 PM, Timothy Sipples wrote:

OK, first comment: why the  are you FTP'ing data in the first place?
This isn't 1989 any more.:-)  And this is a serious question. It's
increasingly expensive and fraught with security risks to copy data
wantonly. What's this PC going to do with a bulk, point-in-time dump of all
this data?


The OP stated that he was using Rocket Software's BlueZone FTP, which is 
secure and effecient.


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

Re: Transferring hebrew data from Db2 Z/OS to PC

[ITschak Mugzach]

I wonder how will it solve the Hebrew reading direction issue...

ITschak

בתאריך 9 בינו׳ 2018 7:51 לפנה״צ,‏ "Timothy Sipples" 
כתב:

> OK, first comment: why the  are you FTP'ing data in the first place?
> This isn't 1989 any more. :-) And this is a serious question. It's
> increasingly expensive and fraught with security risks to copy data
> wantonly. What's this PC going to do with a bulk, point-in-time dump of all
> this data?
>
> Now, trying to answer your question directly (and perhaps at your own
> peril):
>
> 1. I see in DB2-L that Kai Stroh already suggested checking your UNLOAD
> options. That's a good suggestion.
>
> 2. You can very likely use an ETL/ELT tool that specializes in this sort of
> work, notably IBM InfoSphere DataStage (preferably running on the IBM Z
> machine itself). InfoSphere DataStage Version 11.7 was released in
> December, 2017.
>
> 3. The Db2 cross-loader function is another possible option, as a part of
> the data journey anyway. You would set up a Db2 instance on the target
> platform (such as on the IBM Z machine itself, with Db2 for Linux), and
> you'd use the cross-loader function, with Db2 for z/OS as the input and Db2
> on the other machine as the target. If any encoding scheme conversion is
> required, the cross-loader should handle it. You can find some more
> information on the cross-loader here (Db2 for z/OS Version 12 assumed):
>
> https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.
> 0.0/ugref/src/tpc/db2z_loadusecrossloaderfunction.html
>
> 4. Db2 High Performance Unload for z/OS might add some value here. The
> latest version is 5.1 as I write this.
>
> 5. One more try per the first comment: just access the data (more securely)
> using Db2 for z/OS native RESTful interfaces (HTTPS instead of FTP). See
> here for details, in brief:
>
> http://www.idug.org/p/bl/et/blogid=477=544
>
> http://db2geek.triton.co.uk/db2-native-rest-api-getting-started/
>
> 
> 
> Timothy Sipples
> IT Architect Executive, Industry Solutions, IBM Z and LinuxONE, AP/GCG/MEA
> E-Mail: sipp...@sg.ibm.com
>
> --
> 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: Transferring hebrew data from Db2 Z/OS to PC

[Timothy Sipples]

OK, first comment: why the  are you FTP'ing data in the first place?
This isn't 1989 any more. :-) And this is a serious question. It's
increasingly expensive and fraught with security risks to copy data
wantonly. What's this PC going to do with a bulk, point-in-time dump of all
this data?

Now, trying to answer your question directly (and perhaps at your own
peril):

1. I see in DB2-L that Kai Stroh already suggested checking your UNLOAD
options. That's a good suggestion.

2. You can very likely use an ETL/ELT tool that specializes in this sort of
work, notably IBM InfoSphere DataStage (preferably running on the IBM Z
machine itself). InfoSphere DataStage Version 11.7 was released in
December, 2017.

3. The Db2 cross-loader function is another possible option, as a part of
the data journey anyway. You would set up a Db2 instance on the target
platform (such as on the IBM Z machine itself, with Db2 for Linux), and
you'd use the cross-loader function, with Db2 for z/OS as the input and Db2
on the other machine as the target. If any encoding scheme conversion is
required, the cross-loader should handle it. You can find some more
information on the cross-loader here (Db2 for z/OS Version 12 assumed):

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/ugref/src/tpc/db2z_loadusecrossloaderfunction.html

4. Db2 High Performance Unload for z/OS might add some value here. The
latest version is 5.1 as I write this.

5. One more try per the first comment: just access the data (more securely)
using Db2 for z/OS native RESTful interfaces (HTTPS instead of FTP). See
here for details, in brief:

http://www.idug.org/p/bl/et/blogid=477=544

http://db2geek.triton.co.uk/db2-native-rest-api-getting-started/


Timothy Sipples
IT Architect Executive, Industry Solutions, IBM Z and LinuxONE, AP/GCG/MEA
E-Mail: sipp...@sg.ibm.com

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

Re: VSAM Performance - CPU reduction

[Arun Venkatratnam]

Hi Ron and all, 

I have captured the strobe report for the full run of the job. I will try to 
send it to later. In addition to strobe, i snapped the below statistics of the 
job from Mainview. The report shows that the EXCP and the SSCH counts are 
almost equal. I am of the understanding that if SSCH count can be reduced it 
can help in CPU reduction. Could you please provide some direction on to reduce 
the SSCH count. 

FYI,I also tried with data CISZ of 18K, 30K and 32K. 18K and 26K look to show 
almost similar performance of taking 6.5 CPU minutes for the test files with 
32M records. 26K CISZ showed the least EXCP counts amongst all..
 

CURR WIN ===> 1ALT WIN ===>
>W1 =JDELAYZ==JINFOB33N=*08JAN2018==15:19:20MVMVSD1
 Timeframe... IntervalOwner...SYLFA4V  0...
 Jobname. TSTJEMEMAvg Frames..   5120Workflow... 7.46  
 Step/Proc...STEP1Avg Cframes.   5120Total Use.. 7.46  
 Job Step Mon Avg Eframes.  0 Using Proc 2.99  
 JES Number.. JOB82957Cframes held   5125 Using Dev. 4.48  
 Type  BATEframes held  0Total Dly..92.54  
 JobClassXFixed frames259 Processor.92.54  
 JES Queue Tm 00:00:01Fixed <16M..  0 Device 0.00  
 %CPU Util...  7.4Fixed 16-2G. 38 Storage... 0.00  
 Total CPU Tm 00:04:06Dmd Page/Sec  0 Enqueue... 0.00  
 Totl ECPU Tm 00:04:06Swp Page/Sec  0 SRM... 0.00  
 Tot EXCP Cnt   106547Avg UIC.N/A Msg... 0.00  
 Terminal ID. Avg Wkg Set.0.0 XCF... 0.00  
 ASID  364SU/Sec..   5027 JES... 0.00  
 SrvClassBATMDEXCP/Sec   55.8 HSM... 0.00  
 WorkloadBATCHJobStart Dt.  08JAN2018Idle... 0.00  
 %Connected..  6.3JobStart Tm.   14:29:46ECB/Other.. 0.00  
 Disp. Prty..  206Job Elpd Tm.   00:49:27Sec Userid.  
 Job Status..   ActiveJobEnd Dt...N/ASec Group.. 


Jobname  SSCHI/O%  DDname   Volser Addr DISP  Data Set Name   
---  --- -  --    
TSTJEMEM   31975  29.2 PREVMEM  E30181 C0BB SHR   TEST.SYLFA4V.VTST.MEM1.PREVD
TSTJEMEM   31440  28.7 CURRMEM  E30415 C584 SHR   TEST.SYLFA4V.VTST.MEMBER1.CL
TSTJEMEM6300   5.7 CURRMEM  E30162 C313 SHR   TEST.SYLFA4V.VTST.MEMBER1.CL
TSTJEMEM6001   5.5 PREVMEM  E30316 C557 SHR   TEST.SYLFA4V.VTST.MEM1.PREVD
TSTJEMEM4000   3.6 PREVMEM  E30364 C523 SHR   TEST.SYLFA4V.VTST.MEM1.PREVD
TSTJEMEM3752   3.4 CURRMEM  E30448 C46E SHR   TEST.SYLFA4V.VTST.MEMBER1.CL
TSTJEMEM3476   3.2 CURRMEM  E30121 C235 SHR   TEST.SYLFA4V.VTST.MEMBER1.CL
TSTJEMEM3300   3.0 CURRMEM  E30258 C136 SHR   TEST.SYLFA4V.VTST.MEMBER1.CL
TSTJEMEM3000   2.7 PREVMEM  E30347 C502 SHR   TEST.SYLFA4V.VTST.MEM1.PREVD
TSTJEMEM3000   2.7 PREVMEM  E30186 C019 SHR   TEST.SYLFA4V.VTST.MEM1.PREVD
TSTJEMEM2762   2.5 PREVMEM  E30063 C1B8 SHR   TEST.SYLFA4V.VTST.MEM1.PREVD
TSTJEMEM2421   2.2 PREVMEM  E30247 C11F SHR   TEST.SYLFA4V.VTST.MEM1.PREVD
TSTJEMEM2400   2.2 CURRMEM  E30076 C208 SHR   TEST.SYLFA4V.VTST.MEMBER1.CL
TSTJEMEM2100   1.9 CURRMEM  E30187 C01A SHR   TEST.SYLFA4V.VTST.MEMBER1.CL
TSTJEMEM1500   1.4 PREVMEM  E30392 C5AA SHR   TEST.SYLFA4V.VTST.MEM1.PREVD
TSTJEMEM1500   1.4 CURRMEM  E30198 C025 SHR   TEST.SYLFA4V.VTST.MEMBER1.CL
TSTJEMEM 297   0.3 DVFILE   E30403 C578 SHR   TEST.SYLFA4V.VTST.GROUP.CLUS

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

Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

[Joe Reichman]

I just ran the program again under TESTAUTH and did a WHERE after I got the 
abend from TESTAUTH its pointing to the inst right after the PC thing is the PC 
rtn does what it is supposed to do and I can continue executing   

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Wayne Driscoll
Sent: Monday, January 8, 2018 9:20 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

Are you sure the 0C2 is occurring at the PC instruction, not because your 
program is in problem state when issuing the ETDEF or ETCON macros? I would run 
outside of TESTAUTH, so I could get a dump and then look at the PC table 
definitions to ensure they are what you are expecting.
Wayne Driscoll
Rocket Software
Note - All opinions are strictly my own.

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Joe Reichman
Sent: Monday, January 8, 2018 7:29 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

I have an OLD ESA/390 Pops book I am quoting from

 "if the current PSW specifies problem state the current PSW-key mask in 
control register 3 is tested against the AKM and PSW key mask are anded and if 
the result I zero a privilege operation is recognized"

So If I am in problem state the AKM field which I specified as everything 0
- 15 determines if the PC is a privileged operation

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Charles Mills
Sent: Monday, January 8, 2018 7:44 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

S0C2 is not a key problem, it is a state problem. Does your S0C2 PSW show 
supervisor state?

Is there any possible cause for S0C2 *other* than "you tried a privileged op 
code but you were not in supervisor state"?

Charles


-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Joe Reichman
Sent: Monday, January 8, 2018 3:55 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: PC rtn AKM=(0:15) Getting S0C2 REASON 002

Hi



I have a PC rtn defined in the following way with AKM=(0:15) meaning all keys 
can access



 ETDEF TYPE=SET,ETEADR=ETD,ROUTINE=(R2),SSWITCH=YES,   X

  STATE=SUPERVISOR,AKM=(0:15),EKM=0,PC=STACKING





And yet while running under TESTAUTH I get the following ABEND



IKJ56641I TESTPRGK ENDED DUE TO ERROR

IKJ56640I SYSTEM ABEND CODE 0C2   REASON CODE 0002

--
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 
 Rocket Software, Inc. and subsidiaries ■ 77 
Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323 
Contact Customer Support: 
https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - 
http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy


This communication and any attachments may contain confidential information of 
Rocket Software, Inc. All unauthorized use, disclosure or distribution is 
prohibited. If you are not the intended recipient, please notify Rocket 
Software immediately and destroy all copies of this communication. Thank you.

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

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

Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

[Wayne Driscoll]

Are you sure the 0C2 is occurring at the PC instruction, not because your 
program is in problem state when issuing the ETDEF or ETCON macros? I would run 
outside of TESTAUTH, so I could get a dump and then look at the PC table 
definitions to ensure they are what you are expecting.
Wayne Driscoll
Rocket Software
Note - All opinions are strictly my own.

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Joe Reichman
Sent: Monday, January 8, 2018 7:29 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

I have an OLD ESA/390 Pops book I am quoting from

 "if the current PSW specifies problem state the current PSW-key mask in 
control register 3 is tested against the AKM and PSW key mask are anded and if 
the result I zero a privilege operation is recognized"

So If I am in problem state the AKM field which I specified as everything 0
- 15 determines if the PC is a privileged operation

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Charles Mills
Sent: Monday, January 8, 2018 7:44 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

S0C2 is not a key problem, it is a state problem. Does your S0C2 PSW show 
supervisor state?

Is there any possible cause for S0C2 *other* than "you tried a privileged op 
code but you were not in supervisor state"?

Charles


-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Joe Reichman
Sent: Monday, January 8, 2018 3:55 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: PC rtn AKM=(0:15) Getting S0C2 REASON 002

Hi



I have a PC rtn defined in the following way with AKM=(0:15) meaning all keys 
can access



 ETDEF TYPE=SET,ETEADR=ETD,ROUTINE=(R2),SSWITCH=YES,   X

  STATE=SUPERVISOR,AKM=(0:15),EKM=0,PC=STACKING





And yet while running under TESTAUTH I get the following ABEND



IKJ56641I TESTPRGK ENDED DUE TO ERROR

IKJ56640I SYSTEM ABEND CODE 0C2   REASON CODE 0002

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

Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ 
Main Office Toll Free Number: +1 855.577.4323
Contact Customer Support: 
https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - 
http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy


This communication and any attachments may contain confidential information of 
Rocket Software, Inc. All unauthorized use, disclosure or distribution is 
prohibited. If you are not the intended recipient, please notify Rocket 
Software immediately and destroy all copies of this communication. Thank you.

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

Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

[Joe Reichman]

I have an OLD ESA/390 Pops book I am quoting from 

 "if the current PSW specifies problem state the current PSW-key mask in
control register 3 is tested against the AKM and PSW key mask are anded and
if the result I zero a privilege operation is recognized"

So If I am in problem state the AKM field which I specified as everything 0
- 15 determines if the PC is a privileged operation

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Charles Mills
Sent: Monday, January 8, 2018 7:44 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: PC rtn AKM=(0:15) Getting S0C2 REASON 002

S0C2 is not a key problem, it is a state problem. Does your S0C2 PSW show
supervisor state?

Is there any possible cause for S0C2 *other* than "you tried a privileged op
code but you were not in supervisor state"?

Charles


-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Joe Reichman
Sent: Monday, January 8, 2018 3:55 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: PC rtn AKM=(0:15) Getting S0C2 REASON 002

Hi

 

I have a PC rtn defined in the following way with AKM=(0:15) meaning all
keys can access

 

 ETDEF TYPE=SET,ETEADR=ETD,ROUTINE=(R2),SSWITCH=YES,   X

  STATE=SUPERVISOR,AKM=(0:15),EKM=0,PC=STACKING

 

 

And yet while running under TESTAUTH I get the following ABEND

 

IKJ56641I TESTPRGK ENDED DUE TO ERROR

IKJ56640I SYSTEM ABEND CODE 0C2   REASON CODE 0002   

--
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: PC rtn AKM=(0:15) Getting S0C2 REASON 002

[Charles Mills]

S0C2 is not a key problem, it is a state problem. Does your S0C2 PSW show
supervisor state?

Is there any possible cause for S0C2 *other* than "you tried a privileged op
code but you were not in supervisor state"?

Charles


-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Joe Reichman
Sent: Monday, January 8, 2018 3:55 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: PC rtn AKM=(0:15) Getting S0C2 REASON 002

Hi

 

I have a PC rtn defined in the following way with AKM=(0:15) meaning all
keys can access

 

 ETDEF TYPE=SET,ETEADR=ETD,ROUTINE=(R2),SSWITCH=YES,   X

  STATE=SUPERVISOR,AKM=(0:15),EKM=0,PC=STACKING

 

 

And yet while running under TESTAUTH I get the following ABEND

 

IKJ56641I TESTPRGK ENDED DUE TO ERROR

IKJ56640I SYSTEM ABEND CODE 0C2   REASON CODE 0002   

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

PC rtn AKM=(0:15) Getting S0C2 REASON 002

[Joe Reichman]

Hi

 

I have a PC rtn defined in the following way with AKM=(0:15) meaning all
keys can access

 

 ETDEF TYPE=SET,ETEADR=ETD,ROUTINE=(R2),SSWITCH=YES,   X

  STATE=SUPERVISOR,AKM=(0:15),EKM=0,PC=STACKING

 

 

And yet while running under TESTAUTH I get the following ABEND

 

IKJ56641I TESTPRGK ENDED DUE TO ERROR

IKJ56640I SYSTEM ABEND CODE 0C2   REASON CODE 0002   

  


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

Changing password on IBM Link

[Jesse 1 Robinson]

I need to change my password on IBM Link. After 20 years managing the same 
userid, I find that there is now a new confirmation process that did not exist 
a few months ago. I am sent an email to verify my email address. Unfortunately 
that email never reaches my Inbox. I've tried over and over; it never shows up. 
A problem ticket with my email folks has not resolved the issue.

It's reminiscent of an old problem with IBM Main, where the confirmation email 
for a new subscription also does not show up. I learned some time ago that just 
that particular note is lacking a 'Sender' and is therefore treated here as 
spam. I can't prove it's the same issue with the IBM.COM confirmation, but it 
smells familiar.

Anyone else having issues?

.
.
J.O.Skip Robinson
Southern California Edison Company
Electric Dragon Team Paddler
SHARE MVS Program Co-Manager
323-715-0595 Mobile
626-543-6132 Office <= NEW
robin...@sce.com


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

Re: Accessing 65536 devices

[Jesse 1 Robinson]

Just to clarify a few points here. The old DASD we're moving off of is not 
crusty ancient tired iron: it's DS8800 (2424). The new DASD is DS8886 (2834). 
The motivation for moving is primarily business (fiscal), not technical.

We have millions of customers who are being converted to paperless billing, so 
more and more of them access the system more and more often at all hours of 
every day. There is virtually no time when all data bases happen to be closed. 
Closing them is not impossible, but it constitutes a 'total outage' to Customer 
Service. 

Besides striving to provide continuous availability for our customers' sake, we 
are also mandated by the California Public Utilities Commission to service 
customers' issues in a timely way that gets translated to dollars and cents. An 
extra incentive to minimize total outages.

We maintain three sets of DASD volumes: primary (production), secondary (XRC 
mirror), and tertiary (flash copy from secondary to run DR). These add up to a 
lot of UCBs in addition to lots of virtual tapes and lots of FICON CTCs. 

We're looking at ways to move PAVs to SCS1. Maybe even also the tertiary DR 
volumes. The goal is free up enough SCS0 addresses to put old and new boxes 
online. Meanwhile the new DASD is on the floor, and we need to utilize it. 

.
.
J.O.Skip Robinson
Southern California Edison Company
Electric Dragon Team Paddler 
SHARE MVS Program Co-Manager
323-715-0595 Mobile
626-543-6132 Office ⇐=== NEW
robin...@sce.com


-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Ed Jaffe
Sent: Sunday, January 07, 2018 8:09 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: (External):Re: Accessing 65536 devices

On 1/6/2018 12:27 PM, Mike Schwab wrote:
> If your new dasd allows dynamic growing a volume, you can grow a 
> non-EAV to the maximum EAV volume size, but no bigger.

That was my favorite feature of our old DS8100! We lost that feature when we 
upgraded to DS8870, but so far it hasn't been a problem because we planned 
fairly well.

Having said that, we're running a bit short on mod-216 volumes. I was thinking 
about removing eight of our mod-27s to make room for one more of these bad 
boys! Of course, that kind of re-allocation can be done with the DS8870, just 
not quite as easily as with the DS8100 because you can't grow a device in place.

The downside to in-place growth is varying levels of support from, and 
different procedures for, Linux for Z (we use RHEL), z/VM, z/VSE, and older 
releases of z/OS. You need to be careful or things can go FUBAR in a hurry! 
(Volume backups are a wonderful thing...)

--
Phoenix Software International
Edward E. Jaffe
831 Parkview Drive North
El Segundo, CA 90245
http://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: XKCD's take on Meltdown.

[zMan]

Giants in those days, Ed!

On Mon, Jan 8, 2018 at 3:09 PM, Edward Finnell <
000248cce9f3-dmarc-requ...@listserv.ua.edu> wrote:

> Back in late 60's were were goofing around with  some dimensional
> something that wouldn't converge and the phone rings. Long story short
> local foundry had run payroll three times and different answers every time.
> Could we please borrow some storage oscilloscopes? One guy had key to
> physics lab and I had one to EE lab so we converged at the mill with angry
> union workers about to picket. Fired up payroll again and CE says 'it
> changed' meaning CPU bus. Sure enough one of the scopes had a big off the
> screen blip. So what's changed? Well we did add this new wing of Bessemer
> converters(50 hp electric motors). So the big guy muttered something about
> parenting and lineage. You need isolation transformers-lets go.
>
>
> In a message dated 1/8/2018 9:52:23 AM Central Standard Time,
> dlc@gmail.com writes:
>
>
> Regular hammers have their utility.
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>



-- 
zMan -- "I've got a mainframe and I'm not afraid to use it"

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

Re: XKCD's take on Meltdown.

[Edward Finnell]

Back in late 60's were were goofing around with  some dimensional something 
that wouldn't converge and the phone rings. Long story short local foundry had 
run payroll three times and different answers every time. Could we please 
borrow some storage oscilloscopes? One guy had key to physics lab and I had one 
to EE lab so we converged at the mill with angry union workers about to picket. 
Fired up payroll again and CE says 'it changed' meaning CPU bus. Sure enough 
one of the scopes had a big off the screen blip. So what's changed? Well we did 
add this new wing of Bessemer converters(50 hp electric motors). So the big guy 
muttered something about parenting and lineage. You need isolation 
transformers-lets go.


In a message dated 1/8/2018 9:52:23 AM Central Standard Time, dlc@gmail.com 
writes:

 
Regular hammers have their utility.

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

Re: IBMLink and Knowledge Centre not working

[Charles Mills]

KC working as well as ever for me this AM. Chrome on Windows.

Charles

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Dan Little
Sent: Monday, January 8, 2018 7:41 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: IBMLink and Knowledge Centre not working

Was working fine earlier this morning but screens all screwed up now.

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

Re: XKCD's take on Meltdown.

[Tomasz Rola]

On Mon, Jan 08, 2018 at 09:21:15AM -0600, John McKown wrote:
> https://xkcd.com/1938/
> 

"Honestly, I've been assuming we were doomed ever since I learned
about rowhammer".

This.

-- 
Regards,
Tomasz Rola

--
** A C programmer asked whether computer had Buddha's nature.  **
** As the answer, master did "rm -rif" on the programmer's home**
** directory. And then the C programmer became enlightened...  **
** **
** Tomasz Rola  mailto:tomasz_r...@bigfoot.com **

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

Re: IBM HMC Mobile for Z and LinuxONE Now Available

[Parwez Hamid]

Supported via HMC V2.14.0 on systems including z14, z13/z13s,  zEC12/zBC12 & 
LinuxONE.

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

Re: IBM HMC Mobile for Z and LinuxONE Now Available

[Jesse 1 Robinson]

Learned about this at SHARE in Providence. Is it limited strictly to z14?

.
.
J.O.Skip Robinson
Southern California Edison Company
Electric Dragon Team Paddler 
SHARE MVS Program Co-Manager
323-715-0595 Mobile
626-543-6132 Office ⇐=== NEW
robin...@sce.com


-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Timothy Sipples
Sent: Monday, January 08, 2018 12:37 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: (External):IBM HMC Mobile for Z and LinuxONE Now Available

Amidst the IBM z14 announcement news this past July, IBM said there'd be a new 
mobile app for securely managing and monitoring Z and LinuxONE systems:
IBM HMC Mobile. It's now available, and it's no additional charge. Details and 
download links here:

https://goo.gl/AHiRcH

Here are the direct links to the mobile apps:

Apple iOS (iPhone, iPad, iPod touch): http://www.ibm.biz/hmc-mobile-ios

Android: http://www.ibm.biz/hmc-mobile-android

Enjoy!


Timothy Sipples
IT Architect Executive, Industry Solutions, IBM Z and LinuxONE, AP/GCG/MEA
E-Mail: sipp...@sg.ibm.com


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

Re: XKCD's take on Meltdown.

[David L. Craig]

On 18Jan08:0921-0600, John McKown wrote:

> https://xkcd.com/1938/

Regular hammers have their utility.
-- 

May the LORD God bless you exceedingly abundantly!

Dave_Craig__
"So the universe is not quite as you thought it was.
 You'd better rearrange your beliefs, then.
 Because you certainly can't rearrange the universe."
__--from_Nightfall_by_Asimov/Silverberg_

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

Re: Transferring hebrew data from Db2 Z/OS to PC

[Paul Gilmartin]

On Mon, 8 Jan 2018 05:57:34 +, Gadi Ben-Avi wrote:

>עיברית קשה שפה
>
>Your data is fine.
>The problem is with the way Windows expects Hebrew to be stored.
> 
I'd say the problem is with the way z/OS stores Hebrew.

>On z/OS, Hebrew is usually stored visually - the first letter in a word is on 
>the right.
>On other platforms, including Windows, Hebrew is stored logically - the first 
>letter is on the left, and programs reverse the data before it is displayed.
> 
The z/OS practice makes flowing text even more difficult.  For example,
when I view your Hebrew legal notice with either Firefox or Mail.app and
narrow the window, the last (leftmost) word is moved to the beginning
(right) end of next line.  It even seems to handle parentheses correctly.

Do z/OS editors (e.g. ISPF) do as well when flowing a mixture of Hebrew
and Latin text?

And DFSORT, given SORTIN with some keys in Hebrew ... ?

-- gil

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

IBMLink and Knowledge Centre not working

[Dan Little]

Was working fine earlier this morning but screens all screwed up now.

Dan

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

XKCD's take on Meltdown.

[John McKown]

https://xkcd.com/1938/

-- 
I have a theory that it's impossible to prove anything, but I can't prove
it.

Maranatha! <><
John McKown

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

Re: VSAM Performance - CPU reduction

[Arun Venkatratnam]

Ron,

The job was not profiled for its entire run. All 32M records are read from the 
1st file and 80% will qualify from the 2nd file. The job was profiled to 
capture 4000 samples in an elapsed time of 3 minutes. As I had mentioned in my 
initial post, the job takes nearly 7 minutes of CPU. The profile that this 
strobe report had captured is 1 CPU minute processing 4 M records. I will 
capture a strobe report for a full run of the job this evening.

The CPU model is a Z13S - S04

Thanks
Arun

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

Re: VSAM Performance - CPU reduction

[Lizette Koehler]

I was wondering if this process might be more efficient if it was handled by a 
Data Base, IMS, DB2, etc...

I know when programs are developed the data is usually small and as it grows 
the performance gets affected by increased data it needs to handle.

Would this be one of those cases where the process is not great with VSAM but 
might be helped with a review with a Database in mind?

Lizette


> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
> Behalf Of Wayne Bickerdike
> Sent: Sunday, January 07, 2018 2:18 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: VSAM Performance - CPU reduction
> 
> Quote
> Apologies. I missed to mention that depending on a record that matches in the
> 2nd file, there are some random reads that refer back to a previous record as
> per the business logic. Hence, the second file has to be VSAM. We also see a
> similar behavior with few other programs that do skip sequential reads on
> other VSAM files.
> Unquote
> 
> So do the two file match and utilise the VSAM (second file) for random read
> where it's required.
> 
> You won't tune your way out of this.
> 
> On Mon, Jan 8, 2018 at 6:03 AM, Gerhard Adam  wrote:
> 
> > To me it still looks like you don't have enough index buffers.  My
> > calculation suggests you need at least 137 buffers to keep the index
> > set in memory.
> >
> >
> >
> > Sent from my iPhone
> >
> > > On Jan 7, 2018, at 10:21 AM, Arun Venkatratnam <
> > arun.venkatrat...@cognizant.com> wrote:
> > >
> > > Ron,
> > >
> > > About 80% of the records qualify from the second file. I tried
> > > running
> > the job with BUFND of 2 for the second file. It increased the EXCPs
> > significantly (from strobe report) on the data records for the 2nd
> > file and the CPU time went over the other runs and the elapsed time also
> increased.
> > The job runs better with higher values of BUFND for the second file.
> > >
> > > You had mentioned that the job reads 30 CI for every skip-seq access.
> > Could you please tell how did you arrive at that number. LISTCAT shows
> > that for a CISZ of 26KB, there are 30 CI in 1 CA.
> > >
> > >
> > > Thanks
> > > Arun

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

Re: VSAM Performance - CPU reduction

[Ron hawkins]

Arun,

OK, looking at the full strobe report, if I read it correctly, converting to 
sequential processing may not be the most efficient way to process this. Both 
files have 32.4M records, but you only touch 4.9M records in each file when the 
program executes. You are touching around 15% of the total records in each file 
so a full sequential read of each may cost more CPU time., especially if you 
include the time to build redundant files.

The distribution of touched cylinders in both files is quite random, with 
IEHEYEBALL telling me that the distribution and clustering of touched cylinders 
are similar in both files. The clustered activity supports your finding that 
there is some efficiency from more data chaining for the skip sequential IO.

I'm not sure what your objectives are for this. You have a program that 
processes 8 million records using 2 minutes of CPU time in a three minute 
period and doing 9.4K IO to each of the index and data components of both 
files. Strobe does not report the CPU model in your report, so I don't know if 
this is on z196-401, a z14-708, or something in between, but if you want an 
omelet, you have to crack a few eggs. The CPU time is not SRB time, which 
corresponds to the relatively low IO count.

Strobe support can tell you why IGZEQBL mentions QSAM in the description, but 
it does not mean you are spending time in QSAM. My wife's laptop is an Apple, 
but I can't eat it - it's a label. I think that the time in IQZEQBL and IGZCPCO 
are simply the cost of reading 8 million records from the buffers and not 
related to the actual IO operations. You need to engage a Strobe expert or 
Compuware to dig deeper into this.

Ron

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Chris Hoelscher
Sent: Sunday, January 7, 2018 8:57 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [IBM-MAIN] VSAM Performance - CPU reduction

How 'bout .

Flagging the matches that currently require the random read - and instead pass 
those records thru the 2nd file - both in this random key sequence - that would 
eliminate all random reads - yes another sort or 2 and another match pass - but 
in the past I have found the savings of replacing random reads with sequential 
access is substantial 

Chris Hoelscher
Technology Architect, Database Infrastructure Services Technology Solution 
Services

123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Wayne Bickerdike
Sent: Sunday, January 7, 2018 4:18 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [IBM-MAIN] VSAM Performance - CPU reduction

Quote
Apologies. I missed to mention that depending on a record that matches in the 
2nd file, there are some random reads that refer back to a previous record as 
per the business logic. Hence, the second file has to be VSAM. We also see a 
similar behavior with few other programs that do skip sequential reads on other 
VSAM files.
Unquote

So do the two file match and utilise the VSAM (second file) for random read 
where it's required.

You won't tune your way out of this.

On Mon, Jan 8, 2018 at 6:03 AM, Gerhard Adam  wrote:

> To me it still looks like you don't have enough index buffers.  My 
> calculation suggests you need at least 137 buffers to keep the index 
> set in memory.
>
>
>
> Sent from my iPhone
>
> > On Jan 7, 2018, at 10:21 AM, Arun Venkatratnam <
> arun.venkatrat...@cognizant.com> wrote:
> >
> > Ron,
> >
> > About 80% of the records qualify from the second file. I tried 
> > running
> the job with BUFND of 2 for the second file. It increased the EXCPs 
> significantly (from strobe report) on the data records for the 2nd 
> file and the CPU time went over the other runs and the elapsed time also 
> increased.
> The job runs better with higher values of BUFND for the second file.
> >
> > You had mentioned that the job reads 30 CI for every skip-seq access.
> Could you please tell how did you arrive at that number. LISTCAT shows 
> that for a CISZ of 26KB, there are 30 CI in 1 CA.
> >
> >
> > Thanks
> > Arun
> >
> > 
> > -- 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

The information transmitted is intended only for the person or entity to which 
it is addressed and may 

IBM HMC Mobile for Z and LinuxONE Now Available

[Timothy Sipples]

Amidst the IBM z14 announcement news this past July, IBM said there'd be a
new mobile app for securely managing and monitoring Z and LinuxONE systems:
IBM HMC Mobile. It's now available, and it's no additional charge. Details
and download links here:

https://goo.gl/AHiRcH

Here are the direct links to the mobile apps:

Apple iOS (iPhone, iPad, iPod touch): http://www.ibm.biz/hmc-mobile-ios

Android: http://www.ibm.biz/hmc-mobile-android

Enjoy!


Timothy Sipples
IT Architect Executive, Industry Solutions, IBM Z and LinuxONE, AP/GCG/MEA
E-Mail: sipp...@sg.ibm.com

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