Wednesday, November 30, 2011

DB2, Big Data and Cloud webinar on Dec 6

The next Chat with the Lab is on Tuesday, December 6. Experts from IBM and RightScale will jointly cover DB2, big data, and cloud computing topics:

Leveraging Clouds for Small and Big Data

Date:Dec 6, 2011
Time:12:30 PM - 2:00 PM (Eastern Time)
Hosted By:Rav Ahuja (IBM)
Presented By:Leon Katsnelson (IBM), Uri Budnik (RightScale), Robert Thomas (IBM)
Many experts agree that Cloud Computing has now matured past the initial hype phase and that organizations large and small have started to derive real benefits by placing applications and data on Clouds. In this webinar we will discuss how to leverage Cloud Computing for managing data and gaining insights from big data. We will cover various Cloud options (public, private, and hybrid) available for managing data in the Cloud with IBM DB2 database server as well as for deriving value from big data using IBM BigInsights hadoop-based platform. We will also show you how to be up and running in as little as a few minutes using free editions of DB2 and BigInsights. You ought to find this session useful regardless of whether you are a beginner or expert in cloud computing or big data.

To learn more please Join Uri Budnik (RightScale), Leon Katsnelson (IBM), and Rav Ahuja (IBM) on Tuesday December 6th, 2011 at 12:30 PM Eastern.

Presentation slides will be available for download from shortly before the webcast starts.

Tuesday, November 22, 2011

Over 10,000 people sign up for DB2 University

This morning, DB2 University reached the milestone of 10,000 registered users taking free courses on SQL, DB2, Data Studio, and other topics. The courses are self-paced, with exercises after every topic and a test at the end. People who complete a course receive a certificate and possibly other rewards.

If you've just downloaded the new DB2 Express-C 9.7.5, taking a course on DB2 University might be a good way to bring yourself up to speed.

Monday, November 14, 2011

Download DB2 Express-C 9.7.5, now with Oracle compatibility

The free IBM DB2 Express-C database now includes the same Oracle compatibility features as IBM's enterprise databases. These features include support for PL/SQL, CLP+, data types, syntax, and much more.

Other new features in the 9.7.5 release include:
  • Enhancements for migrating SQL C applications from other database systems
  • Support for nested array and row types
  • New HexToRaw, NVL2, and SubStr2 functions and enhancements to other functions
  • Additional diagnostic options for various commands
Next steps

Wednesday, October 05, 2011

Hadoop programming challenge extended

The Hadoop programming challenge at Big Data University has been extended to October 10th. This is due to many of the nearly 2000 people who've taken the Hadoop Fundamentals course asking for an extension.

The challenge involves completing the Hadoop Fundamentals course and doing an additional exercise to demonstrate skill and creativity with the Hadoop data processing framework. The submission deadline is now Monday, October 10th, 11:59pm PST.

Three participants in the challenge will be selected for an expense paid trip to the IOD conference in Las Vegas.

Big Data University and its sister site DB2 University offer free courses in SQL, Hadoop, and other topics.


Leons Petrazickis
DB2 Community Team

Tuesday, October 04, 2011

Free InfoSphere Data Architect book, now in Chinese

The free Getting Started with InfoSphere Data Architect book is now available in Simplified Chinese as well as English. InfoSphere Data Architect (IDA) is a data modelling and integration tool aimed at the enterprise. The book aims to help you:

  • Learn how to work with logical and physical database designs
  • Learn how to create, deploy, and update data models
  • Discover how to forward- and reverse-engineer your data sources
  • Learn more about data privacy, security, and lifecycle management
  • Practice using hands-on exercises   

The book is part of the DB2 on Campus book series, which includes among others:

Next Steps

Leons Petrazickis
DB2 Community Team

Wednesday, September 14, 2011

Go back to school, take a free SQL course

DB2 University is a site that offers free online courses in basic SQL as well as DB2, Data Studio, and other technologies. The courses are self-paced and guide students through series of exercises. Course completion is recognized with a certificate.

At the time of writing, DB2 University boasts of nearly 6000 students worldwide who've taken a quick course or two and bolstered their database skills.

The Big Data University sister site is running an interesting promotion for its Hadoop Fundamentals I course. The best three students who complete the free Hadoop course and an additional exercise for October 3rd will get to go on an expenses-paid five day trip to Las Vegas and attend the Information on Demand 2011 conference.

