We are trying to align our Lotus Domino database with a DB2 database.
The DECS is installed, and using the “External Database Source” tag in field properties, we have been able to see changes to Notes documents in the DB2 table.
However, the reverse has become rather difficult. I would appreciate any help trying to help me understand better how to send changes in the DB2 database to Notes documents. Our developers are all skilled DB2, but have helped none when dealing with Notes. Any help would be greatly appreciated.
Thanks in Advance.
-V
Subject: Domino and DB2
Vasco - I think that there is an IBM Redbook on this subject - you might check there. Good luck!
Subject: some information for you…
Here is the DECS doc on LDD: http://www-10.lotus.com/ldd/notesua.nsf/0b345eb9d127270b8525665d006bc355/de610bd75c25f3818525698100547d4a?OpenDocument
DECS monitors events that occur in Notes, captures them and performs the appropriate action on the external record. If they update a record directly in the external system, and that record already has an equivalent key document in the nsf, then the next time that document is opened, the update would be seen. If they are adding new records directly to the external table, then they need to create a corresponding key document in the NSF. Customers typically use LEI’s replication activity to do this or they write a LC LSX agent to create the key document in the NSF.