|
View previous topic :: View next topic
|
| Author |
Message |
Venkat Oruganti
New User
Joined: 29 Jul 2008
Posts: 2
Location: Los Angeles
|
|
|
|
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 |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Venkat Oruganti
New User
Joined: 29 Jul 2008
Posts: 2
Location: Los Angeles
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
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 |
|
|
|
|
