View previous topic :: View next topic
|
Author |
Message |
Frederic Lavoie
New User
Joined: 07 May 2007 Posts: 6 Location: Ottawa
|
|
|
|
I would like to listcat thousands VSAM and NONVSAM files and keep an historic of that information. I figure that once I listcat them all into one file, then I can extract all the information and then load tables in DB2 and query these tables in the future. I have to write a program to extract that information from the listcat output.
Before writing the program, I would like to know if something exists before. If any other tool can be used to extract the information. Is there any CLIST or REXX that already exist? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If you look at the bottom of this topic that was active earlier today, you may find something that gathers the data you want.
http://ibmmainframes.com/viewtopic.php?t=20670
It is not exactly what you want, but might be a good start - this was to delete rather than capture info, but the first part of the delete was to obtain the names and then format the delete statements. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
What information do you want to keep about the datasets ? |
|
Back to top |
|
|
Frederic Lavoie
New User
Joined: 07 May 2007 Posts: 6 Location: Ottawa
|
|
|
|
expat wrote: |
What information do you want to keep about the datasets ? |
I would like to extract as much information from the listcat as possible to archive them every weeks. Then later have historic to query against and I'm talking about 400,000 vsam file. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Have you defined what information you want to capture and how you want to use it? There may be other ways to approach what you want (rather than listcat, unless you know that is exactly what you want and it is all in the listcat output). If you want to track when files are deleted or the times it is updated, that info is not in a listcat.
Depending on what you want and what use it will be may help determine what type of process you implement. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
IDCAMS DCOLLECT is a far easier way of doing it. |
|
Back to top |
|
|
Frederic Lavoie
New User
Joined: 07 May 2007 Posts: 6 Location: Ottawa
|
|
|
|
expat wrote: |
IDCAMS DCOLLECT is a far easier way of doing it. |
I do not have access to run it the Security group do not want to give me access.
Code: |
TSS7250E 136 J=IDCAMS A=userid TYPE=IBMFAC RESOURCE=xxxx.xxx.DCOLLECT
TSS7251E Access Denied to IBMFAC <xxxx.xxx.DCOLLECT>
|
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You might talk with your storage management people and see if there is something already being done that you could use or add to to get the data you want. You might also taks with your system support people.
If there is not something you can use to meet your requirement, i'd suggest you report this to your manager and if the organization wants this functionality, you will need to be given access or some other group will need to have it set up as a production job.
My guess is that the security people didn't create this rule, but are following some already established rule. |
|
Back to top |
|
|
|