Hi All,
I got stuck when resetting the value in SDKSequences routine.
I used the below statement in UV environment.
UPDATE SDKSequences USING DICT VOC SET F1='87228' WHERE @ID='<sequence name>';
1. The execution takes too long.
2. The command failed with error -- DataStage/SQL: NOWAIT, Can't lock record, conflict with user "62160".
Please help.
Also, I tried to ran the routine manually and the sequence number is incremental in the output of the routine. But the hash file is not updated.
Please help me to understand why hash file is not updated when routine was run manually?
Thanks
Arif
Help resetting SDKSequences
Moderators: chulett, rschirm, roy
You replied to a thread last touched in 2007. It is better form to create your own thread for a new Problem.
In your case the record is indeed locked by another process. You can use the "PORT.STATUS" command to see which user might be locking the record for your sequence in the SDKSequences file.
In your case the record is indeed locked by another process. You can use the "PORT.STATUS" command to see which user might be locking the record for your sequence in the SDKSequences file.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
... or just wait for someone to come along and split them for you.
Here is the original 11 yeard old topic for reference:
viewtopic.php?t=98814
And since this was your first post, had to guess about your version number. Please feel free to edit your post and correct it if needed.
Here is the original 11 yeard old topic for reference:
viewtopic.php?t=98814
And since this was your first post, had to guess about your version number. Please feel free to edit your post and correct it if needed.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Help resetting SDKSequences
DataStage will not update the hashed file if it cannot lock the record for update.imsularif wrote: Please help me to understand why hash file is not updated when routine was run manually?
2. The command failed with error -- DataStage/SQL: NOWAIT, Can't lock record, conflict with user "62160".
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.