Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    11

    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?

    RESOURCE UNAVAILABLE
    REASON 00C9008E
    TYPE 00000200

  2. #2
    Join Date
    Jan 2004
    Location
    Europe, Finland, Helsinki
    Posts
    64
    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

  3. #3
    Join Date
    Jun 2004
    Posts
    11
    Thanks! I'll try that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •