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.

What are the important features of datastage?

1051

---

What is size of a transaction and an array means in a datastage?

1243

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2227

---

Differentiate between data file and descriptor file?

989

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2407

---

How many types of hash files are there?

1122

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

754

---

Define APT_CONFIG in Datastage?

1022

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2003

---

Distinguish between informatica & datastage. Which one would you choose and why?

954

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3078

---

client know skid info?

2035

---

Which algorithm you used for your hashfile?

1121

---

What is a ds designer?

1025

---

What is the purpose of pivot stage?

1100

---