To ensure the integrity of your application and cube data, update it only through the Application Manager and other clients and applications. Although it is possible to update the relational tables that DB2 OLAP Server creates using SQL, it is not recommended.
You can set the isolation level that you want DB2 OLAP Server to use when you work with your relational database to control how the relational database locks data and handles concurrent data access. For more information about setting an isolation level, see ISOLATION.