Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
SGT
Participant
Posts: 9 Joined: Tue May 04, 2004 12:57 pm
Post
by SGT » Tue May 04, 2004 1:03 pm
I need to find out all the jobs in a project which accesses a particular Database table.
What is the easiest way to get this list?
Thanks,
SGT
kduke
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Post
by kduke » Tue May 04, 2004 3:10 pm
You need either Reporting Assitant or MetaStage. Do a search. Both have been covered. Let us know if you still cannot figure it out.
Mamu Kim
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue May 04, 2004 3:14 pm
Failing that, you could also export the project and then search for the table name in the file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue May 04, 2004 4:42 pm
It gets really ugly if the table names are job parameters!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
mhester
Participant
Posts: 622 Joined: Tue Mar 04, 2003 5:26 am
Location: Phoenix, AZ
Contact:
Post
by mhester » Tue May 04, 2004 4:50 pm
If you have followed some kind of standard for naming and saving table definitions you might try usage analysis for Manager. You can right click on an object and choose usage analysis. Maybe this will help you too.
Regards,
Michael Hester
SGT
Participant
Posts: 9 Joined: Tue May 04, 2004 12:57 pm
Post
by SGT » Tue May 04, 2004 6:48 pm
Unfortunately there is no proper standard where we used table definitions. But the table names are hardcoded.
rasi
Participant
Posts: 464 Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney
Post
by rasi » Tue May 04, 2004 7:40 pm
If the table is hardcoded then the best way is to export to dsx file and search for the table name to get the jobs used for that particular table.
Siva
kduke
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Post
by kduke » Wed May 05, 2004 8:03 am
The tablenames are stored in either DSLinks.InpTableFileSPName, DSLinks.OutputFileSPName in the doc_tool.mdb or in DSProperties.PropValue where PropName like "TABLE*" or *TABLES".
If you need more then let me know.
Mamu Kim