Re: DB2 Forum
The db2-l listserv software/server was retired a number of years ago. In its place the new home for the forum is at IDUG.ORG. one will need to register but afterwards you can opt in for the mail reflector. While not exactly the same, the benefits/resources are. If you have any questions feel free in contacting my off list. For transparency sake, i am one of the administrators of the DB2-l forum. On 2015-03-09 4:46 PM, Ed Finnell wrote: Guess it's peer to peer; i.e. Lsoft to Lsoft. quote from UA listserv The DB2-L list is unknown to lists...@listserv.ua.edu. Your request is being forwarded to the nearest backbone server, _LISTSERV@SWGATE.LSOFT.COM_ (mailto:lists...@swgate.lsoft.com) . which gets forwarded to: quote from LSOFT: Your request is being forwarded to _LISTSERV@LISTSERV.AMERICAN.EDU_ (mailto:lists...@listserv.american.edu) which gets queued: quote from American: Your request to join the DB2-L list has been forwarded to the list owner for approval. If you have any question about the list, then you can reach the list owner at _DB2-L-request@LISTSERV.AMERICAN.EDU_ (mailto:db2-l-requ...@listserv.american.edu) . Right string baby, but wrong yo yo In a message dated 3/9/2015 7:42:43 A.M. Central Daylight Time, shmuel+ibm-m...@patriot.net writes: Unless things have changed, the listservs are interconnected; each listserv will have a table of where to forward subscription requests. -- 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: DB2 Forum
You are right. We do not use listserv but another facility. On 2015-03-09 12:38 PM, Charles Mills wrote: Generally Yes (RACF, VM, OE) but in this case I think No. It is not actually LISTSERV (TM) but some other forum-type software. I think. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Shmuel Metz (Seymour J.) Sent: Monday, March 09, 2015 5:43 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DB2 Forum In 008701d059fe$6c39b1b0$44ad1510$@mcn.org, on 03/08/2015 at 05:17 PM, Charles Mills charl...@mcn.org said: As I recall you have to sign up at the IDUG Web site (www.idug.org). Unless things have changed, the listservs are interconnected; each listserv will have a table of where to forward subscription requests. -- 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: DB2 with Easytrieve R11.6
best answered on the IDUG.ORG db2-l listserv On 2014-11-13, 3:53 PM, David Platt wrote: Is anyone accessing DB2 with Easytrieve R11.6 and if so are you doing any updating? -- 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 data
And I have another suggestion. There is a mail reflector/listserv for DB2 (if that is the data store here) with many experts and those whop have done similar functions like what you are asking about. I suggest they you go over to idug.org (international db2 user group) and ask the question there. though the more information you provide the faster the response you will get. here or there On 2014-08-05, 2:18 AM, Elardus Engelbrecht wrote: Ron Thomas wrote: We have a huge table with around 125 million records and we are unloading this file in a job based on the current date, there are some instances where this job gets delayed and runs past 12.00 AM and the records fetched is not correct. Could some one please let me know in the unload whether we can pass some parms as we have a cycle file which has the current date stored and by this way we need not worry whether the job is delayed or not. and We are using DB-2 unload utility as the table size is 125 million, the Unload data is fed to the downstream programs for further processing. You did not answered all of Lizette's questions. My one question is: What is 'unload'? Is it a dump, copy (re-formatted contents or not) , SQL query, etc? Also you asked about 'parms', but you did not said what parms you tried out or against what program you're trying to use parms. I have other questions: What version of DB2 do you have? Is this an once off problem or not? For how long is it that you have that huge table? With what are you 'fetching' the records and storing it somewhere else? Some possible suggestions: Do your work hourly or give your job higher priority or split up your table in smaller chunks. Best solution was given by Ed Gould! 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Fileaid Error
you will need to put comma at the end of every out (except the last) On 2014-04-15, 20:20, Ron Thomas wrote: Hello. I am running File aid job and getting the errored out, could someone please let me know what is the issue in the card? //STEP03 EXEC PGM=FILEAID //DD01 DD DSN=P01.MPLTD.D0415.NEW,DISP=SHR //SYSLIST DD DSN=RKKUDE.S1ANCOPY.LIBR,DISP=(,CATLG,CATLG), //RECFM=FB,LRECL=132, //SPACE=(CYL,(50,20),RLSE) //**amp; ADD $$DD CARDS //SYSINDD * $$DD01 LIST IF=(1,0,C'BAIS_LIMIT'), ORIF=(1,0,C'CALC_ETHOD_CODE'), ORIF=(1,0,C'COMENT_TEXT'),OUT=0 ORIF=(1,0,C'C1MENT_TEXT'),OUT=0 ORIF=(1,0,C'C2MMENT_TEXT'),OUT=0 ORIF=(1,0,C'C3MMENT_TEXT'),OUT=0 /* Here I am getting the below error. $$DD01 LIST IF=(1,0,C'BASIS_LIMIT'), ORIF=(1,0,C'CALC_METHOD_CODE'), ORIF=(1,0,C'COMMENT_TEXT'),OUT=0 ABOVE FUNCTION ENDED ON DIRECTORY ENDRC=0 MEMBERS-READ=23,SELECTED=23,RECORDS-READ=25449 ORIF=(1,0,C'C1MMENT_TEXT'),OUT=0 CONTROL CARD DOES NOT BEGIN WITH $$DD .SKIPPING TO NEXT $$DD CARD RC=4 Thanks Rajeev V -- 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: DB2 v9-v10 problem
This would be better asked on the IDUG.ORG forum On Thursday, October 24, 2013, R.S. r.skoru...@bremultibank.com.pl wrote: Environment z/OS 1.11, DB2 v9.1, CICS TS 4.1 is being migrated to z/OS 1.13, DB2 v10.1, CICS TS 4.2 (DB2 in Compatibility Mode) One CICS transaction expected strange behavior: much more CPU used for open cursor operation. Acces path wasn't changed. It seems DB2 lost ability to read index in both ways (during MI/MX access) and read and sort more data than it should. Any clue? Anyone experienced similar problem? -- Radoslaw Skorupka Lodz, Poland -- Treść tej wiadomości może zawierać informacje prawnie chronione Banku przeznaczone wyłącznie do użytku służbowego adresata. Odbiorcą może być jedynie jej adresat z wyłączeniem dostępu osób trzecich. Jeżeli nie jesteś adresatem niniejszej wiadomości lub pracownikiem upoważnionym do jej przekazania adresatowi, informujemy, że jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne działanie o podobnym charakterze jest prawnie zabronione i może być karalne. Jeżeli otrzymałeś tę wiadomość omyłkowo, prosimy niezwłocznie zawiadomić nadawcę wysyłając odpowiedź oraz trwale usunąć tę wiadomość włączając w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorised to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. BRE Bank SA, 00-950 Warszawa, ul. Senatorska 18, tel. +48 (22) 829 00 00, fax +48 (22) 829 00 33, www.brebank.pl, e-mail: i...@brebank.pl Sąd Rejonowy dla m. st. Warszawy XII Wydział Gospodarczy Krajowego Rejestru Sądowego, nr rejestru przedsiębiorców KRS 025237, NIP: 526-021-50-88. Według stanu na dzień 01.01.2013 r. kapitał zakładowy BRE Banku SA (w całości wpłacony) wynosi 168.555.904 złotych. -- 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
blog security by design
Rarely I post a note here about my blog. While it is not only an IBM issue (mainframe or not) I thought this maybe of interest to the list. In a world where we all have to deal with various aspects of the online world. We are, both personally and professionally, concerned about security and new technology. Robert's Law of security and technology progress. I did this for a couple of reasons. 1) We, as professionals, at times do not see the forest because of the trees (me included). And I thought I could start an discussion concerning this. 2) A little self promotion, as the euphemism goes, I am looking for new opportunities (got laid off). Please feel free in forwarding this to anyone you may want to, http://robertdataprivacytesting.blogspot.ca/2013/10/security-by-design.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: EBCDIC and the P-Bit
Actually I would say its that the Operating system has been in 'development'/available for more then 50 years. more time to get it right. Then is the aspect that in the earlier years there was less of a push for getting out the door, because there was not the same level of competition. The aspect of the Character set (codepage) would have little effect. If there was money to be had, Hackers would try to get at it. On 2013-06-21 10:00 AM, Roland Kinsman wrote: So, this is going to sound extremely naïve, but I wonder if having EBCDIC instead of ASCII helped make IBM mainframe OS less penetrable to hackers. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Robert Galambos CIPP/C, CIPP/IT, IBM DB2 DBA for z/OS Email: rgalam...@gmail.com Blog:http://robertdataprivacytesting.blogspot.ca/ LinkedIn:http://ca.linkedin.com/in/robertgalambos/ Objective: Senior Pre-Sales Technical Professional Consultant delivers Client Satisfaction with Technical Expertise Dynamic Energy Skills: Implemented Data Privacy strategies and processes, product positioning to achieve territory sales and increase market share within managed care markets. Sr. Pre-Sales Consultant with more than $2 MM sales yearly. Serviced, retained, and expanded major accounts Dedicated, Self-Starter, Dependable, 'Go to' person On Fri, Jun 21, 2013 at 9:57 AM, Roland Kinsman rjkins...@hotmail.comwrote: From: Mike Schwab mike.a.sch...@gmail.com Date: Thu, 20 Jun 2013 12:34:59 -0500 Posted link on http://en.wikipedia.org/wiki/EBCDIC#External_links Thanks, Mike. I did see the EBCDIC article, but I did not notice the link near the bottom. But I think this merits a separate article, and I might just post it. After all, I can copy/paste with the best of them! -- 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