job locking methods? How can we unlock the job?
Answers were Sorted based on User's Feedback
I think this answer might satisfy you..
1.just open administrator
2.Go to projects tab
3.click on command button.
4.Give list.readu command and press execute(It gives you all the jobs status
and please not the PID(Process ID) of those jobs which you want to unlock)
5.Now close that and again come back to command window.
6.now give the command ds.tools and execute
7.read the options given there.... and type "4" (option)
8.and now give 6/7 depending up on ur requirement...
9.Now give the PID that you have noted before..
10.Then "yes"
11.Generally at first time it won't work.. but if we press again 7 then
after that give PID again.. It ll work....
Please get back to me If any further clarifications req
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sreenu
one way is to use open the
xmeta lock info and delete the corresponding record.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
What are stage variables?
How to find value from a column in a dataset?
can explain wt is the pool for file.
Distinguish between informatica & datastage. Which one would you choose and why?
How a routine is called in datastage job?
How to implement complex jobs in data stage?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
What are the some differences between 7.x and 8.x version of datastage?
What are the types of containers and how to create them?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.