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 |
How will you move hashed file from one location to another location?
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
what is 'reconsideration error' and how can i respond to this error and how to debug this
what is data mapping
how to find out number of records imported into source file?
What are constraints and derivations?
On which Dimension Table you implemented SCD Type in your Project
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
How do u set a default value to a column if the column value is NULL?
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
What is RCP?