Check in datastage
Moderators: chulett, rschirm, roy
Check in datastage
Hi
I would like to know if there is a way to lock a job without staying in the designer.
Regards
I would like to know if there is a way to lock a job without staying in the designer.
Regards
Hope This Helps
Regards
Regards
if you intentionally crash out of, lose the network, or similar while having it open in datastage designer it will lock as you without being actively open (alt f4 will do the trick). However, in either case, be aware that its possible to force them unlocked if someone is annoyed. We wrote a job to do just that, because people kept locking by accident. The job locking was never meant to be a surrogate for code check in / check out type locks. If that is what you want it for, there are some tricks for using a code repository with datastage (I found it extremely clunky, but its possible).
our group managed to connect it into microsoft's TFS but it was too clunky to use. There was some direct connect via a third party library or plug in to tfs.
There are all sorts of ways to set something up.
you can export jobs/whatever and save those in any normal repository tool.
you can also use the package deployment system as a repository. Just don't overwrite them, always do a new build and it tracks versions nicely.
The repository tricks don't lock the job. They just do version control. Datastage itself keeps 2 people from editing the same job at once so long as you don't force it and intentionally confuse it. I don't know a way to combine the two. You can do it, but it would be awkward to use. I mean you can probably write something that moves the code in and out of the folders ... force users to check it out which puts it in the repository for editing, check in bundles the changes up to the repository and removes it again... or similar ideas.
My team went with the deployed packages approach. That + nightly backups has been more than enough to keep us out of trouble. And I work at a large place.
There are all sorts of ways to set something up.
you can export jobs/whatever and save those in any normal repository tool.
you can also use the package deployment system as a repository. Just don't overwrite them, always do a new build and it tracks versions nicely.
The repository tricks don't lock the job. They just do version control. Datastage itself keeps 2 people from editing the same job at once so long as you don't force it and intentionally confuse it. I don't know a way to combine the two. You can do it, but it would be awkward to use. I mean you can probably write something that moves the code in and out of the folders ... force users to check it out which puts it in the repository for editing, check in bundles the changes up to the repository and removes it again... or similar ideas.
My team went with the deployed packages approach. That + nightly backups has been more than enough to keep us out of trouble. And I work at a large place.
DS locking is a mostly functional tool to prevent 2 people from editing the same job at the same time. It works for that, more or less -- the biggest issue we have with it is that it can lock you out from the job you were editing (locked by you preventing you from entry) which is mostly caused by even the smallest of network glitches (eg drop a wireless packet is enough, or swapping wired to wireless via docking does it).
I personally would not trust it to keep people out of the code, as it can be bypassed easily -- again, we had to make a job that unlocks it to counter the above network fails, and that was not difficult to do...
It will work, if your team agrees to use it the way you want them to, which is normal for these kinds of tools anyway, most operate on a good faith / honor type system as much as tech.
I personally would not trust it to keep people out of the code, as it can be bypassed easily -- again, we had to make a job that unlocks it to counter the above network fails, and that was not difficult to do...
It will work, if your team agrees to use it the way you want them to, which is normal for these kinds of tools anyway, most operate on a good faith / honor type system as much as tech.
Dastastage can lock jobs to prevent multiple people editing at once. You can manually lock and unlock them yourself, but I am advising against this as a form of code repository control because locks would not always imply repository lock / failure to check the code out, but could be caused by network problems and other issues.