DS - system files/tables

Ritesh Vikram · Post by **Ritesh Vikram** » Tue Mar 11, 2008 5:17 pm

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

chucksmith · Post by **chucksmith** » Tue Mar 11, 2008 5:28 pm

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 .

ray.wurlod · Post by **ray.wurlod** » Tue Mar 11, 2008 5:51 pm

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.