Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
boris
Participant
Posts: 19 Joined: Wed Jan 21, 2004 2:51 pm
Contact:
Post
by boris » Wed Jul 07, 2004 1:13 pm
Hi all,
Some of the jobs are getting locked due to temporary network disconnection.How to unlock these jobs? Any clues would be appriciated.
Thanks
kcbland
Participant
Posts: 5208 Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Post
by kcbland » Wed Jul 07, 2004 1:20 pm
Search the forum, this has been covered lots of times.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ketfos
Participant
Posts: 562 Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:
Post
by ketfos » Wed Jul 07, 2004 5:13 pm
Hi,
Go to DataStage Director and choose CleanUp resources.
Select the PID# and Release it.
Ketfos
Bhusan
Premium Member
Posts: 15 Joined: Wed Jul 07, 2004 4:04 pm
Post
by Bhusan » Wed Jul 07, 2004 5:19 pm
If Datastage director cleanup does not release the job, then do a grep on dsapi_slave and find the pid of the process and kill that.
rasi
Participant
Posts: 464 Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney
Post
by rasi » Wed Jul 07, 2004 6:11 pm
goto uv and type DS.TOOLS. A menu will appear and choose 5 from that option which gives you all information about locks.
Rasi
boris
Participant
Posts: 19 Joined: Wed Jan 21, 2004 2:51 pm
Contact:
Post
by boris » Thu Jul 08, 2004 8:05 am
Thanks guys,
It worked.
chucksmith
Premium Member
Posts: 385 Joined: Wed Jun 16, 2004 12:43 pm
Location: Virginia, USA
Contact:
Post
by chucksmith » Thu Jul 08, 2004 10:23 am
Be aware that the DataStage pid only report 6 digit PIDs. On some Unix boxes, I have found 7 digit PIDs. Be sure to use the correct PID. You may want to verify it with a ps -ef .