Wednesday, December 20, 2006

More DB2 Express-C on MS Vista info/news

Our friend Chris Gruber is blogging about DB2 Express-C, Vista, and XML over at his blog. He talks about some changes to security in MS Vista, as well as some Web 2.0 topics. Interesting read, go check it out!

Ryan Chase

Tuesday, December 19, 2006

DB2 Express-C 9 for MS Windows Vista is here!

The wait is over, you can now download DB2 Express-C 9 for MS Windows Vista for free! It is available on our DB2 Express-C download page, or if you would prefer here is the direct download link.

As always feel free to leave us a comment here, or in our DB2 Express-C forum, or you can head on over to our friend Antonio Cangiano's blog to see what people are saying about DB2 Express-C on Vista over there.

Ryan Chase
DB2 Express-C team

Friday, December 08, 2006

What's happening?

It may be December, but the DB2 Express-C team isn't powering down for the holiday season just yet.

We've got some exciting projects on the way for December and in the new year. I can't say too much at this point, but one highlight is to have Microsoft Vista support for Express-C so you can combine the newest operating system with the best of breed database server, DB2 Express-C 9!

Keep an eye on the DB2 Express-C website and the forum for the latest announcements.

Thursday, October 26, 2006

DB2 Express-C at IBM's IOD conference!

The rest of the team and I returned home this week after spending last week in sunny Anaheim, California for IBM's Information on Demand (IOD) conference. The conference was a great success this year, I haven't heard official #'s of attendees but I believe we had something like 6000+ attendees!

There was a lot of interest in DB2 Express-C and I had some great conversations with a number of people . Thanks to everyone that came out and talked to us.

If anyone has any further comments or feedback we would love to hear from you, either by adding comments to this blog, or to this thread in the DB2 Express-C forum


Friday, July 28, 2006

DB2 Express C 9 images are here!

We've been a little quiet over the past weeks, but for a good reason -- we've been working hard on DB2 9! Well the wait is finally over, DB2 9 is here today!

You can download DB2 Express C 9 images right now over at . Go get it!

Ryan Chase

Thursday, June 15, 2006

DB2 speeding ahead on Rails

In the application development world, 2006 is likely to be remembered as the year of Ajax and Ruby on Rails or RoR (roar) as it is commonly known to lazy typists. We are not going to talk about Ajax just yet but if you are interested in Ruby on Rails, you really need to look at the Startup Toolkit for DB2 on Rails project on IBM alphaWorks. It is the fastest way to get started with RoR no matter what database you fancy for your web projects and it is an absolute must for DB2 people. Startup Toolkit for DB2 on Rails has everything you need packaged in to a single one-click installer that will make your Windows PC in to real RoR development workstation. This includes the Ruby language itself, the Rails framework, DB2 enablement for Ruby on Rails, assorted learning materials and, naturally, DB2 Express-C 9 test drive (formerly known as DB2 Viper). And, if you are familiar with DB2 Express-C then you know that there are absolutely no charge for developing, deploying, and even redistributing DB2 with your applications. Yes, completely free and including way cool pureXML technology.
We have also started a new blog dedicated to DB2 and Ruby on Rails at So, don't delay, point your browser to and let your machine download and install DB2 on Rails while you are watching that gripping Soccer World Cup match.

Sunday, May 21, 2006

DB2 Express-C events at universities in Brazil


Just like my other team mates, I've been on the road for the past week. Last week I delivered a DB2 Viper training course for business partners in Brazil, and next week (May 22 - 26), I will be promoting the use of DB2 Express-C at several of the best universities in Brazil. I'm sure they will be impressed by the Viper hybrid data server. If you happen to be in the Sao Paulo area, and would like to attend these events, or meet me in person, send me a note to

Cheers, Raul.

Still time for DB2 people to win a 50 inch plasma TV or one of 25 iPods.

I did not want any of our DB2 Express - C community to miss out on a chance to win a really big TV or one of 25 really small iPods. Take a look at my ITToolbox blog post Penny for your thoughts ... or better yet a 50 inch plasma TV or one of 25 iPods. for details of the contest. The important part is not the prizes. This survey gives you a chance to have your opinions heard by the International DB2 Users Group (IDUG) and to influence the programs that IDUG brings to you in the future. If you are not familiar with what IDUG can do for you, take the opportunity to browse their web site. It is a terrific resource for anybody who works with DB2.

Winds of change

