How to add entry in VOC file
Moderators: chulett, rschirm, roy
How to add entry in VOC file
Hi All,
I am trying to unlock the job from the Datastage shell. It is giving an error as:
Verb "DS.UNLOCK" is not in your VOC.
Is it possible to add an entry into this file? If yes please guide me. Let me know if you require any more information.
I am trying to unlock the job from the Datastage shell. It is giving an error as:
Verb "DS.UNLOCK" is not in your VOC.
Is it possible to add an entry into this file? If yes please guide me. Let me know if you require any more information.
Hi Nick,
CLEAR.LOCKS would clear all the locks but I want to unlock a particular job.
Previously I used to go to the dssh shell and then give
"LIST.READU EVERY" | grep $JOBNAME
from that I find the userno. and atlast I give the UNLOCK command
"DS.UNLOCK USER $USERNO ALL"
I used to pass the jobname as a parameter. This was working fine in the previous DataStage 6.0.1 environment but it is not working in the current DataStage 7.5.2 environment.
So please guide.
CLEAR.LOCKS would clear all the locks but I want to unlock a particular job.
Previously I used to go to the dssh shell and then give
"LIST.READU EVERY" | grep $JOBNAME
from that I find the userno. and atlast I give the UNLOCK command
"DS.UNLOCK USER $USERNO ALL"
I used to pass the jobname as a parameter. This was working fine in the previous DataStage 6.0.1 environment but it is not working in the current DataStage 7.5.2 environment.
So please guide.
Or you can create an entry in VOC
Code: Select all
SET-FILE UV VOC UV.VOC
COPYI FROM UV.VOC TO VOC 'UNLOCK'
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's not the same as the DS.UNLOCK entry, though. Or is it?
Executing an unlock command from the DS.TOOLS menu will catalog the UNLOCK command into your VOC file without your needing to risk corrupting the VOC file with any external operation.
Executing an unlock command from the DS.TOOLS menu will catalog the UNLOCK command into your VOC file without your needing to risk corrupting the VOC file with any external operation.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Nick,
As you said, I tried that before. See the output
DataStage Process and Lock Administration
1. List all processes
2. List state of a process
3. List state of all processes in a job
----------------------------------------------
4. List all locks
5. List locks held by a process
6. List locks held by all processes in a job
----------------------------------------------
7. Clear locks held by a process
8. Clear locks held by all processes in a job
----------------------------------------------
9. Logout a process
10. Logout all processes in a job
11. Clear status file for a job
Which would you like? ( 1 - 11 ) ?6
Enter job name or <CR> for list=J1
Job J1 does not have a status of 'Running'.
Its status is currently 'Finished'. OK to continue? (N):Y
Processes for job J1 are or were:
24751 = sc_EndContInput.CurrentCycleHash.IDENT1 (Finished)
Press any key to return to the menu...
24794 = x2 (Finished)
sc_EndContInput.VerifyDateFormat (Finished)
sc_EndContInput.CheckProcess (Finished)
sc_EndContInput.BuildStartProcStats (Finished)
24957 = sc_EndContInput.BuildEndProcStats (Finished)
====================Locks held by process 24751 (user# -1)====================
No locks or semaphores active.
====================Locks held by process 24752 (user# -1)====================
No locks or semaphores active.
====================Locks held by process 24794 (user# -1)====================
No locks or semaphores active.
====================Locks held by process 24957 (user# -1)====================
No locks or semaphores active.
The output shows that all the locks are released, but actually they are not. I could still see that jobname from option 4:
4. List all locks
This is why I was trying using the DS.UNLOCK command from the dssh shell.
As you said, I tried that before. See the output
DataStage Process and Lock Administration
1. List all processes
2. List state of a process
3. List state of all processes in a job
----------------------------------------------
4. List all locks
5. List locks held by a process
6. List locks held by all processes in a job
----------------------------------------------
7. Clear locks held by a process
8. Clear locks held by all processes in a job
----------------------------------------------
9. Logout a process
10. Logout all processes in a job
11. Clear status file for a job
Which would you like? ( 1 - 11 ) ?6
Enter job name or <CR> for list=J1
Job J1 does not have a status of 'Running'.
Its status is currently 'Finished'. OK to continue? (N):Y
Processes for job J1 are or were:
24751 = sc_EndContInput.CurrentCycleHash.IDENT1 (Finished)
Press any key to return to the menu...
24794 = x2 (Finished)
sc_EndContInput.VerifyDateFormat (Finished)
sc_EndContInput.CheckProcess (Finished)
sc_EndContInput.BuildStartProcStats (Finished)
24957 = sc_EndContInput.BuildEndProcStats (Finished)
====================Locks held by process 24751 (user# -1)====================
No locks or semaphores active.
====================Locks held by process 24752 (user# -1)====================
No locks or semaphores active.
====================Locks held by process 24794 (user# -1)====================
No locks or semaphores active.
====================Locks held by process 24957 (user# -1)====================
No locks or semaphores active.
The output shows that all the locks are released, but actually they are not. I could still see that jobname from option 4:
4. List all locks
This is why I was trying using the DS.UNLOCK command from the dssh shell.
Hi Kumar,
I have given the commands to enter the VOC entry:
When I am executing the command of unlock:
Unlocking all locks for user number 39564
Verb "DS.UNLOCK" is not in your VOC.
Please suggest.
I have given the commands to enter the VOC entry:
It is saying that UNLOCK already exists in the file.>SET-FILE UV VOC UV.VOC
Q-pointer written to VOC file.
>COPYI FROM UV.VOC TO VOC UNLOCK
Record "UNLOCK" already exists in file "VOC"; not COPIED
When I am executing the command of unlock:
See the output :echo "Unlocking all locks for user number $USERNO"
./bin/dssh "DS.UNLOCK USER $USERNO ALL"
Unlocking all locks for user number 39564
Verb "DS.UNLOCK" is not in your VOC.
Please suggest.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: