content_image/982419.jpg
This notify message traffic introduces another overhead for GBP-dependent indexes that use fast index traversal in a Db2 data sharing environment. In our test scenarios, notify message traffic was observed to be approximately 10 sends and receives every second, compared to approximately 1.5 sends and receives per second for the tests in which fast index traversal was disabled, as shown in Figure 2-4. 

<img src='content_image/982419.jpg'>

The observed total Db2 CPU time per commit (which includes class 2 CPU time and MSTR, DBM1, and IRLM address CPU time) shows a 2% reduction when fast index traversal is enabled (and used), compared to when fast index traversal disabled. The ITR of the data sharing group improved by 1.3% with fast index traversal enabled. 

