How to find the table used by datastage jobs.

Saama · Post by **Saama** » Wed Apr 11, 2007 5:22 pm

Hi,

Is there any way to find the table used in datastage jobs (ie) I want to find the dependent analysis.

One of the way is usage analysis, by which dependency analysis can be found.
Another way is by generating report using designer.
Is there any other way to find the dependency analysis .

cheers;
Saama

chulett · Post by **chulett** » Wed Apr 11, 2007 7:07 pm

Yes, there are queries you can run in the Administrator or at a TCL prompt against the DS_JOBS and DS_JOBOBJECTS repository tables. They've been posted here many times, a search for those table names should turn them up. Mostly from our resident guru Mr Kim Duke.

Also, Chuck Smith has a job to parse the information out of a .dsx extract and put it in a database table which I find to come in quite often. Check (from memory) http://www.anotheritco.com - one of his free tools available there for download.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 11, 2007 7:29 pm

What's the problem with Usage Analysis? That's what it's there to do.

Have you not taken appropriate pains with your metadata management?

kduke · Post by **kduke** » Wed Apr 11, 2007 7:49 pm

Try viewtopic.php?t=99349&highlight=Search1