Get FREE DB2 and FREE tools

Lower Amazon S3 cloud storage price is good news for DB2 users

Amazon announced that they are reducing charges for their S3 cloud storage offering. The announcement boasts about a 19% percent reduction. Savings are higher as the amount of storage you use increases. Amazon S3 is not suitable as DB2 storage but it is a great place to keep backups and log archives. Lower price coupled with DB2 backup compression makes Amazon S3 an even more compelling solution for backing up DB2 databases. [...]

Read …

Comparing Free Databases: Oracle XE vs IBM DB2 Express-C 2 years later

With Oracle’s acquisition of MySQL it is quite clear that Oracle XE is at the end of its road. DB2 Express-C on the other hand has been continuously enhanced with cutting edge features. And unlike Oracle XE which takes you to a dead end, DB2 Express-C provides a very clear growth path that wil take your application where it needs to be no matter how big its needs to be and how fast it needs to get there. I believe that with MySQL replacing of Oracle XE at the low end of the portfolio, it makes more sense to compare DB2 Express-C to MySQL than Oracle XE. I think I will do just that in one of my future posts. I will say, however, that with today’s price reduction for DB2 Express, MySQL is at a big disadvantage. [...]

Read …

Top 3 ways to return TOP 10 rows by an SQL query

Limiting amount of data returned by a database to an application is probably the easiest and the most effective way to improve performance your application. DB2 provides 3 ways of accomplishing this. You can use DB2 SQL FETCH FIRST n ROWS syntax. You can use SQL syntax of another DBMS like MySQL, Oracle or Sybase, or you can do this in a database independent way by using the capabilities provided by the database API you are using in your application code. [...]

Read …

Will Oracle lay off more MySQL people?

This really interesting article just crossed my desk. It looks like Oracle’s latest SEC filing is a pretty good indication of massive layoffs still coming as a result of the SUN acquisition. There is no way to tell which part of the business the layoffs will be in but I wonder if MySQL is affected. MySQL is not exactly a cash cow for Oracle and the business seems to be drying up as many loyal MySQL customers are heading for alternative sources of support for MySQL. It is not really cool or fiscally responsible to get support for MySQL from [...]

Read …

MySQL Conference: the state of the MySQL community

This week I had an opportunity to spend some time at the annual MySQL conference in Santa Clara California. This is the second time I attended this conference. Last time I was at the MySQL conference was in the Spring of 2008 and the big news then was SUN acquisition of MySQL for a cool billion $s. This time it was Oracle swallowing SUN. So, when I was ready to go I was really curious to see how the conference would have changed and what the mood of the community would be.

Here are my highly subjective impressions. First, I [...]

Read …

Stay in touch …

FreeDB2

Categories

Archives