Re: Is there an IBM program that will tell me what job created a DASD DSN?
Richard, Yes that would apply to DAF, MICS, and MXG. Are we assuming that rename updates the format9 DSCB? Rename does not really create the dataset :-) I suspect the Type 18 and 66 SMF records would be helpful here - if your kept them.. Ron -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Richard L Peurifoy Sent: Wednesday, December 14, 2011 8:21 AM To: IBM-MAIN@bama.ua.edu Subject: Re: [IBM-MAIN] Is there an IBM program that will tell me what job created a DASD DSN? On 12/14/2011 2:32 AM, Ron Hawkins wrote: Richard, If the format 9 DSCB includes the date, time and jobname of the creating job it should not be too hard to tie this to an SMF Type30 subtype 2 or 3 record to get additional auditing information. This is true, but unless you keep SMF data forever, you will eventually not be able to do this. Of course, once we start down this path you might need the USERID for a rename as well, etc. It could get very messy. :-) -- Richard -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Richard, If the format 9 DSCB includes the date, time and jobname of the creating job it should not be too hard to tie this to an SMF Type30 subtype 2 or 3 record to get additional auditing information. Ron -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Richard L Peurifoy Sent: Tuesday, December 13, 2011 11:31 AM To: IBM-MAIN@bama.ua.edu Subject: Re: [IBM-MAIN] Is there an IBM program that will tell me what job created a DASD DSN? On 12/13/2011 1:15 PM, Bill Fairchild wrote: -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Elardus Engelbrecht Sent: Tuesday, December 13, 2011 12:43 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Is there an IBM program that will tell me what job created a DASD DSN? Mike Wood wrote: The format-9 DSCB contains the creating information. This requires a format-8 DSCB rather than format-1. Please be very kind to share any documentation/links/webpages/background info, if you wish? I have searched, but I must missed something obvious or in the wrong bookshelves... See SYS1.MODGEN(IECSDSL1) for the Format 1 through Format 9 DSCB DSECTs. It would have been nice to have the creating USERID as well, but it doesn't seem to be there. There are 18 unused bytes in the attribute data, so maybe it will be added at some point. -- Richard -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Bill Fairchild wrote: See SYS1.MODGEN(IECSDSL1) for the Format 1 through Format 9 DSCB DSECTs. Thanks Bill for kindly giving me a wee hint. :-) Browsing this thing showed it is a truly ancient art modified over the years all the way from indexed VTOC support in 1979 around... ;-D Just curious... was there ever a number 7 at all in this? Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
If you mean was there ever a Format 7 DSCB, then the answer is yes. It is not included in this DSECT for some reason. If you GOOGLE-advanced search for DSCB and Format 7 you can find some information on it. Bill Fairchild -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Elardus Engelbrecht Sent: Wednesday, December 14, 2011 7:14 AM To: IBM-MAIN@bama.ua.edu Subject: Re: Is there an IBM program that will tell me what job created a DASD DSN? Just curious... was there ever a number 7 at all in this? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
In 7017189519691316.wa.elardus.engelbrechtsita.co...@bama.ua.edu, on 12/14/2011 at 07:14 AM, Elardus Engelbrecht elardus.engelbre...@sita.co.za said: Browsing this thing showed it is a truly ancient art modified over the years all the way from indexed VTOC support in 1979 around... ;-D All the way? It goes back well before 1979, to OS/360, although I haven't checked whether there are change flags from that era. -- 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...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
On 12/14/2011 2:32 AM, Ron Hawkins wrote: Richard, If the format 9 DSCB includes the date, time and jobname of the creating job it should not be too hard to tie this to an SMF Type30 subtype 2 or 3 record to get additional auditing information. This is true, but unless you keep SMF data forever, you will eventually not be able to do this. Of course, once we start down this path you might need the USERID for a rename as well, etc. It could get very messy. :-) -- Richard -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
I think they still existing on non-indexed volumes. http://publib.boulder.ibm.com/infocenter/zos/v1r11/index.jsp?topic=/com.ibm.zos.r11.idar100/r1042.htm On Wed, Dec 14, 2011 at 8:40 AM, Bill Fairchild bfairch...@rocketsoftware.com wrote: If you mean was there ever a Format 7 DSCB, then the answer is yes. It is not included in this DSECT for some reason. If you GOOGLE-advanced search for DSCB and Format 7 you can find some information on it. Bill Fairchild -- 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...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Shmuel Metz (Seymour J.) wrote: Browsing this thing showed it is a truly ancient art modified over the years all the way from indexed VTOC support in 1979 around... ;-D All the way? It goes back well before 1979, to OS/360, although I haven't checked whether there are change flags from that era. Thanks for your very helpful comments. Bill Fairchild wrote: If you mean was there ever a Format 7 DSCB, then the answer is yes. It is not included in this DSECT for some reason. If you GOOGLE-advanced search for DSCB and Format 7 you can find some information on it. Got it! :-D Thanks to Shmuel and Bill for giving me these hints. :-D Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
--snip- Thanks Bill for kindly giving me a wee hint. :-) Browsing this thing showed it is a truly ancient art modified over the years all the way from indexed VTOC support in 1979 around... ;-D Just curious... was there ever a number 7 at all in this? -unsnip- I don't think Format-7 ever made it into IECSDSL1, but it described the free space for volumes too large for Format-5 DSCB's. Rick -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Roberts, John J jrobe...@dhs.state.ia.us wrote in message news:93891f43642f3c419a7d75acc2b1db6f3c12507...@exchangemb2.dhs.state.i a.us... Going back to fundamentals, my recollection is that this information is not in the VTOC (F1 DSCB), nor is it to be found in the catalog. Unless someone puts it there, like CA-DISK does. So it is only to be found in the SMF data. I hope I have it right so far. One implication could be that for certain ancient datasets, there will be no record of the dataset creation event to be found, unless of course the OP keeps SMF archives forever. John And the final detail: SMF14/15 is written at CLOSE. If a dataset is created and never opened, there will be no SMF14/15, nor any CA-DISK info. If the dataset is cataloged, you can look at SMF61 (catalog define). Kees. 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...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
W dniu 2011-12-13 08:57, Vernooij, CP - SPLXM pisze: [...] And the final detail: SMF14/15 is written at CLOSE. If a dataset is created and never opened, there will be no SMF14/15, nor any CA-DISK info. If the dataset is cataloged, you can look at SMF61 (catalog define). Of course one must care *in advance* to collect given SMF records. As an alternative to the records above I would add SMF80 - RACF. It also requires SETROPTS settings for DATASET class. Advantage: easy to report, covers SMS, non-SMS, cataloged, non-cataloged datasets. -- Radoslaw Skorupka Lodz, Poland -- 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 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, e-mail: i...@brebank.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.2011 r. kapita zakadowy BRE Banku SA (w caoci wpacony) wynosi 168.346.696 zotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Cosby, Bob wrote: nothing? ;-) Ok, From the subject above you want something to tell you what created a dataset? One question: do you want to be notified IMMEDIATELY or do you want some 'after the event' reports? You got good replies for the latter. For the first, AFAIK, there is nothing 'ready to use thing' out there which can notify you the moment a dataset is created. Perhaps you can setup RACF to notify you, but that is for violations. I think there are 3th party products (for those who have deeep pockets and dislikes freebies) which can monitor the system and notifies you immediately about such events. Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
You did not state what kind of dataset 1) SEQ/PS/PO/PDSE Or 2) VSAM If the first - SMF 14/15 - there are records for create/update/read/delete for these types of files. If the second - SMF Type 60s (I do not have the SMF manual to refer to which one is CREATE for VSAM). There are different record types depending on the type of dasd DSN you are referring to. As you can see there are many answers to your question. If you provide more details, we can help narrow it down for you. So it is just CREATE you need or do you need something else as well (update/modify, delete/create, etc...) Lizette -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
One more thing no-one mentioned yet The format-9 DSCB contains the creating information. This requires a format-8 DSCB rather than format-1. So, going forward, hopefully, more data set will readily have that information in the vtoc. Mike Wood -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Mike Wood wrote: One more thing no-one mentioned yet :-D The format-9 DSCB contains the creating information. This requires a format-8 DSCB rather than format-1. So, going forward, hopefully, more data set will readily have that information in the vtoc. Please be very kind to share any documentation/links/webpages/background info, if you wish? I have searched, but I must missed something obvious or in the wrong bookshelves... ... or I'm really that search challenged ... :-D Thanks in advance for your very kind reminder about those VTOC formats. Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
-Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Elardus Engelbrecht Sent: Tuesday, December 13, 2011 12:43 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Is there an IBM program that will tell me what job created a DASD DSN? Mike Wood wrote: The format-9 DSCB contains the creating information. This requires a format-8 DSCB rather than format-1. Please be very kind to share any documentation/links/webpages/background info, if you wish? I have searched, but I must missed something obvious or in the wrong bookshelves... See SYS1.MODGEN(IECSDSL1) for the Format 1 through Format 9 DSCB DSECTs. Bill Fairchild Rocket Software -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
On 12/13/2011 1:15 PM, Bill Fairchild wrote: -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Elardus Engelbrecht Sent: Tuesday, December 13, 2011 12:43 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Is there an IBM program that will tell me what job created a DASD DSN? Mike Wood wrote: The format-9 DSCB contains the creating information. This requires a format-8 DSCB rather than format-1. Please be very kind to share any documentation/links/webpages/background info, if you wish? I have searched, but I must missed something obvious or in the wrong bookshelves... See SYS1.MODGEN(IECSDSL1) for the Format 1 through Format 9 DSCB DSECTs. It would have been nice to have the creating USERID as well, but it doesn't seem to be there. There are 18 unused bytes in the attribute data, so maybe it will be added at some point. -- Richard -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Is there an IBM program that will tell me what job created a DASD DSN?
-- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
There are probably several on the CBT tape (www.cbttape.org) I recommend the DAF utility on the CBT tape (file094). You can look at the SMF 14/15 records using IEHEYEBALL. AFAIK, there is no supplied program with z/OS. HTH, -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
SAS + MICS or SAS + MXG or DAF from CBT Lizette -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Liz, The list you provided is OK, but in reality you really only need DAF and its free. While the others an do the job well I might add. The simple answer is usually the best. Ed -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Liz, The list you provided is OK, but in reality you really only need DAF and its free. While the others an do the job well I might add. The simple answer is usually the best. Ed Absolutely agree. DAF is usually sufficient. However, some shops do not like freeware and this shop may already have SAS+MICS or SAS+MXG to do this and may not allow the use of DAF. So a more general list - do to the lack of information about this shop. Lizette -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Actually, IBM does supply DFSORT which makes the answer to the question yes plus SMOP. For some complex value of simple :) Dave Gibney Information Technology Services Washington State University -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Lizette Koehler Sent: Monday, December 12, 2011 1:33 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Is there an IBM program that will tell me what job created a DASD DSN? Liz, The list you provided is OK, but in reality you really only need DAF and its free. While the others an do the job well I might add. The simple answer is usually the best. Ed Absolutely agree. DAF is usually sufficient. However, some shops do not like freeware and this shop may already have SAS+MICS or SAS+MXG to do this and may not allow the use of DAF. So a more general list - do to the lack of information about this shop. Lizette -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Going back to fundamentals, my recollection is that this information is not in the VTOC (F1 DSCB), nor is it to be found in the catalog. So it is only to be found in the SMF data. I hope I have it right so far. One implication could be that for certain ancient datasets, there will be no record of the dataset creation event to be found, unless of course the OP keeps SMF archives forever. John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Dave, Technically IBM also supplies HLASM as well but the question was phrased to let the reader to think that a canned solution. The DFSORT option (actually semi valid) requires a bit of logic and some amount of programming type logic ie packed, binary etc and of course record layouts and what the fields mean. DAF relieves the user of some or most of these items. SAS has it#39;s own set of issues and unless you have macro definitions and then you need to understand SAS processing I have never become proficient in it as I keep thinking how it should work rather than how it really works DAF takes most if not all of the processing out of the hands of the user. The basics needed to know are at best minimal DSN in this case is all besides the file name of the dataset where SMF resides is basic. Ed -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Is there an IBM program that will tell me what job created a DASD DSN?
Liz, I know what you mean, however most shops turn a blind eye to systems people running their own acquired code on their own ID. I understand and fully agree that programs like DAF and others on the CBT or other such places should not be given to applications programs . I have been burned by such programs from outside sources. One consultant brought in his own goody bag and somehow it got into production and of course it was then thrown in my direction and all of a sudden I was supposed to support it. I threw it back and told personally to the head of programming and he really hit the ceiling. Ed -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html