Given DSN belongs to which Team..?

satya12 · New User Joined: 25 Apr 2006 Posts: 21 Location: India

Hi Anuj

I am working on mainframe apps decommission project.I came accross same situation at the beginning of the project.We have so many old apps sitting on mainframe no idea who is using them.I created a spread sheet with all of the high level qualifiers and sent it to RACF security adminstrator.These guys logs team name and apps steward information whenver they create a Profile.So i got the contact list for each qualifier and dealt with the apps from there.

Hope this helps you.

Thanks
Satya

Anuj D. · Posted: Wed Apr 09, 2008 11:44 am Post subject:

Hi,

I don't have an easy access to these RACF guys, they can be contacted via proper (actually tedious) channel only. However, Thanks for sharing your experience, I'll try it, lets' see what's in store for me..

enrico-sorichetti

there are two maybe three issues discussed on in this thread....

which datasets belong to which teams and the relative security privileges
... ask the security support, they must know

SMF processing...
its a responsibility of the storage support for the sms records related to storage...
a very good tool to analyze smf record os the free:
DAF dataset Audit Facility, by Mke Cleary
File # 094 DAF from Mike Cleary - Dataset Audit Facility NEW
http://www.cbttape.org/ftp/cbt/CBT094.zip
but better search for the latest release

DCOLLECT processing
same as above for responsibilities
a reasonable good tool ( must be reviewed, but a very good starting point )
File # 206 DCOLLECT REXX execs from Linnea Nichols
http://www.cbttape.org/ftp/cbt/CBT206.zip

Remember, with the proper JCL DCOLLECT will collect also the relevant information
from the MCDS to give a proper picture of the datasets/volumes involved

these and lots of other useful stuff at
http://www.cbttape.org

sameer · Posted: Fri Apr 11, 2008 2:30 am Post subject:

Hello Douglas Wilder

Can you please elaborate how to use LMDLIST LISTID ? I basically want to display all datasets start with "MSA"

MSA* is not working when i tried to code LMDLIST in REXX program.

can't this be done using IDCAMS itself ?

sameer · Posted: Fri Apr 11, 2008 4:58 am Post subject:

Douglas Wilder,

Can you please help me how to use LMDLIST LISTID

Any sample code can help me better.

Thanks

Anuj D. · Posted: Fri Apr 11, 2008 7:14 am Post subject:

Sameer,

Check this link
http://www.ibmmainframes.com/viewtopic.php?t=29466&highlight=lmdlist
might help.

Well, my thread is going in different direction...ah

Bill,

Yeah, instead of 'ALL' in LISTCAT 'NAME' gives me enough neat list, but I'm done with the list using IKJEFT1A. Main concern is

Anuj D. · Posted: Fri May 02, 2008 4:40 am Post subject:

Hi,

While working on above requirment LISTCAT gives me some datasets which are not on volume but are in system-catalog..

I mean, LISTCAT shows me these data sets when i execute an IDCAMS JOB but when I try to open them using ISPF 3.4, message is "No data set names found", what should I conclude ?

I think, one would say "DSNs are deleted but their catalog entry is not deleted", ritght? If yes, I would like to ass, why would one do this ?

dick scherrer · Posted: Fri May 02, 2008 6:05 am Post subject:

Hi Anuj,

Anuj D. · Posted: Fri May 02, 2008 7:20 am Post subject:

Hi Dick,

Thanks for Your time...

Well, this is little new for me

dick scherrer · Posted: Fri May 02, 2008 8:00 am Post subject:

Hi Anuj,

Anuj D. · Posted: Fri May 02, 2008 8:30 am Post subject:

Hi Dick,

Agreed, but now how to deal with it now. If they exist with out catalog entry they (might) exist at multiple volumes & they exist physically & "eating" my DASD, I need to "kill" them, but how ?

Please assist.

dick scherrer · Posted: Fri May 02, 2008 8:42 am Post subject:

Hi Anuj,

One way is to create a "list" if all cataloged datasets and the volume where they are cataloged. Then create another "list" gathered from the dasd volumes you are interested - this list would also have dsn and volume. Compare the lists to identify the "orphans".

If there are thousands of dasd volumes and millions of datasets, you may need to break the process into pieces.

Given that most/all of your dasd is sms-managed, the problem should not be large.

Anuj D. · Posted: Sat May 03, 2008 4:18 am Post subject:

Hi Dick,

I do have a list for cataloged DSNs, how to get the DSNs residing on a given volume, is it IDCAMS?

dick scherrer · Posted: Sat May 03, 2008 6:30 am Post subject:

Hi Anuj,

You can use IEHLIST/LISTVTOC.

expat · Posted: Sat May 03, 2008 12:14 pm Post subject: