How can I determine if DB2 or SQL Server would be a better data store for my Lotus Notes apps?

We are looking for a more robust data store with our Lotus Notes applications. We were thinking about DB2 or SQL Server, but is there a way to determine the best to suit us? The exact number of records to store is undetermined as of yet but could be 10,000 to 500,000. We are also looking at the possibility of loading the database software on the same server as Domino is running. Is this possible? Any help is appreciated.
You stated what you want to accomplish, but not why.... The NSF can handle a considerable amount of data -- far more than 500,000 records, unless each of these records is more than 1 MB each. It really depends on how you architect your Notes application(s), which should be very consistent with how you would design an RDBMS (relational database management system) schema. That being said, either SQL Server or DB2 is a viable option, and both will scale way beyond what you've mentioned. If you ever expect to have terabytes of data then I would recommend DB2 over SQL Server. To answer your question about loading all the software on the same system, the answer is: Yes, it is possible. I run an RDBMS, Domino 6 with LEI 6, Notes 6 & Designer 6 all at the same time on my ThinkPad laptop and it all works fine. Would I run this as a production server? Never!!! When you approach server configuration think of Domino as you would any one of the application servers of the market. Consider the load that will be placed on the server -- number of users, transactions, etc. Can you configure the server system (HDD space, RAM, cache, etc.) to handle that load plus the overhead of a RDBMS?

Dig Deeper on Lotus Notes Domino Interoperability

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...