I am not sure why below command hungs in qa project executing through DSADMIN which was working absolutely fine in dev project .
UPDATE SDKSequences USING DICT VOC SET F1 = 'New_Value' WHERE @ID = 'Sequence_Name';
I am not able to update the seqname with new value .
I created the seqname using sdk/KeyMgt/KeyMgtGetNextValue .
Please suggest me .
Thanks
Update to SDKSequences hungs
Moderators: chulett, rschirm, roy
Update to SDKSequences hungs
There is nothing good or bad, but thinking makes it so. --William Shakespeare
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray ,
Nothing .
My main purpose was to start a sequence 'SEQ1' with value other than 1.
Since SEQ1 never created or existed in QA project , i ran KeyMgtGetNextValue routine in QA project and gave test value as 'SEQ1' (for example ) and it returned 1. After this i see SEQ1 listed in SDKSequences.
Before this i tried running the update statement in DSADMIN and it gave message saying SEQ1 does not exist .
I have to mention, after seeing SEQ1 listed in SDKSequences, i tried updating the sequence number more than 5 times and result is the command hungs when i hit "Respond Tab".
After this i had no option other than close the whole window and come out of administrator.
1) Do you think , there is some kind of LOCK on SDKSequences?If yes, how to release ?
2) Can i delete SEQ1 from SDKSequences and use below statement to make an entry in SDKSequences table and value other than 1 ?
INSERT INTO SDKSequences(@ID,F1) VALUES(SEQ1,1000);
Please suggest.
Thanks
paddu
Nothing .
My main purpose was to start a sequence 'SEQ1' with value other than 1.
Since SEQ1 never created or existed in QA project , i ran KeyMgtGetNextValue routine in QA project and gave test value as 'SEQ1' (for example ) and it returned 1. After this i see SEQ1 listed in SDKSequences.
Before this i tried running the update statement in DSADMIN and it gave message saying SEQ1 does not exist .
I have to mention, after seeing SEQ1 listed in SDKSequences, i tried updating the sequence number more than 5 times and result is the command hungs when i hit "Respond Tab".
After this i had no option other than close the whole window and come out of administrator.
1) Do you think , there is some kind of LOCK on SDKSequences?If yes, how to release ?
2) Can i delete SEQ1 from SDKSequences and use below statement to make an entry in SDKSequences table and value other than 1 ?
INSERT INTO SDKSequences(@ID,F1) VALUES(SEQ1,1000);
Please suggest.
Thanks
paddu
There is nothing good or bad, but thinking makes it so. --William Shakespeare
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you've never used it you need to create SDKSequences. Run any of the SDK key management routines from its test grid as the easy way to do so.
Other than that you're right - if the sequence name does not exist in SDKSequences you will need an INSERT statement - normal SQL rules.
Other than that you're right - if the sequence name does not exist in SDKSequences you will need an INSERT statement - normal SQL rules.
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.
This is happening because some other process holds a lock on the record in the file. If you don't know which one that could be, use another command windows or the TCL prompt and issue "LIST.READU EVERY", this is a bit complex to read but, particularly if your system isn't busy, you should be able to find out which 2 processes have that lock open. with "PORT.STATUS" you could find the pid of the "UPDATE..." command process, then cross reference that pid with the lock table.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What happens if you execute ?
Code: Select all
SELECT @ID, F1 FROM SDKSequenes USING DICT VOC;
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.
Thank you ArndW and Ray
ArndW- I did try your command "LIST.READU EVERY" and saw only one PID .
Then i tried to update the sequence name with new value and 1 record was updated in SDKSequences.
Ray - Using your command now i see the new value for the sequence name .
I do not know what happened from yesterday to today , we did not even recycle ETL box .Update statement works absolutely fine now .
Thanks
Paddu
ArndW- I did try your command "LIST.READU EVERY" and saw only one PID .
Then i tried to update the sequence name with new value and 1 record was updated in SDKSequences.
Ray - Using your command now i see the new value for the sequence name .
I do not know what happened from yesterday to today , we did not even recycle ETL box .Update statement works absolutely fine now .
Thanks
Paddu
There is nothing good or bad, but thinking makes it so. --William Shakespeare