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
What is "fatal error/rdbms code 3996" error?
Why do we use exception activity in Datastage?
What is the difference between passive stage and active stage?
What are the job parameters?
Describe the architecture of datastage?
What is the difference between orabulk and bcp stages?
What are the differences between datastage and informatica?
Differentiate between odbc and drs stage?
Can you define merge?
What are iconv and oconv?
how to abort the job its matain duplicates?
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?
How can you write parallel routines in datastage PX?
What is the use of datastage designer?
how to sort two columns in single job in datastage.