Locked Job

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Locked Job

Post by admin »

Hi all,

What are the options to unlock a locked job?
Do we have to kill all sessions and reset DataStage?

Thanks in advance.

NP
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Nuno:
If youre on UNIX, write yourself the following shell
script to run the DataStage tools program:

UVHOME=`cat /.uvhome`
. $UVHOME/dsenv
cd /DataStage project directory Hi all,
>
> What are the options to unlock a locked job?
> Do we have to kill all sessions and reset DataStage?
>
> Thanks in advance.
>
> NP
>


__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals. http://personals.yahoo.com
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

HI,

If DS server is installed in NT server, the following command can be used to unlock the job.

The command can be executed from client (Provided you connected with
Server) and Server as well.

From the Client:

Login to server through Telnet. (IP address of DS server can be used to
login)

You will be prompted to connect with a particular project then key in project name. You will be in > prompt when you connected with Project.

Then execute the following command to find out user no for the particular job.

LIST.READU EVERY

Find the locked job and get the user no for locked job and execute the following command to unlock the job.

UNLOCK USER ALL

Then the job job would be released. Hope this will help you.

Rgds
Saravanan








"Nuno
Pimenta" To: "LIST-DataStage (E-mail)"
Subject: Locked Job

17-Oct-2001
03:39
Please
respond to
datastage-use
rs

Sender Info:
No Sender
Info found in
the address
Book






Hi all,

What are the options to unlock a locked job?
Do we have to kill all sessions and reset DataStage?

Thanks in advance.

NP
Locked