Client Repository structure in DS server
Posted: Wed Mar 14, 2018 6:14 am
Can we get the Client Repository structure (Jobs folder structure) from DS server (unix)?
DSXchange
A short text to describe your forum
http://www.dsxchange.com/
Client Repository structure in DS server
Page 1 of 1
Posted: Wed Mar 14, 2018 7:05 am
If you just want to create a text dump of the folder structure, then I suppose you could piece it together from a DSX or ISX export file. Is that what you're looking for? What have you tried?
Posted: Wed Mar 14, 2018 7:13 am
If you are just looking for Locations for Jobs and subdirectories, the DataStage hashed file "DS_JOBS" contains that Information.
Code: Select all
LIST DS_JOBS CATEGORY WITH NAME LIKE \...Posted: Wed Mar 14, 2018 7:59 am
My 'Jobs' folder has too many sub folders. I'd like to create same folder structure in my version control tool. Is there any way get it, instead of manual creation?. If my server is also resides in windows, will it be possible?
Posted: Wed Mar 14, 2018 4:50 pm
You could script a line parsing script from the following output:
$DSHOME/../../Clients/istools/cli/istool.sh export -preview -domain $domain:9445 -v -u $user -p $passw -ar /tmp/$projectName.NeverCreatedProjectExportPreview.isx -ds "-incdep $server/$projectName/*/*.*";
That should list each asset in your project. That would include jobs, table def, stage types, build ops, routines, etc... The -preview is the trick you want. It will LIST the contents of the export, but not actually do the export.
You might also want to store those other objects into your external repository so that is why I did not filter them out with the above command.
And yes, I highly recommend storing those into your version control system as well. Routines are just as important as a job when you have to rebuild your environment from scratch.
$DSHOME/../../Clients/istools/cli/istool.sh export -preview -domain $domain:9445 -v -u $user -p $passw -ar /tmp/$projectName.NeverCreatedProjectExportPreview.isx -ds "-incdep $server/$projectName/*/*.*";
That should list each asset in your project. That would include jobs, table def, stage types, build ops, routines, etc... The -preview is the trick you want. It will LIST the contents of the export, but not actually do the export.
You might also want to store those other objects into your external repository so that is why I did not filter them out with the above command.
And yes, I highly recommend storing those into your version control system as well. Routines are just as important as a job when you have to rebuild your environment from scratch.
Posted: Thu Mar 15, 2018 3:23 am
I'm a bit confused; The LIST command I provided gives exactly what the OP wanted. For example in my small test Project, with a bit of formatting in the LIST command:
I don't have any Folders in the original "Jobs", but created a subfolder under "1_Jobs".
Code: Select all
LIST DS_JOBS CATEGORY FMT 64L WITH NAME LIKE \... ID.SUP BY CATEGORY 10:22:07
03-15-18 PAGE 1
Category........................................................
\0_General
\0_General\01_Table Definitions
\0_General\01_Table Definitions\REGTEST
\1_Jobs
\1_Jobs\99_REGTEST
\Jobs
9 records listed.
>
Posted: Mon Mar 19, 2018 11:06 pm
Not confused, just old. Like me. The command line interfaces such as dsjob are now to be the preferred mechanism, against the day that the "UniVerse" engine is dropped.
More on that shortly, once IBM Think 2018 finishes.
More on that shortly, once IBM Think 2018 finishes.