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.
-
- 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?
-
- Participant
- Posts: 24
- Joined: Fri Nov 25, 2005 4:16 pm
-
- Participant
- Posts: 24
- Joined: Fri Nov 25, 2005 4:16 pm
-
- 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.