source code for KeyMgtResetValue

battleboy1 · Post by **battleboy1** » Tue Dec 27, 2005 1:10 pm

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.

ArndW · Post by **ArndW** » Tue Dec 27, 2005 1:16 pm

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.

battleboy1 · Post by **battleboy1** » Tue Dec 27, 2005 1:22 pm

it just hangs

battleboy1 · Post by **battleboy1** » Tue Dec 27, 2005 1:25 pm

i am on developer privileges. but is the command in right syntax. am i missing quotes or need double quotes? would be great of you if you could post the source code for keymgtresetvalue.

thanks

ArndW · Post by **ArndW** » Tue Dec 27, 2005 1:34 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?

battleboy1 · Post by **battleboy1** » Tue Dec 27, 2005 1:36 pm

i am working on windows. but i want to write a routine based on the keymgtresetvalue routine. can you help?

thanks

battleboy1 · Post by **battleboy1** » Tue Dec 27, 2005 1:45 pm

i dont remeber doing a ctrl-c. tell me this thing. i should be executing the command from admin command window right? if yes then i tried from there. there are no locks as i checked.

ArndW · Post by **ArndW** » Tue Dec 27, 2005 2:23 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.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 27, 2005 3:23 pm

Even just try

Code: Select all

SELECT @ID, F1 FROM SDKSequences USING DICT VOC;

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?