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
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Define orabulk and bcp stages?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How many areas for files does datastage have?
What are the main features of datastage?
how to implement scd2 in datastage 7.5 with lookup stage
What are the types of hashed files in data stage
What are the types of jobs we have in datastage?
How a source file is populated?
Describe link sort?
how to export or import the jobs in .ISX file
sed,awk,head
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
AGGREGATOR default datatype
