I have a requirement for generating unique numbers and I am using DB2 sequence object.
My sequence object is defined like this:
CREATE SEQUENCE MYSEQUENCE
START WITH 1
INCREMENT BY 1
Now my question is what happens when two different processes
request for this sequence number?
Is there a possiblility that DB2 will generate the same number?
In that case there can be an error of duplicate rows as this sequence number will be used to insert in a table as the key.