W dniu 2012-09-14 08:29, Tsai Laurence pisze:
Dear listers,
as the subject, anybody knows ?
Not much.
See redbook VSAM Demistyfied for details.
--
Radoslaw Skorupka
Lodz, Poland
--
Tre tej wiadomoci moe zawiera informacje prawnie chronione Banku
przeznaczone wycznie do uytku
CA Reclaim is the one item I can think of.
Cheers, Martin
Martin Packer,
zChampion, Principal Systems Investigator,
Worldwide Banking Center of Excellence, IBM
+44-7802-245-584
email: martin_pac...@uk.ibm.com
Twitter / Facebook IDs: MartinPacker
Blog:
Hi
Is it possible , i.e. , to have a recovery backup z/OS system in USB stick ?
(Currently we have the catastrophe recovery system in 3590 tapes in a
bank safe , but it can be also in my pocket in an USB stick ).
It is a z9 machine
Miklos Szigetvari wrote:
Is it possible , i.e. , to have a recovery backup z/OS system in USB stick ?
Good lazy Friday question! ;-D
In theory, yes, in fact any storage medium (CD/DVD/etc) will do. The trick is
of course, how and in what format do you want to load and unload your data. It
W dniu 2012-09-14 10:10, Miklos Szigetvari pisze:
Hi
Is it possible , i.e. , to have a recovery backup z/OS system in USB
stick ?
(Currently we have the catastrophe recovery system in 3590 tapes in a
bank safe , but it can be also in my pocket in an USB stick ).
It is a z9 machine
Yes
On 9/13/2012 1:14 PM, Jousma, David wrote:
Do something like this:
//SMPCNTL DD *
SET BDY(GLOBAL) .
REJECT HOLDDATA NOFMID
PRODUCT DELETEFMID (HKAH33T HWRE330 JWRE33C JWRE33I JWRE331).
Except change the FMID's to your desired ones.
If you're concerned about the
You're not the only one with the problem. I don't remember all the details at
the moment, but I think I eventually got somebody in IBM to point me to the FP
14 refresh download, which I was able to install, and then I was able to
install FP15 over top of that.
Clearly they have some issues
File 686 on the CBT 'tape' has a program called SMFDUMP that will format the
output into a report. It takes in most of the SMF records. I use it to track
down the same thing all the time.
Betsy
--
For IBM-MAIN subscribe /
Hello all,
I've been asked if there is the possibility to create Excel tables (.xls) files
on z/OS,
using a batch job. I've searched the archives, the developerwork IBM's site,
redbooks,
but found no clue.
We run the XMITIP tool which is able to create .csv files, but this seems not
enough.
Supposedly, but I haven't actually tried. Look at:
http://poi.apache.org/
quote
The Apache POI Project's mission is to create and maintain Java APIs for
manipulating various file formats based upon the Office Open XML standards
(OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). In
General note . Close Pending status for an SMF dataset is actually fairly
normal but should NOT persist for very long. It basically means that SMF is
still writing data out to that physical dataset but has logically reached the
end of the file and is collecting/targetting its current input
On Fri, 14 Sep 2012 06:44:23 -0700, Walter Marguccio wrote:
I've been asked if there is the possibility to create Excel tables (.xls)
files on z/OS,
You might also see if .ods spreadsheets would be acceptable. A quick qoogle
search turns up lots of information about creating them. Here is
The xml toolkit contains the xsl processer and sample xsl files.
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Walter Marguccio
Sent: Friday, September 14, 2012 9:44 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Creating .xls on z/OS
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU]
On Behalf Of William Richardson
Sent: Friday, September 14, 2012 8:57 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SMF Dataset CLOSE PENDING ISSUE
General note . Close Pending status for
You don't have SAS? I believe it can.
Kees.
Walter Marguccio walter_marguc...@yahoo.com wrote in message
news:1347630263.5695.yahoomail...@web114704.mail.gq1.yahoo.com...
Hello all,
I've been asked if there is the possibility to create Excel tables (.xls)
files on z/OS,
using a batch
I'm not sure, but looking at
http://support.sas.com/rnd/base/ods/templateFAQ/Excel1.pdf
quote
There are several methods of generating Excel or spreadsheet files using the
Output
Delivery System. The first method that we will discuss is using the HTML
destination to
create the Excel or
John,
I have used ODS in SAS and you can generate the XLS into a PDSE file that is
then send (via email or other FTP to a site) very easily.
From the ODS manual
With ODS, you can produce tabular output , which can be viewed with Excel.
D\
Lizette
I'm not sure, but looking at
Thanks for the correction. That is a real XLS file, not just a file which can
be opened in Excel (like CSV can be opened in Excel)?
--
John McKown
Systems Engineer IV
IT
Administrative Services Group
HealthMarkets(r)
9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone *
Walter - I have recently completed development of a COBOL and Assembler
compatible API that allows the creation of full fidelity .xls and .xlsx
spreadsheets. Below is a summary of supported functions.
Full unicode support
Ebcdic (all code pages) to unicode
Packed, binary integers, ibm hex
Frank,
I would strongly recommend a checklist style with places for initials
for each of the MK holders.
Naming conventions - Your naming convention takes care of the test
v.s. prod.. which is good. But how do you handle migrating from one
key to another. Example. KEY1 is in use, KEY2 is the
One more note...
While you can do the keys via panels, it is not as secure as doing it via TKE.
Rob Schramm
Senior Systems Consultant
Imperium Group
On Fri, Sep 14, 2012 at 10:55 AM, Rob Schramm rob.schr...@gmail.com wrote:
Frank,
I would strongly recommend a checklist style with places for
John,
Not truly my area of expertise. I know it works. But from the z/OS
Companion for SAS has a description.
The SAS Output Delivery System can be used to generate graphical reports of
your SAS data. Remote browsing enables you to view your output directly from
the SAS session, either in
Hi,
I am looking for a jcl to change the expiration date of some tapes in CA TLMS.
This partition is running z/OS 1.12. I looked at the user guide for an example
but I didn't find any. Perhaps I missed it. Could anybody help me out please?
Thanks.
I've used POI to create simple, straightforward spreadsheets and it works fine.
The program is easy enough although I'm not sure what complications have been
introduced with Excel 2007.
Robert Crawford
CICS Technical Support
United Services Automobile Association
(210) 913-3822
For Service
Here's what I use:
//*
//TLMSPROC JCLLIB ORDER='OEM#P.CAI.TLMS.R11.CAIPROC'
//STEP010 EXEC CATRPTS
//SYSOUTDD SYSOUT=X
//SYSIN DD *
UPV volser,EXPDT=juliandate
/*
*
*
*George Rodriguez*
*Specialist II - IT Solutions*
*Application
Lizette,
I loved SAS, did a lot of network performance with SNA with it.
Scott ford
www.identityforge.com
On Sep 14, 2012, at 10:37 AM, Lizette Koehler stars...@mindspring.com wrote:
John,
I have used ODS in SAS and you can generate the XLS into a PDSE file that is
then send (via email
Willie,
The support group at CA should be more than able to help you with this. I
have opened cases to CA on just these types of questions to CA1. I am sure
TLMS will be just as good.
Lizette
TAPE
Hi,
I am looking for a jcl to change the expiration date of some tapes in CA
TLMS. This
Willie, Please open an issue with Level 1 support. We need to determine how the
particular volume(s) is being retained. Just changing the KEEPDATE may not
change the retention if the volume is retained by another retention method,
catalog control for example.
Pat Hughes - TLMS Level II
Pat
Frank,
That is not true. Try option k. But the only reason you would need
it would be if you need to store the operational key parts outside of
the mainframe. Also, KGUP should support key part entry... although
it is one of the oldest interfaces for ICSF. Auto generating keys is
probably be
I have successfully used the java based jexcelapi.
http://jexcelapi.sourceforge.net/
Its open source.
Denis.
-Original Message-
From: Walter Marguccio walter_marguc...@yahoo.com
To: IBM-MAIN IBM-MAIN@LISTSERV.UA.EDU
Sent: Fri, Sep 14, 2012 3:44 pm
Subject: Creating .xls on z/OS
George,
Thanks. Once this is run do I need to do anything else for example run a
scratch report etc? I noticed in the user guide it says to run CATINQPR proc.
I noticed that you are using CATRPTS. Is that okay?
From: George Rodriguez
Wouldn't that depend on why you are changing the date? What is the real
issue for which a date change is your chosen solution?
:: -Original Message-
:: From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
:: Behalf Of willie bunter
:: Sent: Friday, September 14, 2012
Willie, CATINQR/TLMSINQR is the only supported PROC/Program in current
releases of TLMS (12.0 12.5). It has not been officially supported for the
majority of the TLMS reports and updated since release 5.5. It was provided
through release 12.0 to allow clients time to modify all their JCL.
Robert,
I like the idea of OpenOffice also ring able to create Excel spreadsheets, it
ales a lot of sense to me.
Scott ford
www.identityforge.com
On Sep 14, 2012, at 11:41 AM, Crawford, Robert C. robert.crawf...@usaa.com
wrote:
I've used POI to create simple, straightforward spreadsheets
All, the various solutions given are the reason I suggested the OP contact CA
Support. Since we have various solutions, and also the most important question,
WHY?, I will try to explain some parts of TLMS Retention processing.
1. VOLUME level KEEPDATE/EXPDT values (UPV) are not used by TLMS
That's it and yes, that's the program used by TLMS to set dates. My
recommendation is try one, then use eith TI or TLMS volume display to see
if the EXPDT is set to what you want.
On Friday, September 14, 2012 x-apple-data-detectors://19, Pat Hughes1
wrote:
All, the various solutions given are
.CSV won't contain formulae. Don't know if that's what bothers the OP -
but it bothers ME as I'd like to generate them in REXX.
Cheers, Martin
Martin Packer,
zChampion, Principal Systems Investigator,
Worldwide Banking Center of Excellence, IBM
+44-7802-245-584
email: martin_pac...@uk.ibm.com
Have you tried putting in =A1+B2 between commas for a cell value?
1,2,=SUM(A1:B1)
11,22,=SUM(A2:B2)
=SUM(A1:A2),=SUM(B1:B2),=A1+B2
On Fri, Sep 14, 2012 at 4:08 PM, Martin Packer martin_pac...@uk.ibm.com wrote:
.CSV won't contain formulae. Don't know if that's what bothers the OP -
but it
Martin,
I have no trouble with formulae in .csv, I do it all the time from Rexx on
z/OS. I will generate two calculation cells like this, for instance:
=IF(D20,(F2-D2), ),=IF(D20,(H2/D2), ),
I found that I have to surround the formula with double quotes (because of the
embedded spaces) and
W dniu 2012-09-14 23:08, Martin Packer pisze:
.CSV won't contain formulae. Don't know if that's what bothers the OP -
but it bothers ME as I'd like to generate them in REXX.
There are many things which cannot be kept in .CSV: graphs, complex
formula, column formatting, page setup, multiple
Wow, Sam very nice
Scott ford
www.identityforge.com
On Sep 14, 2012, at 10:54 AM, Sam Siegel s...@pscsi.net wrote:
Walter - I have recently completed development of a COBOL and Assembler
compatible API that allows the creation of full fidelity .xls and .xlsx
spreadsheets. Below is a
Here's a Friday topic if there ever was one. A friend who is cleaning out
his place just sent me a scan of a purported IBM DPD press release (on what
appears to be genuine DPD letterhead) from 12/11/1980 announcing the model
3082 Attached Toilet. (The 3082 is a multi-port, user-operated waste
Color me very confused. Do you not agree with the following statement from
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS189?
Abstract:The ICSF, application key generation
utility, KGUP, does not provide the capability to enter keys using dual custody
of key parts. Without
_IBM Comedy 1970: Bob Newhart - A Call From Herman Hollerith_
(http://businessphonesystemvoip.org/ibm-comedy-1970-bob-newhart-a-call-from-herman-holler
ith.html)
Well, for Friday's sake
--
For IBM-MAIN subscribe /
No doubt this is wonderfully documented somewhere but I am sitting here
tearing my hair out.
I have a C++ *batch* program that I could not get to open a conventional
z/OS dataset by name to save my life until I finally figured out it was
prepending my userid onto the specified name a la TSO.
If
My bad -- DEBUG, not TRACE.
Try
DEBUG FLO
DEBUG INT
DEBUG ACC
DEBUG SEC
Charles
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of John Chase
Sent: Thursday, September 13, 2012 11:05 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re:
Frank,
Sorry... I was just referring to ways to get operational keys in... Not
under dual control or separation.
If you need real control over MK and operational keys... Then TKE and DKMS
is it.
How many keys are you going to be managing?
Rob Schramm
On Sep 14, 2012 7:14 PM, Frank Swarbrick
TSO it's prefix
Scott ford
www.identityforge.com
On Sep 14, 2012, at 8:02 PM, Charles Mills charl...@mcn.org wrote:
No doubt this is wonderfully documented somewhere but I am sitting here
tearing my hair out.
I have a C++ *batch* program that I could not get to open a conventional
z/OS
Say what?
Charles
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Scott Ford
Sent: Friday, September 14, 2012 5:29 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: C and LE -- when prepend userid on file names?
TSO it's prefix
Scott
PROFile NOPRE
HELP PROFile
In a message dated 9/14/2012 7:30:09 P.M. Central Daylight Time,
scott_j_f...@yahoo.com writes:
TSO it's prefix
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to
On Fri, 14 Sep 2012 22:04:02 -0400, Ed Finnell wrote:
PROFile NOPRE
HELP PROFile
In a message dated 9/14/2012 7:30:09 P.M. Central Daylight Time,
scott_j_f...@yahoo.com writes:
TSO it's prefix
Does this apply even outside TSO? Does LE read the TSO profile
data set to make the decision? I
On Fri, Sep 14, 2012 at 5:02 PM, Charles Mills charl...@mcn.org wrote:
No doubt this is wonderfully documented somewhere but I am sitting here
tearing my hair out.
I have a C++ *batch* program that I could not get to open a conventional
z/OS dataset by name to save my life until I finally
As I said in the OP, ***BATCH***. //STEP1 EXEC PGM=
Charles
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Ed Finnell
Sent: Friday, September 14, 2012 7:04 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: C and LE -- when prepend userid
Been through that section of the PG half a dozen times. I see no references
at all to prepending userids. I come down in the flowchart to z/OS XL C/C++
opens an OS file.
Charles
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Sam
On Fri, Sep 14, 2012 at 10:01 PM, Charles Mills charl...@mcn.org wrote:
Been through that section of the PG half a dozen times. I see no references
at all to prepending userids. I come down in the flowchart to z/OS XL
C/C++
opens an OS file.
Agreed ... I miss read your post. Sorry about
If you are a DB2 pureXML (with XQuery Update) facility, I had a sample
where, the unzipped .ods files are queried/modified as required by the
ODF schema. The unzipped files are of course XML.
http://opendocument.xml.org/resource/using-db2-purexml-and-odf-spreadsheets
On 9/15/12, Scott Ford
56 matches
Mail list logo