Domino and DB2 integration

BackBy — January 24, 2008

These questions are based on 802 - IBM Lotus Notes Domino 8 System Administration Update.

Objective: Domino and DB2 integration
Sub-objective: Understanding DB2 integration enhancements

Single answer, multiple choice

Which of the following is a TRUE statement regarding the processing of SQL transactions against a DB2 Access View?

1. Bulk Update transactions are committed as a single transaction. If the operation fails before all rows are updated, the entire transaction is rolled back and no rows will be updated.
2. Bulk Insert transactions are processed as individual transactions. If the operation fails before all rows are processed, only the rows that were processed before the failure will be inserted.
3. Bulk Delete transactions are processed as individual transactions. If the operation fails before all rows are processed, only the rows that were processed before the failure will be deleted.
4. Bulk Delete transactions are committed as a single transaction. If the operation fails before all rows are processed, the rows that were processed before the failure will be removed, and all other rows in the Delete transaction will contain delete stubs.

Answer:

A. Bulk Update transactions are committed as a single transaction. If the operation fails before all rows are updated, the entire transaction is rolled back and no rows will be updated.

Tutorial:
In Lotus Notes and Domino Release 8, bulk updates/inserts/deletes in SQL transactions that are processed against DB2 Access Views are transactional. This means the entire SQL operation is committed as a single transaction. The entire operation must complete successfully or the operation is rolled back and no rows will be inserted/updated/deleted.

Reference:
Lotus Domino Administrator 8 Help Database Topic: Understanding Domino and DB2

IBM Lotus Notes Domino 8 Reviewers Guide