Answer / shar

It is like:
1)When we want to clean DataStage Repository.
2)when we are trying to use a job then we get a message
telling error : job jobnumber is being used by another user.
we get only read only mode to use it.
it is being protected by a lock.
so if we want to use job we need to unlock it.
3)If a job is hanging or failing and not releasing locks :
4)to stop a job when its status is running.
Then go to Director (but not to Administrator) and select
the job u want to access and go to job menu where u will
find clear up resources option.
clicking it u will be shown a window where u will see to
panes top(processes) and bottom(locks).

here we can view and end job processes
and release the associated locks.
select a process which holds a lock and click logout.
by doing so we can unlock a job.

Actually a job can be used only by a single user at a time.

Answer / santhu

When we want to kill the process in unix we need clean up resources.
Actually to kill any process we need process id. Then this option is available in administrator then we have to check the option called clean up resouces

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

---

What is datastage engine?

0 Answers  

---

What all the types of jobs you developed?

0 Answers  

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

what is sparse lookup?

7 Answers   IBM,

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

how to convert rows into columns

2 Answers   IBM,

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

what is repositery?

0 Answers   IBM,

---

How many types of views are there in a datastage director?

0 Answers  

---

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

---