I am pleased to announce that DB2 Express - C team is now a part of the DB2 Technical Marketing team. What does this mean? Well, many things will stay the same. Raul, Ian and Ryan will still be blogging here and will continue to facilitate discussion on the DB2 Express - C forum.
You will also notice some changes. DB2 Technical Marketing is a team of product evangelists. Our job is not just teach people how to use DB2 products but to, what I call, demonstrate the art of the possible.
With data servers becoming a mature technology that firmly implanted in the application infrastructure, databases don't get the recognition they deserve. We plan to bring the "cool factor" back to data servers. We have the technology to make this happen. DB2 Viper is changing the landscape of database technology by becoming a hybrid Relational-XML data store. We also have richer Web Services support, RSS, Atom, PHP, Ruby on Rails and other Web 2.0 must-haves. Our focus will be to spread the message and to demonstrate how DB2 servers can deliver value beyond providing a simple data repository.
Oh, and as you may have guessed already, I manage the DB2 Technical Marketing team. My name is Leon Katsnelson and you will be seeing me around here quite a bit.

Tuesday, May 16, 2006

DB2 Express-C at Wireless Enterprise Symposium in Orlando, Florida


Just like Ryan, I'm away from my desk this week; I'm here in Orlando at the Wireless Enterprise Symposium. I'm working under the "Lotus software" banner here at the showcase, but I'm talking up DB2 and how to use it for your Blackberry mobility backend. Feel free to stop by and chat -- I've got lots of copies of the DB2 Express-C discovery DVD to give away!

Monday, May 15, 2006

DB2 Express C at JavaOne conference in San Francisco!

Just a quick note to let everyone know that I'm in San Francisco right now for the JavaOne conference that runs from May 16-19 at the Moscone Center. All the details are at .

This is one of the biggest Java developer's conferences in the world, so I'm sure there will be at least a few DB2 Express C users attending. Feel free to drop by the DB2 pedestal and say hi, we'll have some fun stuff as well as some cool demos.

Ryan Chase

Thursday, May 11, 2006

Easy Linux Desktop and Server Operating Systems - Xandros

Cool - I just learned that not only has Xandros Linux been certified as "Ready for IBM DB2 Software for Linux", meaning that it is officially a supported OS for DB2, but that the current version of Xandros Server includes DB2 Express-C!

This is fabulous -- now we'd like to get Express-C included in Red Hat...and SLES...and Fedora...and Ubuntu...and CentOS...and....

Thursday, May 04, 2006

Hierarchical Data (DB2 vs. MySQL)

I attended the MySQL User's Conference in Santa Clara last week -- big thanks to the organizers, it was an excellent event. While there, I attended a number of session talks, including one on hierarchical data handling in MySQL, presented by Mike Hillyer. I came away somewhat puzzled by the methodology of the handling of hierarchical data.

The method proposed to handle this kind of data was to used nested sets to encapsulate the data so that it can be processed through SQL query methods. In nested set theory, essentially you surround a root node with numerical values starting at 1, and going up to a given maximum number that allows you to give a left (1) and right (max) number to surround all your child nodes.

For example, if we had a parent with two child nodes, and each of those child nodes had two leaf nodes (leaf nodes are child nodes, but with the smallest possible data element), then the numbers would be:

parent: left => 1, right => 14
child: left => 2, right => 7
leaf: left => 3, right => 4
leaf: left => 5, right => 6
child: left => 8, right => 13
leaf: left => 9, right => 10
leaf: left => 11, right => 12

Then you can programmatically determine leaf nodes by a simple alegbraic formula that states that the leaf nodes are the only children where the left value + 1 = right value.

As interesting an implementation as this is (and you can read a more detailed exampled about it here), it still leaves me confused. Why not use a database that handles XML data trees (which is essentially what a hierarchical data set is) natively? The nested set theory is a much more inefficient means of data storage and retreival, and means that you have to continually rebase your node numbers if you add elements, and therefore you also need to keep re-indexing your database.

What I would recommend is that developers look into the native XML storage facilities of DB2's Viper release and see how much faster both data queries and database administration can be when you can handle hierarchical data in a more straightforward manner.

Tuesday, April 25, 2006

Viper Test Drive of DB2 Express C is now available!

This is kind of exciting, my first post in our team blog and I get to announce some big news!

Viper Test Drive of DB2 Express C is now available for free download!

This is the next version of DB2, and delivers some exciting new function, particularly in the XML world ... just for a little taste of some of the cool new XML function, you can now store XML natively using the new XML data type, or you can store your data in the traditional relational format ... a true hybrid data store! You can work with this XML data using XQuery ... finally a standard!

I won't go on and list all the exciting stuff in this new release, go check it out yourself and download a free copy at ! For full details about the Viper Test Drive, check out .

Ryan Chase
DB2 Express Community Team

Wednesday, April 12, 2006

Viper test drive for Express-C coming soon!

We're dotting the i's and crossing the t's to get the Express-C versions of the DB2 Viper Test-drive ready.

Keep watching the website and this blog so that you can download them as soon as they're ready!

Wednesday, April 05, 2006

How are you using DB2 Express-C?

