Andrew Pollack's Blog

Technology, Family, Entertainment, Politics, and Random Noise

Well, IBM really has set DB2 free. As Domino admins and developers, we are very well positioned to take advantage of this. So, how do we get started?

By Andrew Pollack on 01/31/2006 at 01:06 PM EST

First, I have to say that setting DB2 free was a fantastic move. PC based servers have never been the large part of the revenue stream for DB2 anyway, though it is for Microsoft's MSSQL. DB2 is very well regarded in the I.T. industry and compares very favorably at the top end. Even the Slashdot community which is heavily biased toward MYSQL has good things to say about DB2 and has taken this news favorably.

IBM is effectively saying "If your product is targetted at x86 servers -- even multiprocessor/multi-core -- you don't really have a product." Microsoft's market is exclusively (or nearly so) now forced to compete against a product that most of the industry considers vastly superior, and yet is free to anyone using it on a scale that Microsoft typically sells to. IBM Isn't, and has never been effective at selling DB2 to SOHO. By giving away this market, they have the opportunity to capture some of it, poison the water supply of their competitor in Microsoft SQL, and for those successful companies that grow from PC based servers to serious hardware they can easily migrate them to iSeries or zSeries big boxes with lots of zeros on the price tag. Its a solid strategy and a good product.

Given that, we as Domino centric partners have the most to gain here. The vast majority of our servers are capable of hosting a DB2 instance and fall under the free licensing category for doing so now. In my considered opinion, IBM has just passed us the ball and set up the play. The big question is, will we pick up the ball and run with it?

Here's catch -- most of us know very little about the DB2 product line. I've installed it and created some simple databases. I've even written some fairly interesting script to handle the SQL / Object conversion once or twice. Beyond that, I don't even know enough to know what I can do, let alone how to accomplish it.

I'd like to install a DB2 instance on my linux based Domino 7 server. I'd like to have a good reporting tool to point at it, so that when I fill database tables with log data and other such things I can use DB2 as the back end for reporting -- preferebly web based reporting.

What specifically do I need to install?
What optional tools & products are the de-facto standard for this?
What do I need to open for ports to the machine?
How secure are those ports if I open them up?

Where can I get up to speed quickly, as a partner, to add this to my toolbox?

There are  - loading -  comments....

Other Recent Stories...

  1. 01/28/2020Copyright Troll WarningThere's a copyright troll firm that has automated reverse-image searches and goes around looking for any posted images that they can make a quick copyright claim on. This is not quite a scam because it's technically legal, but it's run very much like a scam. This company works with a few "clients" that have vast repositories of copyrighted images. The trolls do a reverse web search on those images looking for hits. When they find one on a site that looks like someone they can scare, they work it like ...... 
  2. 03/26/2019Undestanding how OAUTH scopes will bring the concept of APPS to your Domino serverWhile a full description of OATH is way beyond what I can do in this quick blog entry, I wanted to talk a bit about how "SCOPES" interact with the already rich authorization model used by Domino. Thanks to the fantastic work by John Curtis and his team, the node.js integration with Domino is going to be getting a rich security model. What we know is that a user's authorizations will be respected through the node.js application to the Domino server -- including reader names, ACLs, Roles, and so on. The way ...... 
  3. 02/05/2019Toro Yard Equipment - Not really a premium brand as far as I am concernedDear Toro Customer Service, I arm writing about the following machine: Toro Power Max 1120 OXEModel:38654S/N:31000#### Specifically, bearing part #:63-3450 This is the part ($15 online / $25 at the local dealer) that caused me to raise my objections on-line. This piece of garbage is supposed to be a bearing. It carries the shaft which drives both stages of the auger. The shaft passes through the bearing (which is what bearings do) after the auger drive pulley as the shaft goes through the back (engine ...... 
  4. 10/08/2018Will you be at the NYC Launch Event for HCL Domino v10 -- Find me! 
  5. 09/04/2018With two big projects on hold, I suddenly find myself very available for new short and long term projects.  
  6. 07/13/2018Who is HCL and why is it a good thing that they are now the ones behind Notes and Domino? 
  7. 03/21/2018Domino Apps on IOS is a Game Changer. Quit holding back. 
  8. 02/15/2018Andrew’s Proposed Gun Laws 
  9. 05/05/2016Is the growing social-sourced economy the modern back door into socialism? 
  10. 04/20/2016Want to be whitelisted? Here are some sensible rules for web site advertising 
Click here for more articles.....

pen icon Comment Entry
Your Name
*Your Email
* Your email address is required, but not displayed.
Your thoughts....
Remember Me  

Please wait while your document is saved.