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: 7932
Location: Bellevue, IA

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
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm


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