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 |
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
what is operator combinality in datastage?
where the log files or tables can store in DS?
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
Which type of joins Merge stage can support?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
What is RCP?