Peter,
I fully agree with other guys advising you to use csv format.
In this case Sort utility is your best friend.
I massively use csv to feed some Excel documents to show data coming from
SMF and more.
I download csv to a common directory path and use Excel data import
(automatic) to refresh dat
You might need nothing more than a CSV file like others mentioned, so
ignore this post if you want.
I've been making scripts for years that create CSV files from various
data sources, but I soon found myself updating them on my PC by hand and
saving as XLSX so I can format the cells, add color
Le 24/03/2021 à 05:31, Peter a écrit :
Hello
I am looking for a freeware or any sample program which can covert my
mainframe file into an excel file.
Just to be clear we don't have SAS or any seperate tool to achieve this.
Is there any working solution who can point me in the right direction?
I just went with adding quotes and commas between fields in a new or
revised program.
On Tue, Mar 23, 2021 at 11:31 PM Peter wrote:
>
> Hello
>
> I am looking for a freeware or any sample program which can covert my
> mainframe file into an excel file.
> Just to be clear we don't have SAS or any
Tom Brennan wrote:
>SKLM also has a backup function that creates a *.jar data file with all
>its certs and settings. I've installed totally new versions of SKLM,
>restored a jar file, set the SKLM servers to the old IP address, and the
>DS/TS boxes grab their keys without any knowledge of the h
If it's just text, creating a csv file shouldn't be too difficult, and Excel
will be able to read it with no problems.
Separate the fields with commas, and if a field has spaces, surround it with ".
Format dates and time as something excel will understand as a date or time.
-Original Message-
I have used java and jexcelapi library for that:
http://jexcelapi.sourceforge.net/
Its not maintained anymore but works pretty well. I have used it to extract SMF
data and data from z/OS logs.But you need to do the programming, its just an
API to create a workbook and add data to it and change
Hello
I am looking for a freeware or any sample program which can covert my
mainframe file into an excel file.
Just to be clear we don't have SAS or any seperate tool to achieve this.
Is there any working solution who can point me in the right direction?
Peter
-
It's useful when you want to say "STOP IT!" to run-away CPU or spool jobs.
Will buy you some time to investigate.
- KB
‐‐‐ Original Message ‐‐‐
On Tuesday, March 23, 2021 7:07 PM, Pommier, Rex
wrote:
> Hey Carmen,
>
> At least you had an operator tell you what they did. :-) Once we det
Off hand you could do two usermods one for the z/OS zone to put the CICS svc
into the nucleus. And another for the CICS zone that marks the module with a
do nothing modification but also has a doc hold to mention the z/OS usermod
that it is to go into the z/OS nucleus.
A cross zone usermod wo
On 23/03/2021 11:55 pm, Paul Gilmartin wrote:
What infuriates me is that when I want, e.g., 1GB (a reasonable amount
given that I can carry terabytes in my shirt pocket), I must factor it into
U, K, or M (why no "G", even "T"?) rather than the intuitive
BLKSIZE=0,SPACE=(10,1).
I'm not s
SKLM also has a backup function that creates a *.jar data file with all
its certs and settings. I've installed totally new versions of SKLM,
restored a jar file, set the SKLM servers to the old IP address, and the
DS/TS boxes grab their keys without any knowledge of the hardware switch.
So if
When copying an existing dataset, why not use the LIKE JCL parameter?
> -Original Message-
> From: IBM Mainframe Discussion List On
> Behalf Of David Staudacher
> Sent: Tuesday, March 23, 2021 2:17 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: "Wrong" Size Allocation with AVGREC?
>
>
If you are looking for a 1megabyte multiplier, just specify CYLinders
and multiply by 1.3, since 30 half track blocks is 839,940 bytes, and
5 cylinders is 4MB. That gives you about a 5% margin for lower
efficiency block size.
On Tue, Mar 23, 2021 at 4:17 PM David Staudacher wrote:
>
> Using Steve
There is also a recovery key that is used in the event SKLM isn't reachable.
It needed to be setup when encryption was enabled.
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of Ed
Jaffe
Sent: Tuesday, March 23, 2021 1:12 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re:
Using Steve Pryor's IEBDG suggestion, I think I found an explanation for the
case where a copy of a "SPACE=(TRK,1)" file filled with 698 80-byte records
ends up with 2 tracks when copied using DFSORT to a second file with
"AVGREC=U,SPACE=(80,698),DISP=(,CATLG)".
First, using IEBDG *did* work to
Thanks. I'll review those too.
Mark Jacobs
Sent from ProtonMail, Swiss-based encrypted email.
GPG Public Key -
https://api.protonmail.ch/pks/lookup?op=get&search=markjac...@protonmail.com
‐‐‐ Original Message ‐‐‐
On Tuesday, March 23rd, 2021 at 3:11 PM, Michael Brennan
<034cc18fb
If you override CSSLIB, that will work for all invocations of only CSSLIB. If
your CSSLIB DDDEF is part of a DDDEF concatenation such as a SYSLIB then you
will need to override the entire SYSLIB concatenation also.
From: IBM Mainframe Discussion List on
I was also going down that same path while looking at it. Now, how to fix
without changing the DDDEFs, which was the entire point behind using DD
overrides. I just might open a ticket with SMP/e support and get their take on
the situation.
Mark Jacobs
Sent from ProtonMail, Swiss-based encrypte
Short answer is that yes it should cause a concern. Will SMP/E drop something
into one of those libraries then go get it to perform a link or something later
in the apply? I wouldn't trust it if I had some parts of SMP/E pointing to
overrides and other parts of SMP/E not using the same librari
Because I (stupidly? ha) worked somewhat with Linux over the years, I
became the SKLM person at the company I work for. Over the past 5 years
we've ordered 2421's with DS8000 boxes. They came with SUSE installed,
but I would often replace it with the latest SUSE version, and then
install SKLM
Hi Ed,
I believe you're right in that you're in a catch-22 with z/OS based ISKLM
servers. If your DC has a complete power down and the DS8Ks need to get keys
before coming up and those keys are on z/OS that needs the DS8K up to IPL
you're going to have trouble. That's why we're reliant on a W
You're correct. If you're just using the z/OS LDAP server as a conduit to RACF
services you don't need DB2 in the mix.
Mark Jacobs
Sent from ProtonMail, Swiss-based encrypted email.
GPG Public Key -
https://api.protonmail.ch/pks/lookup?op=get&search=markjac...@protonmail.com
‐‐‐ Original
We host our SKLM on Windows virtual servers that can - and do - migrate from
VMWare cluster to VMWare cluster in a couple of widely separated datacenters.
Bruce Lightsey
Mainframe and Database Manager
MS Department of Information Technology Services
601-432-8144 | www.its.ms.gov
DISCLAIMER:
At one time TSO performance was an issue, now most of our users are not typical
TSO or ISPF users, more and more function folks did day to day work is done
from a PC / Server.
Carmen Vitullo
-Original Message-
From: Mike
To: IBM-MAIN
Date: Tuesday, 23 March 2021 11:56
Hi,
I have been given the task of implementing a z/OS LDAP server on a sandbox.
I have been reading the manuals (the RedBook IBM Tivoli Directory Server
for z/OS and the IBM Tivoli Directory Server Administration and Use for
z/OS)
The idea is to have this LDAP acting as a bridge between RACF and a
We're using ISKLM on a pair of Windows servers for both disk and tape.
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of Ed
Jaffe
Sent: Tuesday, March 23, 2021 11:35 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: [External] SKLM Servers
Curious what folks are doing to provid
We replicate our storage subsystems to our own DR data center, we have 2 SKLM
servers that are standalone Linux based servers one in each data center, one
primary and one backup.
Carmen Vitullo
-Original Message-
From: Ed
To: IBM-MAIN
Date: Tuesday, 23 March 2021 12:14 PM
>We have the Java-based ISKLM running on two z/OS LPARs for our tape.
>I assumed ISKLM would not be usable for DASD because of the "catch-22"
>situation of needing the DASD to IPL z/OS.
>Suppose we had a complete power down of the computer room. Could we
>still somehow IPL z/OS from DASD that h
On 3/23/2021 10:05 AM, Dave Jousma wrote:
DS8K's only *need* to retrieve keys at IML time, but does reach out regularly
for heartbeat, and will phone home if unreachable.Pretty easy to setup, let
me know you need any assist.
We have the Java-based ISKLM running on two z/OS LPARs for our t
On Tue, 23 Mar 2021 16:54:57 +0100, Radoslaw Skorupka wrote:
>
>>> However when you specify records or kilobytes, the system assumes the
>>> following:
>>> a) you have only inkling about mainframe DASD
>>>
>> Wrong! It forces me to know more than I care to.
>
>Agreed. However that was the intentio
On 3/23/2021 9:56 AM, Ed Jaffe wrote:
They have since replaced the word "Security" with "Guardium" ...
Actually they *inserted* the word "Guardium"...
--
Phoenix Software International
Edward E. Jaffe
831 Parkview Drive North
El Segundo, CA 90245
https://www.phoenixsoftware.com/
---
On 3/23/2021 9:40 AM, Farley, Peter x23353 wrote:
OK, I'll bite. I googled that KMIP stands for "Key Management Interoperability
Protocol", but what is SKLM?
I googled (actually Duck-Duck-Goed) for "IBM SKLM" and right away saw it
was "Security Key Lifecycle manager". They have since replace
Security Key Lifecycle Manager.
Mark Jacobs
Sent from ProtonMail, Swiss-based encrypted email.
GPG Public Key -
https://api.protonmail.ch/pks/lookup?op=get&search=markjac...@protonmail.com
‐‐‐ Original Message ‐‐‐
On Tuesday, March 23rd, 2021 at 12:40 PM, Farley, Peter x23353
<03
ISPF can be loaded into shared memory for increased performance but
reduces private memory.
If you don't use the shared memory you get increased private memory
but slow starting up users.
https://www.ibm.com/support/knowledgecenter/SSLTBW_2.2.0/com.ibm.zos.v2r2.f54pc00/isppcalmlpa.htm
On Tue, Mar
OK, I'll bite. I googled that KMIP stands for "Key Management Interoperability
Protocol", but what is SKLM?
Peter
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of Ed
Jaffe
Sent: Tuesday, March 23, 2021 12:35 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: SKLM Servers
Cur
Curious what folks are doing to provide SKLM to your IBM Z DASD and tape
devices?
Are people using an IBM Storage Appliance (such as 2421 model AP1),
hosting SKLM on your own dedicated "in room" Linux machines, using
competing KMIP-compliant solutions, or something else entirely?
Thanks...
It is, yes.
SMP1
SCEEOBJ SMP1 PERMCEE.SCEEOBJ Z24A01 3390 SHR
SCEELKEX SMP2 PERMCEE.SCEELKEX Z24A01 3390 SHR
SCEELKED SMP3 PERMCEE.SCEELKED Z24A01 3390 SHR
CSSLIB SMP4 PERMSYS1.CSS
yes, I remember storage size and boundaries, and I did find the HC,
unfortunately my site does not want HC running in prod (2.3), I normally check
prior to the first IPL of my test LPAR, its notated in the Migration workflow.
my issue was self inflicted, a usermod I neglected moving ISPF LPA RM
Mark,
Thats probably part of a dynamic concatenation that SMP/E did for a SYSLIB sort
of a input DD name. Is the DDDEF part of a concatenation similar to this?:
DDNAME DDDEFNAM SMPDDNAM TYPE ---DATA SET OR
PATH---
SMP00048
W dniu 23.03.2021 o 13:55, Paul Gilmartin pisze:
On Tue, 23 Mar 2021 12:03:09 +0100, Radoslaw Skorupka wrote:
However when you specify records or kilobytes, the system assumes the
following:
a) you have only inkling about mainframe DASD
Wrong! It forces me to know more than I care to.
Agree
Also SMF 78-2 is pretty useful here. You could see the trend and what
drove it. Both above and below the line.
Cheers, Martin
Martin Packer
WW z/OS Performance, Capacity and Architecture, IBM Technology Sales
+44-7802-245-584
email: martin_pac...@uk.ibm.com
Twitter / Facebook IDs: MartinPack
Keep trying decrementing by 1 until you get the straddling case, I. E.
80,n = 1 track, 80,n+1 = 2 tracks.
On Tue, Mar 23, 2021 at 3:11 AM David Staudacher wrote:
>
> I've looked over all the IBM-MAIN posts referring to AVGREC and don't see
> that anyone has ever brought this up before.
> I've re
Yep. Our site had 3380 set until about 2010.
On Tue, Mar 23, 2021 at 6:46 AM Clifford McNeill wrote:
>
> This smells like the default geometry in DFSMS is set to a 3380 instead of a
> 3390. Option 8 in ISMF will allow display of the CDS Base which will show
> the defaults being used. Ensure
The boundary between PVT/CSA and ECSA/EPVT is a 1-M boundary.
A tiny change in nucleus, LPA, CSA allocation, SQA allocation can result
in reduction of PVT size by 1M.
Health check VSM_CSA_CHANGE can provide useful information about how close
to the "tipping point" you are.
Did you look at that c
I'm running an apply check with dataset overrides, same DSN, different volume.
Here's one example.
//CSSLIB DD DISP=SHR,UNIT=3390,VOL=SER=Z24AM1,DSN=SYS1.CSSLIB
The SMP APPLY CHECK FILE ALLOCATION REPORT shows that my override is being used,
SYS1.CSSLIB Z24AM1 SHR
But in the dynamic allocation p
Hey Carmen,
At least you had an operator tell you what they did. :-) Once we determined
what had happened (after a painful middle-of-the-day IPL) the only response I
got back from anybody was "I didn't do anything like that!" But now that I
know what that command does and how it works I dou
I think we need to 'see the work'. You mention 'copying' the dataset. But
allocation doesn't depend on the program being executed - only the SPACE
specification. So if you allocate something like:
//DG2 EXEC PGM=IEBDG
//SYSPRINT DD SYSOUT=*
On Tue, 23 Mar 2021 12:03:09 +0100, Radoslaw Skorupka wrote:
>
>However when you specify records or kilobytes, the system assumes the
>following:
>a) you have only inkling about mainframe DASD
>
Wrong! It forces me to know more than I care to.
>b) you want such and such number or kilobytes, megab
I did it in SNA shop.
To be honest I don't know how does it affect performance, but it was no
pain to do it.
--
Radoslaw Skorupka
(looking for new job)
Lodz, Poland
W dniu 22.03.2021 o 19:45, Carmen Vitullo pisze:
At one time it was a big deal when SNA was all the rage :)
I did forget this
WOW! this takes me back 20 years when an operator wanted to quiesce a job and
issues that command from the console
he called my told me what he did, I researched what that command does, seemed
to me it was like on the old system consoles O2 and O3 IIRC one was a PSW stop
and one a restart, I f
I do now. :-) Somehow it got missed a long time ago and nobody noticed it.
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of
Radoslaw Skorupka
Sent: Tuesday, March 23, 2021 5:36 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [External] Re: z14 HMC log information
Jus
Thank you.
On Mon, Mar 22, 2021 at 8:35 PM Seymour J Metz wrote:
> REXX-aware means that it can handle an EFPL as described at <
> https://www.ibm.com/servers/resourcelink/svc00100.nsf/pages/zOSV2R4sa320972/$file/ikja300_v2r4.pdf#page=290
> >
>
>
> --
> Shmuel (Seymour J.) Metz
> http://mason.gm
This smells like the default geometry in DFSMS is set to a 3380 instead of a
3390. Option 8 in ISMF will allow display of the CDS Base which will show the
defaults being used. Ensure Bytes/track is 56664 (3390 track size).
Cliff McNeill
W dniu 23.03.2021 o
General rule:
when you specify TRK or CYL you get it. Number of records is predictable
and depends of BLKSIZE and CKD voodoo. Of course you can find out before
you allocate new dataset or just check with some small (1 TRK/CYL) sample.
However when you specify records or kilobytes, the system a
Just curious: do you have CL(OPERCMDS) MVS.QUIESCE not protected with
proper ACL or just the SDSF-like product somehow bypassed OPERCMDS
security?
BTW: I used QUIESCE solely for education purposes - that shows how HMC
facilities cooperate with the system. No other uses.
--
Radoslaw Skorupka
Is the target file in Extended Format?
Lennie Dymoke-Bradshaw
Consultant working on contract for BMC mainframe Services by RSM Partners
‘Dance like no one is watching. Encrypt like everyone is.’
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of
David Staudacher
Sent:
I've looked over all the IBM-MAIN posts referring to AVGREC and don't see that
anyone has ever brought this up before.
I've read the relevant manuals, so I'm familiar with AVGREC syntax and how it's
supposed to work.
My concern is how to explain the differences in size allocation using
BLKS/TR
59 matches
Mail list logo