job locking methods? How can we unlock the job?

Answer Posted / sekhar

Follow below steps to unlock all the jobs in a project.
1) Go to the $DSHOME directory and then to bin Directory.

2)Then login to Bin using uvsh like below..

IIS/IBM/InformationServer/Server/DSEngine/bin]$ uvsh

After logged in,the below message will be displayed.

DataStage Command Language 8.7 Licensed Materials - Property
of IBM
(c) Copyright IBM Corp. 1997, 2011 All Rights Reserved.
bin logged on: Thursday, March 06, 2014 18:35

Now Just use the commands as shown below
>LOGTO UV
>LOGTO PROJECT(your Project name as mentioned in Datastage)
>UNLOCK ALL
All the jobs which are locked in that particular project
will be unlocked and below message will be displayed.

Clearing Record locks.
Clearing GROUP locks.
Clearing FILE locks.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is "fatal error/rdbms code 3996" error?

666


Why do we use exception activity in Datastage?

732


What is the difference between passive stage and active stage?

829


What are the job parameters?

712


Describe the architecture of datastage?

574






What is the difference between orabulk and bcp stages?

581


What are the differences between datastage and informatica?

572


Differentiate between odbc and drs stage?

597


Can you define merge?

670


What are iconv and oconv?

779


how to abort the job its matain duplicates?

2112


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

1787


How can you write parallel routines in datastage PX?

623


What is the use of datastage designer?

642


how to sort two columns in single job in datastage.

2549