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
 

 

Extract LISTCAT information into DB2 Table or flat file etc.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Frederic Lavoie

New User


Joined: 07 May 2007
Posts: 6
Location: Ottawa

PostPosted: Wed May 09, 2007 12:39 am    Post subject: Extract LISTCAT information into DB2 Table or flat file etc.
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed May 09, 2007 1:39 am    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed May 09, 2007 12:11 pm    Post subject:
Reply with quote

What information do you want to keep about the datasets ?
Back to top
View user's profile Send private message
Frederic Lavoie

New User


Joined: 07 May 2007
Posts: 6
Location: Ottawa

PostPosted: Thu May 17, 2007 1:12 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 17, 2007 3:19 am    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu May 17, 2007 3:21 pm    Post subject:
Reply with quote

IDCAMS DCOLLECT is a far easier way of doing it.
Back to top
View user's profile Send private message
Frederic Lavoie

New User


Joined: 07 May 2007
Posts: 6
Location: Ottawa

PostPosted: Tue May 29, 2007 5:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed May 30, 2007 2:31 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics 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 Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm


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