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?

RESOURCE UNAVAILABLE
REASON 00C9008E
TYPE 00000200

Hi!

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.

Cheers, Bill

ps. See DB2 Utility manuals:

http://publib.boulder.ibm.com/cgi-bi...20030507154051

Thanks! I'll try that.