What is Cleanup Resources and when do you use it?

Answers were Sorted based on User's Feedback



What is Cleanup Resources and when do you use it?..

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.

Is This Answer Correct ?    1 Yes 0 No

What is Cleanup Resources and when do you use it?..

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

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Data Stage Interview Questions

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,


what is the use of invokation id

2 Answers   IBM,


What are the enhancements made in datastage 7.5 compare with 7.0?

0 Answers  


count number of deptno in a emp table?

2 Answers   IBM,


how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,






Define meta stage?

0 Answers  


What are the some differences between 7.x and 8.x version of datastage?

0 Answers  


table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  


what is the use of surogate key in datastage

3 Answers  


Which commands are used to import and export the datastage jobs?

0 Answers  


Does datastage support slowly changing dimensions ?

0 Answers  


Describe routines in datastage? Enlist various types of routines.

0 Answers  


Categories