Usage Analysis- Manager

[nkln@you]

I am trying find out the places in a project where a table by name EDWADM.STAGE_END_USER i used. When I used Usage Analysis, nothing is being shown though there are jobs which use this table.

Any thing extra steps should I take care.

[ray.wurlod]

There are steps that you should have taken.

Diligent and systematic management of table definitions.

Usage Analysis relies upon the linkage between the Repository and the job design being maintained and preserved. In short, this means that you import table definitions into the Repository and load these into jobs, or you save table definitions created during the design process into the Repository from the links where they were created, and you NEVER edit the table definition within the job design without saving.

Without these linkages intact you can not get Usage Analysis to work.

[DS_SUPPORT]

There are some other ways to find the information you want. Kim Duke has posted lot of queries like this. one of them are

Code: Select all

SELECT 
   DS_JOBS.NAME AS JOB_NAME, 
   DS_JOBS.CATEGORY, 
   DS_JOBOBJECTS.NAME AS OBJECT_NAME, 
   DS_JOBOBJECTS.OLETYPE, 
   EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOURTABLENAME',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L'
FROM 
   DS_JOBS, 
   DS_JOBOBJECTS 
WHERE 
   DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO 
   and FOUND = 'FOUND'
GROUP BY
   JOB_NAME, 
   DS_JOBS.CATEGORY, 
   OBJECT_NAME, 
   DS_JOBOBJECTS.OLETYPE, 
   FOUND
;

This query will search the entire project for the specified string.

These queries wont work in 8x.