If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Image Copy Contention with SHRLEVEL CHANGE

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jun 2004
Posts: 11
Thanks! I'll try that.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On