Stay in touch …

FreeDB2

Archives

POWER7: What’s in it for the free DB2 Express-C?

Earlie today without much pomp or ceremony IBM announced the new POWER7 microprocessor architecture and the 4 new SYSTEM p servers that  utilize the new architecture. POWER7 is the next step in the IBM POWER roadmap and as far as next steps go it is a very significant one. I don’t intend to do a blow by blow account of everything that is new in POWER7 and what it really means. For those that are interested, I recommend attending one of the POWER 7 launch events/webcasts. Power.org

If you are interested in databases (why else would you read this blog), then you will be interested to learn that DB2 takes full advantage of the POWER7 architecture. DB2 development team worked closely with the POWER7 team to deliver top performance, better energy efficiency and lower overall costs.

Multithreading is the star of the POWER7 architecture with each processor sporting 8 cores and each core running up to 4 threads for a total of 32 threads per chip. And these threads utilize a technique called Simultaneous Multithreading or SMT4 to make sure that threads are scheduled for execution with out most efficiency. DB2 takes full advantage of all of the new POWER7 cores and the new SMT4 threads. DB2 memory management is also optimized to take advantage of POWER7 improvements in this area. And DB2 can now exploit larger page sizes. All of this results in better price performance not only when compared to the previous POWER6 and POWER5 generation of chips but also when compared to competitive DBMS running on Intel’s latest Nehalem chips. Early internal tests point to a 38% cost advantage for DB2 pureScale running on Power 780 turbo over Oracle Real Application Cluster (RAC)  on Nehalem.

Since the free DB2 Express-C is not available for AIX, does it mean that using this free database locks you out of benefiting from the POWER7 architecture? Not really. The free DB2 Express-C is available for Linux on POWER; has been for years. This means you can run DB2 Express-C on a Linux LPAR on System p or System i server. So, if Linux on POWER is a consideration for you, take a look at the new POWER7 architecture and download the free DB2 Express-C for Linux on POWER to get the most out of your System p and System i.

  • Share/Bookmark

Jonathan Schwartz resigns as SUN CEO with a tweet

“Today’s my last day at Sun. I’ll miss it. Seems only fitting to end on a #haiku. Financial crisis/Stalled too many customers/CEO no more”

Jonathan Schwartz – Best Leader no more

These are the parting words of Jonathan Schwartz on Twitter. No multi-page letter like Scott McNealy did when he resined this post.

I am constantly amazed at just how much the social media phenomenon has changed the corporate attitude in just a couple of years. I see it reflected greatly in our own efforts to get everyone to partake in the goodness that is DB2. We have embraced social media out of [...]

Read …

Is Hadoop = Cloud Computing?

If I had a nickel for every time I heard people mention Hadoop or Map/Reduce in the same sentence with Cloud Computing, well … I would have a lot of nickels. If you are not familiar with Hadoop, the best way to understand what it does is to think of it as a method or a programming model for executing complex compute jobs on very large clusters of computers. These clusters can comprise hundreds and, sometimes, thousands of machines. What Hadoop does is break, or Map, these complex jobs in to much more manageable tasks that are distributed to run [...]

Read …

DB2 on Rails is now faster and more secure with parametrized query support

Not too long ago, I blogged about importance of getting developers to code parametrized queries  instead of using literal values in SQL queries. In this post I urged every DBA to forward an article that talked about SQL injection attacks to their developers. Well, it would not have helped any to send this article to a Ruby on Rails developer because Ruby on Rails does not support parametrized queries.  I should say “did not support till today”. Today IBM delivered version 2.0 of the Rails adapter for DB2 and the key future of this new version is support for parametrized [...]

Read …

A free book for a free database

This week we were at Lotusphere 2010 demonstrating DB2 Express-C  for Lotus Foundations. One of the giveaways we had was a free book on DB2 Express-C. The book proved top be very popular and we ran out very quickly. I also got a lot of questions from people who did not have an opportunity to go to Lotusphere if there was a way to get a copy of the book. My answer is “absolutely, as long as you don’t mind getting it in an electronic form”. A real paper book that you can flip through is always nice but in [...]

Read …