Re: Unload data
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
Anothe DFSORT question (EXPMAX)
Documentation says: EXPMAX Specifies the maximum total amount of available storage to be used at any one time by all Hipersorting, memory object sorting, and dataspace sorting applications. Is it the limit for all concurrently running DFsort jobs/tasks or it is per job limitation? -- 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 authorized 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. mBank S.A. z siedzibą w Warszawie, ul. Senatorska 18, 00-950 Warszawa, www.mBank.pl, e-mail: kont...@mbank.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.2014 r. kapitał zakładowy mBanku S.A. (w całości wpłacony) wynosi 168.696.052 złote. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Anothe DFSORT question (EXPMAX)
Radoslaw Skorupka wrote: EXPMAX Specifies the maximum total amount of available storage to be used at any one time by all Hipersorting, memory object sorting, and dataspace sorting applications. Is it the limit for all concurrently running DFsort jobs/tasks or it is per job limitation? Hmmm, interesting question, but see this note (DFSORT Application Programming Guide): quote - Note all quoted text has Vertical Bar as from z/OS v1.12: DFSORT only uses memory object or Hiperspace storage when there is sufficient central storage available to back all the DFSORT work data. DFSORT's use of memory object and Hiperspace storage is very dynamic: multiple concurrent sort applications always know each other's storage needs and never try to back their memory objects or Hiperspaces with the same portion of storage. In addition, DFSORT checks the available storage throughout the run, and switches from using memory objects or Hiperspaces to using disk work data sets when either a storage shortage is predicted or the total Hipersorting, memory object sorting, and dataspace sorting activity on the system reaches the limits set by the EXPMAX, EXPOLD, and EXPRES installation options. end quote So, it seemed that whatever the limit is, DFSORT will check it anyways and all jobs are checking each other's usage. If one job is hogging storage, others will have to wait, reduce their demand or use other storage methods. Is the question related to a problem you're having? 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: Anothe DFSORT question (EXPMAX)
W dniu 2014-08-05 11:23, Elardus Engelbrecht pisze: Radoslaw Skorupka wrote: EXPMAX Specifies the maximum total amount of available storage to be used at any one time by all Hipersorting, memory object sorting, and dataspace sorting applications. Is it the limit for all concurrently running DFsort jobs/tasks or it is per job limitation? Hmmm, interesting question, but see this note (DFSORT Application Programming Guide): [snip] So, it seemed that whatever the limit is, DFSORT will check it anyways and all jobs are checking each other's usage. If one job is hogging storage, others will have to wait, reduce their demand or use other storage methods. Is the question related to a problem you're having? Yes. I observed excessive paging (and OLTP problems) when some DB2 REORG job runs. REORG does use DFsort under the cover. I limited the job using MEMLIMIT (and REGION) in a jobcard, but DFsort was smarter: instead of 64-bit Memory Objcects it used Hiperspaces. The result was as before: excessive paging. We talk aout tens of gigabytes used by single job. Regards -- 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 authorized 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. mBank S.A. z siedzibą w Warszawie, ul. Senatorska 18, 00-950 Warszawa, www.mBank.pl, e-mail: kont...@mbank.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.2014 r. kapitał zakładowy mBanku S.A. (w całości wpłacony) wynosi 168.696.052 złote. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Anothe DFSORT question (EXPMAX)
I'm hoping my colleague Dave Betten will chime in on this at some point. Particularly as z/OS 2.1 DFSORT has some enhancements in this area. CONCURRENCY is always the challenge here. And equally I would reinforce MEMLIMIT with a decent IEFUSI exit (which I would hope included limiting hiperspace). I've seen this scenario a number of times, often represented by the RMF interval-level Minimum Available Frames being near zero while the interval-level Average Available Frames is usually (but not always) somewhat higher. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: R.S. r.skoru...@bremultibank.com.pl To: IBM-MAIN@listserv.ua.edu Date: 05/08/2014 11:28 Subject:Re: Anothe DFSORT question (EXPMAX) Sent by:IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu W dniu 2014-08-05 11:23, Elardus Engelbrecht pisze: Radoslaw Skorupka wrote: EXPMAX Specifies the maximum total amount of available storage to be used at any one time by all Hipersorting, memory object sorting, and dataspace sorting applications. Is it the limit for all concurrently running DFsort jobs/tasks or it is per job limitation? Hmmm, interesting question, but see this note (DFSORT Application Programming Guide): [snip] So, it seemed that whatever the limit is, DFSORT will check it anyways and all jobs are checking each other's usage. If one job is hogging storage, others will have to wait, reduce their demand or use other storage methods. Is the question related to a problem you're having? Yes. I observed excessive paging (and OLTP problems) when some DB2 REORG job runs. REORG does use DFsort under the cover. I limited the job using MEMLIMIT (and REGION) in a jobcard, but DFsort was smarter: instead of 64-bit Memory Objcects it used Hiperspaces. The result was as before: excessive paging. We talk aout tens of gigabytes used by single job. Regards -- 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 authorized 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. mBank S.A. z siedzibą w Warszawie, ul. Senatorska 18, 00-950 Warszawa, www.mBank.pl, e-mail: kont...@mbank.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.2014 r. kapitał zakładowy mBanku S.A. (w całości wpłacony) wynosi 168.696.052 złote. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Anothe DFSORT question (EXPMAX)
EXPMAX limit applies to total storage used by concurrent sorts. Usually when excessive paging happens it's in environments like DB2 where there's a high number of old frames in central storage that have not been recently referenced. DFSORT includes those frames in its calculations of storage available for memory object, Hiperspace or Dataspace sorting. The way to limit that is with the EXPOLD installation default. Usually I recommend EXPMAX be left at its shipped default of MAX but change EXPOLD from its shipped default of MAX to EXPOLD=0. This causes DFSORT to only consider available frames in its calculations and minimizes the risk causing pages to be stolen from other workloads like DB2. Usually customer is having a severe aux stor problem which is why I normally recommend going straight to EXPOLD=0 and then they can gradually increase it and monitor the effect on paging and performance. EXPMAX, EXPOLD and EXPRES are described in more detail in Chapter 4 of the DFSORT Tuning Guide. There is a section on Hipersorting, Memory Object Sorting and Data Space Sorting which describes and gives recommenations for setting these installation default. Have a nice day, Dave Betten IBM Corporation email: bet...@us.ibm.com IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 08/05/2014 06:38:33 AM: From: Martin Packer martin_pac...@uk.ibm.com To: IBM-MAIN@listserv.ua.edu Date: 08/05/2014 06:38 AM Subject: Re: Anothe DFSORT question (EXPMAX) Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu I'm hoping my colleague Dave Betten will chime in on this at some point. Particularly as z/OS 2.1 DFSORT has some enhancements in this area. CONCURRENCY is always the challenge here. And equally I would reinforce MEMLIMIT with a decent IEFUSI exit (which I would hope included limiting hiperspace). I've seen this scenario a number of times, often represented by the RMF interval-level Minimum Available Frames being near zero while the interval-level Average Available Frames is usually (but not always) somewhat higher. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: R.S. r.skoru...@bremultibank.com.pl To: IBM-MAIN@listserv.ua.edu Date: 05/08/2014 11:28 Subject:Re: Anothe DFSORT question (EXPMAX) Sent by:IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu W dniu 2014-08-05 11:23, Elardus Engelbrecht pisze: Radoslaw Skorupka wrote: EXPMAX Specifies the maximum total amount of available storage to be used at any one time by all Hipersorting, memory object sorting, and dataspace sorting applications. Is it the limit for all concurrently running DFsort jobs/tasks or it is per job limitation? Hmmm, interesting question, but see this note (DFSORT Application Programming Guide): [snip] So, it seemed that whatever the limit is, DFSORT will check it anyways and all jobs are checking each other's usage. If one job is hogging storage, others will have to wait, reduce their demand or use other storage methods. Is the question related to a problem you're having? Yes. I observed excessive paging (and OLTP problems) when some DB2 REORG job runs. REORG does use DFsort under the cover. I limited the job using MEMLIMIT (and REGION) in a jobcard, but DFsort was smarter: instead of 64-bit Memory Objcects it used Hiperspaces. The result was as before: excessive paging. We talk aout tens of gigabytes used by single job. Regards -- 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 authorized to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be
Re: Dynamic Alocation question
Changing the TASKLIB or STEPLIB or JOBLIB after it has been set by the system is not supported, any more than is changing many of the system-built control blocks. Might doing so work? Sure. There certainly are programs around that do this. Peter Relson z/OS Core Technology Design -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Dynamic Alocation question
On Tue, Aug 5, 2014 at 6:52 AM, Peter Relson rel...@us.ibm.com wrote: Changing the TASKLIB or STEPLIB or JOBLIB after it has been set by the system is not supported, any more than is changing many of the system-built control blocks. Might doing so work? Sure. There certainly are programs around that do this. Peter Relson z/OS Core Technology Design Yeah. And, IIRC, the dynamic STEPLIB facility would basically schedule an IRB onto the initiator TCB. This would do a STATUS STOP on all the other TCBs in the address space. Then find the DCB for the STEPLIB by chasing chains. It would CLOSE that DCB, reallocate STEPLIB, OPEN the DCB again, do a STATUS START, then exit. That never gave me any warm fuzzies. And, horribly, could convert the STEPLIB concatenation from APF authorized to not APF authorized. burr/ -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload data
Then you need to post your entire control cards for UNLOAD. And provide us with what UNLOAD Utility. Is it IBM's DB2 Unload or CA's DB2 Tools or OTHER? It would be better to post the entire step that runs long and one that runs normally. Otherwise you will continue to get questions from the list. That includes the JCL, the control cards and the messages produced at run time. If you are having issues with DB2 Unload, then you should open an problem ticket with the vendor for assistance. Without very specific information it is very difficult for the list to comment on your issue. There is a lot of wisdom on this list as well as other mainframe lists (like DB2, IMS, CICS, MQ, TSO-REXX and so forth). However if you want a comment on your issue, the more specific information you provide the less questions will be asked and perhaps some guidance on your issue could be provided. A List is not a help desk. Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ron Thomas Sent: Monday, August 04, 2014 10:29 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Unload data 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. Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
XCF Signaling Paths
Hi, In a parallel sysplex, if you lost access to your XCF CDS's would your systems stay up using the XCF signaling structures using the coupling facility? Or are the XCF signaling structures only used for structures defined to CFRM datasets. Thanks, Dean Sent from my iPhone -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: XCF Signaling Paths
On 08/05/14 09:23, Dno wrote: Hi, In a parallel sysplex, if you lost access to your XCF CDS's would your systems stay up using the XCF signaling structures using the coupling facility? Or are the XCF signaling structures only used for structures defined to CFRM datasets. Thanks, Dean Sent from my iPhone Nope. An immediate wait state would occur on all systems that lost connectivity to the CDS's. -- Mark Jacobs Time Customer Service Tampa, FL The standard you walk past is the standard you accept. Lt. Gen. David Morrison, Australian Army Chief -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
z/OS Hot Topics and a bonus
Hi Everyone, The latest issue of z/OS Hot Topics is now available: www.ibm.com/systems/z/os/zos/library/hot-topics/hot-topics.html Our theme this issue is Smarting computing with z/OS V2R1. In addition to all the great articles about z/OS V2R1, cloud, analytics, mobile, security, and social, check out our new Facebook page too: https://www.facebook.com/zosHotTopics If you “like” the page before September 1, 2014, you are automatically in the running to be among the ten lucky readers, chosen at random, to receive a T-shirt from our most recent Master the Mainframe Contest in the US and Canada. Happy Reading and Good Luck! Jodi Everdon -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: LE APAR PM99349
It was my impression that SECINT PTFs were shipped in the normal maintenance stream with the description 'INTEGRITY PROBLEM' as the only description (and of course the SUPed apar). I am not aware if SECINT PTFS go through the RSU process. If they do not, this would be an argument for SMP apply using the PUT level as opposed to the RSU level. As far as I know, SECINT PTFs/apars do not show up in the public searches of IBMLINK (or even entitled searches). I have not attempted any searches while logged into the Security Portal. HTH, snip Best I can tell, the SECINT SOURCEID is available only via the SECINT.ASSIGNS file, available only through the Security Portal. I've never seen a SECINT PTF in any RECEIVE ORDER with CONTENT(RECOMMENDED) (but that doesn't mean there aren't any). Thus, it appears that one is expected to subscribe to the Security Portal and to its notification process to learn when a security/integrity problem has been identified and fixed. /snip -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload data
Ok Thanks every one, as i told this is a DB2 SQL query . We have found a solution to read the unload table query from the PDS and will be replacing the where clause current date with the date from the cycle file. Thanks Ron T -- 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: Unload data
On Tue, 5 Aug 2014 08:47:31 -0500, Ron Thomas wrote: Ok Thanks every one, as i told this is a DB2 SQL query . We have found a solution to read the unload table query from the PDS and will be replacing the where clause current date with the date from the cycle file. I'm slightly surprised that current-date is evaluated for each row inspected rather than once at the start of the query. Or does the problem arise because depending on workload it's unpredictable on which date the query is issued? Anyway, sounds like a proper solution. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Initialization problem in Storage Group
CDS Name 'ACTIVE' in ISMF panel DGTSCSG1 STORAGE GROUP APPLICATION SELECTION? Otherwise, you get the information stored in the CDS not the actual system state that you'd also get from DISPLAY SMS,VOLUME(FC1800). ps. I discovered you can DISPLAY SMS,VOLUME() on a non-existent volume that is defined to a StorGrp. For example, I routinely over-define more volumes in a StorGrp than are initialized so I can increase the pool without activating a new configuration ie. DB2000-DB2080 when only 30 volumes exist. When I INIT VOL(DB2031) STORAGEGROUP, it's automagically in the pool with no further SMS work. signature = 6 lines follows Neil Duffee, Joe Sysprog, uOttawa, Ottawa, Ont, Canada telephone:1 613 562 5800 x4585 fax:1 613 562 5161 mailto:NDuffee of uOttawa.ca http:/ /aix1.uOttawa.ca/ ~nduffee “How *do* you plan for something like that?” Guardian Bob, Reboot “For every action, there is an equal and opposite criticism.” “Systems Programming: Guilty, until proven innocent” John Norgauer 2004 -Original Message- From: Rajesh Janakiraman [mailto:raj.janaki...@gmail.com] Sent: August 4, 2014 13:29 Subject: Re: Initialization problem in Storage Group All the volumes are displayed in pool. [snip] -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z/OS Hot Topics and a bonus
Featured topics: Smarter Computing with z/OS V2R1: cloud, analytics, mobile, social, and security. In a message dated 8/5/2014 8:26:19 A.M. Central Daylight Time, jever...@us.ibm.com writes: Our theme this issue is Smarting computing with z/OS V2R1. ^^ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: [Marketing Mail] Re: Initialization problem in Storage Group
Dear Mates, Issue got resolved, sorry for the inconvenience. Actually there were two Storage Class presented in the name of one Storage Group. Thanks for the responses. Thanks Regards, Rajesh Janakiraman Mainframe System Analyst From: Pommier, Rex rpomm...@sfgmembers.com To: IBM-MAIN@LISTSERV.UA.EDU, Date: 08/06/2014 12:24 AM Subject:[Marketing Mail] Re: Initialization problem in Storage Group Sent by:IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU Neil, What does the StorGrp display look like in ISMF when you have the non-existent volumes in the SG? Do they show up on the CDS-name display but not on the ACTIVE display? Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Neil Duffee Sent: Tuesday, August 05, 2014 1:33 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Initialization problem in Storage Group CDS Name 'ACTIVE' in ISMF panel DGTSCSG1 STORAGE GROUP APPLICATION SELECTION? Otherwise, you get the information stored in the CDS not the actual system state that you'd also get from DISPLAY SMS,VOLUME(FC1800). ps. I discovered you can DISPLAY SMS,VOLUME() on a non-existent volume that is defined to a StorGrp. For example, I routinely over-define more volumes in a StorGrp than are initialized so I can increase the pool without activating a new configuration ie. DB2000-DB2080 when only 30 volumes exist. When I INIT VOL(DB2031) STORAGEGROUP, it's automagically in the pool with no further SMS work. signature = 6 lines follows Neil Duffee, Joe Sysprog, uOttawa, Ottawa, Ont, Canada telephone:1 613 562 5800 x4585 fax:1 613 562 5161 mailto:NDuffee of uOttawa.ca http:/ /aix1.uOttawa.ca/ ~nduffee “How *do* you plan for something like that?” Guardian Bob, Reboot “For every action, there is an equal and opposite criticism.” “Systems Programming: Guilty, until proven innocent” John Norgauer 2004 -Original Message- From: Rajesh Janakiraman [mailto:raj.janaki...@gmail.com] Sent: August 4, 2014 13:29 Subject: Re: Initialization problem in Storage Group All the volumes are displayed in pool. [snip] -- 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 Know more about us on www.hdfcbank.com. Connect with us on Facebook at www.facebook.com/hdfcbank Disclaimer: The information contained herein (including any accompanying documents) is confidential and is intended solely for the addressee(s). If you have erroneously received this message, please immediately delete it and notify the sender. Also, if you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this message or any accompanying document is strictly prohibited and is unlawful. The organization is not responsible for any damage caused by a virus or alteration of the e-mail by a third party or otherwise. Regd. Office : HDFC Bank Ltd., HDFC Bank House, Senapati Bapat Marg, Lower Parel (W), Mumbai - 400 013. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Visara Virtual Tape
Hello, We're looking into VTLs. Is anyone using Visara's virtual tape appliance or library? Would you please share your experience with the company as far as support and hardware reliability? Thanks in advance. Vince -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z/OS Hot Topics and a bonus
Still Smarting from ESP's! Featured topics: Smarter Computing with z/OS V2R1: cloud, analytics, mobile, social, and security. In a message dated 8/5/2014 8:26:19 A.M. Central Daylight Time, jever...@us.ibm.com writes: Our theme this issue is Smarting computing with z/OS V2R1. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Visara Virtual Tape
Try www.luminex.com Very easy implemantation and administration *Carlos Bodra IBM Certified zEnterprise Sao Paulo - SP - BRAZIL* Em 05/08/2014 16:09, Vinson Lee escreveu: Hello, We're looking into VTLs. Is anyone using Visara's virtual tape appliance or library? Would you please share your experience with the company as far as support and hardware reliability? Thanks in advance. Vince -- 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: Dynamic Alocation question
In bay169-w587eb19110078468862cd5a3...@phx.gbl, on 08/04/2014 at 11:29 AM, J R jayare...@hotmail.com said: Well, the tasklib, whether it be JOBLIB, STEPLIB or some other, is opened at step initiation, No, only JOBLIB and STEPLIB; any other tasklib is opened by the attaching task or a parent within the jobstep. -- 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: Dynamic Alocation question
In 5361904817893993.wa.paulgboulderaim@listserv.ua.edu, on 08/04/2014 at 11:00 AM, Paul Gilmartin 000433f07816-dmarc-requ...@listserv.ua.edu said: And I'll suspect the programmer is not allowed to CLOSE it; re-ALLOCATE; and re-OPEN. Is something similar true for the TASKLIB optional argument to ATTACH? If the parent task closed, reallocated and reopened and none of the subtasks was doing a fetch during that window, it might work. I see no way to do the requisite serialization. -- 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: Dynamic Alocation question
In bay169-w10481432472db094d28d9c9a3...@phx.gbl, on 08/04/2014 at 12:30 PM, J R jayare...@hotmail.com said: Of course, if authorized one can do what one likes, Including shooting oneself in the foot. -- 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: Dynamic Alocation question
In 970d418f-dbb3-492f-a630-8962ddbac...@comcast.net, on 08/04/2014 at 12:55 PM, Micheal Butz michealb...@comcast.net said: Wait open at step initiation The Initiator does not open TSOLIB. Believe I can load am APF authorized program from Of course, but it won't run as authorized unless you were already authorized. -- 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
Remote HMC or HMC with Remote Access
Any reason to prefer one setup over the other? Local (my office) HMC connected to remote datacenters (50+ miles and 200+ miles) Remote access (from my office) to an HMC in remote datacenters (50+ miles and 200+ miles) I’m going to have 2 datacenters (200+ miles apart) in CoLo providers Closest datacenter will be within 50 miles of the office where I work Intent is to have only “smart” third party support access to the datacenter (for racking/cabling/rebooting) Mainframe activity (IPL/POR) to take place remotely with fallback to “smart” third party support if needed. Rack space will be at a premium so they don’t want to waste it on an HMC if they can avoid it. Thanks all for your input. Ken Ken Porowski VP Mainframe Engineering CIT Information Technology One CIT Drive Livingston, NJ 07039 +1 973 740 5459 (tel) ken.porow...@cit.commailto:ken.porow...@cit.com www.cit.comhttp://www.cit.com This email message and any accompanying materials may contain proprietary, privileged and confidential information of CIT Group Inc. or its subsidiaries or affiliates (collectively, “CIT”), and are intended solely for the recipient(s) named above. If you are not the intended recipient of this communication, any use, disclosure, printing, copying or distribution, or reliance on the contents, of this communication is strictly prohibited. CIT disclaims any liability for the review, retransmission, dissemination or other use of, or the taking of any action in reliance upon, this communication by persons other than the intended recipient(s). If you have received this communication in error, please reply to the sender advising of the error in transmission, and immediately delete and destroy the communication and any accompanying materials. To the extent permitted by applicable law, CIT and others may inspect, review, monitor, analyze, copy, record and retain any communications sent from or received at this email address. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Remote HMC or HMC with Remote Access
My $0.02 would be to keep the HMC in the Data Centers and remotely access them, because would not the CE (sorry old term, but I am not sure what they are called now these days) need or prefer direct access to the HMC while working on the hardware? I think the systems would continue to run should connection to the HMC be lost, but why chance it? 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 Ken Porowski Sent: Tuesday, August 05, 2014 4:29 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Remote HMC or HMC with Remote Access Any reason to prefer one setup over the other? Local (my office) HMC connected to remote datacenters (50+ miles and 200+ miles) Remote access (from my office) to an HMC in remote datacenters (50+ miles and 200+ miles) I'm going to have 2 datacenters (200+ miles apart) in CoLo providers Closest datacenter will be within 50 miles of the office where I work Intent is to have only smart third party support access to the datacenter (for racking/cabling/rebooting) Mainframe activity (IPL/POR) to take place remotely with fallback to smart third party support if needed. Rack space will be at a premium so they don't want to waste it on an HMC if they can avoid it. Thanks all for your input. Ken Ken Porowski VP Mainframe Engineering CIT Information Technology One CIT Drive Livingston, NJ 07039 +1 973 740 5459 (tel) ken.porow...@cit.commailto:ken.porow...@cit.com www.cit.comhttp://www.cit.com This email message and any accompanying materials may contain proprietary, privileged and confidential information of CIT Group Inc. or its subsidiaries or affiliates (collectively, CIT), and are intended solely for the recipient(s) named above. If you are not the intended recipient of this communication, any use, disclosure, printing, copying or distribution, or reliance on the contents, of this communication is strictly prohibited. CIT disclaims any liability for the review, retransmission, dissemination or other use of, or the taking of any action in reliance upon, this communication by persons other than the intended recipient(s). If you have received this communication in error, please reply to the sender advising of the error in transmission, and immediately delete and destroy the communication and any accompanying materials. To the extent permitted by applicable law, CIT and others may inspect, review, monitor, analyze, copy, record and retain any communications sent from or received at this email address. -- 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: Remote HMC or HMC with Remote Access
In the old days of OS/2 based HMC there was a difference in the bandwith requirement. Now it's irrelevant. I know no pro's of remote HMC (maybe except backup critical data) I know some con's: - HMC is expensive. Much more expensive than regular PC - you already have some PC on your desktop, so you don't want to have another one (HMC). - all your coworkers can have remote access, it does cost nothing except setup. HMC for everyone sounds less reasonable. Some additional remarks: - install some ftp server on your PC. You'll be able to peform some useful actions like OSA definitions upload. Note: your PC should answer to PINGs, which isn't default Windows setup. - for IOCDS import from text file you need to have access from SE to your ftp server. That's *another* network! - the same for Load from ftp task. HTH -- Radoslaw Skorupka Lodz, Poland W dniu 2014-08-05 22:28, Ken Porowski pisze: Any reason to prefer one setup over the other? Local (my office) HMC connected to remote datacenters (50+ miles and 200+ miles) Remote access (from my office) to an HMC in remote datacenters (50+ miles and 200+ miles) I’m going to have 2 datacenters (200+ miles apart) in CoLo providers Closest datacenter will be within 50 miles of the office where I work Intent is to have only “smart” third party support access to the datacenter (for racking/cabling/rebooting) Mainframe activity (IPL/POR) to take place remotely with fallback to “smart” third party support if needed. Rack space will be at a premium so they don’t want to waste it on an HMC if they can avoid it. Thanks all for your input. Ken Ken Porowski VP Mainframe Engineering CIT Information Technology One CIT Drive Livingston, NJ 07039 +1 973 740 5459 (tel) ken.porow...@cit.commailto:ken.porow...@cit.com www.cit.comhttp://www.cit.com This email message and any accompanying materials may contain proprietary, privileged and confidential information of CIT Group Inc. or its subsidiaries or affiliates (collectively, “CIT”), and are intended solely for the recipient(s) named above. If you are not the intended recipient of this communication, any use, disclosure, printing, copying or distribution, or reliance on the contents, of this communication is strictly prohibited. CIT disclaims any liability for the review, retransmission, dissemination or other use of, or the taking of any action in reliance upon, this communication by persons other than the intended recipient(s). If you have received this communication in error, please reply to the sender advising of the error in transmission, and immediately delete and destroy the communication and any accompanying materials. To the extent permitted by applicable law, CIT and others may inspect, review, monitor, analyze, copy, record and retain any communications sent from or received at this email address. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN --- Tre tej wiadomoci moe zawiera informacje prawnie chronione Banku przeznaczone wycznie do uytku subowego adresata. Odbiorc moe by jedynie jej adresat z wyczeniem dostpu osób trzecich. Jeeli nie jeste adresatem niniejszej wiadomoci lub pracownikiem upowanionym do jej przekazania adresatowi, informujemy, e jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne dziaanie o podobnym charakterze jest prawnie zabronione i moe by karalne. Jeeli otrzymae t wiadomo omykowo, prosimy niezwocznie zawiadomi nadawc wysyajc odpowied oraz trwale usun t wiadomo wczajc 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 authorized 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. mBank S.A. z siedzib w Warszawie, ul. Senatorska 18, 00-950 Warszawa, www.mBank.pl, e-mail: kont...@mbank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237, NIP: 526-021-50-88. Wedug stanu na dzie 01.01.2014 r. kapita zakadowy mBanku S.A. (w caoci wpacony) wynosi 168.696.052 zote. -- For IBM-MAIN subscribe / signoff / archive access instructions, send
Re: Initialization problem in Storage Group
Volumes named but not created appear on the list but all values are blank. On Tue, Aug 5, 2014 at 1:52 PM, Pommier, Rex rpomm...@sfgmembers.com wrote: Neil, What does the StorGrp display look like in ISMF when you have the non-existent volumes in the SG? Do they show up on the CDS-name display but not on the ACTIVE display? Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Neil Duffee Sent: Tuesday, August 05, 2014 1:33 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Initialization problem in Storage Group CDS Name 'ACTIVE' in ISMF panel DGTSCSG1 STORAGE GROUP APPLICATION SELECTION? Otherwise, you get the information stored in the CDS not the actual system state that you'd also get from DISPLAY SMS,VOLUME(FC1800). ps. I discovered you can DISPLAY SMS,VOLUME() on a non-existent volume that is defined to a StorGrp. For example, I routinely over-define more volumes in a StorGrp than are initialized so I can increase the pool without activating a new configuration ie. DB2000-DB2080 when only 30 volumes exist. When I INIT VOL(DB2031) STORAGEGROUP, it's automagically in the pool with no further SMS work. signature = 6 lines follows Neil Duffee, Joe Sysprog, uOttawa, Ottawa, Ont, Canada telephone:1 613 562 5800 x4585 fax:1 613 562 5161 mailto:NDuffee of uOttawa.ca http:/ /aix1.uOttawa.ca/ ~nduffee “How *do* you plan for something like that?” Guardian Bob, Reboot “For every action, there is an equal and opposite criticism.” “Systems Programming: Guilty, until proven innocent” John Norgauer 2004 -Original Message- From: Rajesh Janakiraman [mailto:raj.janaki...@gmail.com] Sent: August 4, 2014 13:29 Subject: Re: Initialization problem in Storage Group All the volumes are displayed in pool. [snip] -- 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 -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Remote HMC or HMC with Remote Access
Preferred: Remote access (from my office) to an HMC in remote datacenters (50+ miles and 200+ miles) Built-in redundancy. Also allow HMC's to network so either location can support the other i.e. your office-HMCNETWORK / \ HMC#1 -- HMC#2 HTH, snip Any reason to prefer one setup over the other? Local (my office) HMC connected to remote datacenters (50+ miles and 200+ miles) Remote access (from my office) to an HMC in remote datacenters (50+ miles and 200+ miles) I'm going to have 2 datacenters (200+ miles apart) in CoLo providers Closest datacenter will be within 50 miles of the office where I work Intent is to have only smart third party support access to the datacenter (for racking/cabling/rebooting) Mainframe activity (IPL/POR) to take place remotely with fallback to smart third party support if needed. Rack space will be at a premium so they don't want to waste it on an HMC if they can avoid it. /snip -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Initialization problem in Storage Group
Thanks! -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Mike Schwab Sent: Tuesday, August 05, 2014 4:09 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Initialization problem in Storage Group Volumes named but not created appear on the list but all values are blank. On Tue, Aug 5, 2014 at 1:52 PM, Pommier, Rex rpomm...@sfgmembers.com wrote: Neil, What does the StorGrp display look like in ISMF when you have the non-existent volumes in the SG? Do they show up on the CDS-name display but not on the ACTIVE display? Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Neil Duffee Sent: Tuesday, August 05, 2014 1:33 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Initialization problem in Storage Group CDS Name 'ACTIVE' in ISMF panel DGTSCSG1 STORAGE GROUP APPLICATION SELECTION? Otherwise, you get the information stored in the CDS not the actual system state that you'd also get from DISPLAY SMS,VOLUME(FC1800). ps. I discovered you can DISPLAY SMS,VOLUME() on a non-existent volume that is defined to a StorGrp. For example, I routinely over-define more volumes in a StorGrp than are initialized so I can increase the pool without activating a new configuration ie. DB2000-DB2080 when only 30 volumes exist. When I INIT VOL(DB2031) STORAGEGROUP, it's automagically in the pool with no further SMS work. signature = 6 lines follows Neil Duffee, Joe Sysprog, uOttawa, Ottawa, Ont, Canada telephone:1 613 562 5800 x4585 fax:1 613 562 5161 mailto:NDuffee of uOttawa.ca http:/ /aix1.uOttawa.ca/ ~nduffee “How *do* you plan for something like that?” Guardian Bob, Reboot “For every action, there is an equal and opposite criticism.” “Systems Programming: Guilty, until proven innocent” John Norgauer 2004 -Original Message- From: Rajesh Janakiraman [mailto:raj.janaki...@gmail.com] Sent: August 4, 2014 13:29 Subject: Re: Initialization problem in Storage Group All the volumes are displayed in pool. [snip] -- 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 -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? -- 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: z/OS Hot Topics and a bonus
Please excuse the typo... the theme of z/OS Hot Topics, Issue 28 is Smarter Computing with z/OS V2R1 In addition to the topics I mentioned in my previous post, the list of articles includes other great topics such as consoles, QSAM/BSAM, catalog contention, VSAM, z/OS Fixed Block Architecture services, zBNA, SMC-R, PCI Express, JZOS, two articles about zEDC, and two that cover everything you need to know about migration to z/OS V2R1. Enjoy! Jodi -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: z/OS Hot Topics and a bonus
On Tue, 5 Aug 2014 16:42:50 -0500, Jodi Everdon wrote: Please excuse the typo... If we all got shot for typos there'd be precious few of us left on the list. Think I'll skip the invite to set up a facebook account though. Shane ... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload data
Ok The current date is one of the fields in the where clause. There are few others too. Let me know if there is any other way to handle ?. Thanks. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload data
On Tue, Aug 5, 2014 at 6:03 PM, Ron Thomas ron5...@gmail.com wrote: Ok The current date is one of the fields in the where clause. There are few others too. Let me know if there is any other way to handle ?. Thanks. This really should be on the DB2-L list. But that's not important. (Airplane!) You didn't show the WHERE clause. So I must try to guess. I'll guess that the WHERE uses the CURRENT_DATE special register. E.g. WHERE some-var = CURRENT_DATE . The somv-var is a DATE field in each row of the table. You might get away with a WHERE clause like: WHERE some-var = CAST(CURRENT_TIMESTAMP - 5 HOURS AS DATE) . Hopefully the previous expression is obvious in intent. But it basically sets the current DATE to start at 05:00:00 and end at 04:59:59.99 on the next day. So, as long as the job runs on or after 05:00:00 of day n and strictly before 05:00:00 of day n+1, then the WHERE will be TRUE for day n. Wish I were a better communicator. It may be nasty to say, but I find it puzzling that this is not blatantly obvious to whomever is responsible for crafting your SQL queries. Unless, of course, there is more to this than has been revealed as yet. Again: POST THE SQL! It will make things much easier. Redact the names if they are somehow proprietary or not to be revealed under pain of pain. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload data
Bracket the potential dates in the SELECT and eliminate the ones you don't want using DFSORT in a later step. So if you are using CURRENT_DATE in the SELECT use = CURRENT_DATE for the situation where the job clicks over to next date. 125 million rows is not a lot for DFSORT to filter later. On Wed, Aug 6, 2014 at 9:56 AM, John McKown john.archie.mck...@gmail.com wrote: On Tue, Aug 5, 2014 at 6:03 PM, Ron Thomas ron5...@gmail.com wrote: Ok The current date is one of the fields in the where clause. There are few others too. Let me know if there is any other way to handle ?. Thanks. This really should be on the DB2-L list. But that's not important. (Airplane!) You didn't show the WHERE clause. So I must try to guess. I'll guess that the WHERE uses the CURRENT_DATE special register. E.g. WHERE some-var = CURRENT_DATE . The somv-var is a DATE field in each row of the table. You might get away with a WHERE clause like: WHERE some-var = CAST(CURRENT_TIMESTAMP - 5 HOURS AS DATE) . Hopefully the previous expression is obvious in intent. But it basically sets the current DATE to start at 05:00:00 and end at 04:59:59.99 on the next day. So, as long as the job runs on or after 05:00:00 of day n and strictly before 05:00:00 of day n+1, then the WHERE will be TRUE for day n. Wish I were a better communicator. It may be nasty to say, but I find it puzzling that this is not blatantly obvious to whomever is responsible for crafting your SQL queries. Unless, of course, there is more to this than has been revealed as yet. Again: POST THE SQL! It will make things much easier. Redact the names if they are somehow proprietary or not to be revealed under pain of pain. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Wayne V. Bickerdike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Unload data
On Wed, 6 Aug 2014 10:30:19 +1000, Wayne Bickerdike wrote: Bracket the potential dates in the SELECT and eliminate the ones you don't want using DFSORT in a later step. So if you are using CURRENT_DATE in the SELECT use = CURRENT_DATE for the situation where the job clicks over to next date. 125 million rows is not a lot for DFSORT to filter later. Say what That's the (ex ?) DBA in you talking Wayne. As if we don't have enough trouble in the world from DBAs selecting everything, sorting it, throwing it away then doing it all again - when they only need a (smal) subset of the data. Aggghhh - go read Radoslaws' Anothe(r) SORT question thread again. DB2 is a pig as far as overall system management is concerned - just like every other database system. Give me everything (page-fixed), the rest of the users can go slowly stew in hell. Shane ... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: XCF Signaling Paths
Signalling CF structures can be backed up by CTC connections, but nothing backs up CDS connections. You must retain at least one of each type in use. . . 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 From: Mark Jacobs mark.jac...@custserv.com To: IBM-MAIN@LISTSERV.UA.EDU, Date: 08/05/2014 06:25 AM Subject:Re: XCF Signaling Paths Sent by:IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU On 08/05/14 09:23, Dno wrote: Hi, In a parallel sysplex, if you lost access to your XCF CDS's would your systems stay up using the XCF signaling structures using the coupling facility? Or are the XCF signaling structures only used for structures defined to CFRM datasets. Thanks, Dean Sent from my iPhone Nope. An immediate wait state would occur on all systems that lost connectivity to the CDS's. -- Mark Jacobs Time Customer Service Tampa, FL -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN