var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Image Copy Contention with SHRLEVEL CHANGE
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?
Do you have WHERE clause in your DELETE FROM? If not and the target object is a segmented table space, SHRLEVEL CHANGE does not allow you to concurrently execute this DELETE. You must include WHERE clause.
ps. See DB2 Utility manuals: