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
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How one source columns or rows to be loaded in to two different tables?
Explain how a source file is populated?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the different plug-ins stages used in your projects?
What are some prerequisites for datastage?
What is the purpose of pivot stage and types of containers in datastage
Differentiate between validated and Compiled in the Datastage?
Can you explain tagbatch restructure operator?
What is job control?
Can you define merge?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between an operational datastage and a data warehouse?
Define orabulk and bcp stages?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?