Hadoop is an open source programming framework for processing large quantities of data in computer clusters. It's part of IBM's InfoSphere BigInsights offering.

Next steps


Leons Petrazickis
DB2 Community Team

Wednesday, July 20, 2011

Get Data Studio

The free IBM Data Studio tools for DB2 have been updated with new features:
  • Table Data Editor that can directly edit data in tables, views, aliases, and materialized query tables, as well as browse through data in nicknames and synonyms
  • Filters in Administration Explorer to quickly find the object you are looking for
  • Impact and dependency analysis for routines and packages to allow easier change management
  • Performance enhancements for catalog navigation
  • Support for Kerberos, Citrix XenApp, and TABLESAMPLE (see changelog)
It's available for download today:

Leons Petrazickis
DB2 Community Team

Tuesday, June 28, 2011

Private Clouds and DB2: Webcast on Wednesday

The next DB2 Chat with the Lab is this Wednesday. I'll be helping answer your questions in the Q&A, so naturally I encourage everyone to join:
Easily Deploy Database Workloads on Private Clouds
Date: Wednesday, June 29, 2011 (29.6.2011)
Time: e12:30 AM – 2:00 PM Eastern Time (ET)
11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 10 PM
As more and more businesses look for ways to reduce costs within IT, their research typically discovers cloud computing. However Public Clouds are not an option for many enterprise workloads and applications with strict security and privacy requirements. Organizations with such needs can benefit from building Private Clouds within their own data centers. In this webcast we will look at a fast path to deploying private clouds for database workloads.
We will specifically look at instant provisioning of DB2 systems and databases in a private cloud infrastructure using the IBM Workload Deployer (IWD), previously called the WebSphere CloudBurst Appliance. We will also look at how IWD can be easily used for implementing complete web application patterns with web servers, application servers (WebSphere), and DB2 database servers with high availability options. 


Leons Petrazickis
DB2 Community Team

Tuesday, June 14, 2011

Overview: DB2 on Campus book series

DB2 on Campus is a community-driven series of free ebooks. As of June 2011, it includes the following books:
If you are interested in translating one of the books into your native language, or applying your technical skills to review the fine details, you can email the DB2 on Campus program via db2x [at]

Some of the books above are used as reference texts in the free courses on

Leons Petrazickis
DB2 Community Team

Monday, June 06, 2011

Free ebook: Getting Started with pureQuery

Getting Started with pureQuery is the latest free ebook in the DB2 on Campus book series. It aims to help you:
  • Learn how to use pureQuery in Optim Development Studio
  • Write efficient Java database apps using pureQuery
  • Understand how pureQuery can optimize Java Persistence API and Hibernate apps
  • Practice while developing a sample Java app
A good way to get started with pureQuery is to get the following:
If you are a Java dev, you might also want:

    Leons Petrazickis
    DB2 Community Team

    Monday, May 02, 2011

    DB2 Express-C 9.7.4 released!

    DB2 Express-C 9.7.4 is now available for download. It is a full refresh of the free edition of the DB2 database server.

    Improvements include:
    • An up to 37% lighter download footprint on Windows and Linux
    • Ability to store string match patterns for LIKE conditions in database columns
    • Faster indexing and more powerful searches using DB2 Text Search
    • Compound triggers for UPDATE, INSERT, and DELETE
    Download it now!

    It's interesting to note that DB2 Express-C 9.7.4 came out on the cloud first and as a traditional download second. The cloud image template for Rightscale/Amazon EC2 has been available since past Friday.

    Tuesday, April 19, 2011

    DB2 アプリケーション 開発入門

    The free Getting Started with DB2 Application Development book has just been translated into Japanese. The book aims to help you:
    • Work with DB2 and Java, C/C++, .NET, PHP, Ruby on Rails, Perl, and Python
    • Write SQL, XQuery, and understand pureXML
    • Learn how to develop DB2 stored procedures, functions and web services
    • Practice using hands-on exercises

    The main book in the series, Getting Started with DB2 Express-C, is available in Japanese as well as Czech, German, and Vietnamese. An earlier edition is available in Bulgarian, Chinese, Italian, Polish, Portuguese, Spanish, and Thai.

    Books in the DB2 on Campus series are written by community volunteers like yourself. If you are interested in updating or translating one of the books in the DB2 on Campus series, please send an email to: db2x at


    Leons Petrazickis
    DB2 Community Team

    Thursday, April 07, 2011

    Data Studio book updated for 2.2.1

    The free Getting Started with Data Studio book has been updated with new content, including a guide to the new Task Launcher interface, which helps you design, develop, administer, tune, and monitor your databases.

    The book still helps you:
    • Find out what IBM Data Studio can do for you
    • Back up and recover DB2 databases
    • Write and debug SQL stored procedures and routines
    • Learn more about integrated data management
    • Practice using hands-on exercises
    Getting Started with Data Studio is part of the DB2 on Campus book series. The flagship book in the series is the equally free Getting Started with DB2 Express-C.


    Leons Petrazickis
    DB2 Community Team

    Wednesday, April 06, 2011

    Create a free site on Radiant CMS and DB2

    Antonio just put up a a great tutorial for creating a free website using Radiant CMS and DB2 on Amazon.

    A great thing about this configuration is that it uses an Amazon micro instance, and Amazon lets new customers try out micro instances for free for a year. I talk a lot about free cloud offers, but usually I mean that our software is free while you are still paying someone for the hardware. In this case, the hardware is free too.

    Radiant is a content management system (CMS). Other popular CMS software includes Drupal and Joomla, with blogging tools like Wordpress increasingly gaining CMS-like features.

    In my experience, the hardest part of running a website is maintenance. Keeping the content up to date while posting new things can be a challenge. A CMS like Radiant makes this a lot easier by separating your content from the site's structure and appearance, so one doesn't distract you from the other. From the point of view of a site owner, a CMS-drived website really is far superior to the traditional hand-rolled websites of yesteryear.

    What's this got to do with the glory of the free DB2 Express-C database? Well, that's where your content gets stored.

    So, I dare you -- launch a site on Radiant CMS and DB2 today.


    Leons Petrazickis
    DB2 Community Team

    Tuesday, April 05, 2011

    Data Studio Standalone compared to IDE

    Richie on the Data Studio team recently pointed out a great table comparing Data Studio Standalone to Data Studio IDE. The short of it is that both are great tools for administering DB2, with IDE adding some features aimed at Java developers specifically. Let me put a slightly rearranged version here:

    GroupDetailsData Studio StandaloneData Studio IDE
    Architecture data modeling

    Database overview diagramsYesYes
    Instance management

    Start, stop, quiesce, unquiesce a DB2 for Linux, UNIX, and Windows instanceYesYes

    Start, stop, quiesce, unquiesce a DB2 pureScale memberYesYes

    Configure a DB2 for Linux, UNIX, and Windows instanceYesYes

    Configure a DB2 pureScale memberYesYes
    Object management

    Create, alter, drop DB2 or IDS server objectsYesYes

    View and edit privileges for DB2 and IDS data server objects and authorization IDSYesYes

    Impact analysis - report on dependenciesYesYes

    Generate DDLYesYes

    Generate commands for DB2 for Linux, UNIX, and Windows - start, stop, quiesce, etc.YesYes

    Generate utilities for DB2 for Linux, UNIX, and Windows - backup restore, reorg, etcYesYes

    Data distribution viewerYesYes
    Data management

    Export and import tableYesYes

    Extract data, extract as XML (from SQL results)YesYes

    Sample contentsYesYes

    Load dataYesYes

    Unload using Optim High Performance Unload (separate purchase)YesYes

    Edit dataYesYes
    Application development

    Integrated Query Editor (SQL and XQuery) with query formattingYesYes

    SQL BuilderYesYes

    Advanced query formattingYesYes

    Visual ExplainYesYes

    Access plan graph (enhanced Visual Explain)YesYes

    Single query statistics advisorYesYes

    SQL query environment capture for serviceability (z/OS only)YesYes

    SQL routine editor and debugger (including PL/SQL for DB2 for Linux, UNIX, and Windows deployments)YesYes

    Java routine editor and debugger

    SQLJ development

    XML editor, schema editor, and annotated XSD mapping editor

    Data Web Services development and deployment

    Shell sharing with other Rational or Optim products

    I usually recommend Data Studio Standalone since it's a smaller download. Data Studio IDE adds several useful features for Java developers.

    A good resource for learning either is the free Get Started with Data Studio book.
      Google Analytics Alternative