Re: insanity? process SMF with Java on non-z?
In what service class does the SMF processing run? Does the processing have any impact on your monthly peak four hour rolling average? If yes, does it need to? [You can probably figure out where these questions are headed, and I'm surprised nobody else asked already. What, no cost experts in the IBM-MAIN house? :-)] - - - - - Timothy Sipples IBM Consulting Enterprise Software Architect Based in Tokyo, Serving IBM Japan / Asia-Pacific E-Mail: timothy.sipp...@us.ibm.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
New product for SMF reporting on a PC
Coincidentally, while the discussion on SMF reporting has been going on I have been preparing to post this. This post has been approved by Darren. I would like to announce a new product for reporting on SMF data on a PC. EasySMF runs on Windows and reports directly on SMF data. It has a built in FTP client to download data directly from SMF dump datasets, and can also read SMF data from other formats such as TSO TRANSMIT and zip files. Reports are pre-defined so no programming is required. Additional reports will be added over time, based on feedback from users. The aim is to produce a set of reports that covers the most common information that people need from SMF. EasySMF is now available for public beta testing. I would like to hear about: * Additional reports you would like included * Anything you find confusing * Errors in reports * Any other problems you encounter (Preferably directly or in the forum below rather than here) See more detail or download from: http://www.smfreports.com For a lengthier introduction: http://www.blackhillsoftware.com/blog/2009/02/02/introducing-easysmf/ There is a discussion forum at: http://www.blackhillsoftware.com/forum/easysmf The software has a 30 day evaluation period where it will work without a key. A temporary key is also available for beta testing. To receive the key please send an email to: beta-key-requ...@smfreports.com Regards Andrew Rowley Black Hill Software -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
Ted, How does a Canadian say tomato... The CPU cost is the differentiator that you refer to. The additional cost of interpretive languages is that each line of the source code must be evaluated and acted on for every iteration of the code. This is classic CLIST or REXX. No matter how you label the compile/interpretation phase of SAS, the execution phase does not result in line by line interpretation of the source, and thus no interpretive cost. There is a compile and translate cost, but the difference between compile and interpret is more than mere semantics. I don't write REXX or CLIST - I often wonder about that - but from past tests I know that the CPU cost of the following SAS program compares favorably with REPRO and beats IEBGENER, and I'd like to compare it with REXX and CLIST equivalents. Data _null_; Infile ifile; File ofile; Input @; Put _infile_; Return; Run; I'm sure your point only pertains to the data step. It would be a hard argument to convince anyone that PROC SORT parsing into execution DFSORT or SYNCSORT will have interpretive CPU costs. Ron > -Original Message- > From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of > Ted MacNEIL > Sent: Wednesday, February 04, 2009 7:03 PM > To: IBM-MAIN@bama.ua.edu > Subject: Re: [IBM-MAIN] insanity? process SMF with Java on non-z? > > >SAS data steps are not interpreted, they are compiled and executed. > > Now you are getting semantically involved! > > >Would you say that a compile-load-go PL/I job is not compiled? That seems to > be what you're saying, but I don't think that falls within the commonly > accepted meaning of the term. > > The difference is that I can keep PL/I object and load code if I want to. > With SAS, regardless I cannot. > So, translation/interpretation (or whatever you want to call it) is there for > every run, whether I want it or not. > Therefore, the overhead is there everytime, regardless of what it is called. > That was my only point. > > You can argue what you want to call it, but it's still there EVERY run. > > This argument happened, last year. > Hit the archives; I'm not going to have it, again. > > - > Too busy driving to stop for gas! > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
Ted, > > The only problems with MXG on a non-mainframe platform is network capacity (to > get the data down) and disk capacity (to store the data). > While the disk is cheaper than mainframe disk, it still has a non-zero cost. > > As you have read on the MXG list, storage is not such a big problem. Gb Ethernet infrastructure in the glasshouse is extremely cheap and easy to configure, and the existing storage can be used by: 1) Reading the SMF data through the FTP access method 2) Storing your PDB on the MF via CIFS I use the FTP access all the time to read SMF data from my LPARs. There is no redundant storage or movement of the datasets, and they remain safely backed up and archived by DFSMShsm. For my PDB I store them on a Filer, backed with Rack & Stack SATA storage. These directories are mounted as standard Network drives to windows. I used iSCSI before that, and moved to the filer to help infrastructure. The PDB could just as easily be supported on SATA or Fibre Channel arrays from HDS, EMC, Dell, or your local Fry's store at a competitive TCO to your MF storage - YMMV. Ron -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
>SAS data steps are not interpreted, they are compiled and executed. Now you are getting semantically involved! >Would you say that a compile-load-go PL/I job is not compiled? That seems to >be what you're saying, but I don't think that falls within the commonly >accepted meaning of the term. The difference is that I can keep PL/I object and load code if I want to. With SAS, regardless I cannot. So, translation/interpretation (or whatever you want to call it) is there for every run, whether I want it or not. Therefore, the overhead is there everytime, regardless of what it is called. That was my only point. You can argue what you want to call it, but it's still there EVERY run. This argument happened, last year. Hit the archives; I'm not going to have it, again. - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
>>But, if youy run into a problem, you have to reproduce it with SAS, before >>Doctor Barry will investigate. >Do you mean *not* reproduce it with SAS? Are they striving for that level of >bug-compatibility? No. I meant what I said. Dr. Barry will not investigate any WPS problem. It has to be produced with SAS. He has nothing to do with WPS, itself. He is MXG. - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
You guys are almost inspiring me to write up some Java code to read the SMF data and perhaps populate SQL tables in some DBMS. Since I don't have any good way to read SMF data right now, having something I could use would really be cool :) If I only had the time... David Logan Manager of Product Development, Pitney Bowes Business Insight http://centrus.com W: (720) 564-3056 C: (303) 818-8222 -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of jack.hamil...@kp.org Sent: Wednesday, February 04, 2009 15:42 To: IBM-MAIN@bama.ua.edu Subject: Re: insanity? process SMF with Java on non-z? Semantics = Meaning. Meaning is important. SAS data steps are not interpreted, they are compiled and executed. Would you say that a compile-load-go PL/I job is not compiled? That seems to be what you're saying, but I don't think that falls within the commonly accepted meaning of the term. -- Jack Hamilton Management Information & Analysis - Analytic Information Services Kaiser Foundation Health Plan, Inc. 1950 Franklin Street, Oakland, California 94612 +1 510 987-1556 (KP tieline 8-427-1556) NOTE: This email document and attachments are covered by CA Evidence Code §1157 and CA Health and Safety Code §1370. NOTICE TO RECIPIENT: If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them. Thank you. Ted MacNEIL Sent by: IBM Mainframe Discussion List 02/04/2009 12:45 PM Please respond to IBM Mainframe Discussion List To IBM-MAIN@bama.ua.edu cc Subject Re: [IBM-MAIN] insanity? process SMF with Java on non-z? >SAS data steps are compiled, not interpreted. Semantics! I run a first time SAS step. It's not compiled when I submit the job. It has to be interpreted, the compiled. SAS Institute had a way to keep compiled code, but I don't know if that still exists. If the code has been written and submitted without compilation, and executed, in one run, it's interpreted. The rest is semantics! - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Copy SMF Records With Syncsort
Reda, John wrote: Steve/Eric, CHANGE has been around for a while but OVERLAY was introduced in release 1.3. Steve's control cards were real close, I think these will work for you: I kinda' thought you would have that; now it's just a matter if Eric is current in his release of SyncSort (despite his documentation which is "about 6 years old"). You guys make your docs available for free on the Internet, like IBM, right? Maybe you can give Eric a pointer. SORT FIELDS=COPY OUTREC OVERLAY=(15:15,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS'),NOMATCH=(15,4)) The thing that was required was the column designation. Without it, the output of the CHANGE would be placed in the column 1. By putting in the "15:" you are directing the output to be put in column 15. This will leave the RDW alone. Whoa, you're right. I was too quick to just copy over Eric's job and change BUILD to OVERLAY. Good catch. You many also want to consider using the NOMATCH subparameter. This tells OUTREC what to do if column 15 is not either CSYS, DSYS or FSYS. If something other than these 3 values is found, the sort would end with RC=16. NOMATCH will let the execution continue leaving the original value in the field. SMF data is notoriously dirty so it would not surprise me for you to have an unexpected value in at least one of your fields. On the other hand, having NOMATCH would hide the fact there was something in error. Guess it comes down to his real needs here. *** NOTE *** Eric's original cards pointed to column 15 while Steve's used column 19. Please make sure you are using the correct column. I used 15 in my example to match Eric's. I wasn't sure, in the original post, if Eric had allowed for the RDW. In a later post he said he had, so 15 is the value to use. If this doesn't work, let me know and I will work with you. John Reda Syncsort, Inc. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Steve Comstock Sent: Wednesday, February 04, 2009 6:26 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Copy SMF Records With Syncsort Eric Bielefeld wrote: I'm trying to fix some SMF records from our TEST Lpars that have the wrong SMFID in them. I'm pretty sure I can fix them with Syncsort using the OUTREC Change command, but I'm not sure how to do that. I haven't worked with Syncsort that much, and I've spent the last hour or so trying to figure out what I need. I figure there's someone out there that can do this off the top of their head quickly. This is what I have so far: OUTREC FIELDS=(15,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) SORT FIELDS=COPY I'm sure there is a few things missing. I get a message: WER108I SORTIN : RECFM=VBS ; LRECL= 32756; BLKSIZE= 27990 WER235A OUTREC RDW NOT INCLUDED I'd appreciate any help. Thanks. Eric -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 Eric, I've been spending a lot of time developing a DFSORT/ICETOOL class, which I hope to announce next week. Although DFSORT is not SyncSort, I imagine they are the same for this case. OUTREC FIELDS=(15,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) SORT FIELDS=COPY This will copy from your SORTIN data set; the output data set will just be the four bytes ESYS, or FSYS. You want to OVERLAY the field; since the input records are variable, you must also allow for a 4 byte RDW in your positioning. Try this: SORT FIELDS=COPY OUTREC OVERLAY=(19,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques ==> Check out the Trainer's Friend Store to purchase z/OS <== ==> application developer toolkits. Sample code in four<== ==> programming languages, JCL to Assemble or compile, <== ==> bind and test. <== ==> http://www.trainersfriend.com/TTFStore/index.html<== -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Abend 04E - Reason 00E20003 on BIND Job with DB2
The reason code points to a shortage of Private storage not common storage. Check that you have the same REGION being assigned perhaps you dropped a USERMOD or an IEFUSI exit that you had in place on your previous release. Perhaps you changed the size of CSA or ECSA to a much larger size making PVT/EPVT much smaller. The CA-SYSVIEW PRIVATE and REGION commands will show you what your virtual storage boundaries are and use within a given address space. Consider to try coding REGION=nnnM or event REGIOn=0M on your step. Not being a DB2 guy it's not obvious if the storage shortage is local in your BIND job which is what it sounds like or in the DBxxMSTR or DBxxDBM1 address spaces. I think it is the first case. 00E20003 Explanation: In order to satisfy an unconditional request for storage, the get variable storage function needed to obtain storage (from GETMAIN) to expand a storage pool. However, GETMAIN indicated that sufficient storage in the private area was not available. This abend reason code is issued by the following CSECT: DSNSVBK System Action: The agent is abended. Operator Response: Notify the system programmer. System Programmer Response: Increase region size. If the region size is already defined at the maximum, consider enabling the CONTSTOR system initialization parameter. For more information, see DB2 Installation Guide. Good Luck! LookAT is often a good place to start to find a message or code if you don't have the exact book or link handy. http://www-03.ibm.com/systems/z/os/zos/bkserv/lookat/ Best Regards, Sam Knutson, GEICO System z Performance and Availability Management mailto:sknut...@geico.com (office) 301.986.3574 (cell) 301.996.1318 "Think big, act bold, start simple, grow fast..." -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Alvaro Quintupray B. Sent: Wednesday, February 04, 2009 5:47 PM To: IBM-MAIN@bama.ua.edu Subject: Abend 04E - Reason 00E20003 on BIND Job with DB2 Hi. We are migrated from ZOS 1.6 to ZOS 1.8 with DB2 7.10 and we are getting an abend 04E with Reason code 00E20003 at the BIND. -- 1READY DSN SYSTEM (DSNT) DSN BIND PACKAGE(CDDTCBAT)QUALIFIER(WDSIGADM)PATH (HDSIGSTP,HDGRCSTP,HDCRMSTP)LIB('DDTCDB2.DBRMLIB') ACT(REP) ISOLATION(CS) RELEASE(COMMIT)VALIDATE(BIND) MEMBER( DTCLDCFE ); IKJ56641I DSN ENDED DUE TO ERROR+ IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00E20003 PSW 077C10009DE825BC ASIDS: HOME = 0051 PRIMARY = 0048 SECONDARY = 0048 This problem not occurred with ZOS 1.6 ... I know that is a management storage ( CSA, ECSA ) but I can see whith SYSVIEW and RMF/ISPF that Do not have problem with CSA. And can not find one similar report on the web... anyone has any help for me? Thanks Alvaro. This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 4 Feb 2009, Paul Gilmartin wrote: > Good question. I know that John is an NFS user (at least > Linux server; z/OS client). I believe that SMF data are > RECFM=VBS. I know that if a VBS file is overridden to > RECFM=U it can be reconstructed from the RDWs (I've done > it in Rexx with an IEBCOPY-unloaded library). But is > there any way to trick the z/OS NFS server into presenting > an SMF log to the client as such a byte stream? I didn't try NFS. My Linux box is down for a while. It (not I) am accused of streaming data at 7Mbs over our external Internet connection, causing much weeping and wailing. I have no idea what could have done this. I didn't do anything. The LAN people said it was "7Mbs encrypted downloads from Fedora". Whatever that really means. > > The alternative is to override to RECFM=U,FILEDATA=BINARY > in JCL and IEBGENER to the Linux NFS server. > > Does Java on z/OS understand RECFM=VBS legacy data sets? Not directly. But I do an FTP with QUOTE SITE RDW or Co:Z "fromdsn" with standard IBM RDWs. I have written Java code which can read this by decoding the RDWs in the code. It's ugly code (IMO), but not too difficult. > > What's the relative cost of CPU cycles on z/OS vs. desktop? > > -- gil about 200 zillion to one . My desktop is basically "free" due to its age. -- Q: What do theoretical physicists drink beer from? A: Ein Stein. Maranatha! John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Copy SMF Records With Syncsort
Steve/Eric, CHANGE has been around for a while but OVERLAY was introduced in release 1.3. Steve's control cards were real close, I think these will work for you: SORT FIELDS=COPY OUTREC OVERLAY=(15:15,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS'),NOMATCH=(15,4)) The thing that was required was the column designation. Without it, the output of the CHANGE would be placed in the column 1. By putting in the "15:" you are directing the output to be put in column 15. This will leave the RDW alone. You many also want to consider using the NOMATCH subparameter. This tells OUTREC what to do if column 15 is not either CSYS, DSYS or FSYS. If something other than these 3 values is found, the sort would end with RC=16. NOMATCH will let the execution continue leaving the original value in the field. SMF data is notoriously dirty so it would not surprise me for you to have an unexpected value in at least one of your fields. *** NOTE *** Eric's original cards pointed to column 15 while Steve's used column 19. Please make sure you are using the correct column. I used 15 in my example to match Eric's. If this doesn't work, let me know and I will work with you. John Reda Syncsort, Inc. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Steve Comstock Sent: Wednesday, February 04, 2009 6:26 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Copy SMF Records With Syncsort Eric Bielefeld wrote: > I'm trying to fix some SMF records from our TEST Lpars that have the wrong > SMFID in them. I'm pretty sure I can fix them with Syncsort using the OUTREC > Change command, but I'm not sure how to do that. I haven't worked with > Syncsort that much, and I've spent the last hour or so trying to figure out > what I need. I figure there's someone out there that can do this off the top > of their head quickly. > > This is what I have so far: > > OUTREC FIELDS=(15,4, > CHANGE=(4,C'CSYS',C'ESYS', > C'DSYS',C'FSYS', > C'FSYS',C'FSYS')) > SORT FIELDS=COPY > > I'm sure there is a few things missing. I get a message: > > WER108I SORTIN : RECFM=VBS ; LRECL= 32756; BLKSIZE= 27990 > WER235A OUTREC RDW NOT INCLUDED > > I'd appreciate any help. Thanks. > > Eric > > -- > Eric Bielefeld > Systems Programmer > Washington University > St Louis, Missouri > 314-935-3418 Eric, I've been spending a lot of time developing a DFSORT/ICETOOL class, which I hope to announce next week. Although DFSORT is not SyncSort, I imagine they are the same for this case. OUTREC FIELDS=(15,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) SORT FIELDS=COPY This will copy from your SORTIN data set; the output data set will just be the four bytes ESYS, or FSYS. You want to OVERLAY the field; since the input records are variable, you must also allow for a 4 byte RDW in your positioning. Try this: SORT FIELDS=COPY OUTREC OVERLAY=(19,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) Kind regards, -Steve Comstock The Trainer's Friend, Inc. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Copy SMF Records With Syncsort
On Wed, 4 Feb 2009 23:42:38 +, Eric Bielefeld wrote: >Steve, > >Apparently OVERLAY is not a Syncsort keyword. I did a search of the whole Syncsort reference manual, and it wasn't listed, although my book is about 6 years old. I did allow for the RDW in my displacement, I think. > >Eric > Eric, I just looked up OVERLAY in my SyncSort for z/OS 1.3 manuals: "The OVERLAY parameter has been added. OVERLAY enables reformatting of selected portions of records." Further: "OVERLAY Parameter (Optional) The OVERLAY parameter enables you to change particular columns and add fields to the end of a record without rebuilding the entire record. When using the OVERLAY parameter you only need to specify the columns you want to change. The rest of the input record remains unchanged. See OVERLAY Parameter (Optional) on page 2.162 for a complete description." Not sure what release of SyncSort you're using, but you might be able to get the same results with a more complicated OUTREC statement. The variable length nature of the records will be problematic. I'm not that talented with SyncSort or I'd try to work something up. Good Luck, Dave K. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: TLS Cipher Suites
On Wed, 4 Feb 2009 15:45:42 -0600, Hal Merritt wrote: >Awesome! That was too easy. Now All I have to do is figure out what was displayed. The FM just identifies the message number as a response to a display. > >GSK01009I Cryptographic status 024 >Algorithm HardwareSoftware >DES 56 56 >3DES 168 168 >AES -- 256 >RC2 -- 128 >RC4 -- 128 >RSA Encrypt 10244096 >RSA Sign 20484096 >DSS --1024 > >Since I don't see 'anonymous', can I safely say that that algorithm is - not- present? And bet my job on that? (I am only half kidding.) >... I'm pretty sure you can bet your job on it. The anon algorithms ar not supported, either in hardware or software. I've herad that they are not safe to use anyway. A useful table I got from somewhere (that gets pretty garbled with proportional fonts. Each cipher suite is a combination of an encryption algorithm and a hashing algorithm. It's pretty easy to match the parts of the cipher suite names to the lines in the GSKSRVR display. Cipher Suite nameCipher Suite null00 TLS_RSA_WITH_NULL_MD5 01 TLS_RSA_WITH_NULL_SHA 02 TLS_RSA_EXPORT_WITH_RC4_40_MD5 03 TLS_RSA_WITH_RC4_128_MD504 TLS_RSA_WITH_RC4_128_SHA05 TLS_RSA_EXPORT_WITH_RC2_CBC_40_MD5 06 TLS_RSA_WITH_IDEA_CBC_SHA 07 TLS_RSA_EXPORT_WITH_DES40_CBC_SHA 08 TLS_RSA_WITH_DES_CBC_SHA09 TLS_RSA_WITH_3DES_EDE_CBC_SHA 0A TLS_DH_DSS_EXPORT_WITH_DES40_CBC_SHA0B TLS_DH_DSS_WITH_DES_CBC_SHA 0C TLS_DH_DSS_WITH_3DES_EDE_CBC_SHA0D TLS_DH_RSA_EXPORT_WITH_DES40_CBC_SHA0E TLS_DH_RSA_WITH_DES_CBC_SHA 0F TLS_DH_RSA_WITH_3DES_EDE_CBC_SHA10 TLS_DHE_DSS_EXPORT_WITH_DES40_CBC_SHA 11 TLS_DHE_DSS_WITH_DES_CBC_SHA12 TLS_DHE_DSS_WITH_3DES_EDE_CBC_SHA 13 TLS_DHE_RSA_EXPORT_WITH_DES40_CBC_SHA 14 TLS_DHE_RSA_WITH_DES_CBC_SHA15 TLS_DHE_RSA_WITH_3DES_EDE_CBC_SHA 16 TLS_DH_anon_EXPORT_WITH_RC4_40_MD5 17 TLS_DH_anon_WITH_RC4_128_MD518 TLS_DH_anon_EXPORT_WITH_DES40_CBC_SHA 19 TLS_DH_anon_WITH_DES_CBC_SHA1A TLS_DH_anon_WITH_3DES_EDE_CBC_SHA 1B TLS_RSA_WITH_AES_128_CBC_SHA2F TLS_DH_DSS_WITH_AES_128_CBC_SHA 30 TLS_DH_RSA_WITH_AES_128_CBC_SHA 31 TLS_DHE_DSS_WITH_AES_128_CBC_SHA32 TLS_DHE_RSA_WITH_AES_128_CBC_SHA33 TLS_DH_anon_WITH_AES_128_CBC_SHA34 TLS_RSA_WITH_AES_256_CBC_SHA35 Pat O'Keefe -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Copy SMF Records With Syncsort
I don't use SYSCSORT but I think you do have the displacement correct. My SMF manual shows the RDW at offset 0 and the system ID at 14. Since sort starts at 1, 15 should be correct. DFSORT and SYNCSORT manage to stay in step with each other regarding features. OVERLAY is not that new in DFSORT. Chances are that SYNCSORT uses a different name for it. If you really don't have an overlay capability, one possibility would be to break your output record into three sections: 1-14, 15-18, and 19-end. Just copy the first and third sections from the input and use whatever SYSNCSORT calls the change facility for the middle. -Original Message- From: Eric Bielefeld Sent: Wednesday, February 04, 2009 3:43 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Copy SMF Records With Syncsort Steve, Apparently OVERLAY is not a Syncsort keyword. I did a search of the whole Syncsort reference manual, and it wasn't listed, although my book is about 6 years old. I did allow for the RDW in my displacement, I think. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: How to APPLY FMID's again
When you re-receive the SYSMODs as others have suggested, remember to BYPASS the APPLYCHECK and ACCEPTCHECK options. -Original Message- From: Miklos Szigetvari Sent: Wednesday, February 04, 2009 9:56 AM To: IBM-MAIN@bama.ua.edu Subject: Re: How to APPLY FMID's again Hi Thank you. I would like to leave in 1.8 LINKLIB, so i don't want to make a RESTORE. As they are FMID's I get error if I specify in the SELECT, and I get an error if I specify a FORFMID list. The SMP/ is complaining this FMID's are not in the GLOBAL zone. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Copy SMF Records With Syncsort
Steve, Apparently OVERLAY is not a Syncsort keyword. I did a search of the whole Syncsort reference manual, and it wasn't listed, although my book is about 6 years old. I did allow for the RDW in my displacement, I think. Eric -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 Steve Comstock wrote: > > Eric, > > I've been spending a lot of time developing a DFSORT/ICETOOL > class, which I hope to announce next week. > > > Although DFSORT is not SyncSort, I imagine they are the same for this case. > > > OUTREC FIELDS=(15,4, >CHANGE=(4,C'CSYS',C'ESYS', > C'DSYS',C'FSYS', > C'FSYS',C'FSYS')) > SORT FIELDS=COPY > > This will copy from your SORTIN data set; the output > data set will just be the four bytes ESYS, or FSYS. > > You want to OVERLAY the field; since the input records > are variable, you must also allow for a 4 byte RDW in > your positioning. > > Try this: > > SORT FIELDS=COPY > OUTREC OVERLAY=(19,4, > CHANGE=(4,C'CSYS',C'ESYS', > C'DSYS',C'FSYS', > C'FSYS',C'FSYS')) > > > Kind regards, > > -Steve Comstock > The Trainer's Friend, Inc. > > 303-393-8716 > http://www.trainersfriend.com > >z/OS Application development made easier > * Our classes include > + How things work > + Programming examples with realistic applications > + Starter / skeleton code > + Complete working programs > + Useful utilities and subroutines > + Tips and techniques > > ==> Check out the Trainer's Friend Store to purchase z/OS <== > ==> application developer toolkits. Sample code in four<== > ==> programming languages, JCL to Assemble or compile, <== > ==> bind and test. <== > ==> http://www.trainersfriend.com/TTFStore/index.html<== > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
We have had a couple of people report that they have been successful in using Co:Z in a z/OS jobstep to launch the Windows SAS job and pipe it SMF data. If you are going to do this, it would be best to set up Co:Z for "non-tunneling" mode, so that your potentially huge file transfers will ride on a raw socket rather than being tunneled in SSH. This will reduce CPU and improve network throughput. As far as using Java - IBM has recently published some work that we did for them in the JZOS alphaWorks project that you might want to look at. There is a took that allows you to map Cobol copy books or Assembler DSECTs into Java record-mapping code. You can run this code on any platform, so that might be one solution to making the process a little easier. It still seems like a aweful lot of work to me. Kirk Wolf Dovetailed Technologies http://dovetail.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Copy SMF Records With Syncsort
Eric Bielefeld wrote: I'm trying to fix some SMF records from our TEST Lpars that have the wrong SMFID in them. I'm pretty sure I can fix them with Syncsort using the OUTREC Change command, but I'm not sure how to do that. I haven't worked with Syncsort that much, and I've spent the last hour or so trying to figure out what I need. I figure there's someone out there that can do this off the top of their head quickly. This is what I have so far: OUTREC FIELDS=(15,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) SORT FIELDS=COPY I'm sure there is a few things missing. I get a message: WER108I SORTIN : RECFM=VBS ; LRECL= 32756; BLKSIZE= 27990 WER235A OUTREC RDW NOT INCLUDED I'd appreciate any help. Thanks. Eric -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 Eric, I've been spending a lot of time developing a DFSORT/ICETOOL class, which I hope to announce next week. Although DFSORT is not SyncSort, I imagine they are the same for this case. OUTREC FIELDS=(15,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) SORT FIELDS=COPY This will copy from your SORTIN data set; the output data set will just be the four bytes ESYS, or FSYS. You want to OVERLAY the field; since the input records are variable, you must also allow for a 4 byte RDW in your positioning. Try this: SORT FIELDS=COPY OUTREC OVERLAY=(19,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques ==> Check out the Trainer's Friend Store to purchase z/OS <== ==> application developer toolkits. Sample code in four<== ==> programming languages, JCL to Assemble or compile, <== ==> bind and test. <== ==> http://www.trainersfriend.com/TTFStore/index.html<== -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: SDSF - so slow!
This sounds suspiciously like something I saw with SDSF a long time ago. I like to think that things would have improved by now, but who knows? This is how you could tell: If you don't have the original job still on spool run a job to create a test SYSOUT dataset. Use something that will write records that don't contain lots of blanks, and the more records the better - several million would be good. Create a job to run SDSF in batch to select your test SYSOUT and capture it to a DASD dataset (or even to DD DUMMY), using the SDSF PRINT command, but set it up to not capture the whole test dataset - use something like "PRINT 1 50". Run your SDSF batch job a number of times, varying the number of records printed, by changing the second number of the PRINT range. Try it for say 50, 100, 150 etc and see how the resource usage, particularly CPU time increases as it processes more records. If you find that CPU time increases disproportionally with increasing number of records processed, you probably have the same problem I found, where it became unusable for very large datasets. If it is still like that you could try opening a PMR. If they tell you that you are the only one to ever have this problem, suggest that they search the PMR archive for about 1998, looking for the words ISFDSRC and PARROT. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Copy SMF Records With Syncsort
I'm trying to fix some SMF records from our TEST Lpars that have the wrong SMFID in them. I'm pretty sure I can fix them with Syncsort using the OUTREC Change command, but I'm not sure how to do that. I haven't worked with Syncsort that much, and I've spent the last hour or so trying to figure out what I need. I figure there's someone out there that can do this off the top of their head quickly. This is what I have so far: OUTREC FIELDS=(15,4, CHANGE=(4,C'CSYS',C'ESYS', C'DSYS',C'FSYS', C'FSYS',C'FSYS')) SORT FIELDS=COPY I'm sure there is a few things missing. I get a message: WER108I SORTIN : RECFM=VBS ; LRECL= 32756; BLKSIZE= 27990 WER235A OUTREC RDW NOT INCLUDED I'd appreciate any help. Thanks. Eric -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Abend 04E - Reason 00E20003 on BIND Job with DB2
Hi. We are migrated from ZOS 1.6 to ZOS 1.8 with DB2 7.10 and we are getting an abend 04E with Reason code 00E20003 at the BIND. -- 1READY DSN SYSTEM (DSNT) DSN BIND PACKAGE(CDDTCBAT)QUALIFIER(WDSIGADM)PATH (HDSIGSTP,HDGRCSTP,HDCRMSTP)LIB('DDTCDB2.DBRMLIB') ACT(REP) ISOLATION(CS) RELEASE(COMMIT)VALIDATE(BIND) MEMBER( DTCLDCFE ); IKJ56641I DSN ENDED DUE TO ERROR+ IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00E20003 PSW 077C10009DE825BC ASIDS: HOME = 0051 PRIMARY = 0048 SECONDARY = 0048 This problem not occurred with ZOS 1.6 ... I know that is a management storage ( CSA, ECSA ) but I can see whith SYSVIEW and RMF/ISPF that Do not have problem with CSA. And can not find one similar report on the web... anyone has any help for me? Thanks Alvaro. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
Semantics = Meaning. Meaning is important. SAS data steps are not interpreted, they are compiled and executed. Would you say that a compile-load-go PL/I job is not compiled? That seems to be what you're saying, but I don't think that falls within the commonly accepted meaning of the term. -- Jack Hamilton Management Information & Analysis - Analytic Information Services Kaiser Foundation Health Plan, Inc. 1950 Franklin Street, Oakland, California 94612 +1 510 987-1556 (KP tieline 8-427-1556) NOTE: This email document and attachments are covered by CA Evidence Code §1157 and CA Health and Safety Code §1370. NOTICE TO RECIPIENT: If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them. Thank you. Ted MacNEIL Sent by: IBM Mainframe Discussion List 02/04/2009 12:45 PM Please respond to IBM Mainframe Discussion List To IBM-MAIN@bama.ua.edu cc Subject Re: [IBM-MAIN] insanity? process SMF with Java on non-z? >SAS data steps are compiled, not interpreted. Semantics! I run a first time SAS step. It's not compiled when I submit the job. It has to be interpreted, the compiled. SAS Institute had a way to keep compiled code, but I don't know if that still exists. If the code has been written and submitted without compilation, and executed, in one run, it's interpreted. The rest is semantics! - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 4 Feb 2009 12:59:23 -0600, Walt Farrell wrote: >On Wed, 4 Feb 2009 12:30:23 -0600, John McKown wrote: > >>But I was curious if anybody has ever used anything else, such as Java, to >>process SMF data on a Windows or Linux box? Or is that just too crazy? > >If you did decide to use Java, why does that require moving the data off of >z/OS? > Good question. I know that John is an NFS user (at least Linux server; z/OS client). I believe that SMF data are RECFM=VBS. I know that if a VBS file is overridden to RECFM=U it can be reconstructed from the RDWs (I've done it in Rexx with an IEBCOPY-unloaded library). But is there any way to trick the z/OS NFS server into presenting an SMF log to the client as such a byte stream? The alternative is to override to RECFM=U,FILEDATA=BINARY in JCL and IEBGENER to the Linux NFS server. Does Java on z/OS understand RECFM=VBS legacy data sets? What's the relative cost of CPU cycles on z/OS vs. desktop? -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 4 Feb 2009 19:02:44 +, Ted MacNEIL wrote: > >WPS (written in JAVA) already exists, and you can use it with MXG. >But, if youy run into a problem, you have to reproduce it with SAS, before >Doctor Barry will investigate. > Do you mean *not* reproduce it with SAS? Are they striving for that level of bug-compatibility? -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: How to APPLY FMID's again
On Wed, 4 Feb 2009 12:21:58 -0600, Chase, John wrote: >> >> If SMP/E is complaining that PSF isn't in the GLOBAL zone, you will >need >> to RECEIVE it back into the GLOBAL zone then you can apply it. If you >> are using the same CSI you used the first time you installed PSF, you >> will need to use the REDO and SELECT parameters like I mentioned >before. > Or, (re-RECEIVE, yes) and create a new DLIB/TARGET pair and APPLY (and ACCEPT ad-lib) into that. >If the product has been ACCEPTed and you haven't applied subsequent >maintenance that is not also ACCEPTed, you might consider the SMP/E >BUILDMCS command, then RECEIVE, APPLY and ACCEPT its output deck. > Will BUILDMCS unwind the DLIBs into SMPMCS? I didn't know that. RELFILE/LKLIB format, I'd guess? -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: TLS Cipher Suites
Awesome! That was too easy. Now All I have to do is figure out what was displayed. The FM just identifies the message number as a response to a display. GSK01009I Cryptographic status 024 Algorithm HardwareSoftware DES 56 56 3DES 168 168 AES -- 256 RC2 -- 128 RC4 -- 128 RSA Encrypt 10244096 RSA Sign 20484096 DSS --1024 Since I don't see 'anonymous', can I safely say that that algorithm is -not- present? And bet my job on that? (I am only half kidding.) -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Patrick O'Keefe Sent: Wednesday, February 04, 2009 2:43 PM To: IBM-MAIN@bama.ua.edu Subject: Re: TLS Cipher Suites ..snip In addition to those manuals, you may want to crank up GSKSRVR and issue F GSKSRVR,DISPLAY CRYPTO This will show you what encryption and hashing algorithms are supported by System SSL in software and which, if any, are supported by hardware (crypto engines and CPACF instructions). You have to manually translate the algorithm names into cipher suite numbers (which means you need to get the name associated with each cipher suite number, but Google is your friend for that). Armed with that information you can give you tell your servers to preferentially pick cipher suites supported by hardware. Pat O'Keefe NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: TLS Cipher Suites
Great tip!! Thanks. I can use that even though I'm using only RACF? -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Patrick O'Keefe Sent: Wednesday, February 04, 2009 2:43 PM To: IBM-MAIN@bama.ua.edu Subject: Re: TLS Cipher Suites ..snip In addition to those manuals, you may want to crank up GSKSRVR and issue F GSKSRVR,DISPLAY CRYPTO This will show you what encryption and hashing algorithms are supported by System SSL in software and which, if any, are supported by hardware (crypto engines and CPACF instructions). You have to manually translate the algorithm names into cipher suite numbers (which means you need to get the name associated with each cipher suite number, but Google is your friend for that). Armed with that information you can give you tell your servers to preferentially pick cipher suites supported by hardware. Pat O'Keefe NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
>SAS data steps are compiled, not interpreted. Semantics! I run a first time SAS step. It's not compiled when I submit the job. It has to be interpreted, the compiled. SAS Institute had a way to keep compiled code, but I don't know if that still exists. If the code has been written and submitted without compilation, and executed, in one run, it's interpreted. The rest is semantics! - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: TLS Cipher Suites
On Wed, 4 Feb 2009 11:13:03 -0600, Walt Farrell wrote: >... >Assuming you have an application that is using the System SSL function of >z/OS (or the Application Transparent TLS function of z/OS Communications >Server, which uses System SSL): > >(a) z/OS R7: >http://publibz.boulder.ibm.com/cgi- bin/bookmgr_OS390/BOOKS/gska1a30/6.12? SHELF=EZ2ZO10G&DT=20040714151143 >or http://preview.tinyurl.com/bu7tmy > >(b) z/OS R9: >http://publibz.boulder.ibm.com/cgi- bin/bookmgr_OS390/BOOKS/GSKA1A50/6.12? SHELF=EZ2ZO10K&DT=20070508220341 >or http://preview.tinyurl.com/bt4fy8 >... In addition to those manuals, you may want to crank up GSKSRVR and issue F GSKSRVR,DISPLAY CRYPTO This will show you what encryption and hashing algorithms are supported by System SSL in software and which, if any, are supported by hardware (crypto engines and CPACF instructions). You have to manually translate the algorithm names into cipher suite numbers (which means you need to get the name associated with each cipher suite number, but Google is your friend for that). Armed with that information you can give you tell your servers to preferentially pick cipher suites supported by hardware. Pat O'Keefe -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
SAS data steps are compiled, not interpreted. According to a developer I have spoken to, data step code is first turned into a platform-independent p-code (I don't think he actually used the term p-code), and then a platform-dependent module turns that into machine code. This may not result in the most efficient possibly machine code, but nevertheless data steps are compiled, not interpreted. (There are some features, such as the RESOLVE function, that allow for very limited types of dynamic code to be run during a data step.) SAS PROCs are also compiled. There are some procedures that use interpreted code (the data step-like langauage in PROC IML, for example). In general, SAS PROCs build complicated internal data structures and have a lot of conditionally executed code, so they are not as efficient as non-general code might be, but they are compiled. SAS macros are not compiled to machine code as far as I know. SAS can be very fast. It is perceived to be slow, I think, because it is so easy to write code that is very inefficient but still produces the desired results. Business analysts who use SAS are not usually trained to create efficient programs. It is not unusual for a SAS programmer to be able to reduce the run time of a SAS business analyst's code by 50% or more, but few companies are willing to make that investment. -- Jack Hamilton Management Information & Analysis - Analytic Information Services Kaiser Foundation Health Plan, Inc. 1950 Franklin Street, Oakland, California 94612 +1 510 987-1556 (KP tieline 8-427-1556) NOTE: This email document and attachments are covered by CA Evidence Code §1157 and CA Health and Safety Code §1370. NOTICE TO RECIPIENT: If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them. Thank you. Ted MacNEIL Sent by: IBM Mainframe Discussion List 02/04/2009 12:06 PM Please respond to IBM Mainframe Discussion List To IBM-MAIN@bama.ua.edu cc Subject Re: [IBM-MAIN] insanity? process SMF with Java on non-z? >>>WPS (written in JAVA) already exists >Really? What sense would that make to save on SAS costs and then run something that is even more of a CPU hog? Knee-Jerk reaction! Speaking as a long-time performance analyst, JAVA can be optimised. >Even on a zAAP it would still be expensive. The software costs probably mitigate the hardware costs. And, SAS CPU (as an interpreter) isn't cheap either. I have not done an evaluation, but I would bet WPS beats out SAS by cost alone. The only way to find out is to meaure, without prejudice. - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
We have had a couple of people report that they have been successful in using Co:Z in a z/OS jobstep to launch the Windows SAS job and pipe it SMF data. If you are going to do this, it would be best to set up Co:Z for "non-tunneling" mode, so that your potentially huge file transfers will ride on a raw socket rather than being tunneled in SSH. This will reduce CPU and improve network throughput. As far as using Java - IBM has recently published some work that we did for them in the JZOS alphaWorks project that you might want to look at. There is a took that allows you to map Cobol copy books or Assembler DSECTs into Java record-mapping code. You can run this code on any platform, so that might be one solution to making the process a little easier. It still seems like a aweful lot of work to me Kirk Wolf Dovetailed Technologies On Wed, Feb 4, 2009 at 12:30 PM, John McKown wrote: > We are losing our SAS license. Cost containment. We are looking at getting > our main SAS user a Window desktop license so that he can continue to use > MXG. Apparently this is fairly popular. > > But I was curious if anybody has ever used anything else, such as Java, to > process SMF data on a Windows or Linux box? Or is that just too crazy? > > -- > John > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
>>>WPS (written in JAVA) already exists >Really? What sense would that make to save on SAS costs and then run >something that is even more of a CPU hog? Knee-Jerk reaction! Speaking as a long-time performance analyst, JAVA can be optimised. >Even on a zAAP it would still be expensive. The software costs probably mitigate the hardware costs. And, SAS CPU (as an interpreter) isn't cheap either. I have not done an evaluation, but I would bet WPS beats out SAS by cost alone. The only way to find out is to meaure, without prejudice. - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
>We tried to get hold of them. My manager got so frustrated that he has sent >them to the garbage bin. As he said: "If I can't get hold of the sales people, >what chance would I have for tech support???". Unfortunate! At the time I was looking at WPS, they were crawling all over us to get us to look at the product. But, at the time MXG had a much harder stance against it, so we dropped the whole thing, and went with SAS. >He said that the Web site would not do "anything" about getting a trial. Bad marketting! Not a good way to penetrate the market. >Some sort of error that just sent him over the edge. And no response to emails. As I said, unfortunate! And, I agree with your manager. (Rarely, do I agree with management( - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 4 Feb 2009 19:02:44 +, Ted MacNEIL wrote: > >WPS (written in JAVA) already exists Really? What sense would that make to save on SAS costs and then run something that is even more of a CPU hog? Even on a zAAP it would still be expensive.I thought WPS it relied on LE, so I would have guessed it was written in C / C++.- Not SAS/C though! :-) Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America / Farmers Insurance Group - ZFUS G-ITO mailto:mark.zel...@zurichna.com z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
>I would think it'd take a long time to redo the several thousand man-years of >work that MXG represents. And Dr. Merrill might get upset if you were to just >translate the SOURCLIB into Java or Whatever. The WPS solution is NOT translating the SOURCLIB. Who said we were going to do that? Rather, it's running it with a different interpreter. When WPS first came out, he wouldn't touch it. Now, he says that if you have a problem with MXG using WPS, re-run with SAS (difficult if you don't have a SAS licence). If the problem recurrs, he'll look into it. In other words, it's sort of a passive support stance. Of course, I'm just (mis-)quoting his statements on his web-site. Go to www.mxg.com to get his direct comments; don't depend on mine. - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 4 Feb 2009 12:59:23 -0600, Walt Farrell wrote: > >If you did decide to use Java, why does that require moving the data off of >z/OS? > >Just curious... > >-- > Walt 1) no CPU power to run Java on our current system 2) no money to get a zAAP 3) Intel is dirt cheap compared to "z" MIPS. All, in all, Linux/Intel or Windows/Intel is so much cheaper than the z, that using one of them, where possible, is preferred. Let's not get into TCO discussions. "Intel is more cost effective" is the mantra around here and that is that. Trying to convince people otherwise is unwise. off topic point - some may remember that in 2002, the then-management wanted to replace the "z" with Wintel on a particular vendor's boxes. Vendor promised performance and RAS equal to or better than "z". We are now totally replacing that vendor's hardware due to reliability problems. No, I won't reveal the vendor. These boxes are __OLD__ (the 2002 boxes, in fact). -- John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 2009-02-04 at 12:51 -0600, Scott Barry wrote: > consider the SAS-alternative WPS [...] Visit the website below > and you can request a WPC trial Unfortunately, pricing for z/OS appears to be $CALL. -- David Andrews A. Duda and Sons, Inc. david.andr...@duda.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
>SAS/MXG on a non-mainframe platform is actually pretty inexpensive. At a >prior employer, I did just that along with MXG running on SUSE linux on Intel. > For us, it ran faster than on the mainframe. It was a small shop, so there was not an overabundance of SMF data. The only problems with MXG on a non-mainframe platform is network capacity (to get the data down) and disk capacity (to store the data). While the disk is cheaper than mainframe disk, it still has a non-zero cost. >As zfor your question of rolling your own via JAVA, sounds like a fulltime job. WPS (written in JAVA) already exists, and you can use it with MXG. But, if youy run into a problem, you have to reproduce it with SAS, before Doctor Barry will investigate. - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 4 Feb 2009 12:51:24 -0600, Scott Barry wrote: >Most definitely consider the SAS-alternative WPS from World Programming >(WPS). The software runs most SAS Base application language, and it is >certified for MXG on both Windows and z/OS. The product is evolving and >possibly in 2009, it will be certified for use with CA MICS, as I learned >recently at CA World. Visit the website below and you can request a WPC >trial install very easily. > >Scott Barry >SBBWorks, Inc. > Scott, We tried to get hold of them. My manager got so frustrated that he has sent them to the garbage bin. As he said: "If I can't get hold of the sales people, what chance would I have for tech support???". He said that the Web site would not do "anything" about getting a trial. Some sort of error that just sent him over the edge. And no response to emails. -- John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Ann Totten/Poughkeepsie/IBM is out of the office.
I will be out of the office starting 02/04/2009 and will not return until 02/09/2009. I will be checking my email, but may not be available for a timely response. For technical issues, please contact Bob Kindt, for other issues, please contact Michele Jakuba. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 4 Feb 2009 12:30:23 -0600, John McKown wrote: >We are losing our SAS license. Cost containment. We are looking at getting >our main SAS user a Window desktop license so that he can continue to use >MXG. Apparently this is fairly popular. > >But I was curious if anybody has ever used anything else, such as Java, to >process SMF data on a Windows or Linux box? Or is that just too crazy? If you did decide to use Java, why does that require moving the data off of z/OS? Just curious... -- Walt -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
Most definitely consider the SAS-alternative WPS from World Programming (WPS). The software runs most SAS Base application language, and it is certified for MXG on both Windows and z/OS. The product is evolving and possibly in 2009, it will be certified for use with CA MICS, as I learned recently at CA World. Visit the website below and you can request a WPC trial install very easily. Scott Barry SBBWorks, Inc. http://teamwpc.co.uk -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
On Wed, 4 Feb 2009 10:36:21 -0800, Gibney, Dave wrote: > I would think it'd take a long time to redo the several thousand >man-years of work that MXG represents. And Dr. Merrill might get upset >if you were to just translate the SOURCLIB into Java or Whatever. > >Dave Gibney >Information Technology Services >Washington State Univsersity OH! Let me clarify that immediately. I did not mean that I would look at the MXG code and transliterate it into Java. That would be, at least, copyright infringement. And I'm really sensitive to that (being a FOSS bigot). I was meaning to download the SMF data to __something__, likely Intel, then processing it there using a language such as Java. I would most likely try to store the data in some sort of a relational database. But I'd likely need to get a few of those new WD 2Tb disk drives to store it! OK, I think that I'll just mark this idea as "way to crazy to try." -- John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
SAS/MXG on a non-mainframe platform is actually pretty inexpensive. At a prior employer, I did just that along with MXG running on SUSE linux on Intel. For us, it ran faster than on the mainframe. It was a small shop, so there was not an overabundance of SMF data. As for your question of rolling your own via JAVA, sounds like a fulltime job. _ Dave Jousma Assistant Vice President, Mainframe Services david.jou...@53.com 1830 East Paris, Grand Rapids, MI 49546 MD RSCB1G p 616.653.8429 f 616.653.8497 -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, February 04, 2009 1:30 PM To: IBM-MAIN@bama.ua.edu Subject: insanity? process SMF with Java on non-z? We are losing our SAS license. Cost containment. We are looking at getting our main SAS user a Window desktop license so that he can continue to use MXG. Apparently this is fairly popular. But I was curious if anybody has ever used anything else, such as Java, to process SMF data on a Windows or Linux box? Or is that just too crazy? -- This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: insanity? process SMF with Java on non-z?
I would think it'd take a long time to redo the several thousand man-years of work that MXG represents. And Dr. Merrill might get upset if you were to just translate the SOURCLIB into Java or Whatever. Dave Gibney Information Technology Services Washington State Univsersity -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, February 04, 2009 10:30 AM To: IBM-MAIN@bama.ua.edu Subject: insanity? process SMF with Java on non-z? We are losing our SAS license. Cost containment. We are looking at getting our main SAS user a Window desktop license so that he can continue to use MXG. Apparently this is fairly popular. But I was curious if anybody has ever used anything else, such as Java, to process SMF data on a Windows or Linux box? Or is that just too crazy? -- John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
insanity? process SMF with Java on non-z?
We are losing our SAS license. Cost containment. We are looking at getting our main SAS user a Window desktop license so that he can continue to use MXG. Apparently this is fairly popular. But I was curious if anybody has ever used anything else, such as Java, to process SMF data on a Windows or Linux box? Or is that just too crazy? -- John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: How to APPLY FMID's again
> -Original Message- > From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex R. > > Hi. > > Apparently I misunderstood and thought you had just installed PSF into > the 1.8 LINKLIB by accident and wanted to correct the DDDEF and re-apply > it. Am I correct now in guessing that you have PSF installed and > working in the 1.8 LINKLIB and you want to reinstall it into a 1.9 or > 1.10 new environment? Has PSF been ACCEPTED into the 1.8 level DLIBs? > > If SMP/E is complaining that PSF isn't in the GLOBAL zone, you will need > to RECEIVE it back into the GLOBAL zone then you can apply it. If you > are using the same CSI you used the first time you installed PSF, you > will need to use the REDO and SELECT parameters like I mentioned before. If the product has been ACCEPTed and you haven't applied subsequent maintenance that is not also ACCEPTed, you might consider the SMP/E BUILDMCS command, then RECEIVE, APPLY and ACCEPT its output deck. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: $P JOBQ Question
Sorry about my bad memory regarding the defaults for PCEDEF. I went back through my init deck notes and found a comment from 10 OCT 1999 saying that I set most of the PCEDEFs to 10 based on Chip Wood's presentation at SHARE 93. (Chicago, AUG 1999) This was probably session 2658 JES2 Configuration & Tuning Tips. SHARE's online handouts do not appear to go back that far, but the abstract for the session said: Is your JES system running as well as it should? There are some simple things you may be able to do which can improve the efficiency or availability of your system. In this session, a representative from JES2 development will discuss: (.) Initialization statements which must be coded, or for which the default is not the best choice, (.) Tuning tips to improve performance of checkpoint and spool, (.) Recommendations for maximizing the availability of your JESplex. I would guess that I would not have set these values to the max if any potential downside had been mentioned at the session. /jack - Original Message - From: "Richards, Robert B." Newsgroups: bit.listserv.ibm-main To: Sent: Friday, January 30, 2009 6:54 AM Subject: Re: $P JOBQ Question Rick, Thanks for the reminder. Wow, 8 years ago. Time flies Back on topic: Anyone experience any downside to specifying the maximum? Bob -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Rick Fochtman Sent: Thursday, January 29, 2009 12:27 PM To: IBM-MAIN@bama.ua.edu Subject: Re: $P JOBQ Question -- I looked at the JES2 Init and Tuning Reference manual and it indicates that the default value is "2", not "10". 10 is the maximum value that can be specified. I would be interested in the rationale from anyone who has the maximum values set. --- Bob, we discussed this when you were at Clearing. We ran an automatic command at midnight every night to purge old test garbage from the spool. Because of the nature of our processing, the fewer PCEDEFs we had, the longer it took, on rare occaissions running into morning processing and impacting job turnaround times. And you KNOW how upset people got around there when things showed any slowing down! :-)) Rick -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: How to APPLY FMID's again
Hi. Apparently I misunderstood and thought you had just installed PSF into the 1.8 LINKLIB by accident and wanted to correct the DDDEF and re-apply it. Am I correct now in guessing that you have PSF installed and working in the 1.8 LINKLIB and you want to reinstall it into a 1.9 or 1.10 new environment? Has PSF been ACCEPTED into the 1.8 level DLIBs? If SMP/E is complaining that PSF isn't in the GLOBAL zone, you will need to RECEIVE it back into the GLOBAL zone then you can apply it. If you are using the same CSI you used the first time you installed PSF, you will need to use the REDO and SELECT parameters like I mentioned before. Rex -Original Message- Hi Thank you. I would like to leave in 1.8 LINKLIB, so i don't want to make a RESTORE. As they are FMID's I get error if I specify in the SELECT, and I get an error if I specify a FORFMID list. The SMP/ is complaining this FMID's are not in the GLOBAL zone. Pommier, Rex R. wrote: >Miklos, > >Do you want to clean up the "stuff" you put into the 1.8 LINKLIB? If >so, leave the DDDEFs alone and run a RESTORE command of PSF. This will >remove PSF from the target libraries - including the 1.8 LINKLIB. Then >update the DDDEF to point to the correct LINKLIB and run the APPLY again >- with no changes needed. If you don't care that you have "stuff" in >the LINKLIB, you can just rerun the APPLY with a REDO parameter on it. >This will reapply the PSF code. Using the REDO parameter you will also >have to specifically SELECT the appropriate sysmods. > >HTH > >Rex > >-Original Message- > >Hi > >All the PSF related FMID's are applied in a unique CSI but the >LINKLIB DDDEF >was pointed to the SYS1:LINKLIB of zOS 1.8 . >I would like to change the DDDEF for LINKLIB to another library (I can >do this) > and run the APPLY again (till now I was unable) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: How to APPLY FMID's again
Has PSF been accepted ? Lizette > >Hi > >Thank you. >I would like to leave in 1.8 LINKLIB, so i don't want to make a RESTORE. >As they are FMID's I get error if I specify in the SELECT, and I get an >error if I specify a FORFMID list. >The SMP/ is complaining this FMID's are not in the GLOBAL zone. > > > >Pommier, Rex R. wrote: > >>Miklos, >> >>Do you want to clean up the "stuff" you put into the 1.8 LINKLIB? If >>so, leave the DDDEFs alone and run a RESTORE command of PSF. This will >>remove PSF from the target libraries - including the 1.8 LINKLIB. Then >>update the DDDEF to point to the correct LINKLIB and run the APPLY again >>- with no changes needed. If you don't care that you have "stuff" in >>the LINKLIB, you can just rerun the APPLY with a REDO parameter on it. >>This will reapply the PSF code. Using the REDO parameter you will also >>have to specifically SELECT the appropriate sysmods. >> >>HTH >> >>Rex >> >>-Original Message- >>From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On >>Behalf Of Miklos Szigetvari >>Sent: Wednesday, February 04, 2009 11:32 AM >>To: IBM-MAIN@bama.ua.edu >>Subject: How to APPLY FMID's again >> >>Hi >> >>All the PSF related FMID's are applied in a unique CSI but the >>LINKLIB DDDEF >>was pointed to the SYS1:LINKLIB of zOS 1.8 . >>I would like to change the DDDEF for LINKLIB to another library (I can >>do this) >> and run the APPLY again (till now I was unable) >> >> >> > >-- >Miklos Szigetvari -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: How to APPLY FMID's again
Hi Thank you. I would like to leave in 1.8 LINKLIB, so i don't want to make a RESTORE. As they are FMID's I get error if I specify in the SELECT, and I get an error if I specify a FORFMID list. The SMP/ is complaining this FMID's are not in the GLOBAL zone. Pommier, Rex R. wrote: Miklos, Do you want to clean up the "stuff" you put into the 1.8 LINKLIB? If so, leave the DDDEFs alone and run a RESTORE command of PSF. This will remove PSF from the target libraries - including the 1.8 LINKLIB. Then update the DDDEF to point to the correct LINKLIB and run the APPLY again - with no changes needed. If you don't care that you have "stuff" in the LINKLIB, you can just rerun the APPLY with a REDO parameter on it. This will reapply the PSF code. Using the REDO parameter you will also have to specifically SELECT the appropriate sysmods. HTH Rex -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Miklos Szigetvari Sent: Wednesday, February 04, 2009 11:32 AM To: IBM-MAIN@bama.ua.edu Subject: How to APPLY FMID's again Hi All the PSF related FMID's are applied in a unique CSI but the LINKLIB DDDEF was pointed to the SYS1:LINKLIB of zOS 1.8 . I would like to change the DDDEF for LINKLIB to another library (I can do this) and run the APPLY again (till now I was unable) -- Miklos Szigetvari Development Team ISIS Information Systems Gmbh tel: (+43) 2236 27551 570 Fax: (+43) 2236 21081 E-mail: miklos.szigetv...@isis-papyrus.com Info: i...@isis-papyrus.com Hotline: +43-2236-27551-111 Visit our Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. This email has been checked for known viruses, but ISIS accepts no responsibility for malicious or inappropriate content. --- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: How to APPLY FMID's again
Miklos, Do you want to clean up the "stuff" you put into the 1.8 LINKLIB? If so, leave the DDDEFs alone and run a RESTORE command of PSF. This will remove PSF from the target libraries - including the 1.8 LINKLIB. Then update the DDDEF to point to the correct LINKLIB and run the APPLY again - with no changes needed. If you don't care that you have "stuff" in the LINKLIB, you can just rerun the APPLY with a REDO parameter on it. This will reapply the PSF code. Using the REDO parameter you will also have to specifically SELECT the appropriate sysmods. HTH Rex -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Miklos Szigetvari Sent: Wednesday, February 04, 2009 11:32 AM To: IBM-MAIN@bama.ua.edu Subject: How to APPLY FMID's again Hi All the PSF related FMID's are applied in a unique CSI but the LINKLIB DDDEF was pointed to the SYS1:LINKLIB of zOS 1.8 . I would like to change the DDDEF for LINKLIB to another library (I can do this) and run the APPLY again (till now I was unable) -- Miklos Szigetvari Development Team ISIS Information Systems Gmbh tel: (+43) 2236 27551 570 Fax: (+43) 2236 21081 E-mail: miklos.szigetv...@isis-papyrus.com Info: i...@isis-papyrus.com Hotline: +43-2236-27551-111 Visit our Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. This email has been checked for known viruses, but ISIS accepts no responsibility for malicious or inappropriate content. --- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
How to APPLY FMID's again
Hi All the PSF related FMID's are applied in a unique CSI but the LINKLIB DDDEF was pointed to the SYS1:LINKLIB of zOS 1.8 . I would like to change the DDDEF for LINKLIB to another library (I can do this) and run the APPLY again (till now I was unable) -- Miklos Szigetvari Development Team ISIS Information Systems Gmbh tel: (+43) 2236 27551 570 Fax: (+43) 2236 21081 E-mail: miklos.szigetv...@isis-papyrus.com Info: i...@isis-papyrus.com Hotline: +43-2236-27551-111 Visit our Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. This email has been checked for known viruses, but ISIS accepts no responsibility for malicious or inappropriate content. --- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: TLS Cipher Suites
On Wed, 4 Feb 2009 10:55:49 -0600, Hal Merritt wrote: >I'm slogging through the FM's hunting for a definitive, official list of cipher suites supported by z/os 1.7 and 1.9. It seems that the lists in the Redbooks are in error. As are some of the FM's. > Assuming you have an application that is using the System SSL function of z/OS (or the Application Transparent TLS function of z/OS Communications Server, which uses System SSL): (a) z/OS R7: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/gska1a30/6.12?SHELF=EZ2ZO10G&DT=20040714151143 or http://preview.tinyurl.com/bu7tmy (b) z/OS R9: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/GSKA1A50/6.12?SHELF=EZ2ZO10K&DT=20070508220341 or http://preview.tinyurl.com/bt4fy8 If you have an application with its own SSL support (e.g., Java via JSSE/JSSE2) or Websphere Application Server you need to look at their documentation (pointers previously provided here on IBM-MAIN, I believe). -- Walt Farrell, CISSP IBM STSM, z/OS Security Design -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
TLS Cipher Suites
I'm slogging through the FM's hunting for a definitive, official list of cipher suites supported by z/os 1.7 and 1.9. It seems that the lists in the Redbooks are in error. As are some of the FM's. Anyone danced with this bear yet? Thanks!! NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
I Just Registered for SHARE in Austin -- Have You?
Check out the agenda at http://www.share.org. This proves to be one of the most informative conferences in recent memory. Our platform, indeed the entire IT industry, is going through a transformation and SHARE seems to be covering it all. For years, SHARE abandoned keynote presentations. I guess that reflected the lack of clear direction for our platform that was so pervasive at the time. In Austin there will be _three_ keynotes. (Talk about a swinging pendulum!) I plan to attend all of them but, as a self-described "MVS bigot" whose keenly interested in where our platform is headed both near and long term, I'm particularly looking forward to hearing Karl Freund's keynote address: "Building a Dynamic Infrastructure - Trends and Directions for System z." Mainframe meets cloud computing? Does System z have a leg up on the competition? The MVS/SCP Project has an exciting and varied agenda planned that ranges from presentations by acknowledged subject matter experts to user experiences related by competent people from installations just like yours. As you would expect, there will be plenty of information on the most recent hardware and software offerings from IBM and ISVs, including previews of upcoming releases and loads of migration advice to get you there with a minimum of problems. Real "techies" can learn how an operating system works, tour I/O subsystem internals, learn how HiperDispatching and other complex algorithms work (and why they're needed), learn the best techniques for diagnosing system and application problems, and discover free tools that can help you work smarter, not harder every day. There are even a few "hand's in" opportunities (noted as such in the session titles) that provide an opportunity to help shape IBM's direction without the need for those "pesky" formal requirements. Some of our speakers are flying in from other countries or haven't been to SHARE in a decade. There is a resurgence happening, folks. And SHARE seems to be at the forefront! I'll be simultaneously everywhere and nowhere. You can stop me in the hall and say "Hi" or, in keeping with 21st-century SHARE tradition, snub me. (Someone even has stickers that say, "I got snubbed at SHARE.") The choice is yours... -- Edward E Jaffe Phoenix Software International, Inc 5200 W Century Blvd, Suite 800 Los Angeles, CA 90045 310-338-0400 x318 edja...@phoenixsoftware.com http://www.phoenixsoftware.com/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: 1.9 and PDF's EDIT hide function
On 1.9, when I try the edit command 'hide x', I get the message 'ISRE200 The edit panel has not been configured to support the HIDEX command." The problem turned out to be that I did not have the 'Extended Attribute' function enable on my 3270 emulator. Appears that you get a different EDIT panel (ISREDDE3) is the terminal isn't 'Extended Attribute' enabled. This is different than it was on 1.7. Jack Kelly 202-502-2390 (Office) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IEAOPTxx
Can you elaborate on this? We are running IDMS DB and DC and aren't seeing this issue. What resource are you enqueuing on? here's the update that I got from CA. Since we're a uniprocessor, my solution was to set ERV=0 which was the least worse solution. Background from issue #17033487-01 In terms of the enqueuing of batch jobs in general, our process is: 1. When a CV batch job begins, it ENQUEUES SHARED on a MAJOR name of IDMSCV and a MINOR name of BATC, where is a binary time stamp. 2. When CV gets control, RHDCCKUR attempts an ENQUEUE EXCLUSIVE on the same MAJOR and MINOR names, but since the batch job still control of the enqueue names, it goes to sleep. 3. When the cv batch job terminates, RHDCCKUR will wake up and the CV will do the necessary cleanup for the batch job. This poses a problem for IBM's WLM, ERV function. The 'sleep' scenario described above is making WLM 'misbehave'. WLM / ERV wants to increase the priority of a task that holds an enque that someone else wants. That's ERV's function. This was put in place to reduce enque lockouts, ie low priority task has enque that a higher priority task need. Even though IDMS isn't waiting on the enque, WLM 'sees' the conflict and keeps trying to give the holder more cycles. Since the holder is batch, the user basically has a batch job sucking up all the resources and IDMS keeps passing it data. This causes all CV activity to grind to a halt. When the batch job is a long-running one, it creates unacceptable delays for the online system which is now running at a lower priority than the batch job. WLM ERV is adjusting the zos dispatching priority of the jobs. This gets boosted up into the F1, F2 range (higher than the IDMS CV's) for the batch jobs; the client turns off ERV and the batch jobs stay where they belong, ie high C0, low D0 range. This method of managing ENQ resources was changed in z/OS 1.3. In this processing, ERV is overriding the Service Class management of batch jobs that we suggest in technote QI02781. IBM has stated that their ERV funcionality is working as intended. It does not include a method for ignoring some jobs that hold an ENQUEUE, or for selectively implementing the feature. The client requests that we change our processing to use a RET=TEST on the enque instead of an EXCL request, or that we use POST to communicate serialization, so that this problem can be avoided. Level2 has said that the reason we do the ENQ is to allow the CV to be notified if the Batch job goes away for some reason. Without the ENQ the batch job would remain active within the CV. This would result in resources being held indefintely (Storage, DBKEY locks, RCEs, RLEs, DPEs, etc.). We We need the Batch job to hold the ENQ so when the CV CKUR task attempts to get the ENQ it waits. If the batch job goes away, the CKUR acquires the ENQ and notifies the CV that things may need to be cleaned up. Client feels that the current methodology is one way to do it BUT it has adverse affects on performance and should be changed. IBM has said ERV is working as designed, so the CA IDMS approach has forced them to disable an important vehicle to minimize contention. CV could issue EXCL enq and if it fails, then a batch job is executing. --- Error --- The operation completed successfully. Jack Kelly 202-502-2390 (Office) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: convert DB2 data to a flat file
Thank you all - I'll pass this info along. Regards, Jasbir -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, February 04, 2009 9:53 AM To: IBM-MAIN@bama.ua.edu Subject: Re: convert DB2 data to a flat file You can go directly from I to Z via ftp. Beware of Date fields and packed fields. Depending on which language the Z is going to use, it may not be able to handle it. When I do this, I make sure all data is character or zoned.I have consistently moved data from the I to Z with this technique. The CPYTOIMPF you can "format" with the type of delimiter or fixed format you want. You can also define the end of record delimiter you want to use. I would go directly from I to Z rather than CPYTOIMPF. Sharon Wintermute -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IEAOPTxx
Jack, Can you elaborate on this? We are running IDMS DB and DC and aren't seeing this issue. What resource are you enqueuing on? Rex -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John Kelly Sent: Wednesday, February 04, 2009 7:59 AM To: IBM-MAIN@bama.ua.edu Subject: Re: IEAOPTxx It is the time the ENQ will be promoted. In addition to DSN Enq, I ran into the problem with CA's IDMS. It enqueues on a resource (seems to be a heart beat indicator) and batch IDMS jobs also enque on it but don't wait. These batch jobs then get ERV assignment and usually make a bad scenario worse. IBM said that there's no exclusion methodology for ERV and CA says that the way IDMS works. Jack Kelly 202-502-2390 (Office) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: convert DB2 data to a flat file
I asked this question on the midrange-l forum and got the following response from one person: You can go directly from I to Z via ftp. Beware of Date fields and packed fields. Depending on which language the Z is going to use, it may not be able to handle it. When I do this, I make sure all data is character or zoned.I have consistently moved data from the I to Z with this technique. The CPYTOIMPF you can "format" with the type of delimiter or fixed format you want. You can also define the end of record delimiter you want to use. I would go directly from I to Z rather than CPYTOIMPF. Sharon Wintermute -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IEAOPTxx
On Wed, 4 Feb 2009 08:58:34 -0500, John Kelly wrote: > >It is the time the ENQ will be promoted. > > >In addition to DSN Enq, I ran into the problem with CA's IDMS. It enqueues >on a resource (seems to be a heart beat indicator) and batch IDMS jobs >also enque on it but don't wait. These batch jobs then get ERV assignment >and usually make a bad scenario worse. IBM said that there's no exclusion >methodology for ERV and CA says that the way IDMS works. > Can you elaborate on what your problem was. We don't run IDMS except for CA-Dispatch. We run its archive and extract tasks externally (as STCs) and those operate like an IDMS batch job would. Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America / Farmers Insurance Group - ZFUS G-ITO mailto:mark.zel...@zurichna.com z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: convert DB2 data to a flat file
Oh, you might also want to look at the CPYTOIMPF command on the iSeries. It is built-in. But I don't really know what its output looks like. iSeries info center is at: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp -- John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: convert DB2 data to a flat file
On Wed, 4 Feb 2009 08:10:12 -0500, Chauhan, Jasbir wrote: > > >One of my clients is running a DB2 application on an iSeries system (not >sure about the version). Their goal is to send us DB2 application data >in the form of a flat file that can then be loaded to a non-DB2 >application on our z/OS system (1.9). Is there a third party product or >a utility they can use to accomplish this? > >Regards, > >Jasbir Chauhan I am a novice, just starting to learn about the "i" because we are looking at converting from z/OS to the "i". In any case, the DB2 system on the "i" is integrated into the system directly. The data in the DB2 system is kept in what is called a PF (or Physical File). From my reading, you should be able to directly ftp this file from the "i" to the "z" in BINary mode. The output file on the "z" should be allocated with an LRECL equal to the record length on the "i" and an RECFM of FB. IOW - I don't think you need to copy it to a sequential file because a PF file on the "i" is very much like a VSAM ESDS (or maybe an RRDS) on the "z", but with SQL interfaces available. It should be directly FTP'able as is. You might want to ask this question on the iSeries technical forum. mailto:lists...@midrange.com subscribe midrange-l Chauhan, Jasbir -- John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: SDSF - so slow!
So, perhaps opening a PMR against SDSF for performance issues in reading the spool files would be in line. Usually this works with IBM but SDSF folks seem to take pleasure in not incorporating functionality nor addressing issues/problems but then again I was use to (E)JES before this shop. Jack Kelly 202-502-2390 (Office) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IEAOPTxx
It is the time the ENQ will be promoted. In addition to DSN Enq, I ran into the problem with CA's IDMS. It enqueues on a resource (seems to be a heart beat indicator) and batch IDMS jobs also enque on it but don't wait. These batch jobs then get ERV assignment and usually make a bad scenario worse. IBM said that there's no exclusion methodology for ERV and CA says that the way IDMS works. Jack Kelly 202-502-2390 (Office) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: convert DB2 data to a flat file
Probably but they already have what they need, just use SQL to extract and write the records using a noddy written in just about anything. They must do this themselves all the time anyway. GA "Chauhan, Jasbir" To Sent by: IBM IBM-MAIN@bama.ua.edu Mainframe cc Discussion List convert DB2 data to a flat file 04/02/2009 13:10 Please respond to IBM Mainframe Discussion List One of my clients is running a DB2 application on an iSeries system (not sure about the version). Their goal is to send us DB2 application data in the form of a flat file that can then be loaded to a non-DB2 application on our z/OS system (1.9). Is there a third party product or a utility they can use to accomplish this? Regards, Jasbir Chauhan Generally, this communication is for informational purposes only and it is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. In the event you are receiving the offering materials attached below related to your interest in hedge funds or private equity, this communication may be intended as an offer or solicitation for the purchase or sale of such fund(s). All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and affiliates, as applicable, for any loss or damage arising in any way from its use. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. Please refer to http://www.jpmorgan.com/pages/disclosures for disclosures relating to UK legal entities. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: convert DB2 data to a flat file
Chauhan, Jasbir wrote: One of my clients is running a DB2 application on an iSeries system (not sure about the version). Their goal is to send us DB2 application data in the form of a flat file that can then be loaded to a non-DB2 application on our z/OS system (1.9). Is there a third party product or a utility they can use to accomplish this? Regards, Jasbir Chauhan You may want to ask if there is some form of DATAUNLOAD available that can take the output from a SELECT statement and write it to a flat file. They can then use ssh/scp or some other secure means of data transfer to get the data to you. -- Rich Smrcina VM Assist, Inc. Phone: 414-491-6001 Ans Service: 360-715-2467 http://www.linkedin.com/in/richsmrcina Catch the WAVV! http://www.wavv.org WAVV 2009 - Orlando, FL - May 15-19, 2009 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: TIOT usage
Off the top of my head, I am not able to think of any way to get definitive TIOT usage. You should be able to estimate it from the type 14/15 records or from the EXCP section of the type 30 record. You can certainly get which jobs are the biggest that way, giving you an opportunity to look at them or test them individually. David Logan Manager of Product Development, Pitney Bowes Business Insight http://centrus.com W: (720) 564-3056 C: (303) 818-8222 -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Bob Sent: Tuesday, February 03, 2009 16:10 To: IBM-MAIN@bama.ua.edu Subject: TIOT usage We have some "bigger" jobs coming that may stress our TIOT limit. Anyone know a way to determine this for past job runs (SMF) or a tool that might help? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
convert DB2 data to a flat file
One of my clients is running a DB2 application on an iSeries system (not sure about the version). Their goal is to send us DB2 application data in the form of a flat file that can then be loaded to a non-DB2 application on our z/OS system (1.9). Is there a third party product or a utility they can use to accomplish this? Regards, Jasbir Chauhan -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: SLIP - SA - DATA= for a dataspace???
SLIP SET,SA,A=SVCD,ID=S001,+ DSPNAME=jobname'.dspname,+ DSSA='jobname'.dspname,+ RA=(0001C681),+ DA=(0001C681,EQ,F1),+ E For data spaces, you must have the address in a register and do indirection off that register. Neither DSPNAME (which is a dumping parameter) nor DSSA has any bearing on the way slip does its data match. DSSA does help a lot to limit the "false" PER interrupts. The ALET to use is, in general, not obtainable. SLIP can use the AR associated with the indirecting GPR at the time of the PER interrupt.. Peter Relson z/OS Core Technology Design -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: SDSF - so slow!
Brian, here is the the file after, it's blocked efficiently, indeed other things process it in minutes: Data Set Information Command ===> Data Set Name . . . . : SZ.SDSF.WORK General Data Current Allocation Management class . . : DEVSTD Allocated cylinders : 4,015 Storage class . . . : STANDARDAllocated extents . : 201 Volume serial . . . : HAT10D + Device type . . . . : 3390 Data class . . . . . : MULTDVECurrent Utilization Organization . . . : PS Used cylinders . . : 4,012 Record format . . . : FBA Used extents . . . : 201 Record length . . . : 133 Block size . . . . : 27930 1st extent cylinders: 15 Secondary cylinders : 20 Data set name type : SMS Compressible : NO Creation date . . . : 2009/02/03 Referenced date . . : 2009/02/03 Expiration date . . : ***None*** To display multiple volumes press Enter or enter Cancel to Exit. Brian Westerman To Sent by: IBM IBM-MAIN@bama.ua.edu Mainframe cc Discussion List Re: SDSF - so slow! 04/02/2009 06:03 Please respond to IBM Mainframe Discussion List I can't believe how stupid my last comment (and test) was, I looked at the wrong line of his output and completely missed that the next DS in line was 25 MILLION lines. I don't have any 25M line jobs to test, but I went to our test runs of SyzSpool and looked at the stats for various size output. I don't see how any of them would multiply out to the numbers that he is seeing. The 120,000 EXCPs is possible putting about 400 recs/block in the datasets, but that seems to be strange (or maybe pretty big records). Maybe your writing them out to a dataset that is blocked badly, or the JES dataset is really screwed up. If you were to select your output in SDSF, then MAX DOWN to the bottom, how long does that take? If it isn't 1/2 of the numbers that you have provided initially, then the problem isn't with the input dataset (or SDSF) itself, but rather with the output DS that you are writing it into. Although if it's the input DS that is the problem then this test will not really show us very good results, only if the output dataset is the issue. It would be interesting to know the record size of the input and the DCB of the output. Sorry for the stupidity of the last post. Brian Generally, this communication is for informational purposes only and it is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. In the event you are receiving the offering materials attached below related to your interest in hedge funds or private equity, this communication may be intended as an offer or solicitation for the purchase or sale of such fund(s). All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and affiliates, as appli
Re: SDSF - so slow!
Frank, write them to standard DASD, and if necessary IEBGENER the DS to SYSUT2=* as well then you can have them on the spool also. Several have suggested this and I had already recomeneded that too it's just that I was mainly curious at what SDSF was doing to be so dam slow. In my case I wasn't even doing a "FIND" I was just just doing a PRINT ODSN as described in my original post. GA Frank Swarbrick To Sent by: IBM IBM-MAIN@bama.ua.edu Mainframe cc Discussion List Re: SDSF - so slow! 03/02/2009 18:58 Please respond to IBM Mainframe Discussion List On Tue, 3 Feb 2009 11:25:05 +, Gerry Anstey wrote: >OK bad design, we have lot of cack here, probably due to hiring cheap >programmers, any way, I digress. > >Here s the SDSF summary: > > PREFIX=GCSPROCP DEST=(ALL) OWNER=* SYSNAME=FMVS > NP DDNAME STEPNAME PROCSTEP DSID OWNERC DEST REC-CNT > JESMSGLG JES2 2 PSTGCS T LOCAL 52 > JESJCL JES2 3 PSTGCS T LOCAL 44 > JESYSMSG JES2 4 PSTGCS T LOCAL 94 > DDPRINT GCSPROCP 106 PSTGCS 0 LOCAL 3 > CMPRINT GCSPROCP 107 PSTGCS 0 LOCAL 28,559 > CMPRT01 GCSPROCP 108 PSTGCS T LOCAL 25M > >Now we had a need to extract some of the records in CMPRT01, I wrote job to >run SDSF in batch and to use the PRINT ODSN command to extract the data to >a data set. > >Then I read the dataset with Filemaster and extracted the desired records >into a smaller file. > >My questions are: > >1. Any ideas why SDSF takes appox 90 minutes (12 EXCPs + 31mins CPU) to >read and write out the data and Filemaster takes about 3 minutes to read >25million recs and write about 1.5million? > >2. Is there any way to make SDSF extract faster? Hope you don't mind me stealing your thread, but it made me think of something we need to deal with. We are on the front end of a project to move from VSE to z/OS. We currently archive our reports in IBM Content OnDemand (Windows version, not z/OS version). Basically we write all of our reports to the VSE/POWER list queue and then we run a job that FTPs them out of the list queue to the OnDemand server, which then loads them in to OnDemand. Can you FTP from the JES spool? And even if you can, is it a good idea? Or should we just go ahead and write them to sequential disk files instead of SYSOUT? Frank Generally, this communication is for informational purposes only and it is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. In the event you are receiving the offering materials attached below related to your interest in hedge funds or private equity, this communication may be intended as an offer or solicitation for the purchase or sale of such fund(s). All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. This transmission may contain information that is privileged, confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by JPMorgan Chase & Co., i
Re: B18 VTS replication question
Meganen How you doing - take a look at www.brocade.com we are currently talking to the, about their DCX backbone for a customer with an issue similar to yours. Jim Smith On Wed, Feb 4, 2009 at 8:33 AM, Meganen Naidoo wrote: > Hi All, > I need some advise concerning the following: > The current environment has a B18 VTS / ATL at the primary site and a B18 > VTS / ATL at the DR site 30km away. > We now need to move the B18 VTS / ATL to a DR site that is approx 1000km > away. > Will it still be possible to use a peer to peer replication between the 2 > VTS's. I heard that only > synchronous replication can be used by the B18 VTS. What other options > are available. > I do understand that the B18 VTS is out of support, but this will be an > interrim measure before they are > converted to more current technologies. > > Kind Regards, > Meganen Naidoo > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html