Friday, November 16, 2007

Lunch with DB2 launched

I am both happy and proud to announce that our latest DB2 education effort -- "Lunch with DB2" -- has been launched today.

The "Lunch with DB2" series is an ongoing series of recorded screencasts that walk you through some of the fundamental aspects of DB2 setup, administration, maintenance, and application development. The series title "Lunch with DB2" springs from our idea that you can watch the screencast and replicate the lesson over a single lunch break.

The first episode is available (all episodes will be free of charge, of course!) from They are best watched using the "full screen" option, so that you get the entire 1024x768 resolution.

This first episode walks you a typical local installation of DB2 Express-C 9.5, explaining each of the panels as you go through the setup process.

In the coming weeks, we'll cover topics like:
  • Getting to know the Control Center
  • Exploring the Health Monitor
  • Learning the DB2 command line processor
  • Importing and exporting data
  • Running a backup and restore operation
  • Learn about DB2 pureXML
Our goal is to deliver at one episode per week, and feedback is always welcome! Send your comments to, or post them on the DB2 Express-C forum.

Wednesday, October 31, 2007

New DB2 Express-C 9.5 downloads are now available!

DB2 Express-C 9.5 (formerly known as Viper2) is now available!

This is the next major release of DB2 and delivers new functionality as well as significant improvements from DB2 9.1.

You can download the new DB2 Express-C 9.5 images for free from the following links:

DB2 Express-C data server for Linux

DB2 Express-C data server for Windows

IBM Data Studio (new development and administration tooling for DB2 9.5)

DB2 9.5 Information Center online

DB2 9.5 Information Center local install image

DB2 9.5 Net Search Extender

DB2 9.5 National Language Package

DB2 9.5 Spatial Extender

If you are looking for more information to help you get started with DB2 9.5, here are some links to get you started:

Home page for DB2 9.5 Information Center

Get started doc in DB2 9.5 Information Center

And of course, we invite you to download DB2 Express-C 9.5 for free, try it out, and post your questions, comments, feedback, usage experience, etc. in the DB2 Express-C forum.

The DB2 Express-C download page will be updated in the next 2 days as we replace the DB2 9.1 downloads with the DB2 9.5 downloads, but you can access all the links in this post now to get the latest and greatest DB2 downloads.

Tuesday, September 04, 2007

Coming soon!: The DB2 on Campus Exam

For many students, it is important to receive a certificate after attending a course, speech or event. With this in mind,we are working on a DB2 on Campus exam, where students can obtain a DB2 on Campus certificate after passing the exam. To prepare for the exam, students can attend one of the workshops offered as part of the DB2 on Campus program; they can also read a free online DB2 Express-C book (coming soon!). With this completion certificate, students will feel more confident to add "DB2" in their resumes.

In addition, a system is being developed to deliver this exam. The project name is OSOTS (Open Source Online Testing System), and has been approved as an open source project in Members of the DB2 community (from Argentina and Brazil) are working on the analysis and design phase, and we expect their design to be completed by October. The design will then be made available to anyone interested in developing the system. Some will develop it on PHP, others in Java, others in .NET, and so on. Once the system is developed it would be used as well to showcase a DB2 application!. In addition, the students and teachers participating in this project will be invited to write articles about the system and the different implementations. To participate in this (an other) projects, sign up to, and take a look at this entry:

The DB2 Express-C team will be feeding the system with questions, but in the future, this project may be extended so the system generates the questions by itself... but let's do this one step at a time!

Cheers! Raul.

DB2 on Campus update: & Latin american tour

After a few weeks of vacation, I'm back with an update aboutDB2 Express-C and the DB2 on Campus program. First of all, if you have not seen it, check out how DB2 Express-C saves the world!:

We have also started a few months ago an online community for the DB2 on Campus program using is a social network popular amongst many universities worldwide. If you would like to join, follow these instructions:

Through I'm keeping the DB2 on Campus community informed about news and events. Students and teachers from each of the universities visited are invited to join. As of today there are 165 members who have signed up. Through, I've posted a few projects where members can contribute on a voluntary basis. The most important one of these projects is the Online Exam System. I will post more information about it on a separate blog.

I also started in July a Latin American university tour reaching approximately 1200 students in 5 countries: Mexico, Peru,Brazil, Argentina, and Colombia.

In Mexico, I'm glad to report a good number of the students who are members of the DB2 user groups at UNITEC and UNAM passed their DB2 Certification Exam 730!. More information can be found here:

In Peru I delivered a speech about DB2 at the IEEE Intercon 2007 conference in the city of Piura and provided a DB2 workshop. I also served as judge for one of their project competitions. In Lima I visited the University of Lima where students from several universities in Peru gathered to know more about DB2. I was pleased to hear after the speech and courses, that many students were motivated about trying out the product, and it is likely I will return for a course and other speeches early in December. The day of my speech at the Universityof Lima, a 7.9 earthquake hit several cities in Peru, and lasted more than 2 minutes. This was a very frightening experience, especially because it lasted for a very long time. I was told there were actually two or three big earthquakes one after the other, and that is why it looked like a never ending earthquake. Fortunately, the speech was over by the time the earthquake happened. The following days, there were many aftershocks of smaller magnitude. Two days after the earthquake, I travelled to several cities/universities in Brazil: Curitiba, Sao Carlos, Rio Claro, Campinas. It was a hectic tour with several speeches/courses per day and travel by car to the different cities. Overall it was a good Latin American tour, and I hope it repeats in the future.

Cheers, Raul.

P.S: I will be posting most of the university tour pictures in

Tuesday, August 21, 2007

DB2 for Linux HOWTO now available

Hi everyone,

I've just published a major revamp of the DB2 for Linux HOWTO document, and it's available for reading/downloading from:

and the PDF is directly available at:

This update covers DB2 Express-C 9, and includes instructions for the latest Linux distributions. All comments are welcome, either in the DB2 Express-C forum, or through an email to Please check it out and let me know if it helps you, or needs additional coverage, or anything else!


Sunday, June 10, 2007

University visits in Korea, Japan and Singapore

About four weeks ago, starting May 11, 2007 I visited Korea, Japan, and Singapore (One week each). In total I reached approximately 760 students and teachers in 8 university visits. In Korea I attended as well the Korean Database Conference in Mokpo, south of the country. Cheol Kang (IBM Korea) is doing a superb job delivering many DB2 lectures. He is also the co-author of a DB2 book written in Korean, and he gave me several copies to give away during my speeches. Professor Park from Yonsei University is also very kind to organize several of my visits. In Japan, I had the honor to be hosted by Hiroshi Maruyama, the IBM Tokyo Research Lab director, and IBM distinguished engineer. The picture is with Mr. Maruyama (or as they say in Japan "Maruyama-san") at the ACM event held in March 2006. Maruyama-san accompanied me to two of the three universities visited in Japan, and in fact he was the one responsible of organizing these visits. Maruyama-san also delivered a speech about the Global Technology Outlook (GTO) for 2007, and kindly offered to replicate my speech whenever possible in the future. In Singapore, I delivered a speech to customers at the IBM Singapore location. I discussed as well with a professor from NUS School of Computing, attending the speech, the possibility of starting a DB2 certification program in their school. At Nangyang politechnic, I delivered a speech to close to 240 students. Some teachers at this institution visit every year the IBM Toronto Lab for joint-research projects and to learn about new technologies. After almost 3 months in Asia, I finished my first DB2 on Campus tour of 2007 in that continent on June 2nd!!!.

Cheers, Raul.

Wednesday, June 06, 2007

University DB2 User Groups in Mexico

Last year I visited several universities in Mexico, and I'm very glad about the progress of the DB2 on Campus program in that country. Miguel Angel Garcia Trujillo, the DB2 on Campus program manager in Mexico maybe one of the reasons why the program is becoming a successful one since my last visit. The picture in this blog item is of him with students of two DB2 User Groups.

In total there are three very active DB2 user groups in Mexico:


These DB2 user groups have been promoting DB2 in their universities and other universities, they have helped with the translation of several DB2 documents to Spanish, and many of the students are preparing to write the DB2 Certification Exam 730 (DB2 Fundamentals). Their enthusiasm is contagious!.

I will be visiting Mexico again this year (June - July), and I will have the chance to see the members of these DB2 User Groups. They plan to write the exams prior to my visits.

Congratulations Mexico!

Saturday, May 12, 2007

DB2 on Campus: Thank you IBM volunteers!

Reaching thousands of students and visiting hundreds of universities worldwide would be an impossible task for the DB2 Express-C team alone. Thanks to several IBM volunteers the reach of the program has grown considerably. For example, in Vietnam Nguyen Khiem (IBM Software Group Vietnam) has delivered the speech "The role of DB2 Express-C in the information on demand world" in four universities reaching more than 400 students. The picture in this blog is of him delivering this speech.

Another example is Andrea Cristina Rodacki (IBM Brazil). She has been able to reach at least 300 students in Curitiba, Brazil, and has delivered courses for post graduate students about DB2.

Hiromiti Nakagawa, also from IBM Brazil continuously provides support for the program, and is coordinating a big event in Brazil this June to reach 600 students.

In Korea, Cheol Kang has done an incredible job to deliver DB2 classes using the DB2 on Campus materials to 5 univerities reaching more than 700 students.

In Malaysia, Allan Tham will start delivering many DB2 on Campus events once students go back to school in July.

In Mexico, Miguel Angel Garcia Trujillo is doing a terrific job of keeping students motivated and helping the three active (very active!) DB2 user groups created recently. Students in these groups are replicating themselves the program.

In Thailand, Sunicha Eckachai has been able to keep the momentum going of my visit las year. Eight academic institutions in that country will be delivering DB2 classes this year.

Thank you very much to all of these IBM volunteers!


Friday, April 20, 2007

DB2 on Campus program in Malaysia

From April 16th, 2007 until the 20th I had the chance to visit several universities in Kuala Lumpur, Malaysia. Malaysia is a very beautiful country with many trees and excelent infrastructure. Two university DB2 User Groups were set up during my visit. One at MMU, and the other one at the University Technical Malaysia Malacca (UTeM). At UTeM, Lang Ley, the first DB2 Student Ambassador in Malaysia will promote the DB2 on Campus program to not only her university, but other universities. I will be featuring Lang Ley in the DB2 Express-C Web site in a couple of weeks as she has also developed a useful application using PHP and DB2 Express-C. The picture is from my speech at MMU with about 100+ student attending.


DB2 on Campus program in China

Last Friday I finished my first tour in China for year 2007. This time I visited 10 universities in 8 cities reaching approximately 1000 students and teachers. China is a large and great country. I am always amazed every time I visit its universities; most of them include a hospital, a hotel, many restaurants, and of course many classrooms and labs. I believe the smallest university I visited had 20,000 students, and the largest 60,000!. In China I normally get large attendance to my speeches and courses. The largest one was 300+ students at SCUT. University infrastructure in China is just as amazing as the desire for Chinese students to learn more and improve themselves. China is where my grandparents came from, but unfortunately, I don't speak Chinese, so I'm always in trouble when dealing with the locals (eg: Ordering at a restaurant). Closing my eyes and pointing to the menu has served me well so far =). As part of the DB2 on Campus program for the rest of the year, local IBMers may be able to replicate the program. I'm also hoping DB2 User Groups start flourishing. Some universities such as Xi'an JiaoTong University, Wuhan university of technology, and Jilin university are working to set up their DB2 User groups and Web sites. I hope to collect their URLs soon and post them in the DB2 Express-C web site.


Wednesday, April 18, 2007 + more DB2 Express-C news

We're happy to announce that is now live on the web! is a blog aggregrator which takes all the DB2 related blogs (that we know about!) and displays them in one place and also provides a feed for you to sign up to get all the latest DB2 related blogs. is not just for IBMers, anyone that blogs regularly about DB2 is welcome to join, just email us at join [at] !

We also have a lot of exciting news in the pipeline ... I can't give you all the details yet, but stay tuned to this blog at also our DB2 Express-C home page for all the latest updates. We have a new DB2 Express-C update coming soon, but that's definitely not all!

We'd also love to hear from you if you are using DB2 Express-C and have a success story to share with us. Let us know how you found out about DB2 Express-C, how you are using it, and how it's made a difference for you. If you used DB2 Express-C with an application you are building, let us know! Or maybe you learned DB2 using a free copy of DB2 Express-C and managed to land a great job ... or perhaps you impressed your boss by moving to a world class database without costing the company any money ... whatever the success story, we'd love to hear it.

You can post your success stories on the DB2 Express-C forum, or send them via email to db2x [at]

Ryan Chase

Friday, March 16, 2007

ACM - ICPC World Finals in Tokyo, Japan

Last week (March 12 - 16, 2007), Bradley (Brad) Steinfeld and myself represented the DB2 Express-C team at the ACM International Collegiate Programming Contest (ICPC) in Tokyo Japan. We delivered demos including one on Ruby on Rails and DB2 Express-C. Ruby on Rails is an open-source framework for creating database backend web applications, and is becoming increasingly popular for Web 2.0 development. The demonstration showcased Aurora, an application builder which allows business professionals to build and secure web-based applications with little or no programming skills. Aurora was created on top of DB2 and Ruby on Rails using the Starter Toolkit for DB2 on Rails which conveniently packages Ruby, Rails, DB2 Express-C and the drivers/adapters required. The demonstration was timely, as the highlight of this ACM event was the speech from Yukihiro Matsumoto (Matz), the creator of the Ruby language.

