Hi All,
I am maintainig a datastage project that has sequential file stages and oracle stages defined in jobs and not in manager.
As a result, I can't use the manager's "Usage Analysis" to track where a file is created from or a table being used.
Is there a way track usage in this situation?
Thanks.
Tracking file/table usage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Tue Oct 07, 2003 4:55 am
Check out this post. It identifies a tool that Chuck Smith created that can be used to search a project for file or table usage.
Keith
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Keith mentioned my tool that lists all files and tables used by jobs in a dsx file. Just export your job designs and routines with source, then copy this dsx file to your DataStage server. On the DataStage Tools page on my web site, www.anotheritco.com, the second link is the tool Keith mentioned. Import my tool, and run it specifying your dsx file as the input file. The tool produces a file listing category name, job name, file type and direction, and file/table name or user defined sql.
Give it a try, and let me know what you think.
Give it a try, and let me know what you think.
Chuck Smith
www.anotheritco.com
www.anotheritco.com
Guys, you are very helpful. Thank you all very mcuh.
Chuck,
I tried one of your tools, I don't know where to put the search string - For example, I tried to use a string like 'Transformer' in variable StagesTypesOfInterest (assuming this is the search arg) and ran this against the tool's .dsx file but I got no output.
Could you please indicate how to pass a search argument to the program?
Thanks.
ekareem
Chuck,
I tried one of your tools, I don't know where to put the search string - For example, I tried to use a string like 'Transformer' in variable StagesTypesOfInterest (assuming this is the search arg) and ran this against the tool's .dsx file but I got no output.
Could you please indicate how to pass a search argument to the program?
Thanks.
ekareem