Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Given DSN belongs to which Team..?
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Apr 03, 2008 12:34 am    Post subject: Given DSN belongs to which Team..?
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Apr 03, 2008 12:45 am    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu Apr 03, 2008 12:52 am    Post subject: Reply to: Given DSN belongs to which Team..?
Reply with quote

IDCAMS DCOLLECT icon_biggrin.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Apr 03, 2008 11:45 am    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Apr 03, 2008 1:47 pm    Post subject:
Reply with quote

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
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Fri Apr 04, 2008 9:00 am    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Apr 04, 2008 12:02 pm    Post subject:
Reply with quote

Hi,

This
Code:
HMIG DSNAME
works for me without (/). However, would like to know can we use it in Batch?
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Fri Apr 04, 2008 12:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Apr 04, 2008 1:02 pm    Post subject:
Reply with quote

Unfortunately only if he has ALTER access on the datasets being migrated.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Apr 04, 2008 1:32 pm    Post subject:
Reply with quote

You are obviously suffering from severe mainframe addiction icon_biggrin.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Apr 04, 2008 3:42 pm    Post subject:
Reply with quote

Quote:
... icon_smile.gif ..I'm drinking, eating..& chewing Mainframes...hfff...mercy...God.


Look on the bright side, it could be UNIX icon_eek.gif
Back to top
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Fri Apr 04, 2008 6:27 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sameer

New User


Joined: 10 Mar 2005
Posts: 41
Location: United States Of America

PostPosted: Tue Apr 08, 2008 10:35 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Douglas Wilder

Active User


Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL

PostPosted: Tue Apr 08, 2008 11:56 pm    Post subject:
Reply with quote

Listcat uses whole nodes only. LMDLIST LISTID will use partial nodes.
Back to top
View user's profile Send private message
HappySrinu

Active User


Joined: 22 Jan 2008
Posts: 195
Location: India

PostPosted: Wed Apr 09, 2008 11:11 am    Post subject: Reply to: Given DSN belongs to which Team..?
Reply with quote

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
View user's profile Send private message
satya12

New User


Joined: 25 Apr 2006
Posts: 32
Location: India

PostPosted: Wed Apr 09, 2008 11:17 am    Post subject: Reply to: Given DSN belongs to which Team..?
Reply with quote

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
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Apr 09, 2008 11:44 am    Post subject:
Reply with quote

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..
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Apr 09, 2008 12:46 pm    Post subject: Reply to: Given DSN belongs to which Team..?
Reply with quote

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
Back to top
View user's profile Send private message
sameer

New User


Joined: 10 Mar 2005
Posts: 41
Location: United States Of America

PostPosted: Fri Apr 11, 2008 2:30 am    Post subject:
Reply with quote

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 ?
Back to top
View user's profile Send private message
sameer

New User


Joined: 10 Mar 2005
Posts: 41
Location: United States Of America

PostPosted: Fri Apr 11, 2008 4:58 am    Post subject:
Reply with quote

Douglas Wilder,

Can you please help me how to use LMDLIST LISTID

Any sample code can help me better.

Thanks
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Urgent Mainfram team lead opening at ... rameshchandra Mainframe Jobs 0 Mon Jul 08, 2013 6:43 pm
No new posts M S Dhoni and the Indian cricket team gcicchet General Talk & Fun Stuff 7 Mon Aug 01, 2011 3:53 am
This topic is locked: you cannot edit posts or make replies. Mainframe Team Lead Requirement In Gu... lokeshmehtacse Mainframe Jobs 0 Sun May 08, 2011 11:02 am
This topic is locked: you cannot edit posts or make replies. Urgent requirement for Team Lead Posi... lokeshmehtacse Mainframe Jobs 0 Thu Dec 09, 2010 6:35 pm
No new posts BUG LOGGING BY TESTING TEAM....Incred... priya_d General Talk & Fun Stuff 0 Mon Jun 09, 2008 1:28 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us