DSXchange

I would like to find all the jobs having a particular field.
Would like to know which internal Datastage Hash file should I search to get the same?

Note: Cannot use Datastage manager for Usage analysis as Metadata management(Table Definitions) are not maintained properly.

But you can use the Reporting Tool, which will transfer all actual available metadata to a Database which you can analyze the way you like it.

WoMaWil wrote:But you can use the Reporting Tool, which will transfer all actual available metadata to a Database which you can analyze the way you like it.

Metadata/table definition is

NOT

maintained properly. So reporting tool won't help.

Reporting Tool not equal Usage Analysis. Two different things.

You could also find posts from Chuck Smith and get his free utility that would help in this effort. The URL is www.anotheritco.com from what I recall.

Select the table definition in which the field occurs and perform a usage analysis on it. When a usage analysis is performed on a table definition it reports the columns from that table definition that are actually used in the job. Having performed the usage analysis, go to its File menu and choose View HTML.