DataStage 7.5 Repository directories ...where are they?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
moose2079
Premium Member
Premium Member
Posts: 48
Joined: Tue Mar 07, 2006 4:52 pm
Location: Australia

DataStage 7.5 Repository directories ...where are they?

Post by moose2079 »

I am in a project where they need to setup a baseline

The strategy is to read the DtaStage categories and output category/Job Identifier to use to do single job export commands to GIT(like SVN...release management)

We are on DataStge 7.5 .... the repository is not in DB2 tables ...its in files(uv)

what is the directory to the projects repository ...ie what is the directory for the Categories and Jobs?
YUM
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Everything in your version is in tables, Universe tables as you noted. They're still there in subsequent releases, it's just that there is also an XMETA relational database along for the ride as well. To query these tables, you'll need to connect to the project using uvsh/dssh and then run some SQL like commands. The two primary tables are DS_JOBS and DS_JOBOBJECTS and you can do an exact search here for them to find a plethora of discussions on the subject. One example is here. Sounds like everything you'll need is in the former, the latter is mentioned just for completeness.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply