Urs Meli

Yesterday I made NSFDB2 working on my test servers. I had this strange errormessage: "Error managing DB2 groups....DB2 Authorization violation" when I tried to compact a database to DB2.

I did the installation 3 or 4 times. DB2 enable ran successfull but compacting never succeeded.  After checking every parameter several times I found the mistake. I entered a path for the "DB2 datastore directory". When I removed the entry for this field, compacting ran without issues.

Short tipp: If you plan to enable db2 on a remote server, don't start the local DB2 command center.

I did it to test the connection between my domino server and the db2 server. Afterwards I was not able to enable the db2 on the domino server.
I got a strange communication error. And some hint about the catalog.

So I started the command center, removed my db2 node from the list. Tada! Now I could enable  the db2 on my domino.

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...