Hello All,
I want to know the list of system files/ tables (with their structures) that stores job information ( such as SQLs used in jobs, etc.)
I work on DS server edition.
Ritesh
DS - system files/tables
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
My tool, List all files and tables used by jobs in a dsx file will provide you with information you can use for impact analysis.
You will find it, and other tools, on the DataStage Tools page of www.anotheritco.com .
You will find it, and other tools, on the DataStage Tools page of www.anotheritco.com .
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The structure of the repository is deliberately not published by the vendor, who reserves the right to change it at any time, and has done so in the past. Further, the repository makes use of capabilities such as tables having variant and nested structures, so it is a rather esoteric art to figure out what is going on.
Chuck's toolset is about reporting where particular files/table names are used in jobs in the project; that is the precise purpose it serves. It is NOT about revealing the structure of the repository's "system tables" themselves.
Chuck's toolset is about reporting where particular files/table names are used in jobs in the project; that is the precise purpose it serves. It is NOT about revealing the structure of the repository's "system tables" themselves.
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.