Page 1 of 1

undo DELETE VOC LOGIN

Posted: Wed Nov 09, 2005 1:11 am
by kzy66w
Hi,


I've executed a DELETE VOC LOGIN as explained in the "DataStage Signal Handling Issue on Solaris" in the dsxchange forum. Now the problem is that I've executed it on an HP machine and now the controlled processes remain as "defunc" processes until the controlling job stops.

Is there a way to add the VOC LOGIN again, or do I need to setup a new Datastage project and copy everything from old to new project.

Thanks & regards
Luc

Posted: Wed Nov 09, 2005 1:26 am
by ArndW
There is no undelete built into the UniVerse files automatically. I don't know the thread where the recommendation is to remove the LOGIN paragraph (I'll have to check that one out to see why), but normally the LOGIN only has a couple of lines that check to see if the process is a PHantom and to disable notification.

The LOGIN paragraph can be copied from another VOC file or entered with the EDITor, there is normally no need for a partial or full restore. Since you were able to DELETE the entry, you can login into the UV system, do so again and enter the command "ED VOC LOGIN", this will put you into the editor.
Then type 'I' and hit return to put you into insert mode and enter the following {remember, case is important}

Code: Select all

PA
IF @TTY NE 'phantom' THEN GO ENDOFPA:
NOTIFY ON
ENDOFPA:


Then type a <CR> on an empty file to get back into edit mode and enter the comman "FILE" and you should be back in business.

Posted: Wed Nov 09, 2005 3:27 am
by ray.wurlod
If you don't want to use ED you can use SQL:

Code: Select all

INSERT INTO VOC (F0, F1, F2, F3) VALUES ('PA', 'IF @TTY NE "phantom" THEN GO ENDOFPA:', 'NOTIFY ON', 'ENDOFPA:'); 

Posted: Wed Nov 09, 2005 3:32 am
by ArndW
I don't know why they used this type of construct with a GOTO; it could just as easily have been programmed as:

Code: Select all

PA
IF @TTY = 'phantom' THEN NOTIFY ON

Posted: Wed Nov 09, 2005 3:37 am
by ray.wurlod
In case they wanted to put in other stuff for interactive processes.

Re: undo DELETE VOC LOGIN

Posted: Wed Nov 09, 2005 5:17 am
by kzy66w
ok Arnd and Ray thanks a lot , this problem is solved now.