We have a requirement as follows:
A surrogate key (primary key) needs to be generated for an Exception table.
Our jobs reference a shared container which inserts this surrogate key (using surrogate key generator and lookup to MAXVAL) into the table. But this inhibits us to run our jobs in parallel because we are using an ODBC stage to do so.
We were thinking of using the DB2 Identity column to achieve this purpose of running our jobs in parallel.
We can only use DB2 API stage and we can't use a DB2 sequence object.
What do you guys think? Will using an identity column help us run our jobs in parallel?
Thanks
![Smile :)](./images/smilies/icon_smile.gif)