Thursday, December 10, 2009

New free ebook: IBM Data Studio for DB2

A new free ebook titled "Getting started with IBM Data Studio for DB2" is now available here!.

Data Studio is an eclipse-based tool that is replacing the DB2 Control Center and other DB2 tools. In addition to DBA tasks, you can also develop stored procedures (using languages such as SQL PL, PL/SQL, Java), SQL and XQuery scripts, and data Web services.

Download this free ebook and learn!

Enjoy,

Raul.

Wednesday, December 9, 2009

DB2 on Campus Newsletter - 3rd quarter is out

The DB2 on Campus newsletter summarizes many of the activities performed by students, professors, and IBMers around the world working/volunteering on the DB2 on Campus initiative.

The latest edition of the newsletter can be found here:
http://tinyurl.com/yatuhte

You can subscribe to the newsletter by visiting:
http://www.channeldb2.com/group/db2oncampusnewsletter

Enjoy! Raul.

Wednesday, December 2, 2009

DB2 Express-C 9.7.1 is out!

The 9.7.1 refresh of DB2 Express-C free database server is now available:
http://db2expressc.blogspot.com/2009/12/get-db2-express-c-971-now.html

Cheers,

Raul.

Tuesday, November 24, 2009

Waseda university using DB2 Express-C book for DB class

This October 3rd 2009, Waseda University in Japan started a DB2 class that is held every Saturday until late November. The course is part of the "Advanced IT Specialist Fostering Program” promoted by the Department of Education and Science Ministry in Japan. The materials are based on the DB2 on Campus workshop, as well as the "Getting started with DB2 Express-C" book, both of which were translated to Japanese.

Congratulations to IBM Japan to establish this great relationship and class at Waseda university!.

Thursday, October 15, 2009

Story of two DB2 Student Ambassadors

Today the story of two DB2 Student Ambassadors in India has been published online in the Data Management Magazine. I'm very happy these two student ambassadors have been recognized by the IBM Information Champions program. I still recall how these two students became ambassadors. Early in 2008, I received an email from them inquiring about the DB2 on Campus program. At the time I had not visited India, so they showed initiative just by getting in touch with me. As time went on, the two students showed a lot of passion for DB2, and with a lot of enthusiasm, they started organizing events about DB2; therefore they were named DB2 Student Ambassadors, and established a DB2 User Group in their university. I was going to attend the inaguration ceremony, but on short notice, the mayor of the city decided to declare a holiday the day of my visit, which meant it would've been hard for students to use public transportation. Nonetheless, I spoke with Raghuveer/Pradeep on the phone, and congratulated them for their efforts. We also nominated them to the IBM Information Champions program, and I'm glad they were selected. Congratulations again to Raghuveer and Pradeep!

Raul.

Tuesday, October 13, 2009

DB2 pureScale announced!

This week IBM announced DB2 pureScale, new innovative technology to help large OLTP
customers gain virtually unlimited database capacity without changing or tuning their applications. In addition, pureScale helps make their data continuously available and to operate their business without interruptions. The implementation is based in large part on DB2 for z/OS Data Sharing and Sysplex technology that has been in use by the world’s largest organizations for over a decade. This technology is considered by many to be the gold standard for delivering reliability and scalability and is now available for UNIX database servers.

Learn more about it here!

and register for a free "Chat with the Labs" webcast here.

The IBM Press release can be found at this location.

Cheers, Raul.

Saturday, October 10, 2009

IDUG members save $100 on the IOD conference registration rate

From the IBM Marketing team:

--------------------------------------------------------------------------
Attention IDUG members! We've just announced a $100 savings for every IDUG member who registers for the Information On Demand 2009 global conference. To take advantage of the $100 IDUG member discount you must enter a Promotion Code of G09DB2UG. We are even extending an 8% American Airlines travel discount to all attendees of the conference.

