Page 1 of 1
DS - system files/tables
Posted: Tue Mar 11, 2008 5:17 pm
by Ritesh Vikram
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
Posted: Tue Mar 11, 2008 5:28 pm
by chucksmith
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 .
Posted: Tue Mar 11, 2008 5:51 pm
by ray.wurlod
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.