Page 1 of 1

Release a job in DataStage

Posted: Tue Nov 20, 2007 5:03 am
by Mohana Krishnan
Hi,

Can anyone tell me how to release a DS job in Unix.

I tried in DS Director to clean up resource by i could not.

kindly help me out.

Re: Release a job in DataStage

Posted: Tue Nov 20, 2007 5:32 am
by dsusr
If you have dsadm access then either try releasing the job using dssh or thru DS Administrator.

Steps using dssh:-

1) Go to the DSHOME/bin/ directory and get the Userno from the 'list_readu' command.
2) type dssh and use the command LOGTO <ProjectName>
3) Type UNLOCK <Userno>


Steps using DS Administrator

1) Go into Command Line in DS administrator
2) Type DS.TOOLS
3) Choose option 4 i.e Administer Locks
4) Then Choose option 7 to release the locks help by a process
5) Give the Process ID of your job

Regards,
dsusr

Posted: Tue Nov 20, 2007 5:33 am
by ray.wurlod
"Release" has a very specific meaning in DataStage; it means "release (a read-only version-stamped copy of the job) for production". I suspect this is not what you mean.

If you mean deleting a job, then there is no easy way to do it from a UNIX command prompt. There are many interdependencies in the Repository database; you should only delete jobs using Designer or Manager client. And the job must not be in use in any way (open in a client or running).