Job search query

vikas gupta · Post by **vikas gupta** » Tue Mar 01, 2005 3:06 am

Hi,

How I will find out those jobs names, which are using given column name. Suppose column name is Satus then which jobs are using this column.

Regards

Vikas Gupta

roy · Post by **roy** » Tue Mar 01, 2005 6:16 am

Hi,
search this forum some code was givven to query Ds repository in hte past that might answer your need.

by the way although it might not be 100% what you need you could try using the usage analysis from DS maanger to try find all jobs using a specific table definition (but it is not a search by column name used in jobs)

IHTH,

dsxuserrio · Post by **dsxuserrio** » Tue Mar 01, 2005 7:21 am

Here is a crude nonelegant way in case you just want to do it anyway.
Generate reports for all projects and store in a windows folder.
Do you search with column name in the text string.

ArndW · Post by **ArndW** » Tue Mar 01, 2005 7:43 am

Hello Vikas,

In addition to what has already been suggested, you can use the reporting assistant in the manager for a detailed analysis, or even right-click on the table name (again in the manager) to get a usage report, that will tell you which job use the metadata from that table - this method works only if the column name wasn't manually entered in a design.

You can also do a full project export in either .dsx or .xml format and search within those text files for occurrences of your columns of interest; this doesn't really work well if your column name is something like "a"

.

sachinkc · Post by **sachinkc** » Tue Mar 01, 2005 9:44 am

I think I've replied to a similar question before and it has been discussed a lot in this forus. Export out as XML, parse it by some XSL parser or any Javadoc kind of utility. Its very flexible this way.

- Sachin

ArndW wrote:Hello Vikas,

In addition to what has already been suggested, you can use the reporting assistant in the manager for a detailed analysis, or even right-click on the table name (again in the manager) to get a usage report, that will tell you which job use the metadata from that table - this method works only if the column name wasn't manually entered in a design.

You can also do a full project export in either .dsx or .xml format and search within those text files for occurrences of your columns of interest; this doesn't really work well if your column name is something like "a" .

chucksmith · Post by **chucksmith** » Tue Mar 01, 2005 10:39 am

You can use my Search a dsx file for a sting tool. Export your job designs, then copy the dsx file to your DataStage server. Run the tool, giving the dsx file name and column name as parameter values. The tool will give you a list of categories and jobs that include the string (your column name).

You may find the tool on the DataStage Tools page of www.anotheritco.com.

chulett · Post by **chulett** » Tue Mar 01, 2005 10:44 am

I almost posted the link for you, Chuck.

ketfos · Post by **ketfos** » Tue Mar 01, 2005 11:29 am

Hi,
Do you have Metastage tool?
This will be of help for you to find out column names used in different jobs.

Ketfos

kduke · Post by **kduke** » Tue Mar 01, 2005 2:01 pm

Take a look at this viewtopic.php?t=89892 Couple of options here.

kduke · Post by **kduke** » Tue Mar 01, 2005 2:02 pm

If you use Reporting Assistant then the table is DSColumns.

kduke · Post by **kduke** » Tue Mar 01, 2005 2:08 pm

If you want to extract all the columns using a DataStage job then download DsRepository.zip on my tips page. There are dsx files in there and some setup work to make of it work but the next time you have this issue then you can get an answer a lot quicker.

trokosz · Post by **trokosz** » Wed Mar 02, 2005 9:23 pm

The person indicating the use of MetaStage is right on....This will allow you to perform an impactanalysis of where columns are used in what Projects and what Jobs. In addition if you use the specific MetaBrokers to your situation (e.g,, ERwin, Business Objects, Cognos, and so on) then you can know the columns not only in DataStage Jobs but what Business Objects, for example, reports use these columns.