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
 

 

JCL to list the DASD datasets in seq. file by user id.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Venkat Oruganti

New User


Joined: 29 Jul 2008
Posts: 2
Location: Los Angeles

PostPosted: Tue Jul 29, 2008 6:42 am    Post subject: JCL to list the DASD datasets in seq. file by user id.
Reply with quote

Hi

I have a requirement to list the names of all the datasets(PS,GDG and VSAM files) in a output sequential file. I want only those datasets where any one of the qualifier in the dataset name is mainframe user id.

If i have standard of 5 qualifers dataset name and if any one of the qualifier is mainframe user id or part of the qualifier is mainframe user id, I would like to see that dataset name in the output.

Please provide a JCL/any other way to do this. Thank you.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8118
Location: East Dubuque, Illinois, USA

PostPosted: Tue Jul 29, 2008 7:34 am    Post subject:
Reply with quote

Use DCOLLECT
Quote:
DCOLLECT obtains data on:

* Active Data Sets

DCOLLECT provides data about space use and data set attributes and indicators on the selected volumes and storage groups.
* VSAM Data Set Information

DCOLLECT provides specific information relating to VSAM data sets residing on the selected volumes and storage groups.
* Volumes

DCOLLECT provides statistics and information on volumes that are selected for collection.
* Inactive Data

DCOLLECT produces output for DFSMShsm-managed data, (inactive data management), which includes both migrated and backed up data sets.
o Migrated Data Sets: DCOLLECT provides information on space utilization and data set attributes for data sets migrated by DFSMShsm.
o Backed Up Data Sets: DCOLLECT provides information on space utilization and data set attributes for every version of a data set backed up by DFSMShsm.
and hit the output file with SAS or EASYTRIEVE to extract the data you want. Note: you must be authorized before you can run DCOLLECT; talk to your security people.
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: Tue Jul 29, 2008 7:59 am    Post subject:
Reply with quote

Hello Venkat and welcoem to the forums,

Is the plan to specify only one userid when this process is run?

Quote:
if any one of the qualifier is mainframe user id or part of the qualifier is mainframe user id
To clarify - does this say that any dataset name node could be a userid or that a userid might be embedded in any dataset name node?

It may help if you post some example dataset names for 2 or 3 users and the output you want when this process is run.
Back to top
View user's profile Send private message
Venkat Oruganti

New User


Joined: 29 Jul 2008
Posts: 2
Location: Los Angeles

PostPosted: Tue Jul 29, 2008 8:46 am    Post subject: Reply to: JCL to list the DASD datasets in seq. file by user
Reply with quote

Hi I would like to add an example to my post.

I will mention the user ids in my input file like

WIP123
WIP234
WIP345

I want to get all the datasets when one of these ids embedded in the dataset name.

If I have 5 datasets on the DASD like

1)XXXX.WIP123.XXXXX.XXXXX
2)WIP234.XXXXX.XXXXXX.XXXXXX
3)XXXX.XXXX.XXXXX.XXXXX.XXXXX
4)XXXX.XXXXX.XXXXXX.XXXXXX.WIP345
5)XXXXX.XXXXX.WIP123AB.XXXXX.XXXXX

I would like to get the output like

XXXX.WIP123.XXXXX.XXXXX
WIP234.XXXXX.XXXXXX.XXXXXX
XXXX.XXXXX.XXXXXX.XXXXXX.WIP345
XXXXX.XXXXX.WIP123AB.XXXXX.XXXXX

in a sequential file.

Please post some sample JCLs to achieve this in a typical mainframe environment.

Thank you for your help on this
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: Tue Jul 29, 2008 11:55 am    Post subject:
Reply with quote

Venkat Oruganti

Quote:
Please provide a JCL/any other way to do this. Thank you.


Quote:
Please post some sample JCLs to achieve this in a typical mainframe environment.


please DO NOT ask for code on the forum. This is a help forum, not a 'get it done for free forum'.

Take a look at the code in SYS1.SAMPLIB (IGGCSIRX) which is relatively easy to change to give you exactly what you want.

Documentation for CSI is HERE !
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
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm


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