Interested to Buy Any Domain ? << Click Here >> for more details...
job locking methods? How can we unlock the job?
- 3 Answers
- 9425 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is the project in datastage?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
Where do you see different stages in the designer?
What is ibm datastage flow designer?
whats relation between configuration file and datasets?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Where the datastage stored his repository?
What are the different layers in the information server architecture?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is exact difference between Parallel Jobs and server Jobs..
Teradata 