Here is what Business and IT professionals can expect to see at IOD for DB2 LUW and z/OS
An exciting lineup of customer speakers - including Verizon, Verizon Wireless, HSBC and Eli Lilly - who will share real world experiences and benefits from DB2.
An full lineup of DB2 LUW sessions including 41 technical sessions and 22 three-hour hands-on-labs. Plus top 5 reasons to attend. Check out what's in store for DB2 LUW. www.ibm.com/software/data/conf/db2-luw.html
An full lineup of DB2 z/OS sessions including 70 technical sessions and 11 three-hour hands-on-labs. Plus top 5 reasons to attend. Check out what's in store for DB2 z/OS. www.ibm.com/software/data/conf/db2-zos.html
Plus there are over 300 more technical sessions to chose from that will help you build skills across a wide array of IBM technologies including InfoSphere Warehouse, Integrated Data Management, Enterprise Content Management and more!
Professional certification testing available at no additional cost - the cost of equivalent education can be as high as $7,500.
An expanded EXPO of over 200 Business Partners and 175 Exhibitors providing smarter solutions for your business!
----------------------------------------------

Raul.

Tuesday, October 6, 2009

DB2 on Campus in ASEAN and South America


The past few months I've been travelling at a very heave pace, going last July from ASEAN, to North America, then South America, back to ASEAN (Indonesia, Singapore, Philippines & Vietnam), and now finally home in Canada. It has been a very busy time promoting DB2 not only to universities, but also delivering webinars, visiting a few business partners, IBMers, and several customers around the world. The jet lag has been quite a nightmare, and my body cannot yet distinguish between day time and night time... Nonetheless, the results in some countries have been outstanding. In the Philippines for example, I was able to reach almost 3000 students in 1 week. I probably had the three largest audiences I've ever had since the DB2 on Campus program started: 1200, 1000, 800 approximately. The local organizer in the Philippines (Jun Contreras), timed my visit with huge university events: JPCS (Junior Philippines Computer Society) and Y4IT (Youth for IT). Larger crowds though, are tough to entertain for more than 1 hour, but I did carry a few souvenirs I threw to the audience for good answers to questions. The picture in this blog is for the JPCS event.

In Singapore I delivered a seminar at NUS (National University of Singapore) which was recorded here: http://bit.ly/T82C6 (I'm not sure for how long they will host it, but I'm asking them to send me the video in mp4 so I can upload it to channeldb2.com if possible).

In Mexico, Brazil and Peru, I visited several customers providing a 2.5 hour overview of DB2 9.7. In Brazil I also visited a partner (Data Access), and because of my visit, I was invited to deliver a webinar (in Spanish) to their developer audience. See the Webinar abstract. The replay can be found here.

In Indonesia, Binus university is in its second year teaching DB2 as part of their curriculum using DB2 on Campus material. Last year they reached about 300 students, and this year maybe 500. In addition, a colleague of mine is working on an internship program to bring students from Binus to the Toronto lab for a 16 month internship. If it happens, it would start in May of 2010.

In Vietnam as usual, I had a busy schedule, but several universities are teaching now DB2 thanks to our support.

For November, I have another webinar in plan, this time hosted by developerWorks, and also another seminar at the IBM Innovation Center in Toronto (Markham), and am planning a DB2 on Campus tour in Canada, probably for February.

In addition, I'm working with IBMers, teachers, students and professionals around the world to deliver by the end of the year a bunch of free e-books on different technologies. More about this in December!

I tweet a bit more often than blog now. Follow me at http://twitter.com/raulchong

Cheers, Raul.

Thursday, July 30, 2009

Data In Action Virtual Conference: Effective Data Management for Smarter Outcomes

IBM Virtual conference. Register here!:

Conference info below:
===================================
Join IBM August 19, 2009 at 8:00 AM PDT / 11:00 AM EDT for the second semi-annual Data in Action Virtual Conference, the premiere data management event for IT managers and executives.

This conference will feature effective data management solutions for smarter business outcomes. Hear from Donald Feinberg, Vice President and Distinguished Analyst from Gartner, about the state of the DBMS software market and data management challenges facing businesses today. The topics that Mr. Feinberg will examine include; the problem of exploding data volumes, new computing paradigms for handling this explosion, data management cost reduction techniques and technologies, and the perspective of the DBA now and in the future.

Following Mr. Feinberg will be a moderated panel of customers and partners who are leveraging the unique and desirable features only available in DB2 9.7.

This is one event you won't want to miss. Get your questions answered through 2 interactive (webcast) sessions, 8 exhibit booths, and live chat. IBM and it's business partners are helping companies around the globe with industry-leading data management technologies and their world-class expertise. Learn how your company can achieve smarter business outcomes and reduce underlying IT costs.

Attendee incentives include a complimentary memory stick for the first 97 attendees, which includes information on the cost savings of DB2 over Oracle. IBM employees are not eligible for this incentive.
Also a DB2 9.7 Discovery DVD for everyone who completes the event survey. The DVD includes trial code and tutorials. We look forward to seeing you there.

Tuesday, July 28, 2009

Transcripts added to DB2 on Campus videos

Hi All,

We have just added transcripts to each DB2 on Campus video. You can find them in the video description when you watch a video (right under it), or in this page under the "Transcripts" column. If you would like to volunteer to translate the transcripts, let me know!

Enjoy! Raul.

Thursday, July 23, 2009

The great cloud computing deception - Webinar

Join IBM and xkoto to get beyond the hype of the cloud. Attend a free Webinar on the subject. More info here:
http://freedb2.com/2009/07/22/the-great-cloud-computing-deception/

Cheers, Raul.

Monday, July 6, 2009

FREE DB2 Express-C book updated to 9.7

The third edition of the "Getting Started with DB2 Express-C" book has been updated to 9.7 and is available at this link.

Tell us what you think about the book, and how we can improve it! We would like to collect as much feedback from the community as possible, and fix any typos, unclear sentences, incorrect examples, etc, by September, and publish again with the corrections made.

Happy reading!

Raul.

DB2 on Campus Thailand 2009

From June 29th to July 3rd the DB2 on Campus program was presented to several universities in Bangkok, Thailand. As usual, Sunicha E. (IBM Thailand) provided great support and logistics work. Also as usual the schedule was packed with activities. The first two days were spent on a 2-day workshop for instructors which included one full day on DB2 9.7's new features where tutorials were performed using the "Technology Explorer" open source software originally developed at the Toronto lab. The following days were spent at different universities (SIIT, KMUTT, KU, etc) reaching approximately 400 attendees. There was also a 'celebration' event for DB2 Student Ambassadors to thank them for their contribution to the translation of the DB2 Express-C book to Thai (currently under review by IBM Thailand before publishing it). Within this tight schedule, the organizers also managed to squeeze in a customer visit to present to DBAs and developers the new features about DB2 9.7.

The DB2 on Campus program has visited Thailand at least 4 times now. Its impact has been felt as we see several universities adopting DB2 in their curricula, the most number of participants (2000 students) in ASEAN for the XML Superstar challenge, and the fact that Thai students won at the ASEAN level on all three categories of the contest (video mania, Query challenge, and programming contest). Congratulations to Thailand universities and students!

Raul.

Friday, June 26, 2009

DB2 on Campus Tour - Phillipines

After 5 university visits in Manila, and Cebu, the DB2 on Campus tour in the Phillipines ended today. We reached almost 800 students and teachers in 1 week with very good feedback. At UC (University of Cebu - Main campus) the attendance was close to 300 people (this is the second largest attendance in one single event I've ever had, the first one was in China with 330 people approx). According to Jun Contreras (IBM Phillipines), there would've been even more visits and attendance (maybe 2000 to 3000) should the H1N1 (swine flu) scare had not disrupted classes in some universities. I may be returning in September to deliver a TTT (teach the teachers) 2-day workshop. Next stop: Thailand.

Cheers, Raul.

My prediction

While celebrating the DB2 on Campus 3rd birthday, I remember predicting the future of MySQL in one of my presentations. It all happened during my first DB2 on Campus tour in Brazil; I recall being asked why students should choose DB2 Express-C instead of MySQL. At that time, I replied saying that DB2's performance, scalability and support for stored procedures made DB2 Express-C a superior product. I also mentioned that with DB2 Express-C your career would be 'safe' because IBM invests and will keep investing in DB2 Express-C given that DB2 Express-C is the core of the other DB2 editions, and the fact that DB2 is used as the database for many other IBM products. On the other hand, I said
"...with MySQL being open source, its future is not that certain. So investing your time an effort to become a MySQL expert may not pay off in the long run because maybe a company like Oracle would buy it, and then kill it".

Three years after this "prediction", we find that Sun bought MySQL, and then Oracle bought Sun, which made MySQL an Oracle product. I wish I could predict the lottery numbers like this =).

Moreover, this is an interesting article about how Oracle killed a company it bought (Virtual Iron) just 5 weeks after completing its acquisition.

It's time to try DB2 Express-C! Download the newest version, DB2 Express-C 9.7!

Raul.

DB2 on Campus Birthday: 3 years old!

The DB2 on Campus program started 3 years ago in June/July of 2006. I don't recall the exact date, but since today is a Friday I decided to pick this day to celebrate!

Thanks to the many volunteers and DB2 Student Ambassadors who have kept the program going!. So let's join the 28,000+ students and teachers who have attended the DB2 on Campus presentations in more than 250 universities around the world, and let's join the more than 45,000 people who have downloaded the DB2 Express-C book, and the DB2 on Campus videos to say:

Happy 3rd birthday DB2 on Campus program!!!

Raul.

Wednesday, June 24, 2009

Enabling applications from Oracle to DB2 the easy way

Register to the DB2 Chat with the Lab to learn how to enable an Oracle application to DB2 9.7 easily. This event will be held on Thursday 16th July 2009 at:
11:30 am Eastern / 10:30 am Central / 8:30 am Pacific / 4:30 pm London / 17:30 Munich time. Register here.

Cheers, Raul.

Saturday, June 20, 2009

DB2 9.7 is now available!

DB2 9.7 is now available! To download the latest DB2 Express-C 9.7, click here.

DB2 Express-C 9.7 includes a number of improvements and enhancements, too long to provide a complete list here. Other editions of DB2 include even more improvements. You can review the "What's new overview" section of the DB2 Information Center for details. However, these are the ones I like:

1) Locking enhancements
With the new Currently Committed (CC) semantics of the CS isolation level, writers (i.e: UPDATE) will not block readers (i.e SELECT). Readers will read the currently committed value prior to the update operation. This will improve concurrency and reduce deadlocks.

For example, say you have a table T1 with the following contents:

FIRSTNAME LASTNAME
Raul Chong
Jin Xie

Now say an application AppA issues this statement, but does not commit:
update T1 set lastname = 'Smith' where firstname = 'Raul'

Next, application AppB issues this statement:
select lastname from T1 where firstname = 'Raul' with CS

Prior to DB2 9.7, this last statement would hang because it would wait for the exclusive lock held by the update statement of AppA (the writer) to be released. With DB2 9.7 and currently committed enabled (the default for new databases), the statement would return the currently committed value which was Chong.

2) Performance enhancements
For dynamic SQL, DB2 9.7 introduces the 'statement concentrator' feature, which should improve the performance of programs developed in languages such as Ruby and PHP. As its name suggests, the statement concentrator will look for SQL statements that look exactly the same but where the parameter value is different, and will 'concentrate' those statements into one. For example:

SELECT name FROM employee WHERE empid = 10
SELECT name FROM employee WHERE empid = 20
SELECT name FROM employee WHERE empid = 30

will be concentrated into:
SELECT name FROM employee WHERE empid = ?

The question mark (?) represents a parameter marker. At runtime, DB2 will supply the value of 10, 20 and 30 for this particular example. This will provide a huge performance boost. In prior releases, DB2 would treat each statement as unique, and would compile and execute each statement separately. However, the access plan for all these statement was likely the same, so it was a waste of resources to calculate it over and over again. With statement concentrator DB2 will compile the statement only once to obtain the access plan for the statement, and then it will reuse it.

Other performance improvements is the ability to store small LOBs inlined with the data rows. This improves performance for these LOBs as they can be access through the bufferpool.

3) Application development enhancements
A large number of improvements is now available to application developers:

a)
Triggers and UDFs now have enhanced SQL PL support. Before DB2 9.7 they only supported inline SQL PL which is a small subset of SQL PL.

b)
For SQL PL stored procedures, default parameter values and assignment of parameter values by name have been included. In addition, new Boolean, cursor, row and array data types are now supported.

c)
ROWNUM and ROWID are supported

d)
DB2 9.7 now supports the concept of a module (similar to the concept of 'Package' in Oracle). A module can bundle related database object definitions

e)
Implicit casting between data types is now allowed. This will be useful for dynamic languages like PHP and Ruby. For example, this is now allowed:

create table t1 (col1 int)
select * from t1 where col1 = '42'

In the example, the string '42' can now be compared to the integer column col1.

f)
There are many new functions for string, date manipulation and so on.

g)
DB2 now supports Create Global Temporary Tables (CGTTs). These are temporary tables where the data is only available during the session. The difference between CGTTs and Declared Global Temporary Tables (DGTTs) is that in the case of CGTTs, the table definition is persisted in the DB2 catalog tables. So once a CGTT is created, it can be used by any session without having to create it again. The rows will be independent per session though.

g)
Public aliases (a.k.a Public synonyms) for global object referencing have been added. Prior to DB2 9.7 all DB2 objects had a unique two-part name. The first part was the schema name, and the second part was the object name. By creating public synonyms, you can reference to objects without the schema name regardless of the user ID connected to the database. For example:

connect to sample user arfchong using mypsw
create public synonym raul for table arfchong.staff
select * from raul ## works OK
select * from arfchong.raul ## Error
connect to sample user db2admin using psw
select * from raul ## works OK

h)
DB2 9.7 has relaxed its object dependency rules to allow for more flexible schema evolution. For example say you had this dependency:

View2 --> View1 --> Table1

If you wanted to change View1, you first had to drop View2 because it was dependant on View1. Now this is not required. DB2 will perform the revalidation of View2 automatically for you either immediately or when the view is used again. This can certainly help developers when testing their applications, and when they need to add columns, or make other changes to the database schema.

Other improvements in the schema evolution area are: Columns can be renamed, the REPLACE option has been added to several CREATE statements so there is no need to issue a drop statement therefore all privileges on the object remain. ALTER COLUMN can now use SET DATA TYPE for all types.

i)
The Visual Studio add-ins have been enhanced

j)
There have been JDBC and SQLJ enhancements to support some of the things mentioned earlier

k)
The TRUNCATE SQL statement is now supported for fast deletes

l)
New data types such as NUMBER, VARCHAR2, TIMESTAMP with a precision are now supported

m)
Better support for Python-DB2 applications

n)
pureXML enhancements such a support for Declared Global Temporary Tables is now available

4) Storage enhancements
Every time I teach DB2, I often get the question about "how much can DB2 store?". And almost on every release, I'm surprised about how our developers at the lab keep pushing the limits. For DB2 9.7, the size of large and temporary table spaces limits have been increased fourfold. For example, a 32k page large table space can now store 64TB. Previously it could 'only' store 16TB.

5) Security enhancements
In the past I used to compare SYSADM with 'God' because he could pretty much have access to everything in DB2. With DB2 9.7 the security model has been enhanced to allow for separation of duties. This minimizes the risk of data exposure and helps with government compliance requirements. There are several new authorities including DATAACCESS and ACCESSCTRL. These authorities can be given to users to access data, and grant access to data respectively. What this means is that a security administrator (SECADM) could revoke SYSADM or a DBADM these authorities, and therefore they would not be allowed to access any data!

6) Manageability enhancements
Now you have the ability to move tables online to a different table space. This means that while users are accessing a table, you can change where the table storage resides.

7) Installation enhancements
Now you can use the db2val command to verify if your DB2 installation is OK.

Many of these enhancements are described in the free online book "Getting Started with DB2 Express-C - 3rd Edition" which has been updated to DB2 9.7. The book will be available this June 26th!.

Enjoy the new DB2 9.7!!!

Cheers, Raul.

Tuesday, June 16, 2009

Webcast: Enabling Oracle apps to DB2 the easy way

DB2 9.7 for Linux, UNIX, and Windows has out-of-the-box support for Oracle's SQL and PL/SQL dialects. This allows many applications written against Oracle to execute virtually unchanged against DB2. Whether you want to switch your custom application or extend your DBMS vendor support, its now time to break free with DB2!

Join experts from the DB2 labs, Sal Vella - VP, and Serge Rielau - SQL Architect, to learn more about what Oracle compatibility means in DB2.

This Chat with the Lab will be held on thursday July 16, 2009 at: 11:30 a.m. Eastern / 10:30 a.m. Central / 8:30 a.m. Pacific / 4:30 p.m. London / 5:30 p.m. Munich

The presentation will last for 1 hour followed by upto 20 min of Questions and Answers.

To receive instructions for attending this webcast, kindly register at:
http://tinyurl.com/oracle2db2

Tuesday, June 9, 2009

New DB2 9.7 Certification Exams & special offer

There will be two new exams being offered for DB2 9.7:

Exam 000-541: DB2 9.7 DBA for Linux, UNIX and Windows (due - July 2009)
Exam 000-543: DB2 9.7 Application Developer (due - August 2009)

In addition, there is a special "Pass & Save" offer: Candidates, who purchase, take and PASS an eligible DB2 Online Assessment Exam between April 24, 2009 and June 30, 2009, will receive a 50% off certification voucher good for the corresponding exam. That's up to $100 USD savings on each exam.

Visit this link for details.

DB2 9.7 videos & Webcast

There are a few interesting videos about DB2 9.7 posted in YouTube:

VIDEO 1:
The performance and cost savings of IBM DB2 9.7 on the Intel Xeon processor 5500 series.

WhereScape, an IBM business partner that helps customers expedite the process of creating, building and managing a data warehouse, discusses the performance and cost savings of IBM DB2 9.7 on the Intel Xeon processor 5500 series. The video also includes interviews from Intel and IBM executives about the cost savings associated with running DB2 9.7, the performance and energy efficiency of the new server platforms and the advantages that a business partner gains from the combined performance and value of DB2 9.7 on the Intel Xeon processor 5500 series.

VIDEO 2:
DB2 9.7 - Hear what customers and consultants are saying about the new release of DB2 9.7 including results their organizations are seeing.

There is also a DB2 9.7 Technology preview Webcast recorded here

and this interesting Web site to reduce costs with 9.7.

Enjoy!, Raul.

DB2 Express-C is 6 to 7 times faster than MySQL counting records

A colleague of mine recently posted an interesting article about DB2 and MySQL's performance when counting records. It shows that DB2 is about 6/7 times faster on the same data. Click this link for more details.

Cheers, Raul.

My developerWorks

IBM developerWorks just announced My developerWorks - a new professional network and knowledge base to connect the technical community around the world.

Check out the demo , and build your profile!

Raul.

Monday, May 11, 2009

DB2 on Campus at YorkU

On April 22nd, Dan Han, the first DB2 Student Ambassador at York University, organized the first ever, DB2 on Campus event at YorkU.

Over 70 YorkU students from Computer Engineering, Computer Science, and IT programs attended the event to learn about the DB2 on Campus program and to help grow the DB2 community. Also, everyone in attendance requested to be contacted about additional DB2 resources, DB2 certifications, and future DB2 events!

Our featured DB2 on Campus Quarterly Newsletter and DB2 Best Practice flyers were picked up faster than free food! We also handed out DB2 9.5 Discovery Kit DVDs, some free t-shirts, and Raul donated a copy of his book, Understanding DB2: Learning Visually with Examples, to the YorkU Library.

Special thanks to the presenters, Raul Chong, Dan Han, and Ali Khan. Special thanks also to Amyris Rada for fielding the multitude of questions from students, and to Harsimran Singh, Ali Khan, and Raeid Saqur - York interns and Club Presidents for helping Dan organize this event.

Feel free to join the DB2 in YorkU group on channelDB2 to keep up with DB2 on Campus initiatives at YorkU, or if you want to contact the YorkU DB2 Student Ambassadors.

Cheers! Agatha/Dan

