Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain Quality stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Have you have ever worked in unix environment and why it is useful in datastage?
What is the different type of jobs in datastage?
What is "fatal error/rdbms code 3996" error?
Differentiate between hash file and sequential file?
What is job control?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How we can covert server job to a parallel job?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the main differences you have observed between 7.x and 8.x version of datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How will you move hashed file from one location to another location?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
