Ideas on DB2 connecting to NSF?

HCL Domino Domino Forum
1

I apologize of this is off topic, but the problem stems from my current practice of pulling data from DB2 (iseries) into Notes (windows) using ODBCConnection. The data transfer work is always done from Notes/LotusScript in agents or actions. Some processes I am looking at appear to be better in concept if DB2 pulled data from Notes and worked on it in DB2. The DB2 group here is not familiar with such capabilities.

DECS has proven inadequate, and I don’t have EI. I haven’t found conceptual alternatives in the EI forum.

Can anybody point me toward programmable solutions, if they exist, for DB2 to query and/or update NSF data? I’m currently stuck trying to manage DB2 data and activity from Notes via LotusScript.

Thanks

2

Subject: Ideas on DB2 connecting to NSF?

It seems that you are trying to have either program do the pull, but don’t know how to get DB2 to pull from Notes.

If you don’t need the data to be in DB2 real time, you could use lotusscript to push the data into DB2.

3

Subject: RE: Ideas on DB2 connecting to NSF?

Thanks for the response. Yes, which side should do the pulling would depend on the process and downstream use of the information. Sometimes a single Notes action can trigger a large amount of DB2 activity. I don’t want to program all the DB2 activity from Notes; I would like DB2 to pick up on the Notes trigger and do the subsequent work.

Thanks for you idea; I could at least have Notes create a triggering record in DB2, and have the DB2 group work from that.

Any other ideas are appreciated.

4

Subject: RE: Ideas on DB2 connecting to NSF?

Daniel,You have a few options to this problem.

  1. Use XML at both ends

  2. Use JDBC

Or alternatively, as a starting point, have a look at the article “Offloading Lotus Enterprise Integration tasks to the server” by Andre Guirard (Andre_Guirard@us.ibm.com).

Sorry I don’t have a web address to hand.

Regards

Rolf Pfotenhauer