Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


job locking methods? How can we unlock the job?

Answers were Sorted based on User's Feedback



job locking methods? How can we unlock the job?..

Answer / mohammadsadiq

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

job locking methods? How can we unlock the job?..

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

job locking methods? How can we unlock the job?..

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

Post New Answer

More Data Stage Interview Questions

What are the partitioning techniques available in link partitioner?

0 Answers  


Which algorithm you used for your hashfile?

0 Answers  


What is the difference between datastage and datastage tx?

0 Answers  


what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,


Unix command to view the data in a dataset

2 Answers   IBM,


how to call sequential generator in datastage?

1 Answers   IBM,


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  


Describe routines in datastage? Enlist various types of routines.

0 Answers  


Lookup constraints

0 Answers   CTS,


how to convert rows into columns

2 Answers   IBM,


What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  


Categories