Not sure if this is a bug or how its supposed to work. Could not find any hits on the issue.
While looking into an issue noticed that every tablespace in a particular database was in UTRW status. There was no utility running at the time, anywhere and no stopped utilities with a hanging util-id.
Only utility I could find running against these DB/ts' was COPY.
The COPY is a FULL SHRLEVEL CHANGE using a LISTDEF list.
Looked at the doc for COPY and came across this.....
* If you are copying a list and you specify the SHRLEVEL CHANGE option, you can specify OPTIONS EVENT(ITEMERROR,SKIP) so that each object in the list is placed in UTRW status and the read claim class is held only while the object is being copied.
* The read claim class is briefly obtained for each object during the UTILINIT phase to determine the object size if LIMIT is specified on the COPYDDN or RECOVERYDDN template. This applies only if OPTIONS EVENT(ITEMERROR,SKIP) is specified.
* If you do not specify OPTIONS EVENT(ITEMERROR,SKIP), all of the objects in the list are placed in UTRW status and the read claim class is held on all objects for the entire duration of the COPY.
Our COPY does not have an OPTIONS statement.
-Is there any impact of having all those TS in UTRW status other than preventing another utility?
-It reads like it would be of benefit to add an OPTIONS to reduce the time of the read claim. Anyone have any experience on this?
-Will adding the OPTIONS allow the tablespaces to go back to R/W status?
-Is this behavior a bug? Why would the UTRW status remain after the job successfully ends.
Thank you very much for any insight you can provide.
http://www.medmutual.com [cid:[login to unmask email]
Visit MedMutual.com http://www.medmutual.com
This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential or exempt from disclosure by law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that you are strictly prohibited from printing, storing, disseminating, distributing or copying this message. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Neither this information block, the typed name of the sender, nor anything else in this message is intended to constitute an electronic signature, unless a specific statement to the contrary is included in this message.
Thank you, Medical Mutual.