Community

Reading committed records without locks

(Craig Mullins) We have an issue in our OLTP and Datamart 24/7 design (both on DB2 UDB V8.1 on AIX). While running ETL against the OLTP database, if the ETL process uses “Cursor Stability” isolation, it potentially locks out other users. So we changed isolation to “Uncommitted Read.” This added a ne

Read More - Register for Free Membership

Tags: