Page 1 of 1
Usage Analysis- Manager
Posted: Mon May 21, 2007 2:34 pm
by 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.
Posted: Mon May 21, 2007 3:11 pm
by 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.
Posted: Mon May 21, 2007 9:51 pm
by 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.