I have a image copy running against a table with 64 rows. Another process periodically reloads/refreshes the table using a "Delete from" followed by 64 inserts.
Once in a while, I get an abend due to contention between these two jobs. the Image copy completed, the refresh job abended.
I thought that an Image Copy using SHRLEVEL CHANGE would do a "dirty" read and just copy what was in the table at the time. Not cause a problem with contention by locking out other jobs.
Why do I get contention?