unlocking jobs

[Mat01]

Hi All,

I have a problem with the unlock command in Administrator. I am issuing the command:

Code: Select all

LIST.READU

to get the Inode of the process I want to clear. But when I do:

Code: Select all

UNLOCK INODE #node_number# ALL

I get the message: "UNLOCK" is not in you VOC file.
I remember that I need to copy something to my VOC file to make it work but I can't recall the exact command. Any idea?

Thanks

Mat

[chulett]

Are you logging in with the administrator user - typically 'dsadm'?

[Mat01]

Yes I am logged in as dsadm. I know when I did this previuosly that I had to type something like COPY SOMETHING TO VOC FILE but I can't remember what...

Thanks

[kduke]

The UNLOCK verb only exists in the UV account. You can copy it by creating a Q-pointer to the VOC in the UV account or you can LOGTO UV.

[Mat01]

I receive the message: "This command is not supported" when I type LOGTO UV. Maybe v7.5 does not support it anymore...

[ray.wurlod]

You can not use LOGTO from the Administrator client. It is one of a select number of commands (HELP is another) that are explicitly blocked.

If you type DS.TOOLS (which brings up a badly-formatted menu) then respond with 5 (which brings up an equally badly-formatted menu), then respond with a zero-length string twice (to exit from the menus), the UNLOCK command should have been installed in your VOC file.

Or you can execute specific commands

Code: Select all

SET-FILE UV VOC UV.VOC
COPYI FROM UV.VOC TO VOC 'UNLOCK'

Otherwise you will need to establish a telnet session to the server machine, and get into the "UniVerse" environment there.

[Mat01]

Thanks all!

Mat

[vsi]

I tried once to unlock a job and it worked fine. But the second time i am not able to go in with the same commands. What i did was


1. Logged in as dsadm
2. went to DataStage home directory.
3. Entered ". ./dsenv"
4. Entered "bin/uvsh".
5. TCL prompt came
6. Entered "LIST.READU EVERY" at TCL
7. Entered DS.TOOLS

All worked well the first time, but second time i am failing with step 7. It gives error "Verb DS.TOOLS is not in your VOC"

[DSguru2B]

Did you try going through the adminstrator and use DS.TOOLS.

[vsi]

Do you mean in the Command (after selecting the project name in Adminstrator)?? I didnt do it in Administrator. I wanted to do it in UNIX. Because once i used the comman LIST.READU and all the jobs just vanished (in the sense were not visible in the Designer, but existed). Luckily it was my personal computer.

[DSguru2B]

The Admin tool is not meant to do this. Hence, doesn't mean we donot use it?

[ArndW]

... Because once i used the comman LIST.READU and all the jobs just vanished...

The LIST.READU command cannot do this, but the DS.TOOLS reindex can do this if you run it while others are working.

[ray.wurlod]

I tried once to unlock a job and it worked fine. But the second time i am not able to go in with the same commands. What i did was


1. Logged in as dsadm
2. went to DataStage home directory.
3. Entered ". ./dsenv"
4. Entered "bin/uvsh".
5. TCL prompt came
6. Entered "LIST.READU EVERY" at TCL
7. Entered DS.TOOLS

All worked well the first time, but second time i am failing with step 7. It gives error "Verb DS.TOOLS is not in your VOC"

This is because you are in the UV account and not in your project. After step 5 (or after step 6) and before step 7 you need to LOGTO your project. The Administrator client is already connected to your project by the time the Command window is opened.

DS.TOOLS exists in each project, but does not exist in the UV account.

[vsi]

Thanks Ray, got it

[vsi]

Hi ray,

Does it affect the working of Datastage if i clear the status of jobs? i guess i used option 11 and now not able to log in.

Thanks