IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Given DSN belongs to which Team..?


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Anuj Dhawan

Superior Member


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

PostPosted: Fri Apr 11, 2008 7:14 am
Reply with quote

Sameer,

Check this link
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
Quote:
to find which DSN belongs to which team here at my shop?


And what I thought, it happend the same way, I was suggested to do the following
Quote:
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.
and my sentence
Quote:
Ah..it's a donkey's work.

still stands..with grammer/spell correction.. icon_smile.gif, phew all of them are being lazy in updating the sheet even after one week.

does any one has some further suggestion ..?
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Fri May 02, 2008 4:40 am
Reply with quote

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

Moderator Emeritus


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

PostPosted: Fri May 02, 2008 6:05 am
Reply with quote

Hi Anuj,

Quote:
I think, one would say "DSNs are deleted but their catalog entry is not deleted", ritght? If yes, I would like to ask, why would one do this ?
Usually, one does this out of ignorance - they do not know how create proper jcl. Sometimes people try to get too "cute" and create problems by implementing some "trick" they have learned.

Left to themselves, many a system gets out-of-sync. In the pre-sms days, many centers regularly ran jobs to identify catalog entries with no dataset and datasets with no catalog entry. These were then cleaned up. One of the old horror stories is the critical job that cannot allocate a particular output dataset. Seems like a file of that dsn was on every dasd volume . . .
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Fri May 02, 2008 7:20 am
Reply with quote

Hi Dick,

Thanks for Your time... icon_smile.gif

Well, this is little new for me
Quote:
Seems like a file of that dsn was on every dasd volume . .

it's little tricky actually for me to understand, as mine is SMS-shop, this should haapen only on non-SMS site, perhaps I misunderstood something here, please assist.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Fri May 02, 2008 8:00 am
Reply with quote

Hi Anuj,

Quote:
this should haapen only on non-SMS site
As i mentioned, this was in the pre-sms days.

It was quite common for badly written jcl to cause problems. Among the most common was propagating the same dataset across many dasd volumes.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Fri May 02, 2008 8:30 am
Reply with quote

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

Moderator Emeritus


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

PostPosted: Fri May 02, 2008 8:42 am
Reply with quote

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

Superior Member


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

PostPosted: Sat May 03, 2008 4:18 am
Reply with quote

Hi Dick,

I do have a list for cataloged DSNs, how to get the DSNs residing on a given volume, is it IDCAMS?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Sat May 03, 2008 6:30 am
Reply with quote

Hi Anuj,

You can use IEHLIST/LISTVTOC.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Sat May 03, 2008 12:14 pm
Reply with quote

Anuj D. wrote:
Hi Dick,

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

Take a look at IGGCSIRX im SYS1.SAMPLIB - much much easier to use the output from this than from IDCAMS. May need some small changes to get exactly what you want, but it is also much better if you want to use wild cards too.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Mon May 05, 2008 4:26 am
Reply with quote

Hi Anuj,
if you have FILEAID, you can also use it to list the volumes

Code:
//STEP0001 EXEC PGM=FILEAID                                 
//SYSPRINT DD SYSOUT=*                                     
//SYSLIST  DD DSN=OUTPUT DSN,                               
//            DISP=(,CATLG,DELETE),                         
//            UNIT=SYSDA,                                   
//            SPACE=(TRK,(50,10),RLSE),                     
//            DCB=(RECFM=FBM,LRECL=133,BLKSIZE=27930)       
//SYSIN    DD *                                             
$$DD01 VTOCDSN UNIT=3390,DSNAME=*,VOLSER=(CTL0)             
/*                                                         


Above example will list all volumes prefixed with CTL0

Gerry
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts On a team working on a new project fo... All Other Mainframe Topics 2
No new posts Ideas to motivate mainframe team All Other Mainframe Topics 5
No new posts Urgent Mainfram team lead opening at ... Mainframe Jobs 0
No new posts M S Dhoni and the Indian cricket team General Talk & Fun Stuff 7
This topic is locked: you cannot edit posts or make replies. Mainframe Team Lead Requirement In Gu... Mainframe Jobs 0
Search our Forums:

Back to Top