Tracking file/table usage

[ekareem]

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.

[Amos.Rosmarin]

Hi

The best way will be to use metastage,
Another option is to use the job export file (you can use either the dsx or xml) and then analyze it.


HTH,
Amos

[kduke]

Another option is Reporting Assistant.

[KeithM]

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.

[ray.wurlod]

If you Save the column definitions from your jobs to the Repository, Usage Analysis should be able to report on them.

[chucksmith]

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.

[ekareem]

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