Page 1 of 1

DataStage 7.5 Repository directories ...where are they?

Posted: Mon Oct 26, 2015 12:51 am
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?

Posted: Mon Oct 26, 2015 7:15 am
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.