Finding Routines used within a job
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
Finding Routines used within a job
Is there a way to list the routines used in a job?
Heck, for that matter, is there a way to programmatically get a list of routines within a project?
I know that I can manually look through a job and manually see routines used in various places (Derivations, Constraints, Stage vars, etc). I was looking for an automated way to get a list of routines within a job.
Thanks for your help,
Tony
Heck, for that matter, is there a way to programmatically get a list of routines within a project?
I know that I can manually look through a job and manually see routines used in various places (Derivations, Constraints, Stage vars, etc). I was looking for an automated way to get a list of routines within a job.
Thanks for your help,
Tony
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For the first you would need to effect a number of queries against DS_JOBOBJECTS - the ROOT record for before/after subroutines, each active stage record for active stages in server jobs, each Transformer stage record for transform functions in server jobs (and others for parallel jobs).
A query on DS_ROUTINES ought to do it for the second.
A query on DS_ROUTINES ought to do it for the second.
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: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
Thanks, Ray.
Interestingly enough, I tried using the manual "Usage Analysis" function within DataStage Manager. I have some routines that I KNOW are used within a UserVariable activity on a Job Sequencer job. When I run the usage analysis on them, nothing shows up.
I appreciate your help.
Tony
Interestingly enough, I tried using the manual "Usage Analysis" function within DataStage Manager. I have some routines that I KNOW are used within a UserVariable activity on a Job Sequencer job. When I run the usage analysis on them, nothing shows up.
I figured that it would be something like that. I know nothing about DS_JOBOBJECTS, so that project may have to wait for another day when I have more time.For the first you would need to effect a number of queries against DS_JOBOBJECTS...
Is there an easy way to get this list out into a file?A query on DS_ROUTINES ought to do it for the second.
I appreciate your help.
Tony
Is there an easy way to get this list out into a file?
One way would be using COMO, found a small discussion on its use here:
viewtopic.php?t=100948
One way would be using COMO, found a small discussion on its use here:
viewtopic.php?t=100948
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The real table name is DS_ROUTINES (all upper case). The UV stage quotes any table name that contains any non upper case (or numeric or underscore) character. Now you know.
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: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA