DB2 and Domino - Mini Survival Guide
Bookmark :
Since first experimenting with DB2 as a datastore for Domino, I've learnt alot! I now have a production system which uses a DAV to join data from two separate databases - works very nicely. However, it's taken me quite some time to nurse the whole system into a production ready state. Like with most new and ambitious technologies, as this surely is, the road can be treacherous, especially for Domino people who generally just expect things to work out of the box.
I plan to continually update this page as more tidbits appear from my experience.
Number 1: Don't experiment with unsupported version combinations of Domino and DB2. That's right, I did and regretted it. Stick to IBM Lotus requirements or you'll cry.
Number 2: Do Not, I repeat, Do Not name your Domino Access Views (DAVs) using names or aliases used for any other design elements. This seems to be a bug with Domino 8.02 and DB2 v9.1.300.257 (this combination at least).
Number 3: If you're getting the dredded, incomrehensible CLI errors, which appear to be largely related to view indexes maintained in DB2, you must rebuild view indexes regularly using UPDALL -R which is similar to purging views manually using the Domino Administrator. I have had one instance that even this doesn't work, and a critical view became inoperable with a "General NSF DB2" error when trying to open it. In this case, Copy and Paste the effected view, delete the original and rename the copy to the original name.
Bookmark this page, there's more to come!
-