Do you have any great examples of how you're using DB2 Express-C -- either standalone, or as part of an embedded product? Tell us about it with an email to

We love to hear about how our users are maximizing the potential of Express-C, and we'll even feature you on our featured partners page.

Monday, March 27, 2006

Express-C introduction article, with demos


Here's a link to a great introduction to Express-C article on by Justin Whitney:

Introducing DB2 Express-C, with Demos

Thanks for the article, Justin!

Monday, March 20, 2006

Howto: Get the right version for your OS

There's been a number of posts to the support forum that appear to be a result of confusion regarding which version of Express-C to download and install. Here's a quick howto for you to get the right version.

1) Windows or Linux
- simple enough: are you running Redmond or Penguin? Express-C supports both, but you'll definitely need to know this one

2) 32 bit or 64 bit
- on Linux, run the 'uname -i' command. This command queries the system as to what platform is running, and should return one of the following:
  • 'i386' => 32-bit
  • 'x86_64' => AMD 64-bit
  • 'IA64' => Intel 64-bit
  • 'PPC64' => Power PC 64-bit
- on Windows, click "Start" and then "Run". In the dialog box, type winmsd.exe and click "OK". In the "System Information" window, locate the "System Type" record in the right hand pane. It should be one of the following:
  • 'X86-based PC' => 32-bit
  • 'Itanium-based PC' => 64-bit

3) 2.4 or 2.6 kernel (Linux only)
- to get the right kernel level download, run the 'uname -r' command from a terminal. This will return the full kernel level, though you only need to note whether it starts with '2.4' or '2.6'.

So now you have your operating system, your processor level, and kernel level for linux. The only thing you have to remember is that you cannot run the 64-bit version on a 32-bit processor.

Visit the download page to get the right level of DB2 for you.

Thursday, March 16, 2006

Express-C mailing list available

A lot of people have asked for a mailing list for updates and notifications. We have created a list in cooperation with the International DB2 User Group (an independent organization of people - not controlled by IBM). You can see their web site at

To subscribe the mailing list please go to the following web page

Express-C mailing list

Add your email address and select JOIN on the page. This information will never be released to third parties.

To send mails to the list, use "DB2-DB2-EXPRESS-C@WWW.IDUGDB2-L.ORG" as target address.

Wednesday, March 15, 2006

DB2 Express-C can now be installed on Win XP HOME

Hello everyone,

Good news!. A lot of people requested this, so after a lot of hard work, we are providing an experimental image of DB2 Express-C that can be installed on Windows XP Home. The image is available as of Friday March 10th, 2006. I encourage you to try it out by visiting our download page.

Please post any feedback either here or in the DB2 Express online forum.


DB2 Express-C Fixpak 11 images available

Hello everyone,

As of Friday March 10th, 2006 new images were uploaded for DB2 Express-C with fixpak 11 fixes incorporated. I encourage you to download them as soon as you can from our download page.



Monday, March 13, 2006

I'm world-wide

It's official -- DB2's Express-C team has now doubled in size! Instead of just Raul trying to hold down the fort, Ian Hakes (that's me) has officially moved onto the team to help bring this great product out to developers and partners around the world.

We're in the midst of putting together a whole stack of new articles, multimedia presentations and web updates to get you up and running with DB2 Express-C. Be sure to check out the main site frequently, as we'll be updating often.

Talk to you soon!

Thursday, March 02, 2006

RSS now enabled!

An RSS feed is now available through the link in the bottom right side. Just drag the feed icon to your aggregator, or right click on the icon and bookmark the feed URL to the bookmark folder for your RSS feeds.

Let's get this party started!

Hello to one and all,

I've taken it upon myself to put up our team's first blog posting, and to tell you a little about our team, and what we hope to do here.

The DB2 Express-C product is IBM's Information Management foray into releasing a freely distributable, freely downloadable version of the industry leading DB2 database program. The three of us who'll be posting here are the members of a new team leading the efforts to develop and nuture the development community around this new product. Our names are Ryan Chase, Raul Chong, and me, Ian Hakes (conveniently, my name comes last both grammatically and alphabetically).

What we're looking to do in this blog is to provide a bit of an informal means of keeping you informed about the news, events and highlights of the DB2 Express-C community. Eventually, we'll tack on an RSS feed, so your aggregator can keep you informed about the latest and greatest.

Don't forget to visit our home page, or our downloads page, or visit the developerWorks hosted support forum if you have any questions (links are available over there on your right hand side). Or, if you feel like just posting a comment here to one of our blog posts, by all means go ahead, though be advised that we won't be answering any support or product release questions in this space. You'll have to go to the more official channels for that.

Thanks for visiting, and we're all looking forward to a long and prosperous trip with every one of you out there!

Cheers for now.
Google Analytics Alternative