Re: A Must read --------
Does having a password for the Bios, stop this malware? *George Rodriguez* *Specialist II - IT Solutions* *IT Enterprise Applications* *PX - 47652* *(561) 357-7652 (office)* *(561) 707-3496 (mobile)* *School District of Palm Beach County* *3348 Forest Hill Blvd.* *Room B-251* *West Palm Beach, FL. 33406-5869* *Florida's Only A-Rated Urban District For Eight Consecutive Years* On Wed, Feb 25, 2015 at 6:42 AM, Chris Hoelscher choelsc...@humana.com wrote: I note they drop a dll on the victims ... lol. So what you are saying is ... never a dll mment? Chris hoelscher Technology Architect | Database Infrastructure Services Technology Solution Services 123 East Main Street |Louisville, KY 40202 choelsc...@humana.com Humana.com (502) 476-2538 – office (502) 714-8615 – blackberry HumanaVitality LEAD STATUS For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- *Disclaimer: *Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Regular Expressions in ISREDIT z/OS 2.01
In 2502068772076383.wa.rashapoogmail@listserv.ua.edu, on 02/24/2015 at 03:32 PM, Govind Chettiar rasha...@gmail.com said: On zOS if I try f r'([0-9]{4})(\w+)' A while back I looked at the new ISPF documentation and and EDIT is missing much of what I have come to rely on in Perl. I looked online for how to search on words (which is what \w does) No. f r'[:alpha:]' If it doesn't even support /d and /w, why would you expect it to support fancy character classes? Is there an open requirement to support full regex capability? -- Shmuel (Seymour J.) Metz, SysProg and JOAT ISO position; see http://patriot.net/~shmuel/resume/brief.html We don't care. We don't have to care, we're Congress. (S877: The Shut up and Eat Your spam act of 2003) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Delete all members from PDS with symbolic in name?
In 132401d04fbc$92d171b0$b8745510$@mcn.org, on 02/23/2015 at 03:00 PM, Charles Mills charl...@mcn.org said: I'm trying to do the following and I know it does not work because IDCAMS says IDC2559I MEMBER CAN NOT BE SPECIFIED WITH A GENERIC NAME You have an asterisk as an index level in the dsname. But is there a way to do something like this, without restricting the job to V2R1 and symbols in SYSIN? I want to delete all members of a PDS where the PDS is named with a JCL symbol: The asterisk is a wildcard, not a reference to a symbol. You're specifying a dsn mask, a member and a file; you should have only the member and the file. Alternatively, you could run under a batch TMP, but that seems like overkill in this case. -- Shmuel (Seymour J.) Metz, SysProg and JOAT ISO position; see http://patriot.net/~shmuel/resume/brief.html We don't care. We don't have to care, we're Congress. (S877: The Shut up and Eat Your spam act of 2003) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Shop zSeries Issue
I'm told Shopz is back up. I opened a problem yesterday. This morning it was working OK. Bob Shannon Rocket Software Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ +1 800.966.3270 ■ +1 781.577.4321 Unsubscribe From Commercial Email – unsubscr...@rocketsoftware.com Manage Your Subscription Preferences - http://info.rocketsoftware.com/GlobalSubscriptionManagementEmailFooter_SubscriptionCenter.html Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
new version of DAF?
All, Just brought my z/OS 1.13 system up to current maintenance. Interestingly, DAF now abends with a 0C4. Tried reassembling it on latest macros, and that fails too. Looks like something changed in macro GFSAUSMF. 11826+* DESERV -- mapped by ICHRUTKN @26A 11827 AGO .NODFSMS1 11828 .NODFSMS1 ANOP 11829 AIF ('ST_DFSMS07' NE 'YES').NODFSMS071 new in DFSMS 1.2 11830 GFSAUSMF SMF RT 42 ST 7 ** ASMA254I *** MNOTE *** 11831+ 4,SMF must be numeric in GFSAUSMF 01-GFSAU 11832+* 11833+* SMF Records PAGE 193 ACTIVE USINGS: NONE D-LOC OBJECT CODEADDR1 ADDR2 STMT SOURCE STATEMENT HLASM R6.0 2015/02/25 10.37 11834+ 11835+* Header for SMF record type 42 should be used from IGWSMF @02C 11836+ 11837+* _ Dave Jousma Assistant Vice President, Mainframe Engineering david.jou...@53.com 1830 East Paris, Grand Rapids, MI 49546 MD RSCB2H p 616.653.8429 f 616.653.2717 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...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
The relationship between DLIB and target zones is 1-many - I am not actually asking for SMP/E advice, but am interested in what you guys find are best practices regarding promotion (we do have to run the apply process once for each environment). Thanks. Aurora Aurora Dell'Anno | External Staff | Information Technology Swiss Reinsurance Company Ltd | SOODRING, 8134 Adliswil, Zurich, Switzerland Direct: +41 (0)43 2853039 E-mail: aurora_della...@rcomext.com http://www.swissre.com Please consider the environment - do you really need to print this email? From: Paul Gilmartin 000433f07816-dmarc-requ...@listserv.ua.edu To: IBM-MAIN@LISTSERV.UA.EDU, Date: 25.02.2015 17:01 Subject:Re: setting up a new, improved SMP/E environment Sent by:IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU On Wed, 25 Feb 2015 15:48:58 +, Staller, Allan wrote: It might be better to document a procedure as follows: 1) Apply changes to MAINT, test. Resolve any issues. Repeat until clean. 2) Migrate MAINT to DEV, and age for x days. Resolve any issues and return to step 1. 3) migrate DEV to PROD. If 3 separate zones target zones are really required, they should be part of the migration process. SMP/E has commands to facilitate migration of the zones. The alternative is to run the apply/accept 3 times (once for each zone). Do any difficulties arise from operating with multiple target zones and a single DLIB zone? I know the practice has been discussed here, but it appears that SMP/E expects a 1-1 correspondence. For example, when you say run the apply/accept 3 times (once for each zone), do you mean, rather, each target/DLIB zone pair? If a single DLIB zone, which of the several target zones does it identify in the ACCEPT? (I know that a single GLOBAL zone can suffice for several target/DLIB zones.) -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN This e-mail, including attachments, is intended for the person(s) or company named and may contain confidential and/or legally privileged information. Unauthorized disclosure, copying or use of this information may be unlawful and is prohibited. If you are not the intended recipient, please delete this message and notify the sender. All incoming and outgoing e-mail messages are stored in the Swiss Re Electronic Message Repository. If you do not wish the retention of potentially private e-mails by Swiss Re, we strongly advise you not to use the Swiss Re e-mail account for any private, non-business related communications. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
Side comment on this discussion about; Remember, auditors can only advise. They cannot compel. On What Planet are you ON? Okay, maybe they do advise, but every time I have worked with Auditors directly or indirectly, my MANAGEMENT has taken their word as LAW :-) So I have had to do some ridiculous things for the Auditors! I really do not have any good suggestions for your problem. My current setup we have all the SMPe data sets under a unique prefix and service is received, applied accepted in these data sets. I run a copy job that copies and renames the data sets to build an IPL volume and it's secondary volume. In my last job we had a full SMPe setup for EACH LPAR (there were about 50 of them) which had 2 sets based on the primary SYSRES volume and some of the data sets would contain that volume serial name. Each time we did service, we ran a copy job that copied, renamed data sets and used SMPe UCLIN statements to make changes to DDDEF's. I unfortunately do not have a copy of that JCL, it was a little complicated. Al Nims Systems Admin/Programmer 3 Information Technology University of Florida (352) 273-1298 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Staller, Allan Sent: Wednesday, February 25, 2015 10:49 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: setting up a new, improved SMP/E environment It might be better to document a procedure as follows: 1) Apply changes to MAINT, test. Resolve any issues. Repeat until clean. 2) Migrate MAINT to DEV, and age for x days. Resolve any issues and return to step 1. 3) migrate DEV to PROD. If 3 separate zones target zones are really required, they should be part of the migration process. SMP/E has commands to facilitate migration of the zones. The alternative is to run the apply/accept 3 times (once for each zone). Remember, auditors can only advise. They cannot compel. HTH, snip We need to improve our SMP/E practice, and I am fishing for ideas - for audit requirements, we need 3 separate target zones for our MAINT, DEV and PROD environments - my idea would be to have 4 targets including a W.I.P. one where I can apply the very latest maintenance before deploying it. Any ideas and suggestions will be gratefully accepted. /snip -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
It might be better to document a procedure as follows: 1) Apply changes to MAINT, test. Resolve any issues. Repeat until clean. 2) Migrate MAINT to DEV, and age for x days. Resolve any issues and return to step 1. 3) migrate DEV to PROD. If 3 separate zones target zones are really required, they should be part of the migration process. SMP/E has commands to facilitate migration of the zones. The alternative is to run the apply/accept 3 times (once for each zone). Remember, auditors can only advise. They cannot compel. HTH, snip We need to improve our SMP/E practice, and I am fishing for ideas - for audit requirements, we need 3 separate target zones for our MAINT, DEV and PROD environments - my idea would be to have 4 targets including a W.I.P. one where I can apply the very latest maintenance before deploying it. Any ideas and suggestions will be gratefully accepted. /snip -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Shop zSeries Issue
I ordered an RSU this morning. Working, but seems unusually slow. On Wed, Feb 25, 2015 at 10:04 AM, Bob Shannon bshan...@rocketsoftware.com wrote: I'm told Shopz is back up. I opened a problem yesterday. This morning it was working OK. Bob Shannon Rocket Software Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ +1 800.966.3270 ■ +1 781.577.4321 Unsubscribe From Commercial Email – unsubscr...@rocketsoftware.com Manage Your Subscription Preferences - http://info.rocketsoftware.com/GlobalSubscriptionManagementEmailFooter_SubscriptionCenter.html Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy This communication and any attachments may contain confidential information of Rocket Software, Inc. All unauthorized use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify Rocket Software immediately and destroy all copies of this communication. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- The postings on this site are my own and don’t necessarily represent Mainline’s positions or opinions Mark D Pace Senior Systems Engineer Mainline Information Systems -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C++ Batch compile with includes in a USS directory
#MEMBER# is set to the name of the source module to be compiled by an external process. All of the source files -- .C and .h -- are in the same folder, but I guess they would not need to be. This is CBCC, but CBCCL should be very similar. Member CCOPTF does not contain any of the SEARCH type parameters. //CC EXEC CBCC, // CPARM='OPTF(DD:SYSOPTF)' //SYSIN DD PATH='/u/userid/Source/#MEMBER#.C' //SYSLIN DD PATH='/u/userid/Object/#MEMBER#.o', // PATHOPTS=(OWRONLY,OCREAT),PATHMODE=SIRWXU //SYSLIB DD PATH='/u/userid/Source' //SYSOPTF DD DISP=SHR,DSN=hlq.CNTL(CCOPTF) Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Donald Likens Sent: Wednesday, February 25, 2015 7:23 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: C++ Batch compile with includes in a USS directory I want to do a batch compile using procedure CBCCL with the #includes that are required to compile the source in /VERSYSB/usr/lpp/IHSA/V8R5/include. I tried pointing the SYSLIB DD to this directory. I also tried the SEARCH option. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
There are operands on the accept command that should allow the many-to-one relationship between target and dlib zones. IIRC, the command is accept nopurge (haven't looked it up recently). The accept would be run 3 times. Twice w/nopurge and once with no operand to clear the global zone. snip Do any difficulties arise from operating with multiple target zones and a single DLIB zone? I know the practice has been discussed here, but it appears that SMP/E expects a 1-1 correspondence. For example, when you say run the apply/accept 3 times (once for each zone), do you mean, rather, each target/DLIB zone pair? If a single DLIB zone, which of the several target zones does it identify in the ACCEPT? (I know that a single GLOBAL zone can suffice for several target/DLIB zones.) /snip -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
setting up a new, improved SMP/E environment
Hi there, We need to improve our SMP/E practice, and I am fishing for ideas - for audit requirements, we need 3 separate target zones for our MAINT, DEV and PROD environments - my idea would be to have 4 targets including a W.I.P. one where I can apply the very latest maintenance before deploying it. Any ideas and suggestions will be gratefully accepted. Thanks. Aurora Aurora Dell'Anno | External Staff | Information Technology Swiss Reinsurance Company Ltd | SOODRING, 8134 Adliswil, Zurich, Switzerland Direct: +41 (0)43 2853039 E-mail: aurora_della...@rcomext.com http://www.swissre.com Please consider the environment - do you really need to print this email? This e-mail, including attachments, is intended for the person(s) or company named and may contain confidential and/or legally privileged information. Unauthorized disclosure, copying or use of this information may be unlawful and is prohibited. If you are not the intended recipient, please delete this message and notify the sender. All incoming and outgoing e-mail messages are stored in the Swiss Re Electronic Message Repository. If you do not wish the retention of potentially private e-mails by Swiss Re, we strongly advise you not to use the Swiss Re e-mail account for any private, non-business related communications. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
On Wed, 25 Feb 2015 15:48:58 +, Staller, Allan wrote: It might be better to document a procedure as follows: 1) Apply changes to MAINT, test. Resolve any issues. Repeat until clean. 2) Migrate MAINT to DEV, and age for x days. Resolve any issues and return to step 1. 3) migrate DEV to PROD. If 3 separate zones target zones are really required, they should be part of the migration process. SMP/E has commands to facilitate migration of the zones. The alternative is to run the apply/accept 3 times (once for each zone). Do any difficulties arise from operating with multiple target zones and a single DLIB zone? I know the practice has been discussed here, but it appears that SMP/E expects a 1-1 correspondence. For example, when you say run the apply/accept 3 times (once for each zone), do you mean, rather, each target/DLIB zone pair? If a single DLIB zone, which of the several target zones does it identify in the ACCEPT? (I know that a single GLOBAL zone can suffice for several target/DLIB zones.) -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Shop zSeries Issue
I'm told Shopz is back up. -- John Eells z/OS Technical Marketing IBM Poughkeepsie ee...@us.ibm.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
C++ Batch compile with includes in a USS directory
I want to do a batch compile using procedure CBCCL with the #includes that are required to compile the source in /VERSYSB/usr/lpp/IHSA/V8R5/include. I tried pointing the SYSLIB DD to this directory. I also tried the SEARCH option. I have been successful with using the UNIX xlc command but this has other complications. Any help is appreciated. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C++ Batch compile with includes in a USS directory
I was going through this same process a while back. At that time I decided that batch compiles with the XL C/C++ compiler just don't work as documented. The best you can do is find something that works and not try and rationalize it with what the doc says. One thing I remember from that exercise is that the compiler reacts differently in the use of the SEARCH and LSEARCH options if you first reset them before setting them to the value you want. I ended up with this in my OPT file to get it to work: NOSEARCH SEARCH(/USR/LPP/CBCLIB/INCLUDE/) NOLSEARCH LSEARCH(/USR/LPP/CBCLIB/INCLUDE/) I'm not sure this was the total solution to my problems but I remember it made things better. Chuck Arney Arney Computer Systems Web: http://zosdebug.com Facebook: http://www.facebook.com/arneycomputer -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Donald Likens Sent: Wednesday, February 25, 2015 9:23 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: C++ Batch compile with includes in a USS directory I want to do a batch compile using procedure CBCCL with the #includes that are required to compile the source in /VERSYSB/usr/lpp/IHSA/V8R5/include. I tried pointing the SYSLIB DD to this directory. I also tried the SEARCH option. I have been successful with using the UNIX xlc command but this has other complications. Any help is appreciated. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: _FEEDBACK tok_isi interpretation
I thank Tony and Lizette. Janet -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
On 2015-02-25, at 09:06, Staller, Allan wrote: There are operands on the accept command that should allow the many-to-one relationship between target and dlib zones. IIRC, the command is accept nopurge (haven't looked it up recently). The accept would be run 3 times. Twice w/nopurge and once with no operand to clear the global zone. So the sequence is: APPLY MAINT ACCEPT NOPURGE APPLY DEV ACCEPT NOPURGE APPLY PROD ACCEPT PURGE Are there no adverse consequences of having the DLIB zone at a higher service level than the PROD target, a transient state between steps? Given the large capacity and low price of modern DASD (and that SMP/E now supports multiple SMPPTS (am I correct?), circumventing the archaic limits on PDE(E) size), how valuable is PURGE? I could envision a problem's appearing only after ACCEPT; RESTORE is not possible (bad design, IMO). If the GLOBAL were entire, one could define a new target/DLIB pair and iteratively bisect the service stream to find the troublesome PTF. Or, install ab ovo and APPLY selectively -- I can do that hourly during development testing (but it's a small product). VMSES/E makes this easier by having no analogue of a DLIB zone. A programmer can peel off onion layers iteratively to get to any desired earlier level. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C++ Batch compile with includes in a USS directory
On Wed, Feb 25, 2015 at 9:46 AM, Chuck Arney ch...@arneycomputer.com wrote: I was going through this same process a while back. At that time I decided that batch compiles with the XL C/C++ compiler just don't work as documented. The best you can do is find something that works and not try and rationalize it with what the doc says. One thing I remember from that exercise is that the compiler reacts differently in the use of the SEARCH and LSEARCH options if you first reset them before setting them to the value you want. I ended up with this in my OPT file to get it to work: NOSEARCH SEARCH(/USR/LPP/CBCLIB/INCLUDE/) NOLSEARCH LSEARCH(/USR/LPP/CBCLIB/INCLUDE/) Chuck's solution is exactly what i use and it works correctly. You can also add regular PDS files here. Also, remember that USS paths need to be entered in upper and lower case to exactly match the path. I'm not sure this was the total solution to my problems but I remember it made things better. Chuck Arney Arney Computer Systems Web: http://zosdebug.com Facebook: http://www.facebook.com/arneycomputer -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Donald Likens Sent: Wednesday, February 25, 2015 9:23 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: C++ Batch compile with includes in a USS directory I want to do a batch compile using procedure CBCCL with the #includes that are required to compile the source in /VERSYSB/usr/lpp/IHSA/V8R5/include. I tried pointing the SYSLIB DD to this directory. I also tried the SEARCH option. I have been successful with using the UNIX xlc command but this has other complications. Any help is appreciated. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: new version of DAF?
On 2/25/2015 10:47 AM, Jousma, David wrote: All, Just brought my z/OS 1.13 system up to current maintenance. Interestingly, DAF now abends with a 0C4. Tried reassembling it on latest macros, and that fails too. Looks like something changed in macro GFSAUSMF. 11826+* DESERV -- mapped by ICHRUTKN @26A 11827 AGO .NODFSMS1 11828 .NODFSMS1 ANOP 11829 AIF ('ST_DFSMS07' NE 'YES').NODFSMS071 new in DFSMS 1.2 11830 GFSAUSMF SMF RT 42 ST 7 ** ASMA254I *** MNOTE *** 11831+ 4,SMF must be numeric in GFSAUSMF 01-GFSAU 11832+* 11833+* SMF Records PAGE 193 ACTIVE USINGS: NONE D-LOC OBJECT CODEADDR1 ADDR2 STMT SOURCE STATEMENT HLASM R6.0 2015/02/25 10.37 11834+ 11835+* Header for SMF record type 42 should be used from IGWSMF @02C 11836+ 11837+* OA41861 added parameters to the macro and SMF isn't one of the allowable ones. As was taught to me over 45 years ago, it's a really good idea to code a ',' in the absence of operands in assembler statements because you never know who's going to change what. If you do so now to the line generating the error GFSAUSMF ,SMF RT 42 ST 7 it looks like it's going to generate the same definitions as it used to. If not, sing out and I'll take a closer look at it. Bob -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: IEASYMxx: How is possible define more than one LPARNAME at same time in SYSDEF?
Hi. Only a last question: Would be possible this combination in SYSDEF sentence? Q.1a) SYSDEF HWNAME(z196-1) LPARNAME(Test-1) SYSNAME(Test-1) (exactly these three parameters on the same line, rest of parameters in other lines) or else, SYSNAME(Test-1) has to be in another line apart? That is: Q.1b) SYSDEF HWNAME(z196-1) LPARNAME(Test-1) SYSNAME(Test-1) Any answer or simillar explication are welcome. I'm wait your answers. Thank you very much. Greetings. P.D: I know that I need practice with the good recommendation to install SYSPARM dialog from SYS1.SAMPLIB(SPPINST), but I don't have enought time (I hope in the next days, I can do it). -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C++ Batch compile with includes in a USS directory
Thanks for your help... I got the following to work: //PROC JCLLIB ORDER=(CBC.SCCNPRC) //CC EXEC CBCC, // CPARM='OPTF(DD:SYSOPTF)' //SYSIN DD PATH='/u/user/source/main.cpp.C' //SYSLIN DD PATH='/u/user/source/main.cpp.o', // PATHOPTS=(OWRONLY,OCREAT),PATHMODE=SIRWXU //SYSLIB DD PATH='/VERSYSB/usr/lpp/IHSA/V8R5/include' //SYSOPTF DD DISP=SHR,DSN=TSSDON.user.CNTL(CCOPTF) CCOPTF: START OFFSET SOURCE XREF LIST SEARCH(//'CEE.SCEEH.+', //'CBC.SCLBH.+', /VERSYSB/usr/lpp/IHSA/V8R5/include) NOLSEARCH -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
Gil, In the scenario you mention below, there would be 3 different DLIB zones, so the PROD DLIB wouldn't be at a higher level than the PROD TARGET zone. If it were me I wouldn't bother with having 3 DLIB zones, I would have a single DLIB and not do any ACCEPTs until after the maintenance was applied across all the target zones. Like you, I don't especially care for not being able to back a PTF out once it has been accepted, but I guess that's part of the downside of trying to remain backwards compatible until the invention of the wheel. :-) Hence my backing up of the entire environment before doing an accept. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Paul Gilmartin Sent: Wednesday, February 25, 2015 11:19 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: setting up a new, improved SMP/E environment On 2015-02-25, at 09:06, Staller, Allan wrote: There are operands on the accept command that should allow the many-to-one relationship between target and dlib zones. IIRC, the command is accept nopurge (haven't looked it up recently). The accept would be run 3 times. Twice w/nopurge and once with no operand to clear the global zone. So the sequence is: APPLY MAINT ACCEPT NOPURGE APPLY DEV ACCEPT NOPURGE APPLY PROD ACCEPT PURGE Are there no adverse consequences of having the DLIB zone at a higher service level than the PROD target, a transient state between steps? Given the large capacity and low price of modern DASD (and that SMP/E now supports multiple SMPPTS (am I correct?), circumventing the archaic limits on PDE(E) size), how valuable is PURGE? I could envision a problem's appearing only after ACCEPT; RESTORE is not possible (bad design, IMO). If the GLOBAL were entire, one could define a new target/DLIB pair and iteratively bisect the service stream to find the troublesome PTF. Or, install ab ovo and APPLY selectively -- I can do that hourly during development testing (but it's a small product). VMSES/E makes this easier by having no analogue of a DLIB zone. A programmer can peel off onion layers iteratively to get to any desired earlier level. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
FWIW Run an ADRDSSU backup of your whole SMP/E environment to a GDG on CART (or to wherever else), run whatever APPLY/ACCEPTs (or vice versa in IMS) and check that. If all OK then NAPWAD. Else restore your earlier SMP/E environment from ADRDSSU backup on GDG and try again (or try something else). But always ADRDSSU backup your SMP/E environment beforehand. CP Pommier, Rex wrote: Gil, In the scenario you mention below, there would be 3 different DLIB zones, so the PROD DLIB wouldn't be at a higher level than the PROD TARGET zone. If it were me I wouldn't bother with having 3 DLIB zones, I would have a single DLIB and not do any ACCEPTs until after the maintenance was applied across all the target zones. Like you, I don't especially care for not being able to back a PTF out once it has been accepted, but I guess that's part of the downside of trying to remain backwards compatible until the invention of the wheel. :-) Hence my backing up of the entire environment before doing an accept. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Paul Gilmartin Sent: Wednesday, February 25, 2015 11:19 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: setting up a new, improved SMP/E environment On 2015-02-25, at 09:06, Staller, Allan wrote: There are operands on the accept command that should allow the many-to-one relationship between target and dlib zones. IIRC, the command is accept nopurge (haven't looked it up recently). The accept would be run 3 times. Twice w/nopurge and once with no operand to clear the global zone. So the sequence is: APPLY MAINT ACCEPT NOPURGE APPLY DEV ACCEPT NOPURGE APPLY PROD ACCEPT PURGE Are there no adverse consequences of having the DLIB zone at a higher service level than the PROD target, a transient state between steps? Given the large capacity and low price of modern DASD (and that SMP/E now supports multiple SMPPTS (am I correct?), circumventing the archaic limits on PDE(E) size), how valuable is PURGE? I could envision a problem's appearing only after ACCEPT; RESTORE is not possible (bad design, IMO). If the GLOBAL were entire, one could define a new target/DLIB pair and iteratively bisect the service stream to find the troublesome PTF. Or, install ab ovo and APPLY selectively -- I can do that hourly during development testing (but it's a small product). VMSES/E makes this easier by having no analogue of a DLIB zone. A programmer can peel off onion layers iteratively to get to any desired earlier level. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
Yup, that's how I do my pre-accept backup. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of CM Poncelet Sent: Wednesday, February 25, 2015 2:33 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: setting up a new, improved SMP/E environment FWIW Run an ADRDSSU backup of your whole SMP/E environment to a GDG on CART (or to wherever else), run whatever APPLY/ACCEPTs (or vice versa in IMS) and check that. If all OK then NAPWAD. Else restore your earlier SMP/E environment from ADRDSSU backup on GDG and try again (or try something else). But always ADRDSSU backup your SMP/E environment beforehand. CP Pommier, Rex wrote: Gil, In the scenario you mention below, there would be 3 different DLIB zones, so the PROD DLIB wouldn't be at a higher level than the PROD TARGET zone. If it were me I wouldn't bother with having 3 DLIB zones, I would have a single DLIB and not do any ACCEPTs until after the maintenance was applied across all the target zones. Like you, I don't especially care for not being able to back a PTF out once it has been accepted, but I guess that's part of the downside of trying to remain backwards compatible until the invention of the wheel. :-) Hence my backing up of the entire environment before doing an accept. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Paul Gilmartin Sent: Wednesday, February 25, 2015 11:19 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: setting up a new, improved SMP/E environment On 2015-02-25, at 09:06, Staller, Allan wrote: There are operands on the accept command that should allow the many-to-one relationship between target and dlib zones. IIRC, the command is accept nopurge (haven't looked it up recently). The accept would be run 3 times. Twice w/nopurge and once with no operand to clear the global zone. So the sequence is: APPLY MAINT ACCEPT NOPURGE APPLY DEV ACCEPT NOPURGE APPLY PROD ACCEPT PURGE Are there no adverse consequences of having the DLIB zone at a higher service level than the PROD target, a transient state between steps? Given the large capacity and low price of modern DASD (and that SMP/E now supports multiple SMPPTS (am I correct?), circumventing the archaic limits on PDE(E) size), how valuable is PURGE? I could envision a problem's appearing only after ACCEPT; RESTORE is not possible (bad design, IMO). If the GLOBAL were entire, one could define a new target/DLIB pair and iteratively bisect the service stream to find the troublesome PTF. Or, install ab ovo and APPLY selectively -- I can do that hourly during development testing (but it's a small product). VMSES/E makes this easier by having no analogue of a DLIB zone. A programmer can peel off onion layers iteratively to get to any desired earlier level. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to
Re: new version of DAF?
Well, that helped, but I think we need Michael to take a look at his code: 0198EA 0700 89802+ CNOP 0,4 01-CALL 0198EC 47F0 B11C198F4 89803+ B *+8 BRANCH AROUND VCON 01-CALL 0198F0 89804+IHB8321B DCV(DAFMB) ENTRY POINT ADDRESS01-CALL 0198F4 4110 AFF800FF8 89809+ LA1,W_WRK LOAD PARAMETER REG 1 03-IHBIN 0198F8 41E0 B57019D48 89810+ LA14,=C'ITE=' PICKUP PARAMETER 02-IHBOP 0198FC 0 89811+ LA15,SMF82ITE PICKUP PARAMETER 02-IHBOP ** ASMA044E UNDEFINED SYMBOL - SMF82ITE ** ASMA435I RECORD 268 IN SYS1.MACLIB(IHBOPLTX) ON VOLUME: RST01A 019900 4100 00044 89812+ LA0,4 PICKUP PARAMETER 02-IHBOP 019904 90E0 10000 89813+ STM 14,0,0(1) STORE INTO PARAM. LIST 02-IHBOP 019908 58F0 B118198F0 89814+ L 15,IHB8321B LOAD 15 WITH ENTRY ADR 01-CALL 01990C 05EF 89815+ BALR 14,15 BRANCH TO ENTRY POINT 01-CALL 89816 CALL DAFMB, Move Binary Comment X (=C'IML=',SMF82IML,4), Maximum data length X _ Dave Jousma Assistant Vice President, Mainframe Engineering david.jou...@53.com 1830 East Paris, Grand Rapids, MI 49546 MD RSCB2H p 616.653.8429 f 616.653.2717 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Bob Rutledge Sent: Wednesday, February 25, 2015 3:16 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: new version of DAF? On 2/25/2015 10:47 AM, Jousma, David wrote: All, Just brought my z/OS 1.13 system up to current maintenance. Interestingly, DAF now abends with a 0C4. Tried reassembling it on latest macros, and that fails too. Looks like something changed in macro GFSAUSMF. 11826+* DESERV -- mapped by ICHRUTKN @26A 11827 AGO .NODFSMS1 11828 .NODFSMS1 ANOP 11829 AIF ('ST_DFSMS07' NE 'YES').NODFSMS071 new in DFSMS 1.2 11830 GFSAUSMF SMF RT 42 ST 7 ** ASMA254I *** MNOTE *** 11831+ 4,SMF must be numeric in GFSAUSMF 01-GFSAU 11832+* 11833+* SMF Records PAGE 193 ACTIVE USINGS: NONE D-LOC OBJECT CODEADDR1 ADDR2 STMT SOURCE STATEMENT HLASM R6.0 2015/02/25 10.37 11834+ 11835+* Header for SMF record type 42 should be used from IGWSMF @02C 11836+ 11837+* OA41861 added parameters to the macro and SMF isn't one of the allowable ones. As was taught to me over 45 years ago, it's a really good idea to code a ',' in the absence of operands in assembler statements because you never know who's going to change what. If you do so now to the line generating the error GFSAUSMF ,SMF RT 42 ST 7 it looks like it's going to generate the same definitions as it used to. If not, sing out and I'll take a closer look at it. Bob -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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
Re: setting up a new, improved SMP/E environment
I support a single global and multiple maintenance targets / dlib zones for several companies. I have my zone options set to NOPURGE so I never purge during accept. After ACCEPT is done for all the environments, I simply run an SMP/E REJECT in purge mode: SETBOUNDARY (GLOBAL). REJECT PURGE (AAAD101,BBBD101,CCCD101). -- Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS ITIL v3 Foundation Certified mailto:m...@mzelden.com Mark's MVS Utilities: http://www.mzelden.com/mvsutil.html Systems Programming expert at http://search390.techtarget.com/ateExperts/ On Wed, 25 Feb 2015 20:53:22 +, Pommier, Rex rpomm...@sfgmembers.com wrote: Yup, that's how I do my pre-accept backup. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of CM Poncelet Sent: Wednesday, February 25, 2015 2:33 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: setting up a new, improved SMP/E environment FWIW Run an ADRDSSU backup of your whole SMP/E environment to a GDG on CART (or to wherever else), run whatever APPLY/ACCEPTs (or vice versa in IMS) and check that. If all OK then NAPWAD. Else restore your earlier SMP/E environment from ADRDSSU backup on GDG and try again (or try something else). But always ADRDSSU backup your SMP/E environment beforehand. CP Pommier, Rex wrote: Gil, In the scenario you mention below, there would be 3 different DLIB zones, so the PROD DLIB wouldn't be at a higher level than the PROD TARGET zone. If it were me I wouldn't bother with having 3 DLIB zones, I would have a single DLIB and not do any ACCEPTs until after the maintenance was applied across all the target zones. Like you, I don't especially care for not being able to back a PTF out once it has been accepted, but I guess that's part of the downside of trying to remain backwards compatible until the invention of the wheel. :-) Hence my backing up of the entire environment before doing an accept. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Paul Gilmartin Sent: Wednesday, February 25, 2015 11:19 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: setting up a new, improved SMP/E environment On 2015-02-25, at 09:06, Staller, Allan wrote: There are operands on the accept command that should allow the many-to-one relationship between target and dlib zones. IIRC, the command is accept nopurge (haven't looked it up recently). The accept would be run 3 times. Twice w/nopurge and once with no operand to clear the global zone. So the sequence is: APPLY MAINT ACCEPT NOPURGE APPLY DEV ACCEPT NOPURGE APPLY PROD ACCEPT PURGE Are there no adverse consequences of having the DLIB zone at a higher service level than the PROD target, a transient state between steps? Given the large capacity and low price of modern DASD (and that SMP/E now supports multiple SMPPTS (am I correct?), circumventing the archaic limits on PDE(E) size), how valuable is PURGE? I could envision a problem's appearing only after ACCEPT; RESTORE is not possible (bad design, IMO). If the GLOBAL were entire, one could define a new target/DLIB pair and iteratively bisect the service stream to find the troublesome PTF. Or, install ab ovo and APPLY selectively -- I can do that hourly during development testing (but it's a small product). VMSES/E makes this easier by having no analogue of a DLIB zone. A programmer can peel off onion layers iteratively to get to any desired earlier level. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information contained in this message is confidential,
Re: IEASYMxx: How is possible define more than one LPARNAME at same time in SYSDEF?
I haven't played with the syntax of SYSDEF for ages, but here's what I use: SYSDEF HWNAME(BIG-SKIP) LPARNAME(MY-TOY) SYSNAME(SKIPEROO) Indentation is paramount. Start SYSDEF in column 1, 'subordinate' statements in column 2+. The above reads If the box is called BIG-SKIP and the LPAR is called MY-TOY, then set SYSNAME for this LPAR on this box to SKIPEROO Here SYSNAME is hard coded, but it could also be a string of previously defined symbols if you wanted to show off your mettle. ;-) . . . J.O.Skip Robinson Southern California Edison Company Electric Dragon Team Paddler SHARE MVS Program Co-Manager 626-302-7535 Office 323-715-0595 Mobile jo.skip.robin...@sce.com -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Anonymous Sent: Wednesday, February 25, 2015 11:25 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: IEASYMxx: How is possible define more than one LPARNAME at same time in SYSDEF? Hi. Only a last question: Would be possible this combination in SYSDEF sentence? Q.1a) SYSDEF HWNAME(z196-1) LPARNAME(Test-1) SYSNAME(Test-1) (exactly these three parameters on the same line, rest of parameters in other lines) or else, SYSNAME(Test-1) has to be in another line apart? That is: Q.1b) SYSDEF HWNAME(z196-1) LPARNAME(Test-1) SYSNAME(Test-1) Any answer or simillar explication are welcome. I'm wait your answers. Thank you very much. Greetings. P.D: I know that I need practice with the good recommendation to install SYSPARM dialog from SYS1.SAMPLIB(SPPINST), but I don't have enought time (I hope in the next days, I can do it). -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Regular Expressions in ISREDIT z/OS 2.01
On Tue, 24 Feb 2015 23:07:53 -0500, Shmuel Metz (Seymour J.) wrote: Is there an open requirement to support full regex capability? What's full? IBM doesn't seem interested in going much beyond POSIX requirements; sometimes not even that far. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: C++ Batch compile with includes in a USS directory
On Wed, 25 Feb 2015 09:22:59 -0600, Donald Likens wrote: I want to do a batch compile using procedure CBCCL with the #includes that are required to compile the source in /VERSYSB/usr/lpp/IHSA/V8R5/include. I tried pointing the SYSLIB DD to this directory. I also tried the SEARCH option. I have been successful with using the UNIX xlc command but this has other complications. Would BPXBATCH meet your need for batch? (What other complications?) -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload DB2 table in CSV format
On Wed, 25 Feb 2015 17:42:16 -0600, Tony's Outlook via Mozilla wrote: I'd certainly prefer zOS/batch/DFSORT. Unload the table to FB disk, use DF/SORT to insert x'05'(tab) or comma(CSV) where desired. I do this quite often to create a flat file that will eventually go back to MS excel/access. Millions of records? No big deal. And suppose your data contain commas in some column, in some rows but not all? E.g. Babonas, T. Well, the designers should have split those fields into separate columns, but sometimes they don't. Choose a different separator? If you don't know a priori which character meets that requirement you must do a preliminary scan to find one. And if you find none you must establish a convention for escaping metacharacters. I suppose DFSORT can do all this. (Hmmm... Has anyone proven that DFSORT is Turing-complete? Or that it isn't?) Faced routinely with such a problem given a .xlsx file, I open it with LibreOffice and export as HTML, which guarantees that its delimiter tokens don't appear among the output data. Bernd probably has an effective solution. LibreOffice doesn't batch at all well. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload DB2 table in CSV format
And it can be run in batch. Either off platform on z/OS. Rob Schramm Senior Systems Consultant On Wed, Feb 25, 2015 at 5:46 PM, Rob Schramm rob.schr...@gmail.com wrote: If it is something smaller (not millions of rows), connect via JDBC and use SQL Workbench/j. It has plenty of options to pull the data into a CSV. Rob Schramm Senior Systems Consultant On Tue, Feb 24, 2015 at 10:50 AM, Lizette Koehler stars...@mindspring.com wrote: Try adding more volumes. The DB2 List thinks you need to double what you are using with the JCL you posted. Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ron Thomas Sent: Monday, February 23, 2015 7:44 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Unload DB2 table in CSV format Ok Thanks . I am getting the below message when i provided the DCB Parameters FMNBA324 A data set, or volume full condition occurred while attempting to save this data set Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload DB2 table in CSV format
If it is something smaller (not millions of rows), connect via JDBC and use SQL Workbench/j. It has plenty of options to pull the data into a CSV. Rob Schramm Senior Systems Consultant On Tue, Feb 24, 2015 at 10:50 AM, Lizette Koehler stars...@mindspring.com wrote: Try adding more volumes. The DB2 List thinks you need to double what you are using with the JCL you posted. Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ron Thomas Sent: Monday, February 23, 2015 7:44 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Unload DB2 table in CSV format Ok Thanks . I am getting the below message when i provided the DCB Parameters FMNBA324 A data set, or volume full condition occurred while attempting to save this data set Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload DB2 table in CSV format
I'd certainly prefer zOS/batch/DFSORT. Unload the table to FB disk, use DF/SORT to insert x'05'(tab) or comma(CSV) where desired. I do this quite often to create a flat file that will eventually go back to MS excel/access. Millions of records? No big deal. On 2/25/2015 4:47 PM, Rob Schramm wrote: And it can be run in batch. Either off platform on z/OS. Rob Schramm Senior Systems Consultant On Wed, Feb 25, 2015 at 5:46 PM, Rob Schramm rob.schr...@gmail.com wrote: If it is something smaller (not millions of rows), connect via JDBC and use SQL Workbench/j. It has plenty of options to pull the data into a CSV. Rob Schramm Senior Systems Consultant On Tue, Feb 24, 2015 at 10:50 AM, Lizette Koehler stars...@mindspring.com wrote: Try adding more volumes. The DB2 List thinks you need to double what you are using with the JCL you posted. Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ron Thomas Sent: Monday, February 23, 2015 7:44 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Unload DB2 table in CSV format Ok Thanks . I am getting the below message when i provided the DCB Parameters FMNBA324 A data set, or volume full condition occurred while attempting to save this data set Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload DB2 table in CSV format
I posted it on the DB2 list some days ago, and if you don't mind, I post it here, too, because it's the same topic. ad I am selling a product running with DB2 and Oracle DBs, that generates CSV files from SQL results. It runs on almost every platform (mainframe, Unix, Windows). CSV is one of many output formats; others are flat files, XML, and other proprietary formats, which contain not only data, but meta data (like datatypes), too. It is possible to work the other way, too, that is, load DB2 data from CSV files (and the other formats, too, of course). You can trigger insert statements from the data in the CSV files, or updates, or deletes ... any kind of SQL statement that modifies the DB. (You specify the SQL, together with a file description, is necessary, that is: if the file does not already contain the needed meta data). In combination, it is very easy to do database migrations and database schema changes using this tool. I've done this many times for different customers. Please feel free to contact me offline, if you are interested. /ad The mainframe variant of this product is z/OS batch, and it runs very fast. No need to inserts tabs or commas in a second step ... Thank you Bernd Oppolzer Am 26.02.2015 um 00:42 schrieb Tony's Outlook via Mozilla: I'd certainly prefer zOS/batch/DFSORT. Unload the table to FB disk, use DF/SORT to insert x'05'(tab) or comma(CSV) where desired. I do this quite often to create a flat file that will eventually go back to MS excel/access. Millions of records? No big deal. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
Al, Many years ago I had an auditor question me on everything. I ran an SMPE job that produced many many hits in audit. I decided the best way to show him exactly what I was doing was to take the listing (in my case 6 boxes of paper) and explain everything that was going on and why I got hit with an audit. After 3 hours he called you need to have this without question I didn't mind it too much but I got him off of my back for good. Ed On Feb 25, 2015, at 10:06 AM, Nims,Alva John (Al) wrote: Side comment on this discussion about; Remember, auditors can only advise. They cannot compel. On What Planet are you ON? Okay, maybe they do advise, but every time I have worked with Auditors directly or indirectly, my MANAGEMENT has taken their word as LAW :-) So I have had to do some ridiculous things for the Auditors! I really do not have any good suggestions for your problem. My current setup we have all the SMPe data sets under a unique prefix and service is received, applied accepted in these data sets. I run a copy job that copies and renames the data sets to build an IPL volume and it's secondary volume. In my last job we had a full SMPe setup for EACH LPAR (there were about 50 of them) which had 2 sets based on the primary SYSRES volume and some of the data sets would contain that volume serial name. Each time we did service, we ran a copy job that copied, renamed data sets and used SMPe UCLIN statements to make changes to DDDEF's. I unfortunately do not have a copy of that JCL, it was a little complicated. Al Nims Systems Admin/Programmer 3 Information Technology University of Florida (352) 273-1298 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM- m...@listserv.ua.edu] On Behalf Of Staller, Allan Sent: Wednesday, February 25, 2015 10:49 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: setting up a new, improved SMP/E environment It might be better to document a procedure as follows: 1) Apply changes to MAINT, test. Resolve any issues. Repeat until clean. 2) Migrate MAINT to DEV, and age for x days. Resolve any issues and return to step 1. 3) migrate DEV to PROD. If 3 separate zones target zones are really required, they should be part of the migration process. SMP/E has commands to facilitate migration of the zones. The alternative is to run the apply/accept 3 times (once for each zone). Remember, auditors can only advise. They cannot compel. HTH, snip We need to improve our SMP/E practice, and I am fishing for ideas - for audit requirements, we need 3 separate target zones for our MAINT, DEV and PROD environments - my idea would be to have 4 targets including a W.I.P. one where I can apply the very latest maintenance before deploying it. Any ideas and suggestions will be gratefully accepted. /snip -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
On Wed, 25 Feb 2015 18:54:18 +, Pommier, Rex wrote: Like you, I don't especially care for not being able to back a PTF out once it has been accepted, ... That part would be OK if there weren't the additional requirement of ACCEPTing predecessors before RESTORE. The combination is lethal. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload DB2 table in CSV format
With my tool, you can choose the delimiter by parameter (some like semicolon instead of comma, because in some European countries the comma is used instead of decimal point to separate the decimal fraction - tab is possible too, of course), and char fields are enclosed into quotes (or apostrophes), if necessary. ExCel etc. deal with all this, it's tested. Furthermore, you can choose if you want column headings or not. If you have column headings (derived from the SQL result), you can later use those headings to reference your columns, if you use the CSV to do updates on the DB again. If not, you have to specify the numeric position of the column ... in any case, you have to tell the tool the data type in this case, because it does no pre scan of the file, as ExCel does. But this is for the load situation only; for unload, it's as easy as unlddn csvhead := unload qualif.db2table; or unlddn csv := select * from qualif.db2table where ...; Kind regards Bernd Am 26.02.2015 um 04:11 schrieb Paul Gilmartin: On Wed, 25 Feb 2015 17:42:16 -0600, Tony's Outlook via Mozilla wrote: I'd certainly prefer zOS/batch/DFSORT. Unload the table to FB disk, use DF/SORT to insert x'05'(tab) or comma(CSV) where desired. I do this quite often to create a flat file that will eventually go back to MS excel/access. Millions of records? No big deal. And suppose your data contain commas in some column, in some rows but not all? E.g. Babonas, T. Well, the designers should have split those fields into separate columns, but sometimes they don't. Choose a different separator? If you don't know a priori which character meets that requirement you must do a preliminary scan to find one. And if you find none you must establish a convention for escaping metacharacters. I suppose DFSORT can do all this. (Hmmm... Has anyone proven that DFSORT is Turing-complete? Or that it isn't?) Faced routinely with such a problem given a .xlsx file, I open it with LibreOffice and export as HTML, which guarantees that its delimiter tokens don't appear among the output data. Bernd probably has an effective solution. LibreOffice doesn't batch at all well. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: setting up a new, improved SMP/E environment
Nims,Alva John (Al) wrote: Side comment on this discussion about; Remember, auditors can only advise. They cannot compel. On What Planet are you ON? Okay, maybe they do advise, but every time I have worked with Auditors directly or indirectly, my MANAGEMENT has taken their word as LAW :-) So I have had to do some ridiculous things for the Auditors! I think that was Ted MacNeil who always said that (more or less this) : 'Auditors recommend. Management Enforce!' But, when I try to have my users comply to do something, I said this According to Management and Auditors requirements, you need to do xyz... Generally, I get what I want... Sorry, Ted, that I refer to you, but you get the credits. ;-) Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
(was) A new version of DAF? No, the Millionth!
How about the millionth DAF? Yesterday the millionth DAF truck rolled off the assembly line: http://www.nltimes.nl/2015/02/25/prime-minister-rutte-unveils-millionth-daf-truck/ Kees. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Jousma, David Sent: 25 February, 2015 16:48 To: IBM-MAIN@LISTSERV.UA.EDU Subject: new version of DAF? All, Just brought my z/OS 1.13 system up to current maintenance. Interestingly, DAF now abends with a 0C4. Tried reassembling it on latest macros, and that fails too. Looks like something changed in macro GFSAUSMF. 11826+* DESERV -- mapped by ICHRUTKN @26A 11827 AGO .NODFSMS1 11828 .NODFSMS1 ANOP 11829 AIF ('ST_DFSMS07' NE 'YES').NODFSMS071 new in DFSMS 1.2 11830 GFSAUSMF SMF RT 42 ST 7 ** ASMA254I *** MNOTE *** 11831+ 4,SMF must be numeric in GFSAUSMF 01-GFSAU 11832+* 11833+* SMF Records PAGE 193 ACTIVE USINGS: NONE D-LOC OBJECT CODEADDR1 ADDR2 STMT SOURCE STATEMENT HLASM R6.0 2015/02/25 10.37 11834+ 11835+* Header for SMF record type 42 should be used from IGWSMF @02C 11836+ 11837+* _ Dave Jousma Assistant Vice President, Mainframe Engineering david.jou...@53.com 1830 East Paris, Grand Rapids, MI 49546 MD RSCB2H p 616.653.8429 f 616.653.2717 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...@listserv.ua.edu with the message: INFO IBM-MAIN For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: _FEEDBACK tok_isi interpretation
Janet Graff wrote: Thanks! I will look into that. To what? Or to who do you say thank you? Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: _FEEDBACK tok_isi interpretation
My apologies. I'm not trying to solve the U121. I generated that on purpose. I'm working on writing a robust abend handler. It's reporting S0C4 abends nicely but this User abend is coming out as a CEE3250C. Janet -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: _FEEDBACK tok_isi interpretation
Thanks! I will look into that. Janet -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: A Must read --------
I note they drop a dll on the victims ... lol. So what you are saying is ... never a dll mment? Chris hoelscher Technology Architect | Database Infrastructure Services Technology Solution Services 123 East Main Street |Louisville, KY 40202 choelsc...@humana.com Humana.com (502) 476-2538 – office (502) 714-8615 – blackberry HumanaVitality LEAD STATUS For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN