Same DB2 Seuuencer in mulitiple jobs

[mary]

Hi all,

If we use the same db2 sequencer to generate the primary key for the one table in multiple jobs which may run at the same time, will create any lock issue or duplicate number generation?

Thanks in Advance

[ray.wurlod]

Maybe. But the locks aren't held for long, so maybe allowing each job to WAIT for any lock on the sequencer to be released would be a sufficient solution.

[kvonhuene]

The sequence object will not get locked, because the DB2 engine will not have any problem handling requests (function call "nextval"). Further, you cannot get duplicates from using "nextval". The only related concern is that the "prevval" function returns the last value without regard to which process got it.