Thursday, April 23, 2009

DB2 9.7 is announced!

DB2 9.7 is the latest DB2 release bringing compelling features which will reduce COST:

- Reduce storage-related costs for data
- Improve administration productivity, allowing DBAs to focus on higher-value tasks
- Improve developer productivity, accelerating application development.
- Improve business decision making with simplified analytics and end-to-end support for XML documents
- Reduce the expense of deploying and supporting departmental warehousing and analytic solutions

DB2 9.7 will be available for download this June! Read the full press release here.

Register to this Webcast to learn more about DB2 9.7!

Raul.

Tuesday, April 14, 2009

NEW: DB2 on Campus Quarterly Newsletter

Join the new DB2 on Campus Newsletter group on channelDB2
(http://www.channeldb2.com/group/db2oncampusnewsletter)
to download our "first" newsletter! Ask your friends to join as well.

Also use the channelDB2 group to provide feedback, open discussions, or provide material (articles, stories, anything related to DB2 Express-C, etc.) for upcoming newsletters. We look forward to hearing from you.

If you're interested in becoming a DB2 Student Ambassador, write to db2univ@gmail.com

A special thanks to everyone who contributed to this first newsletter!
Agatha (DB2 on Campus Community President)

Tuesday, March 24, 2009

DB2 on Campus 2009 - Book series

This year we started the DB2 on Campus program with a visit to universities in Vietnam late in February. Ninety-one (91) teachers were trained on DB2 Express-C! Each teacher received a hard copy of the Vietnamese version of the book 'Getting Started with DB2 Express-C' in addition to a copy of the DB2 on Campus DVD.

Currently we are updating the DB2 on Campus material, and are developing more free online books. Following the success of the "Getting started with DB2 Express-C" book (which by the way, has been downloaded 35,000 times to date!), we are working on developing 25+ free online books by the community on different subjects: From database fundamentals topics to Cloud computing. More than 100 volunteers are already participating, and they will be published around September. Even though the book work has already started, more volunteers are always welcomed!. English editing and technical reviews will be needed. In the future we will work on translations for the books. If interested, send us a note to db2univ at ca.ibm.com.

Raul.

Wednesday, March 18, 2009

Portuguese (Portugal) translation of free DB2 Express-C book is available!

Hello,

The Portuguese (Portugal) translation of the free "Getting Started with DB2 Express-C" book is now available!. Find it at the same location as the other books.

Thanks to all the volunteers from the community for making this translation a reality!

Other translations almost done: Japanese, Turkish, Thai, Indonesia Bahasa.

Cheers, Raul.

Thursday, February 12, 2009

DB2 Express-C is now on the cloud! - Cloud computing

Today IBM announced a partnership with Amazon Web Services to deliver software via Cloud Computing. Read the full press release.

As part of this announcement we have made available Amazon Machine Images (AMIs) for various IBM products including DB2 Express-C. They can be used for development. More information can be found here.

Check out this general IBM FAQs or DB2 specific FAQs on this subject.

On the technical side, here is documentation for using the pre-built DB2 AMIs:

- Get Started Guide

- Rebundling Guide

We also have a screencast showing you how to create your own DB2 AMIs from scratch

Enjoy! Raul.

Spanish translation of "Getting Started with DB2 Express-C" book now available!

The title says it all!. Let your friends, colleagues, teachers, students know about it!. The Spanish translation of the book can be found with the other ones here. Thus far the following translation are available:

English
Portuguese (Brazil)
Simplified Chinese
Vietnamese
German
Polish
Italian
Spanish

We are constantly looking for volunteers to translate the book, so please send us a note to db2x@ca.ibm.com if interested!

Some other translations still ongoing are: Indonesia Bahasa, Thai, Bulgarian, Japanese, and Russian.

Cheers, Raul.

Thursday, January 8, 2009

Nominate a Data Champion! - Deadline is January 31st

Last October I blogged here about the IBM Data Champion program. This is the perfect way to recognize a community member that's made a difference to the community in their daily work life. The nominations deadline is January 31st! Hurry! More information can be found from this other blog.
Raul.