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

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

---

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

---

What are the types of views in datastage director?

0 Answers  

---

What is audit table?

1 Answers  

---

Can you explain link buffering?

0 Answers  

---

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

---

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

---

What are system variables and sequencers in datastage

0 Answers  

---

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

---

what is .dsx files

3 Answers   IBM,

---

what is a nodemap constraint

2 Answers   IBM,

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---