source code for KeyMgtResetValue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Fri Nov 25, 2005 4:16 pm
source code for KeyMgtResetValue
HI,
Can anyone post the source code for keymgtresetvalue coz i dont have it in the routines in my manager. and also please list the arguments. if that kind of routine does not exist can some one post how to reset the sdk sequences. i tried
UPDATE SDKSequences USING DICT VOC SET F1='0' WHERE @ID='SEQ_NAME';
in the administrator command window.
but its not working. may be syntax or quotes. can some one correct the above line.
thanks in advance.
Can anyone post the source code for keymgtresetvalue coz i dont have it in the routines in my manager. and also please list the arguments. if that kind of routine does not exist can some one post how to reset the sdk sequences. i tried
UPDATE SDKSequences USING DICT VOC SET F1='0' WHERE @ID='SEQ_NAME';
in the administrator command window.
but its not working. may be syntax or quotes. can some one correct the above line.
thanks in advance.
Battleboy,
could you perhaps expand on "It's not working", perhaps with an error message?
The command should work unless the SDKSequences hashed file does not exist or the user executing the command doesn't have sufficient access rights.
could you perhaps expand on "It's not working", perhaps with an error message?
The command should work unless the SDKSequences hashed file does not exist or the user executing the command doesn't have sufficient access rights.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 24
- Joined: Fri Nov 25, 2005 4:16 pm
If it "hangs" then the record is locked by another process. While in the TCL environment do a "LIST.READU EVERY" and see if the there are any locks on the file's inode (you can see the inodes for SDKSequences in the project directory by doing a "ls -i" command.
Perhaps you did an cntrl-c or even a kill -9 earlier on some process that was calling this routine?
Perhaps you did an cntrl-c or even a kill -9 earlier on some process that was calling this routine?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 24
- Joined: Fri Nov 25, 2005 4:16 pm
-
- Participant
- Posts: 24
- Joined: Fri Nov 25, 2005 4:16 pm
there are locks, this is the only reason that an UPDATE command will not return. Try doing a "fuser -fux SDKSequences" to see which processes have that file open. I bet you it will be more than 1.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Even just try
Queries are not affected by row level locks, so you will at least determine that the SDKSequences hashed file exists and is not corrupted.
There is no routine called KeyMgtResetValue supplied with DataStage. The only routines for key management are in the sdk\KeyMgt category of the Routines branch. KeyMgtResetvalue is a routine postulated on this forum - perhaps you could search for it?
Code: Select all
SELECT @ID, F1 FROM SDKSequences USING DICT VOC;
There is no routine called KeyMgtResetValue supplied with DataStage. The only routines for key management are in the sdk\KeyMgt category of the Routines branch. KeyMgtResetvalue is a routine postulated on this forum - perhaps you could search for it?
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.