Job locked

ajongba · Post by **ajongba** » Wed May 02, 2007 6:41 am

Hi I m back again
I have a number of jobs that is run by a sequencer job which again is called by a unix script.As i was checking the jobs individually some of these jobs were found to be locked....I tried freeing it from Datastage Director but it did not worked....
Is there anyother way i can unlock the job

Thanks in advance
Ajong.

chulett · Post by **chulett** » Wed May 02, 2007 6:45 am

ajongba wrote:I tried freeing it from Datastage Director but it did not worked....

How exactly did you "try freeing"? And what "didn't work" about it?

ajongba · Post by **ajongba** » Wed May 02, 2007 6:48 am

chulett wrote: How exactly did you "try freeing"? And what "didn't work" about it? ...

I went to the cleanup resource option and tried logging out the particular job but when i do that the status become unavailable but the job is not released.

chulett · Post by **chulett** » Wed May 02, 2007 6:52 am

Sometimes it takes more than that. Search for any entries that mention your internal job number - RT_LOGnnn, RT_STATUSnnn, etc. Release those as well.

Code: Select all

SELECT JOBNO FROM DS_JOBS WHERE NAME = 'YourJob';

ajongba · Post by **ajongba** » Wed May 02, 2007 6:58 am

chulett wrote:

Code: Select all

SELECT JOBNO FROM DS_JOBS WHERE N ...[/quote]

I did get the internal number and tried clearing that too... but nthing happened...it is still locked.... and i m sorry being a standard member i could not see all the select statement...and where do we use the same... :oops:

DSguru2B · Post by **DSguru2B** » Wed May 02, 2007 7:08 am

In the UV prompt from the unix command line (telnet, putty etc.) or DataStage Administrator.
Also, were the jobs locked by your id? If not then you wont be able to 'free' them. Search for DS.TOOLS in the forum, another way of unlocking the jobs.

chulett · Post by **chulett** » Wed May 02, 2007 7:13 am

In the Administrator. Make sure you 'Show All' in both panes and look very closely for relevant entries.

ajongba · Post by **ajongba** » Wed May 02, 2007 7:25 am

chulett wrote:In the Administrator. Make sure you 'Show All' in both panes and look very closely for relevant entries. ...

I did show all in the upper and lower panes at first...I could see the locked jobs....On the upper pane i tried logging out the locked job but did not work...In the lower one inorder to activate the release all option i did show by process and tried that option too ..doesn't seems to be working ... Can we unlock the jobs through Datastage Administrator???

chulett · Post by **chulett** » Wed May 02, 2007 7:48 am

If these are not your jobs you need to do this as dsadm or root. Or have it done by your Administrator.

vishnuhpatel · Post by **vishnuhpatel** » Thu May 03, 2007 1:07 am

ajongba wrote:Hi I m back again
I have a number of jobs that is run by a sequencer job which again is called by a unix script.As i was checking the jobs individually some of these jobs were found to be locked....I tried freeing it from Datastage Director but it did not worked....
Is there anyother way i can unlock the job

Thanks in advance
Ajong.

Simple way is just ask your admin. he can do it easly.

pranabdas · Post by **pranabdas** » Thu May 03, 2007 4:38 am

Hi,

Go to DataStage Director Job Log. From the Lower pane note down your respective job's process number. Now go to Unix, fire the below mention command from command prompt for each job rather process number.

kill < process number >

I think this will work.

Thanks-
Pranab Das

DSguru2B · Post by **DSguru2B** » Thu May 03, 2007 7:01 am

Kill is the last resort. I dont think the OP is out of options. Many ways of doing it and a mere search will reveal all the different ways of doing it besides kill.

ray.wurlod · Post by **ray.wurlod** » Thu May 03, 2007 4:21 pm

If the job is being monitored, if the job is being edited, if the job is running; you do not want to unlock anything. The locks are there for a reason.

ajongba · Post by **ajongba** » Fri May 04, 2007 12:23 am

ray.wurlod wrote:If the job is being monitored, if the job is being edited, if the job is running; you do not want to unlock anything. The locks are there for a reason. ...

How do we know that...the description in the director does not show anything like it is running or being monitoredor being edited.... please guys show me a way out of this.......Maybe at in the end i might have to kill the process.... please suggest

ray.wurlod · Post by **ray.wurlod** » Fri May 04, 2007 2:25 am

The status that you see in the Director (status view or monitor) is a report from a table as at the most recent time that the job updated the table.

If the job has subsequently hung, aborted or been killed, the status is likely to show Running forever, until you might clear the status file.

Any running job will have a process on the operating system that is executing uvsh (or dssh). The remainder of this command line will identify which job is running. Beware that most jobs - those with active stages - will have child processes - if you kill the job process, the child processes turn into zombies, which are very difficult to kill.

DSXchange

Job locked

Job locked

Re: Job locked

Re: Job locked

Re: Job locked

Re: Job locked