Find job name per project by query on table name

Gaurav.Dave · Posted: Thu Jul 29, 2010 3:48 pm

Hello,

Is there any way we can get list of DataStage jobs name by db2 table of our interest?

We have list of jobs in different folder in our project, and I was trying to get list of jobs which used particular db2 table. I dont want to go by opening and checking each job and looking that table name in all the custom SQL which used inside db2 api stages.

Just wondering if is there any way either via DS Administor command interface or via dsjob.

I appreciate for your time and knowledge sharing.

Thank you,

Gaurav

kduke · Posted: Thu Jul 29, 2010 4:14 pm

Do a search for DsSearch and kduke as the author. If the table name is unique enough then that will work. If your jobs are all PX jobs then there are some jobs in EtlStats to extract some of this information into tables so you can build the relationship between tables and jobs that update them or read from them.

You can use Usage Analysis if you use your metadata properly. Lots of posts on that.

Quick and dirty is use the SQL in DsSearch1.sql in the posts above.