Domino 7.0 and DB2

by Volker Weber

I recently wrote about Notes "Hannover" on heise news. There is also a snippet in there saying that IBM will first have to deliver features that have been promised for version 7. I mention that DB2 will not be provided with the 7.0 release. I have received numerous questions about this. I do know that DB2 support is provided in the current beta release. Unfortunately I cannot reveal the source of my information.

IBM is really quiet about this but I have some very solid information that DB2 support will be turned off in the initial Domino 7.0. Select customers will be able to use it but it is not meant to be used by everyone.

Keep in mind that putting a relational datastore underneath the Notes database model is really hard. It appears they have not been able yet to deliver on it completely.

Comments

I know this is bait for me :)

The story is fairly simple, but not finalized. I think it's a reasonable story, and when I blog it (soon), everyone will relax about what the rumour really means.

Ed Brill, 2005-06-15 15:17

I do remember them saying at LS05 that DB2 support wouldn't be available for the DB2 UDB on iSeries in the 7.0 release but sometime in the 7.0x timeframe.

Chris Whisonant, 2005-06-15 15:31

I've tested the DB2 Integration in the beta release on windows environment. There is nothing 'exciting' about it.
The nsf-files are stored in BLOB-Fields in a DB2 database schema. Some nsf metadata are stored in ordinary table fields.
It's not putting a relational datastore underneath a nsf-file. It's more replacing the filesystem (as nsf-file container) by a relational database.
If you already have a DB2 and tools for backup you'll not need another tool to backup your nsf-files.
There is no 'mapping' between nsf-fields and db2 tables or things like that.

@Chris
The DB2 UDB on iSeries is not the same version than that DB2 UDB on Windows. As I tested the integration on the windows environment I needed the exact DB2 version with a few fixpacks. These were not available for the iSeries DB2.

Tobias Mueller, 2005-06-15 16:10

Nothing "exciting", except perhaps Query Views that allow JOINs, both within Notes data and between Notes and federated data. That's not a little thing, and it's well worth waiting for if they can get it working.

Stan Rogers, 2005-06-15 16:41

This is also true for the new AccessViews. If you do a lot of integrational stuff with Domino, AccessViews working bidirectionally are an extremely powerful feature. True, it's really worth waiting.
We all were hoping that the DB2 support would bring real relational features to Domino when it was announced, we all wondered how this should be achieved and we all were not really surprised when we found out it is just not possible. Domino can never be put into a relational frame with all pros and cons.

Marius Neumann, 2005-06-15 17:18

@Tobias - yeah, I was aware that they were different versions. Thanks!

Chris Whisonant, 2005-06-15 20:11

Since more than one person has interpreted my response above as tepid in some way, I want to clarify: a) I can't post a lot more because some things just haven't made it through IBM processes yet and b) You will be able to run Domino databases on DB2 when Domino 7.0.0 ships.

Ed Brill, 2005-06-16 09:05

{Big sigh of relief} My current project is counting on that DB2 option for the next phase :)

Kevin Presseault, 2005-06-16 19:20

Recent comments

Ralph Hammann on BlackBerry Porsche Design P'9983 at 12:50
Volker Weber on I bet you did not see this coming from BlackBerry at 07:51
Stephan Bohr on I bet you did not see this coming from BlackBerry at 07:13
Lino Helms on iPhone 6 NFC chip is restricted to Apple Pay at 15:29
Franz Mattes on Mittagsspaziergang at 06:52
Eric Hancock on iPhone 6 NFC chip is restricted to Apple Pay at 04:32
Ingo Seifert on iPhone 6 NFC chip is restricted to Apple Pay at 00:24
Ingo Seifert on iPhone 6 NFC chip is restricted to Apple Pay at 23:38
Andrew Magerman on iPhone 6 NFC chip is restricted to Apple Pay at 16:34
Volker Weber on iPhone 6 NFC chip is restricted to Apple Pay at 15:38
Craig Wiseman on iPhone 6 NFC chip is restricted to Apple Pay at 15:28
Eric Bredtmann on iPhone 6 NFC chip is restricted to Apple Pay at 14:17
Johannes Matzke on iPhone 6 NFC chip is restricted to Apple Pay at 12:45
Volker Weber on iPhone 6 NFC chip is restricted to Apple Pay at 09:07
Ole Saalmann on iPhone 6 NFC chip is restricted to Apple Pay at 09:04
Stefan Funke on Why Would Anybody Buy an Apple Watch? at 22:08
Maik Endler on Withings at 20:51
Volker Weber on I bet you did not see this coming from BlackBerry at 14:28
Roland Dressler on A Watch Guy's Thoughts On The Apple Watch After Seeing It In The Metal at 14:24
Karl Heindel on I bet you did not see this coming from BlackBerry at 13:18
Oliver Regelmann on I bet you did not see this coming from BlackBerry at 11:47
Dragon Cotterill on I bet you did not see this coming from BlackBerry at 10:39
Ralph Hammann on I bet you did not see this coming from BlackBerry at 10:13
Abdelkader Boui on I bet you did not see this coming from BlackBerry at 22:55
Volker Weber on I bet you did not see this coming from BlackBerry at 22:35

Ceci n'est pas un blog

vowe.net is a personal website published by Volker Weber a.k.a. vowe. I am an author, consultant and systems architect based in Darmstadt, Germany.

rss Click here to subscribe

Hello

About me
Contact
Publications
Certificates
Amazon Wish List
Frequently Asked Questions
Follow @vowe on Twitter

Local time is 13:41

visitors.gif

Tip jar

Archives

As most of my articles roll off the front page rather quickly, I am making an archive of previous posts available here. You can also use the handy search box at the top of the page if you are looking for something particular.

Last 30 days
More archives

Mobile tag for this page

© 1992-2014 Volker Weber.
All Rights Reserved.

Impressum