|
|
| Author |
Message |
Anuj D.
Global Moderator
Joined: 22 Apr 2006 Posts: 2229 Location: Phoenix, AZ
|
|
|
|
Hi,
Problem: How to find which DSN belongs to which 'team' ?
Scenario: Need to delete/minimize the use of datasets which starts with some HLQ.
My approach:
1. List all the datasets starting with some HLQ.
2. I can use LISTCAT LVL(HLQ) ALL to do this, but for me the output is quite nasty, when I'm just intrested to look for only data set names. So I used IKJEFT1A, this solves my problem a bit.
3. Now that some HLQ is used across teams, how to find which DSN belongs to which team here at my shop ?
My senior suggests that create an excel of DSNs starting with that HLQ & send across the team to check which DSN belongs to which Team, then wait for their mail. Ah..it's a donkey-work.
I'm thinking to use SMF records, something on the line of this topic..
http://www.ibmmainframes.com/viewtopic.php?t=29449&highlight=
So I need two suggestions:
1. Is there any alternate way, as I'm thinking to use SMF records, to do this or not?
2. If we can use SMF records, then I'm stuck up here in how to create SMF Data. looked here
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/IEA2G281/2.3.1?DT=20080122045841
but couldn't get a good solution. Please suggest. |
|
| Back to top |
|
 |
References
|
|
 |
dick scherrer
Global Moderator
Joined: 23 Nov 2006 Posts: 8732 Location: 221 B Baker St
|
|
|
|
Hello,
| Quote: |
| how to find which DSN belongs to which team here at my shop |
From smf you might find who (which teams) use each dataset name, but that may not identify which dsn belongs to which team.
One thing you might identify is a list of datasets that have not been referenced for some amount of time - a year, 2 years, 6 months. . . If you circulate a list and want responses, the way that i believe works best is to tell people that "the following datasets will be deleted on mm/dd/yyyy unless you send a reply that the dataset needs to be retained. Before doing anything, get a couple of backups of the potential scratch datasets. If "they" are not required to respond, many will not. . .
| Quote: |
| I'm stuck up here in how to create SMF Data |
I suspect that you will want to read the existing smf data rather than create new smf data. |
|
| Back to top |
|
 |
enrico-sorichetti
Global Moderator
Joined: 14 Mar 2007 Posts: 3168 Location: italy
|
|
|
|
IDCAMS DCOLLECT  |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 3544 Location: Brussels once more ...
|
|
|
|
Yeah, DCOLLECT is not too bad to use and does contain a whole lot more information than LISTCAT.
What about naming standards, as at most shops I've been involved in the naming setup/revamp the HLQ was DEV and the 2LQ was project id, so that makes it easier to identify which group is eating up all the space.
How about migrating datasets to ML2 and then seeing which ones get recalled. Not the most efficient I know, but it can give a good idea of what's going on |
|
| Back to top |
|
 |
Anuj D.
Global Moderator
Joined: 22 Apr 2006 Posts: 2229 Location: Phoenix, AZ
|
|
|
|
Hi,
| expat wrote: |
| What about naming standards, as at most shops I've been involved in the naming setup/revamp the HLQ was DEV and the 2LQ was project id, so that makes it easier to identify which group is eating up all the space. |
Yeah, nearly same way it's here, but for that matter I've to be involved with all the teams & that makes this process 'manual' instead I'm thinking to do it using some JOB, any suggestion for that.
| Quote: |
| How about migrating datasets to ML2 and then seeing which ones get recalled. Not the most efficient I know, but it can give a good idea of what's going on |
I think, as an Application Engineer I'm not autorized to do it, I need to contact my system guys? |
|
| Back to top |
|
 |
skkp2006
Active User
Joined: 14 Jul 2006 Posts: 67 Location: Chennai,India
|
|
|
|
| Quote: |
I think, as an Application Engineer I'm not autorized to do it, I need
to contact my system guys? |
Can you just try the following...
HMIGRATE Command
You use this command to manually migrate a data set. You may want to do this a 'quick fix' to resolve space problems. At its simplest, the 3.4 line command is
HMIG DSNAME(/)
or
HMIG DSNAME(/) ML2 |
|
| Back to top |
|
 |
Anuj D.
Global Moderator
Joined: 22 Apr 2006 Posts: 2229 Location: Phoenix, AZ
|
|
|
|
Hi,
This
works for me without (/). However, would like to know can we use it in Batch? |
|
| Back to top |
|
 |
skkp2006
Active User
Joined: 14 Jul 2006 Posts: 67 Location: Chennai,India
|
|
|
|
Anuj,
Yes, you can run the HSM Dataset Level Command HMIG In batch.
Try this...
| Code: |
//STEP01 EXEC PGM=IKJEFT01
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
HMIG 'SYAM.TEST.FILE1' ML2
/*
// |
I believe that you have'nt lost your memory... ;-)
http://ibmmainframes.com/about23202.html
Syam |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 3544 Location: Brussels once more ...
|
|
|
|
| Unfortunately only if he has ALTER access on the datasets being migrated. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 3544 Location: Brussels once more ...
|
|
|
|
You are obviously suffering from severe mainframe addiction  |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 3544 Location: Brussels once more ...
|
|
|
|
| Quote: |
... ..I'm drinking, eating..& chewing Mainframes...hfff...mercy...God. |
Look on the bright side, it could be UNIX  |
|
| Back to top |
|
 |
Bill Dennis
Senior Member
Joined: 17 Aug 2007 Posts: 313 Location: Iowa, USA
|
|
|
|
anuj,
If all you want are names, use
| Code: |
| LISTCAT LVL(HLQ) NAME |
instead of the ALL parameter. The listing is way fewer lines! |
|
| Back to top |
|
 |
sameer
New User
Joined: 10 Mar 2005 Posts: 33 Location: United States Of America
|
|
|
|
I have a small question, If I want to list datasets starting with specific string is LVL work ?
Ex I have datasets like
MSA0455.FILE1
MSA0465.FILE2
MSA0488.FILE3
MSA0499.FILE4
In the above example, all datasets starting with "MSA04"
I tried with MSA04* in place of HLQ, but its failing. |
|
| Back to top |
|
 |
Douglas Wilder
Active User
Joined: 28 Nov 2006 Posts: 196 Location: Deerfield IL
|
|
|
|
| Listcat uses whole nodes only. LMDLIST LISTID will use partial nodes. |
|
| Back to top |
|
 |
HappySrinu
Active User
Joined: 22 Jan 2008 Posts: 191 Location: India
|
|
|
|
Why don't you try contact your security team either ACF2/RACF team in your shop?
Who ever be the mainframe team, every one should contact them for the access of HLQ for certain teams.
More over they can run a report on certain machine for all HLQ's and owenrs also. I think I have asked that type report before.
Check with you security admins team. |
|
| Back to top |
|
 |
|
|