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.
Usage Analysis- Manager
Moderators: chulett, rschirm, roy
Usage Analysis- Manager
Aim high
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
There are some other ways to find the information you want. Kim Duke has posted lot of queries like this. one of them are
This query will search the entire project for the specified string.
These queries wont work in 8x.
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
;
These queries wont work in 8x.