DSXchange

Hi - How can I find about which all job's are using a particular file? I know that dssearch can be used to find the jobs but how do I do for the files???

I prefer to use Usage Analysis on the table definition imported from the file. But, then, I am rigorous in preserving the links between the table definitions and the jobs that use them. Are you?

Hello Ray,

Could you explain me how we can find the job, if the meta data or table definition is not imported? And they have been hard coded mannually?

Is t here any other option in DataStage 7x (Server Jobs) ratherthan Usage Analysis?

Thanks in advance for your inputs.

[quote="ray.wurlod"]I prefer to use Usage Analysis on the table definition imported from the file. But, then, I am rigorous in preserving the links between the table definitions and the jobs that use them. Are you? ...[/quote]

One way would be to export the project and then manually search the dsx file. Or use a utility like Chuck Smith and others have built to help in the search.

As Craig suggests, I have used 'List all files and tables used by jobs in a dsx file' tool (!!) to good effect.

Yup, we load the output into an Oracle table so we can query it.

If by file you mean a Sequential File stage as input/output then this may save you a step;