Find Job Creating The Hash File

jerome_rajan · Post by **jerome_rajan** » Fri Jun 20, 2014 3:46 am

Hi,

One of our client's existing DataStage jobs involves a process that reads from a hash file for a lookup. the hash file's metadata seems to have been manually entered.

I need to find the job that's creating this hash file to make some modifications. Is there a way to do this?

vamsi.4a6 · Post by **vamsi.4a6** » Fri Jun 20, 2014 4:17 am

1)Use MEtadataworkbench tool

or

2)Go to Stage Types->server->select Find where used all types for Hashed File which will not give exact solution for but it will help you.
or

3)In one of the post i read we can use ds_jobs or other hashed files but not sure exactly how to join to answer your question

chulett · Post by **chulett** » Fri Jun 20, 2014 5:56 am

Seeing as how you are saying the metadata was "manually entered" I'm assuming you already tried #2 and it didn't work for you, even if you have the metadata saved in the repository. If I can find my DS_JOB notes, I'll post them but someone like Ray will probably wander by and pony up some search SQL. Eventually.

Worst case, export the project and do a string search in it for the hashed file's name.

jerome_rajan · Post by **jerome_rajan** » Sat Jun 21, 2014 1:41 am

chulett wrote:...
Worst case, export the project and do a string search in it for the hashed file's name.

Why should this be the last resort? Any specific reasons?

chulett · Post by **chulett** » Sat Jun 21, 2014 7:23 am

[shrug] No, not really.

I guess just because it involves exporting the entire project, searching for a string and then working back up from there to find the name of the job. Getting a query against DS_JOBOBJECTS would be much more better.

Or as I've mentioned many times over the years, we automated a process that took the daily project exports and then used jobs we adapted from Chuck Smith's website to parse them into database tables. Then you can easily use SQL to find things of this nature.