I am interested in writing some code that would run against a project and tell me which DS jobs update DB2 tables/fields. Looking at the help screens it looks like the function DSGetprojectInfo/Stage Info and DSJ.Joblist is a starting point. Is it possible to identify stages that load DB2 tables and from there extract the relevant table names and field attributes? Such Metadata would then be held out in a flat file and loaded into a DB2 table itself.
Any help would be greatly appreciated.
Identifying Stages that Populate DB2 Tables
Moderators: chulett, rschirm, roy
Re: Identifying Stages that Populate DB2 Tables
The easiest would be to export your jobs to XML format and write a small parse in java or perl to extract your tables.
Ogmios
Ogmios
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you do write something, make sure it finds any ODBC stage that is writing to a DB2 DSN.
It's not good enough to assert that there aren't any; you can't prevent someone from creating one. Your utility must be able to handle it.
And then there's OLEDB...
It's not good enough to assert that there aren't any; you can't prevent someone from creating one. Your utility must be able to handle it.
And then there's OLEDB...
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.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
As Kim suggests I would use the Reporting Assistant for this. Dump your project data into the reporting Access database, write a query against this database against the DSSTAGES table which can be filtered on StageType to give you the right stages and can show things like TargetFileName and DataSourceName so you can find out where specific tables are used.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Use my List all files and tables used by jobs in a dsx file . You can find it on the DataStage Tools page of www.anotheritco.com.
The input to the tools is a DataStage export file. Just export all job designs only.
The input to the tools is a DataStage export file. Just export all job designs only.
Chuck Smith
www.anotheritco.com
www.anotheritco.com