Brad is a student of the University of Waterloo and is working on his last internship at IBM before graduating. Brad was one of the four members of the IBM Extreme Blue team that designed Aurora. What is interesting about Aurora is that it is a neat application built from scratch by students who had no knowledge of Ruby, Rails or DB2. They built it in 3 months. Without taking any credit away from these students (they are very smart!), this does show how easy it is to code on Ruby on Rails using DB2 Express-C as the backend database.

Several students at the event dropped by our ped, especially after Matz speech. We also described DB2 9's pureXML technology.

This is the first time I'm attending the ACM ICPC world finals event. It was an extraordinary event were the smartest students in Computer Science/Engineering all over the world compete to solve a given set of problems in a given amount of time. The winners this year was Warsaw University. Read more about it at the ACM Web site!

Cheers, Raul.

Sunday, March 11, 2007

DB2 on Campus 2007 - Argentina

This February 2007, I visited universities in Argentina for 2 weeks. This is my sixth visit to this beautiful country, however, it is the first one during the summer time... and it was hot, hot, hot!. From the -10 celsius temperatures in Canada to the 35 celsius in Argentina, I felt both extremes in weather weeks apart. I was told in the city of Resistencia that had I arrived a few days earlier, I would have experienced temperatures close to 49 celsius!.

In my visit this time, I finished the DB2 on Campus program cycle in several universities. For example, at the UTN-Resistencia, and UNNE in Corrientes, I delivered a DB2 speech in early 2006 (my 1st visit), delivered DB2 courses by mid 2006 (2nd visit), and this time I proctored the DB2 certification exam 730. In this occassion, I also visited Buenos Aires, Resistencia, Rosario and Cordoba, and delivered DB2 courses to instructors.

The only unpleasant experience in Argentina is probably flying with the national airline. Their planes are old (making funny sounds)... I have an uneasy feeling every time I board one of their planes. This time I was also unfortunate to have all my flights delayed from 2 to 10 hours because the radar at the airport was not working. Many people were frustrated... In my case, I'm used to this type of things; and as long as I have a laptop with me (and Internet connection), I'm happy and productive. In fact, many of the articles I've written were at airports or on planes, that's why I always double check I carry enough batteries for my Thinkpad.

This has been another successful visit to Argentina. I've come often to this country because the local IBM organizer, Fernando Gomez, is keen to schedule many visits. I will support most the people with most interest in the program... so if you are interested, ensure to push your local IBM representative to work scheduling visits to your school!. If you don't know where to start, send a note to with your concerns.

Cheers, Raul.

Tuesday, March 06, 2007

Success story: Marketing your skills

I enjoy working with students and giving them advise...that's why I love running the DB2 on Campus program. For a student, the bottom line is to find a good job in a good company; at least, most of them at the undergraduate level have told me that. I've enjoyed working with the students in Resistencia, Argentina. They have shown a lot of enthusiasm, and have worked very hard to grow their DB2 User's Group. In my last visit, I reminded them the power of "Marketing". It is good to be a good student, and get very good marks; however, in my opinion, it is most important to be visible, and let others know you are good at what you do. That's why I'm encouraging students during my visits to blog, write DB2 articles, write DB2 books, post their resumes including DB2 in them, and participate in the DB2 forums. The more visible you are, the best are your chances of getting that great job you are looking for... And I recently proved this is the right approach. Mario Piz, the first student featured in the IBM DB2 Express-C web site was hired as a coop student at a bank in his province. The manager called and hired him after seeing his picture in the IBM site! (Success story!). Mario is a rather quiet student. I'm sure many engineering and computer science students would identify well with Mario's personality. It is important for Mario and all students like him to market their skills and be visible!. It pays off!


Saturday, March 03, 2007

DB2 on Campus - New name for DB2 Express-C University Program

Hello everyone,

We have decided to rename the "DB2 Express-C University Program" to "DB2 on Campus Program". The new name is shorter, and it reflects the visits my team is doing to universities... I will start blogging my visits for 2007.

Cheers, Raul.

Sunday, January 21, 2007

DB2 Express-C University Program

Last May I visited several Brazilian universities delivering speeches about DB2 Express-C. The feedback I received was excellent!. This convinced me to start a project I called the "DB2 Express-C University Program". I've been running this program worldwide since June 2006. By December 2006 I had reached almost 8000 students and teachers!. The program is self-sustainable through its "child" program called "The DB2 Student Ambassador program". You can read more about these programs at our DB2 Express-C Web site . I have posted several pictures of the 2006 University Tour at this site.

For 2007, I will be visiting Argentina in February, Japan in March, and China in April. I'm still working out the schedule for other universities worldwide throughout the year. I plan to blog after each visit to a country/city.

Cheers, Raul.

Google Analytics Alternative