|
View previous topic :: View next topic
|
| Author |
Message |
ISB
New User
Joined: 15 Feb 2022
Posts: 6
Location: India
|
|
|
|
Hi All,
I need to get a list of all the active VSAMs / PS/ GDGs in the mainframe batch application. I think we can get it from the catalog, but I am looking for a way to extract the whole list of datasets it holds. Possibly an IDCAMS export, backup or SHOWCAT or a LISTCAT parameter might help, but I need to know how to code and execute it. Please suggest.
Thanks,
IB |
|
| Back to top |
|
 |
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1255
Location: Bamberg, Germany
|
|
|
|
| Specify what you want to see from Catalog. Samples always are helpful to help you finding a solution. |
|
| Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009
Posts: 581
Location: London
|
|
|
|
This is impossible to answer without some useful information. There's potentially several ways to do this with different utilities or SMF but it all depends on local knowledge that only people in your local site would know.
What does the application even consist of...one job, or hundreds? How often do they all run?
Is it really ONLY Batch, or are there CICS or other applications using the datasets as well?
Are the datasets identifiable by the dataset names, or part of the names? |
|
| Back to top |
|
|
ISB
New User
Joined: 15 Feb 2022
Posts: 6
Location: India
|
|
|
|
Its a tricky situation actually. I am supporting a migration team and need to prepare a seed list of the files needed to be migrated. But we do not have co operation or support from the local MF team (resistance). We just have an operations team that would try to do the commands we ask them to execute and give us information.
The batch application has hundreds of jobs, that run as part of daily cycle, weekly, monthly, adhoc, triggered, etc. There are online systems and other applications accessing a few of those VSAMs and files as well.
We have prepared a seed list from our target environment's test cycles, but that might not be complete. So I want to get a list of all active / being used files on MF and then find out the missing ones. Just a dump of Catalog might give us many extra, obsolete, unused files. So trying to figure out a way to get list of active ones. |
|
| Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015
Posts: 712
Location: Denmark
|
|
|
|
| I will suggest SMF types 14 and 15, as they will give you the job- and datasetnames for input and output respectively. SMF type 61-6 might be useful too as they deal with VSAM datasets and ICF catalog actions. |
|
| Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015
Posts: 712
Location: Denmark
|
|
|
|
| I will suggest SMF types 14 and 15, as they will give you the job- and datasetnames for input and output respectively. SMF type 61-6 might be useful too as they deal with VSAM datasets and ICF catalog actions. |
|
| Back to top |
|
|
ISB
New User
Joined: 15 Feb 2022
Posts: 6
Location: India
|
|
|
|
| Sure thanks, let me try that. |
|
| Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015
Posts: 712
Location: Denmark
|
|
| Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006
Posts: 2547
Location: Silicon Valley
|
|
|
|
| Quote: |
| in the mainframe batch application |
This term is not clear to me. Are you truly interested in one application among many or are you interested in all batch jobs? |
|
| Back to top |
|
|
ISB
New User
Joined: 15 Feb 2022
Posts: 6
Location: India
|
|
|
|
| all batch jobs |
|
| Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006
Posts: 2547
Location: Silicon Valley
|
|
|
|
Run some IDCAMS jobs. I think you need a multiple step approach:
| Code: |
//STEP2 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
LISTCAT ALIAS
/* |
That should return a list of high level qualifiers. From that list, build another IDCAMS job with a bunch of commands.
| Code: |
LISTCAT LEVEL(PEDRO)
LISTCAT LEVEL(IB)
LISTCAT LEVEL(JEORG)
LISTCAT LEVEL(PETE) |
The LISTCAT command further allows you to select only GDG, CLUSTER or NONVSAM, for example:
| Code: |
LISTCAT LEVEL(PEDRO) GDG
|
You asked for batch jobs... from LISTCAT, you cannot tell if it was for batch or from other usage.
You asked for PS... specifying NONVSAM will give you PS and PDS (maybe others??).
You asked for 'active' datasets. You cannot really determine that through the catalog. Use SMF records as others have recommended. Though, I think the last reference date for PS and PDS is available in ISPF option 3.4. You have to scroll to the right.
The LISTCAT command syntax:
www.ibm.com/docs/en/zos/2.1.0?topic=subcommands-listcat-command
Sample job:
www.ibm.com/docs/en/zos-basic-skills?topic=utilities-idcams-use-access-method-services-catalogs |
|
| Back to top |
|
|
ISB
New User
Joined: 15 Feb 2022
Posts: 6
Location: India
|
|
|
|
| These details are helpful. Thank you all so much ! |
|
| Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
| Quote: |
| The batch application has hundreds of jobs |
You may want to create a list of Datasets used by the Jobs mentioned above.
You can look at the Production Joblib and Proclib datasets.
I am unsure what tools you have available, but XREFPLUS from SEA is very useful at expanding Procs and resolving Symbolic variables. Otherwise you will need to do it yourself (cumbersome).
Then use a series of SORT and Rexx utilities to extract the dataset names from your expanded JCL.
This is another way to identify the 'active' datasets.
This is what we had done to identify usage at a client site.
Just another option. |
|
| Back to top |
|
|
ISB
New User
Joined: 15 Feb 2022
Posts: 6
Location: India
|
|
|
|
yeah, that would have been my approach, but as I said, we dont have support from MF team and cant really get tools to run there. So wanted to explore other options.
Thank you much! |
|
| Back to top |
|
|
|
|
