Q - Can I take an existing Notes db and write the data to a db2 database (nsfdb2)? > see, I don’t need to edit, the tables in the db2 control center? Then eference the db2 table Through a WAS service? Do I need Domino DB Access Installed? Or is writing out to nsfdb2 enough?
What I’m trying to do is keep my current Notes app (interface, notes views and profiles etc) but write the data to the db2 database and use that stored db2 data in a web service. And to make this easier, it would be one way Notes>db2>WAS.
WAS would never need to write to db2 and db2 would never need to write to Notes.
If someone could point me in the right direction I’d appropriate it
If you have a Domino server that is DB2-enabled, you can DB2-enable a database on that server and query it via SQL from other apps (with appropriate credentials of course). For a database not yet DB2-enabled, use compact -p to enabled it. Once it is enabled, you must create a DB2 Access View that defines the Notes data you want to make available to the SQL queries. Once that is enabled, your WAS app should be able to query as you want.
Are there any examples or documentation you can point me to? I’m having trouble finding a (current) doc that explains the Lotus DB2 Access server and it’s relationship to Domino and DB2.