I'm looping thru a collection of records gotten from a SELECT statement on a DB2 table and from each of these records I'm inserting a new row in the same table. First I do the SELECT query, add each row's info to a java collection, then go thru the collection and for each object in the collection I call an insert method which inserts a new row (not a duplicate, I've changed some of the key info) in the same table that I did the SELECT on.

From my debug code I seem to be going thru the right methods the right number of times and not generating any errors, but it's not inserting the rows in the table and when I try and access the table after I've run the routine I get the following error:
Unsuccessful execution caused by deadlock or timeout. Reason code "00C9008E"

Depends on your instalation setting you have to make commits after some number of inserts (updates, deletes).

Lenny

00C9008E is a lock timeout. Do you have multiple connections or just 1?