Somtimes I need to assign a few thousand ID’s ( for copying a chink of records from one environment to another). The way to do this is to incremet the sequence of DB2, assuring that no other client will insert into the ID range that I will get.
When I tried getting a NEXTVAL a few thousand times, I recieved an error.
Today this happened again when I ran a statement to update the sequence to the MAX ID that I created by copying records. According to our DB2 expert, the error was coused by the Toad driver.