DB2 integration is quite tricky. Converting a notes database to DB2 is simple. But the impacts can be horrible 
I tried it with a simple database, no problem.
A more advanced database with 350 views didn't work as expected. I was able to open the database but some views won't display.
I got a "index is corrupt...." message when I've tried to open it. Compact, fixup, updall nothing worked. I tried it with 3 different copies, all with the same result.
Either google nor the notes forum had a solution for that problem. Tomorrow I have to test it with some other databases...
0
0
1
3
1 Tim Tripcony Permalink 350 views? Might want to take a look at the application structure to see if that many views are really necessary... performance would typically be negatively impacted even without introducing DB2 into the environment.
2 Urs Meli Permalink Hi Tim
There are lots of personalized views. The performance issues are
the reason, we are looking at a db2 integration. Because of the
query views, we could replace the personalized views
completly.
kind regards
urs
3 bruce lill Permalink I took a sales management db to db2 backend and was able to remove 180 views. I built an embedded view that let the user select how it was categorized and what columns displayed what along with some pre-defined selections. I was able to use one queryview. The support app was easier since it was web enabled you can use the paramters passed to the view to build the query statement. These were both in the 20gb range with over 100k documents. make sure you have enough resoucres and let it have time to build views. I cleared all views with the admin client then left it for a weekend.
4 Urs Meli Permalink I got the error only on 2 views, which in work perfectly on a domino server. It has to be one or more columns.
5 Urs Meli Permalink In the designer client everything is all right. As soon as I open it in notespreview or in the notesdatabase, the error appears. grrrrrr
6 Urs Meli Permalink Yesterday I removed some columns and suddenly the view worked. Now there are only 10 columns. Original view had about 20 columns.
Great. Adding or copying a new column -> index corrupt...
grrr.