Re: Dataset Aliases - How to find ALL of them
>Finding all aliases without specifying an pattern name seems like it should be >a basic wide-ranging need. I haven't done it for awhile, but I believe you can do it on a user catalogue basis. LISTCAT ENTRY(usercat) xxx Where xxx would be one of ASSOCIATIONS or ALL. Like I said, it's been a long time. Look it up in the Access Methods Services manual. And, try them out. - I'm a SuperHero with neither powers, nor motivation! Kimota! -- 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: Dataset Aliases - How to find ALL of them
In an IDCAMS batch job, not TSO, issue the command LISTCAT CAT(dsn) ALIAS ALL -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Roy Reynolds Sent: Wednesday, July 14, 2010 10:54 AM To: IBM-MAIN@bama.ua.edu Subject: Dataset Aliases - How to find ALL of them Such a basic question I can hardly believe I'm asking it. Is there a way to list all the dataset aliases and their target datasets? Such an option would be useful. I guess I could just go through listing all datasets and checking for an alias association but that seems like a nasty bit of work. -- 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: Dataset Aliases - How to find ALL of them
I would add that this command should be done against your MASTER catalog to get all aliases... This should show you all aliases along with their associated user catalogs. Depending on your system this can be a lengthy output. If you remove the ALL parm you will get a list of all aliases only, which might be better as a start. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Schwarz, Barry A Sent: Wednesday, July 14, 2010 2:33 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Dataset Aliases - How to find ALL of them In an IDCAMS batch job, not TSO, issue the command LISTCAT CAT(dsn) ALIAS ALL -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Roy Reynolds Sent: Wednesday, July 14, 2010 10:54 AM To: IBM-MAIN@bama.ua.edu Subject: Dataset Aliases - How to find ALL of them Such a basic question I can hardly believe I'm asking it. Is there a way to list all the dataset aliases and their target datasets? Such an option would be useful. I guess I could just go through listing all datasets and checking for an alias association but that seems like a nasty bit of work. -- 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: Dataset Aliases - How to find ALL of them
>LISTCAT CAT(dsn) ALIAS ALL I knew it could be done, I just couldn't remember how. - I'm a SuperHero with neither powers, nor motivation! Kimota! -- 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: Dataset Aliases - How to find ALL of them
On Wed, 14 Jul 2010 15:17:49 -0400, Burrell, C. Todd wrote: >I would add that this command should be done against your MASTER catalog >to get all aliases... This should show you all aliases along with their >associated user catalogs. Depending on your system this can be a >lengthy output. > If specify your master catalog, it will only show those aliases that are in the master catalog. Data set aliases are required to be defined in the same catalog as the data set. Do not specify the master to search all catalogs. -- Tom Marchant > >-Original Message- >From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On >Behalf Of Schwarz, Barry A >Sent: Wednesday, July 14, 2010 2:33 PM >To: IBM-MAIN@bama.ua.edu >Subject: Re: Dataset Aliases - How to find ALL of them > >In an IDCAMS batch job, not TSO, issue the command >LISTCAT CAT(dsn) ALIAS 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: Dataset Aliases - How to find ALL of them
On my system, it shows only the aliases defined in the specified catalog. When specifying the master catalog, it does not show dataset aliases defined in user catalogs. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Burrell, C. Todd (CDC/OCOO/ITSO) (CTR) Sent: Wednesday, July 14, 2010 12:18 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Dataset Aliases - How to find ALL of them I would add that this command should be done against your MASTER catalog to get all aliases... This should show you all aliases along with their associated user catalogs. Depending on your system this can be a lengthy output. If you remove the ALL parm you will get a list of all aliases only, which might be better as a start. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Schwarz, Barry A Sent: Wednesday, July 14, 2010 2:33 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Dataset Aliases - How to find ALL of them In an IDCAMS batch job, not TSO, issue the command LISTCAT CAT(dsn) ALIAS 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: Dataset Aliases - How to find ALL of them
On Wed, 2010-07-14 at 12:54 -0500, Roy Reynolds wrote: > Such a basic question I can hardly believe I'm asking it. > > Is there a way to list all the dataset aliases and their target datasets? > Such an option would be useful. > I guess I could just go through listing all datasets and checking for an > alias association but that seems like a nasty bit of work. > > Finding all aliases without specifying an pattern name seems like it should > be a basic wide-ranging need. > Thoughts? > Thanks in advance. > Not where I can test. but I'd try: LISTC ALIAS CAT('catalog') And look at it. Otherwise, you're looking at using IGGCSI00 interface to read the catalog in your own program. -- John McKown Maranatha! <>< -- 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: Dataset Aliases - How to find ALL of them
I think Todd was thinking about catalog aliases, rather than dataset aliases. >>> "Schwarz, Barry A" 7/14/2010 5:23 PM >>> On my system, it shows only the aliases defined in the specified catalog. When specifying the master catalog, it does not show dataset aliases defined in user catalogs. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Burrell, C. Todd (CDC/OCOO/ITSO) (CTR) Sent: Wednesday, July 14, 2010 12:18 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Dataset Aliases - How to find ALL of them I would add that this command should be done against your MASTER catalog to get all aliases... This should show you all aliases along with their associated user catalogs. Depending on your system this can be a lengthy output. If you remove the ALL parm you will get a list of all aliases only, which might be better as a start. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Schwarz, Barry A Sent: Wednesday, July 14, 2010 2:33 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Dataset Aliases - How to find ALL of them In an IDCAMS batch job, not TSO, issue the command LISTCAT CAT(dsn) ALIAS 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 CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains confidential and privileged information intended only for the addressee. If you are not the intended recipient, please be advised that you have received this material in error and that any forwarding, copying, printing, distribution, use or disclosure of the material is strictly prohibited. If you have received this material in error, please (i) do not read it, (ii) reply to the sender that you received the message in error, and (iii) erase or destroy the material. Emails are not secure and can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by email. Thank you. -- 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: Dataset Aliases - How to find ALL of them
-Original Message- From: Tom Marchant >..Data set aliases are required to be defined in the same >catalog as the data set. I would swear that we had an applications manager STEPCAT during a dataset creation to a different catalog than where the alias was defined. Of course, finding it without the STEPCAT was an issue (silly rabbit). Memory may be going bad. Has catalog verification changed/improved? David -- 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: Dataset Aliases - How to find ALL of them
On Wed, 14 Jul 2010 17:29:10 -0400, David Purdy wrote: >-Original Message- >From: Tom Marchant > >>..Data set aliases are required to be defined in the same >>catalog as the data set. > > > >I would swear that we had an applications manager STEPCAT >during a dataset creation to a different catalog than >where the alias was defined. Are you thinking of the alias for the HLQ? That is different from a data set alias. In an SMS environment STEPCAT is not allowed. -- Tom Marchant -- 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: Dataset Aliases - How to find ALL of them
On Wed, 14 Jul 2010 17:27:38 -0400, Scott Rowe wrote: >I think Todd was thinking about catalog aliases, rather than dataset aliases. > Read the "Subject:" line. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Dataset Aliases - How to find ALL of them
-- I would add that this command should be done against your MASTER catalog to get all aliases... This should show you all aliases along with their associated user catalogs. Depending on your system this can be a lengthy output. If you remove the ALL parm you will get a list of all aliases only, which might be better as a start. - I believe the OP was looking for aliases names of individual datasets. 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: Dataset Aliases - How to find ALL of them
I'm well aware of the subject, but he may have missed it. >>> Paul Gilmartin 07/14/10 6:24 PM >>> On Wed, 14 Jul 2010 17:27:38 -0400, Scott Rowe wrote: >I think Todd was thinking about catalog aliases, rather than dataset aliases. > Read the "Subject:" line. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains confidential and privileged information intended only for the addressee. If you are not the intended recipient, please be advised that you have received this material in error and that any forwarding, copying, printing, distribution, use or disclosure of the material is strictly prohibited. If you have received this material in error, please (i) do not read it, (ii) reply to the sender that you received the message in error, and (iii) erase or destroy the material. Emails are not secure and can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by email. Thank you. -- 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: Dataset Aliases - How to find ALL of them
On Wed, 14 Jul 2010 16:33:01 -0500, Tom Marchant wrote: >On Wed, 14 Jul 2010 17:29:10 -0400, David Purdy wrote: > >>-Original Message- >>From: Tom Marchant >> >>>..Data set aliases are required to be defined in the same >>>catalog as the data set. >> >> >> >>I would swear that we had an applications manager STEPCAT >>during a dataset creation to a different catalog than >>where the alias was defined. > >Are you thinking of the alias for the HLQ? That is different from a >data set alias. In an SMS environment STEPCAT is not allowed. > Change that to "was not allowed" because JOBCAT/STEPCAT is no longer allowed period. They were disabled by default at z/OS 1.5 and the ability to use them at all was removed in z/OS 1.7. Goodness IMHO (and please, let's not start the whining about DEFINE PAGESPACE for a target system). Mark -- Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS mailto:mzel...@flash.net Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html Systems Programming expert at http://expertanswercenter.techtarget.com/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Dataset Aliases - How to find ALL of them
I am not sure what the OP meant by "data set alias," or whether we mean the same thing when using this term, so... There are two kinds of aliases. User catalog connector aliases are well-defined in the books, I think, but the "other kind," which I'll call "data set aliases" for now, are not so well-defined if I recall correctly. The VSAM equivalent for what I call a data set alias is a PATHENTRY. (I'm too lazy to search for terms, look up the command syntax today, or test it, so all this is from memory, but you should get the idea anyway.) A user catalog connector alias is created by using: DEFINE - ALIAS(NAME(aliasname) - RELATE(user.catalog.name)) - CAT(master.catalog) A data set alias is created by using DEFINE - ALIAS(NAME(real.data.set.name) - RELATE(other.name.you.want.to.use.for.the.data.set)) - CAT(same.catalog.as.for.real.data.set.name) As you can see, the differences are what you specify as the alias name, what you RELATE the alias to, and where you must place the alias entry. LISTCAT ALIAS will show both kinds. The associations ("related-to") field in the output will tell you what kind of alias it is; if it's a user catalog name, it's a catalog connector alias. Otherwise, it's a data set alias. To find all the user catalog connector aliases in the normal order of catalog search (not what I think the OP wanted, but just to be complete), run a LISTCAT ALIAS ALL against the master catalog. All those associated with a user catalog name are catalog connector aliases. Any others are data set aliases. (If you don't know the names of your catalogs, see the first command below.) To find the data set aliases, run: - LISTCAT USERCATALOG against the master catalog to find all the user catalog entries. - LISTCAT ALIAS ALL CAT(usercat.name) against *each* of the catalogs appearing in the output from the command above. For true user catalogs, this will show only data set aliases. For other master catalogs that are connected to the master catalog (as user catalogs), it will show both user catalog connector aliases and data set aliases. For any catalogs that are not connected to the master catalog, I'm afraid you're on your own so far as finding them goes, but once you find them and IMPORT CONNECT them to the master catalog, the second command above will work. Having completed the steps above, you should have a complete list of every kind of alias entry on your entire system. HTH, -- John Eells z/OS Technical Marketing IBM Poughkeepsie ee...@us.ibm.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Dataset Aliases - How to find ALL of them
On Thu, 2010-07-15 at 07:53 -0500, Mark Zelden wrote: > > Change that to "was not allowed" because JOBCAT/STEPCAT is no longer > allowed period. They were disabled by default at z/OS 1.5 and the ability > to use them at all was removed in z/OS 1.7. Goodness IMHO (and please, > let's not start the whining about DEFINE PAGESPACE for a target system). > > Mark > -- Which is simple to get around with MLA. DEF ALIAS(NAME(PAGE.NEWSYS) RELATE(new.mcat)) DEFINE PAGESPACE(PAGE.NEWSYS.PLPA) - and so on. -- John McKown Maranatha! <>< -- 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: Dataset Aliases - How to find ALL of them
"John McKown" wrote in message news:<1279200787.32235.223.ca...@mckown5.johnmckown.net>... > On Thu, 2010-07-15 at 07:53 -0500, Mark Zelden wrote: > > > > > Change that to "was not allowed" because JOBCAT/STEPCAT is no longer > > allowed period. They were disabled by default at z/OS 1.5 and the ability > > to use them at all was removed in z/OS 1.7. Goodness IMHO (and please, > > let's not start the whining about DEFINE PAGESPACE for a target system). > > > > Mark > > -- > > Which is simple to get around with MLA. > > DEF ALIAS(NAME(PAGE.NEWSYS) RELATE(new.mcat)) > > DEFINE PAGESPACE(PAGE.NEWSYS.PLPA) - > > and so on. > > -- > John McKown > Maranatha! <>< You don't need MLA and a ucat, just define an alias to the target system's mcat. On SYSB: DEF ALIAS(NAME(SYSA) RELATE(SYSA's.mcat)) On SYSB: DEFINE PAGESPACE(SYSA.PAGE.PLPA) - 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: Dataset Aliases - How to find ALL of them
John, I think it should be... DEFINE - ALIAS(NAME(other.name.you.want.to.use.for.the.data.set) - RELATE(real.data.set.name)) - CAT(same.catalog.as.for.real.data.set.name) Regards, John K From: John Eells To: IBM-MAIN@bama.ua.edu Date: 07/15/2010 08:25 AM Subject:Re: Dataset Aliases - How to find ALL of them I am not sure what the OP meant by "data set alias," or whether we mean the same thing when using this term, so... There are two kinds of aliases. User catalog connector aliases are well-defined in the books, I think, but the "other kind," which I'll call "data set aliases" for now, are not so well-defined if I recall correctly. The VSAM equivalent for what I call a data set alias is a PATHENTRY. (I'm too lazy to search for terms, look up the command syntax today, or test it, so all this is from memory, but you should get the idea anyway.) A user catalog connector alias is created by using: DEFINE - ALIAS(NAME(aliasname) - RELATE(user.catalog.name)) - CAT(master.catalog) A data set alias is created by using DEFINE - ALIAS(NAME(real.data.set.name) - RELATE(other.name.you.want.to.use.for.the.data.set)) - CAT(same.catalog.as.for.real.data.set.name) As you can see, the differences are what you specify as the alias name, what you RELATE the alias to, and where you must place the alias entry. LISTCAT ALIAS will show both kinds. The associations ("related-to") field in the output will tell you what kind of alias it is; if it's a user catalog name, it's a catalog connector alias. Otherwise, it's a data set alias. To find all the user catalog connector aliases in the normal order of catalog search (not what I think the OP wanted, but just to be complete), run a LISTCAT ALIAS ALL against the master catalog. All those associated with a user catalog name are catalog connector aliases. Any others are data set aliases. (If you don't know the names of your catalogs, see the first command below.) To find the data set aliases, run: - LISTCAT USERCATALOG against the master catalog to find all the user catalog entries. - LISTCAT ALIAS ALL CAT(usercat.name) against *each* of the catalogs appearing in the output from the command above. For true user catalogs, this will show only data set aliases. For other master catalogs that are connected to the master catalog (as user catalogs), it will show both user catalog connector aliases and data set aliases. For any catalogs that are not connected to the master catalog, I'm afraid you're on your own so far as finding them goes, but once you find them and IMPORT CONNECT them to the master catalog, the second command above will work. Having completed the steps above, you should have a complete list of every kind of alias entry on your entire system. HTH, -- John Eells z/OS Technical Marketing IBM Poughkeepsie ee...@us.ibm.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- 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: Dataset Aliases - How to find ALL of them
On Thu, 15 Jul 2010 09:00:29 -0500, John P Kalinich wrote: > >I think it should be... > >DEFINE - > ALIAS(NAME(other.name.you.want.to.use.for.the.data.set) - > RELATE(real.data.set.name)) - > CAT(same.catalog.as.for.real.data.set.name) > As I remember it also. And the effect of CAT(...) is fairly useless because catalog search will search for the alias in the catalog corresponding to its HLQ, and not find it unless that also happens to be the same.catalog.as.for.real.data.set.name. Or am I missing something? -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Dataset Aliases - How to find ALL of them
In a message dated 7/15/2010 9:04:44 A.M. Central Daylight Time, jkali...@csc.com writes: I think it should be... >> Oh, why not just run Alistar's RCNVTCAT and get a ready made PDS that has all the ALIAS and UCATs? -- 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: Dataset Aliases - How to find ALL of them
Quite right. Sorry 'bout that. John P Kalinich wrote: John, I think it should be... DEFINE - ALIAS(NAME(other.name.you.want.to.use.for.the.data.set) - RELATE(real.data.set.name)) - CAT(same.catalog.as.for.real.data.set.name) Regards, John K From: John Eells To: IBM-MAIN@bama.ua.edu Date: 07/15/2010 08:25 AM Subject: Re: Dataset Aliases - How to find ALL of them I am not sure what the OP meant by "data set alias," or whether we mean the same thing when using this term, so... There are two kinds of aliases. User catalog connector aliases are well-defined in the books, I think, but the "other kind," which I'll call "data set aliases" for now, are not so well-defined if I recall correctly. The VSAM equivalent for what I call a data set alias is a PATHENTRY. (I'm too lazy to search for terms, look up the command syntax today, or test it, so all this is from memory, but you should get the idea anyway.) A user catalog connector alias is created by using: DEFINE - ALIAS(NAME(aliasname) - RELATE(user.catalog.name)) - CAT(master.catalog) A data set alias is created by using DEFINE - ALIAS(NAME(real.data.set.name) - RELATE(other.name.you.want.to.use.for.the.data.set)) - CAT(same.catalog.as.for.real.data.set.name) As you can see, the differences are what you specify as the alias name, what you RELATE the alias to, and where you must place the alias entry. LISTCAT ALIAS will show both kinds. The associations ("related-to") field in the output will tell you what kind of alias it is; if it's a user catalog name, it's a catalog connector alias. Otherwise, it's a data set alias. To find all the user catalog connector aliases in the normal order of catalog search (not what I think the OP wanted, but just to be complete), run a LISTCAT ALIAS ALL against the master catalog. All those associated with a user catalog name are catalog connector aliases. Any others are data set aliases. (If you don't know the names of your catalogs, see the first command below.) To find the data set aliases, run: - LISTCAT USERCATALOG against the master catalog to find all the user catalog entries. - LISTCAT ALIAS ALL CAT(usercat.name) against *each* of the catalogs appearing in the output from the command above. For true user catalogs, this will show only data set aliases. For other master catalogs that are connected to the master catalog (as user catalogs), it will show both user catalog connector aliases and data set aliases. For any catalogs that are not connected to the master catalog, I'm afraid you're on your own so far as finding them goes, but once you find them and IMPORT CONNECT them to the master catalog, the second command above will work. Having completed the steps above, you should have a complete list of every kind of alias entry on your entire system. HTH, -- John Eells z/OS Technical Marketing IBM Poughkeepsie ee...@us.ibm.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- 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 -- John Eells z/OS Technical Marketing IBM Poughkeepsie ee...@us.ibm.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Dataset Aliases - How to find ALL of them
FDR client? FDReport variable DSNALCNT. [snip] TITLE LINE=' : + Datasets having aliases defined' REPORT FIELD=(DSNALIAS, NAME,DSSN,DSNALCNT,RELALCNT) XSELECT DSNALCNT.GT.0 SORTFIELD=(INDEX,DSN),order by ... BREAK=(YES,NO)sub-totals? SUMMARY FIELD=(DSN,BYTES,BYTESUSE) [snip] Runs daily here to generate EXCLUDE DSN= cards for *all* my FDR utilities specifically FdrCopy MOVE TYPE=DSF and FdrAbr DUMP TYPE=ARC that will both trash the aliases when the base dataset is manipulated. --> signature = 6 lines follows <-- Neil Duffee, Joe SysProg, U d'Ottawa, 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: Roy Reynolds [mailto:roy.rey...@uco...edu] > Sent: July 14, 2010 13:54 > Subject: Dataset Aliases - How to find ALL of them > > [snip] > Is there a way to list all the dataset aliases and their target datasets? > [snip] -- 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: Dataset Aliases - How to find ALL of them
FDR client is not enough. FDREPORT is a separate product, included only in an ABR licence (IIRC). Kees. "Neil Duffee" wrote in message news:<7a7b0f9e9f98e0479c437a87af8c7f82013dd...@msmail4.uottawa.o.univ>.. . > FDR client? FDReport variable DSNALCNT. > > [snip] > TITLE LINE=' : + > Datasets having aliases defined' > REPORT FIELD=(DSNALIAS, > NAME,DSSN,DSNALCNT,RELALCNT) > XSELECT DSNALCNT.GT.0 > SORTFIELD=(INDEX,DSN),order by ... > BREAK=(YES,NO)sub-totals? > SUMMARY FIELD=(DSN,BYTES,BYTESUSE) > [snip] > > Runs daily here to generate EXCLUDE DSN= cards for *all* my FDR > utilities specifically FdrCopy MOVE TYPE=DSF and FdrAbr DUMP TYPE=ARC > that will both trash the aliases when the base dataset is manipulated. > --> signature = 6 lines follows <-- > Neil Duffee, Joe SysProg, U d'Ottawa, 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: Roy Reynolds [mailto:roy.rey...@uco...edu] > > Sent: July 14, 2010 13:54 > > Subject: Dataset Aliases - How to find ALL of them > > > > [snip] > > Is there a way to list all the dataset aliases and their target > datasets? > > [snip] > > -- > 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 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: Dataset Aliases - How to find ALL of them
To clarify, FDREPORT is included as a standard feature of ABR but is available as a separately licensed product and now has as a companion product FDRVIEWS. Stephen Mednick Computer Supervisory Services Sydney, Australia Asia/Pacific representatives for Innovation Data Processing, Inc. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Vernooij, CP - SPLXM Sent: Friday, 16 July 2010 4:55 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Dataset Aliases - How to find ALL of them FDR client is not enough. FDREPORT is a separate product, included only in an ABR licence (IIRC). Kees. -- 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: Dataset Aliases - How to find ALL of them
Is this free or bundled with which product? Kees. "Stephen Mednick" wrote in message news:<003a01cb24b8$675335c0$35f9a1...@css.au.com>... > To clarify, FDREPORT is included as a standard feature of ABR but is > available as a separately licensed product and now has as a companion > product FDRVIEWS. > > > Stephen Mednick > Computer Supervisory Services > Sydney, Australia > > Asia/Pacific representatives for > Innovation Data Processing, Inc. > > > > > > -Original Message- > From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf > Of Vernooij, CP - SPLXM > Sent: Friday, 16 July 2010 4:55 PM > To: IBM-MAIN@bama.ua.edu > Subject: Re: Dataset Aliases - How to find ALL of them > > FDR client is not enough. FDREPORT is a separate product, included only in > an ABR licence (IIRC). > > Kees. > > -- > 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 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: Dataset Aliases - How to find ALL of them
Kees, If you're referring to FDRVIEWS, it's a separately licensed product that requires an existing ABR or FDREPORT license. Stephen Mednick Computer Supervisory Services Sydney, Australia Asia/Pacific representatives for Innovation Data Processing, Inc. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Vernooij, CP - SPLXM Sent: Friday, 16 July 2010 5:44 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Dataset Aliases - How to find ALL of them Is this free or bundled with which product? Kees. "Stephen Mednick" wrote in message news:<003a01cb24b8$675335c0$35f9a1...@css.au.com>... > To clarify, FDREPORT is included as a standard feature of ABR but is > available as a separately licensed product and now has as a companion > product FDRVIEWS. > > > Stephen Mednick > Computer Supervisory Services > Sydney, Australia > > Asia/Pacific representatives for > Innovation Data Processing, Inc. > > > > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html