Wednesday, May 2, 2012

DB2 Express-C 10.1 - Faster, more features, and still free!


The new version of DB2 Express-C, version 10, is out, and it's more flexible and powerful than ever before! Starting from the fact that it now allows you to use 4GB of RAM instead of 2GB, this will boost different database operations. The database size is still unlimited (compared to 11GB for Oracle XE, or 10GB for SQL Server Express).  Speaking of Oracle, DB2 Express-C includes the "Oracle compatibility feature", which means that as much as 98% of code written for Oracle could run with no changes on DB2 Express-C!.

There are other cool new features in DB2 Express-C that you can use and configure with minimal effort. For example, "Time Travel Query" allows you to develop "time-aware" applications with minimal effort. This is helpful for audit purposes, governance, and to solve problems because this feature will let you query your data as it was in a given period of time that you specify. This can help you to easily and quickly create charts like the ones you see for stock prices, for example.

Check out the article "DB2 Express-C 10: Even more value" for more details, and download and try DB2 Express-C 10!  It's free!

Monday, November 21, 2011

DB2 Express-C 9.7.5 includes Oracle compatibility

In case you didn't already hear, last week DB2 Express-C 9.7.5 was released!  The main feature it includes is Oracle compatibility! Though this functionality was available for a while in other editions of DB2, it has just been made available in DB2 Express-C.  Read more about it in the DB2 Express-C team blog!

Raul.

Wednesday, September 21, 2011

Just imagine...

 
About two weeks ago, BigDataUniversity.com launched a Hadoop Programming Challenge with the opportunity to give 3 students a free trip to Las Vegas (all travel expenses paid!) and participate in the Information on Demand (IOD) conference.  Students completing the Hadoop Fundamentals I course would be given the details of the challenge.  If you click on the "Participants" link in the course, you will see (as of today) that there are about 1000 people registered in the course.  That means 3 out of 1000 would be traveling to Las Vegas...  That is not a bad ratio, but if you think about it, it is very likely not all registered students will complete the course.  Say 300 (30%) complete it.  This means 3 out of 300 would make it to Vegas!... but wait ...it gets better.  Those who complete the course receive the details of the programming challenge. The challenge requires you to write some code.  My guesstimate is that maybe 30 students (10% of 300) will actually submit their program... So now we have 3 out of 30 flying to Vegas!.  Now, in my experience judging submissions for other challenges, out of those 30, some submissions will be incomplete or disqualified, some would be too simple...  So say 50% are like that....that means 3 out of 15 (or 1 in 5) could be in Vegas this October!

Now remember: This is not a lottery, this is a challenge; therefore you have a say on the outcome. If you put the effort and are creative we can see you at IOD!...moreover, you may network with executives from many companies including IBM and that may open the door to more opportunities!

Now that would be a good reason for participating...

Just imagine!

P.S: Yes, this post will make more people think about participating, but in my opinion, the ratio would still be very good!...I don't think 10000 people would be participating as the submission deadline is this September 30th!

Good luck! Raul.

Saturday, May 14, 2011

DB2 Express-C 9.7.4 - Did you try it out?

Hello,

DB2 Express-C 9.7.4 is out for about a week now.  I wrote an article in developerWorks titled "What's new with DB2 Express-C 9.7.4".  Check it out for details! 

Cheers, Raul.


Thursday, January 13, 2011

DB2 University

Today, DB2 University (db2university.com) was made available (in beta) to the community. DB2 university is an online educational Web site delivering free and paid courses by experienced professionals and teachers.

Why DB2 University?
DB2 University represents many things:

Flexibility
Online delivery of education is a growing trend. It allows students to learn at their own pace, in the comfort of their home, or wherever they may be. It allows companies to have their employees gain skill at a lower cost (No traveling expenses required).

The DB2 community demanded a site like this, and finally we have it! DB2 University delivers courses about DB2 and other technologies online, in either self-paced or Instructor-led format. The site has a sample of courses right now that you can check out:

- SQL Fundamentals I
- DB2 Essential Training I
- DB2 Essential Training II
- Data Studio Essential Training I

Some of these courses have been translated to different languages (Portuguese, Spanish, Russian); and they all have a corresponding book that can be used as a reference.  For example, the SQL Fundamentals I course is based on the Database Fundamentals eBook just published; the DB2 Essential Training I & II courses are based on the Getting started with DB2 Express-C eBook, and the Data Studio Essential Training I course is based on the Getting started with IBM Data Studio for DB2 ebook.

Books, videos, online delivery... A complete set of materials in different formats!

Quality, easily consumable material
Before DB2 University was released -- and this applies to internet content in general -- you could find a lot of material about DB2 on the Web; however, in many cases it was hard to make sense what was relevant or not. Some of the material out there is obsolete, incorrect, or too complex; and this would cause you a headache more than helping you.  Moreover, there is no logical flow when reading this material.  You just get an ocean of information that is hard to digest.

At DB2 University, we use Moodle open source course management system (CMS). A CMS helps instructors organize the material in a relevant and easily digestable way. Now students can go through the material with a logical flow that will save them time in their learning. They can also be confident the material is relevant, up-to-date, and of great quality, since it's been prepared by experienced professionals and teachers.

The Moodle version running on DB2 University was enabled to use DB2 as its database server.  This means Moodle is helping DB2, and DB2 is helping Moodle!

Recognition
Everyone taking a course likes to have some document to attest they completed the course. At DB2 University, we offer completion certificates to all students passing a course.

A real-life reference: Moodle using DB2, DB2 on the Cloud
Every time you access DB2 University you are seeing DB2 in action!. As mentioned earlier, Moodle CMS was enabled to run on DB2.  Moreover, every time you access DB2 University, you are also seeing DB2 in action on the Cloud!. Yes, DB2 University was implemented on the Amazon Cloud. We manage it using Rightscale, a Cloud management platform. Working on the Cloud also enabled us to set up a disaster recovery site at a low cost, so we use a different elastic cloud computing (EC2) instance to run a DB2 Stand-by server in a HADR configuration.

There are many more things to say about DB2 University and how it was implemented. A developerWorks article published on January 13th has more details. It is the first in a series of articles describing how DB2 University was implemented, including it's open-ID sign up capabilities (that is, how ChannelDB2/Facebook/Yahoo/Google IDs can be used to log on to DB2 University), and also using an Android phone to access your marks at DB2 university.

I would like to end this post by inviting you once again to try out DB2 University. Right now we have a special promotion where the top 20 students passing some of the courses offered will receive free or discounted IBM Certification exam vouchers, and also free hard copies of books!

We would like to hear any feedback you may have about the site so we can improve it!.  Moreover, if you would like to host your quality material in our site, please let us know!  It could be hosted either as a free or a fee-based course. It's up to you!

Enjoy!  Raul.

Tuesday, December 7, 2010

Treat yourself to DB2 this holiday

Nice post from my colleague Leons:
http://www.db2teamblog.com/2010/12/treat-yourself-to-db2-this-holiday.html

Happy Holidays! Raul.

Wednesday, December 1, 2010

Experience the next version of DB2 today!

Check out the DB2 Early Experience Program if you would like to experience the next version of DB2 to be released some time in the future.

You can "test drive" this new version without having to install or setup any software as we are running this from the Amazon Cloud. Send a note to db2beta at ca.ibm.com if you'd like to participate! Discount/vouchers may be available to cover any Amazon Cloud expenses.

Enjoy!, Raul