Notes Some Frustrations

I have spent the last few weeks trying out nsfdb2 on a Domino 8 server. Its a secondary task hence the time taken so far. With the use of a excellent powerpoint from Lotussphere (link to follow) I installed a DB2 and Domino 8 server on a Virtual WIn 2003 server). I got this working and then attempted to port a couple of apps to DB2 format using the appropriate compact command. For a simple application this worked fine but the compact failed on a larger application. The error message received on teh console was weird and not entirely helpful! See here for my Notes.net posting . many thanks to Bruce Lill for his helpful responses. It turns out that I had to replace the design of the database with a standard template, convert to DB2 and then replace design with proper one.

After this the database was using DB2 as its backend. The server showed the file on the file system as just 5kb for a 1GB database!

I then created some access views and was able to get our Cognos expert to connect to these views and import into cubes etc for Business Intelligence. All good.

Next step was to try out whether we could maintain our main apps on a Domino 7 server but have a replica on the 8 server (using DB2) for reporting purposes. Today got the 7 server installed and successfully created a replica from the DB2 version . Not tested in any depth but seems to work fine.

I do have some other questions though...

1) Is there a way of accessing DB2/400 data from a query view in Notes?

2) Could a RPG program write out directly to the DB2 access view and 'create' notes documents?

Anyone used nsfdb2 to exchange data with an iseries?