Support Article

0-byte pzPvStream column in work object table

SA-27601

Summary



Some pzPvStream columns in a work object table have 0 bytes associated. When attempting to open the work objects, an error appears in the UI: "Caught exception during autocommit check"


Error Messages



caught exception during autocommit check.


Steps to Reproduce



Not Applicable
 

Root Cause



A third-party product issue.

The issue is due to a third party bug. In this case DB2 zOS had an issue where by the LOB data is 'disconnected' from the base table during normal operations when the LOB data is reorganized due to data changes unrelated to the effected table row instance.
Note that this is not an application error. It is only possible for this to happen under the control of the Database Engine.

Resolution



Make the following change to the operating environment:

IBM L2 recommends installation of PTF UI38976. 
 

 

Published September 2, 2016 - Updated September 15, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.