What is Cleanup Resources and when do you use it?
Answers were Sorted based on User's Feedback
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 |
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 |
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
whats difference between ls -ltr and ls -lrt?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
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?
What is the difference between passive stage and active stage?
What are the different type of jobs in datastage?
how many types of remove the duplicate records?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?