Tuesday, December 07, 2010

Treat yourself to DB2 this holiday season

Earlier this year, Oracle acquired MySQL. They have since significantly hiked up prices across the entire MySQL line. Today, it costs more to get a year's subscription to MySQL than to simply get IBM DB2 Express Fixed Term License (FTL).

What surprises me is how much more value you get by going with IBM. DB2 is 60% cheaper than a comparable MySQL edition. You can set up a cluster of two DB2 servers for the price of one MySQL server and have change left over.

Keep in mind that MySQL Enterprise limits you to four processors, which is comparable to the DB2 Express limit of four cores across two processors.

DB2 Express FTL, which is built on exactly the same code as all IBM DB2 editions, comes with official IBM 24x7 Support, High Availability Disaster Recovery clustering, SQL replication, backup compression, Optim Development Studio, Optim Database Administrator, DB2 fixpacks, and access to older DB2 releases through IBM Passport Advantage.

DB2 users
 New visitors

Tuesday, November 30, 2010

Try the next version of DB2 in the Cloud

The DB2 Early Experience program lets you try the latest version of DB2 under development. Your feedback then helps build a better DB2.

By participating in the DB2 Early Experience program on the cloud, you can create your own DB2 server without having to obtain hardware, install and patch operating systems, or install the DB2 Early Experience code. Simply boot your database server when you want to use it and shut it down when you’re finished.


Leons Petrazickis
DB2 Community Team

Thursday, November 25, 2010

DB2 and Ubuntu whitepaper

Andre, Boris, and Hua just put out a new whitepaper:
The synopsis promises that you will:
  • Get started with DB2 on Ubuntu 10.04
  • Understand the differences between all DB2 for Linux, UNIX, and Windows editions.
  • Practice simple SQL queries against a sample database.
I've made a few blogposts on the same topic in the past couple months:


Leons Petrazickis
DB2 Community Team

Tuesday, November 23, 2010

Check out the Task Launcher in Data Studio 2.2.1

Data Studio V2.2.1 is out and available for download:

I found the new Task Launcher to be a pleasant surprise. It is a very good reorganization of all the different things that Data Studio can do into five simple tabs: Design, Develop, Administer, Tune, and Monitor.

I minimized it in the screenshot above, but the usual interface is still there. There's been a few tweaks, and I think that overall Data Studio V2.2.1 is a great improvement over Data Studio V2.2. I use it regularly myself, and I recommend that anyone who administers or develops with DB2 pick up a free copy:


Leons Petrazickis
DB2 Community Team

Monday, November 15, 2010

Chat about development and test with cloud computing

There's an upcoming DB2 Chat with the Lab on Friday, November 19th:
Leverage Cloud Computing to Accelerate Development and Test

Date: Thursday, November 18, 2010
Time: 11:30 AM - 1PM EST

Are your application development and prototyping projects being put on hold due to budgetary constraints? Do you continually have to wait for new hardware and software to be procured and provisioned before your developers can start new projects? Are your current development and test systems sitting idle most of the time? Do you spend long cycles creating copies of your development or production environments for testing new changes and updates?

Join Sal Vella, VP (IBM), Uri Budnik, Director (RightScale) and Leon Katsnelson, Program Director (IBM) to learn more.

Next steps

Leons Petrazickis
DB2 Community Team

Tuesday, November 02, 2010

Meet some IBMers at the RightScale conference on Nov 3

You might run into some DB2 Community Team folks at the RightScale conference in Santa Clara on Wednesday, November 3rd. We'll be down there both as attendees and as a Gold Sponsor.

RightScale provides an automation wrapper around Amazon EC2 and other clouds, simplifying the management of multiple machine deployments, allowing instant cloning of existing deployments, and automating automatic growth of server clusters based on load among other features. You can find DB2 and WebSphere templates for RightScale today.

One of the things that folks on my team do is build the DB2 templates for RightScale.

Leons Petrazickis
DB2 Community Team

Monday, November 01, 2010

RPM and DEB packages for DB2 Express-C

RPM and DEB are two standard installation package formats on Linux. RPM is the default on Red Hat, SuSE, and CentOS, while DEB is used by Debian and Ubuntu among others.

DB2 Express-C is available for download both of these formats. You can also get it directly through the official Ubuntu repositories.


Leons Petrazickis
DB2 Community Team

Tuesday, October 26, 2010

Get email updates for the DB2 Express-C Team Blog

Thanks to Google FeedBurner, you can now get a copy of new posts to this blog emailed to you. If there's ever more than one post a day, FeedBurner will send a simple daily digest instead.

Subscribe via email

Enter your email address:

Naturally, you can unsubscribe at any time.


Leons Petrazickis
DB2 Community Team

Wednesday, October 20, 2010

The daily #db2 twitter newspaper

There are good tools out there to cut down on the amount of noise on Twitter. One of them is the daily newspaper on paper.li, which presents a summary of the interesting tweets on a specific topic.

Some that you might find interesting:
There's a convenient option to subscribe to these via email, so paper.li notifies you whenever a new one comes out.


Leons Petrazickis
DB2 Community Team

Tuesday, October 19, 2010

Free book: Getting started with DB2 application development

Getting Started with DB2 Application Development is a new book in the On Campus book series. It's available for free download as a pdf.

The book sets out to help readers:
  • Discover application development with DB2 Express-C
  • Write SQL, XQuery, and understand pureXML® technology
  • Learn how to develop stored procedures and web services
  • Work with Java, C/C++, .NET, PHP, Ruby on Rails, Perl, and Python
  • Practice using hands-on exercises
Published books in the series include:

Leons Petrazickis
DB2 Community Team

Wednesday, October 13, 2010

Webinar on using cloud for development and test October 14

There's a joint RightScale and IBM webinar about using cloud computing for development and test on Thursday, October 14:
Higher Quality Development, Faster Release Cycles
Thursday, October 14, 2010
7am Pacific / 10am Eastern / 3pm London
11am Pacific / 2pm Eastern / 7pm London
  • Betsy Zikakis: Vice President, RightScale
  • Uri Budnik, RightScale Evangelist
  • Leon Katsnelson: Program Director, IBM Data Servers
  • Kevin Schroeder: Technology Evangelist, Zend
Join our live webinar to find out how a managed cloud solution can enable software development organizations to overcome common challenges. We’ll demonstrate the RightScale Development and Test Solution Pack featuring Zend and IBM software stacks and show you how you can reduce the time you spend configuring hardware and managing resources. Plus we’ll show you how your developers and testers can spend less time fixing errors and reworking code and more time experimenting, developing and testing.
The RightScale Development and Test Solution Pack delivers:
  • Quickly available, easily provisioned resources
  • Consistent, reproducible environments
  • Pre-configured components to get you started fast
  • Feature-rich options from our partners IBM and Zend
  • Ability to customize to your specific requirements
  • Control over users and costs
  • Powerful multi-cloud management
Register to attend

Leons Petrazickis
DB2 Community Team

Tuesday, October 12, 2010

Cloud computing webinars October 12, 13

IBM developerWorks is hosting free cloud computing webinars today and tomorrow. I highly recommend my colleague Raul Chong's session on October 13th:
Database design for multi-tenancy and resiliency
2:30PM-3:30PM Eastern

I will be presenting on Oct 13th. My session is #3 and is titled "Database design for multi-tenancy and resiliency" ( 2:30PM-3:30PM EST = Toronto time). I will be talking about Amazon's and DB2's offerings/features for Software as a Service (SaaS) vendors who use multi-tenancy to reduce costs. I will also discuss about DB2's HADR feature as part of the resiliency section, and provide a demo to set it up using Rightscale.
Register to attend

    Leons Petrazickis
    DB2 Community team

    DB2 Express-C for Amazon EC2 updated with new interface

    Juice DB reports that the DB2 Express-C Amazon Machine Images (AMIs) for Elastic Compute Cloud (EC2) have been updated to 9.7.2. In addition to running the latest release of DB2 Express-C, they now include a simple web interface for the initial configuration in place of the older console-based approach.

    Run these AMIs through Amazon DevPay:
    DB2 Express-C is a free product. There are no license fees, but you do have to pay Amazon for its hosting.

    Once subscribed, you can launch them with the AMI ids below.

    US Region:
    32-bit ami-1b30db72 ec2-dev-ibm-images/ibm-db2-express-c-9.7.2-32-bit.manifest.xml
    64-bit ami-1930db70 ec2-dev-ibm-images/ibm-db2-express-c-9.7.2-64-bit.manifest.xml

    AP Region:
    32-bit ami-97c7b8c5 ec2-dev-ibm-images-ap/ibm-db2-express-c-9.7.2-32-bit.manifest.xml
    64-bit ami-7bc6b929 ec2-dev-ibm-images-ap/ibm-db2-express-c-9.7.2-64-bit.manifest.xml


    Tuesday, October 05, 2010

    DB2 Express FTL gets more features, lower price

    DB2 Express FTL now has more features and costs half as much. This is part of an array of changes IBM announced today across the DB2 database server line.

    Getting the 12 month subscription to DB2 Express FTL gets you IBM's official 24x7 support, DB2 fixpacks, High Availability and Disaster Recovery clustering, SQL replication, backup compression, and access to older DB2 releases through IBM Passport Advantage.

    As of October 5th, the DB2 Express FTL license also includes Optim Development Studio and Optim Database Administrator. These tools increase development efficiency by 50% for Java data access, help pin-point query bottlenecks, automate data migration with object dependencies, and provide a full range of  functionality for database administration and development.

    High Availability Disaster Recovery (HADR) provides a means for to shift database processing to a standby system in case of a primary system failure. Find out more in the HADR whitepaper (pdf).

    Backup compression is an effective way to reduce storage costs in cloud computing and similar environments. When you renting storage on Amazon S3, a significant reduction in storage required for backups saves you money.

    SQL replication lets you automate the movement of data from your production database for reporting, analysis, and warehousing.

    DB2 Express FTL gets you double the database performance by taking advantage of twice as many cores and twice as much RAM as DB2 Express-C.

    24x7 IBM Support gives you peace of mind should anything ever go wrong.

    DB2 Express Fixed Term License (FTL) is the natural step up from the free DB2 Express-C. The price for it is set at $1990, about half the price of comparable competitor offerings.

    Comparing the free edition with Paid Subscription
     DB2 Express-C  DB2 Express FTL
    Core DB2 capabilities
    Yes Yes
    Free admin tools
    Yes Yes
    Free development tools
    Yes Yes
    Autonomic capabilities
    Yes Yes
    pureXML™ feature
    Yes Yes
    No-charge community-based assistance
    Yes Yes
    Max. processor cores in use
    2 4 over 2 sockets
    Max. memory use
    2GB 4GB
    Official IBM 24x7 support

    Fix packs

    High Availability (HADR)

    Data replication

    Backup compression

    Optim Development Studio

    Optim Database Administrator

    Access to previous versions

    Price per server per year
    $0 US $1,990

    Next steps

    DB2 Express-C ebook and other ebooks updated

    Hi All,

    We have updated the free "Getting started with DB2 Express-C" ebook with information covering up to DB2 version 9.7.2. This is the 3rd printing/update of this popular ebook. The update is minor, so we have not changed the edition of the book which remains at "3rd Edition". Some of the changes/additions made are:
    • Table of content links are now working
    • Typos fixed
    • Updated information about Data Studio
    • Cost of DB2 Express server license reduced to $1500USD per server
    • Availability of lighter DB2 Express-C images on Windows (44% lighter)
    • Added a Download section listing all DB2 Express-C images available for download
    • Added information about Spatial extender
    • Added a paragraph on auditing improvements with 9.7.2
    • Added an ISBN number to the book
    Download the updated ebook now!

    We have also updated all the other ebooks fixing minor typos and formatting issues:
    and we have just published a new ebook: Getting started with DB2 application development.

    All published eBooks and the ones coming soon are listed at ibm.com/db2/books

    Cheers, Raul.

    Make your data always available - 30 minutes to set up

    Having worked in technical support for a number of years, there is one thing that always stressed me out the most: The sound of a pager in the wee hours of the morning. That beeping sound is the most annoying one I've experienced in my IT career so far; it normally signaled an emergency that needed to be fixed asap, no matter how many hours it would take.

    Like me, I don't think DBAs like to be paged in the middle of the night when there is a system failure. With DB2 database servers, you can minimize disruptions to your life and ensure to keep your boss and your company happy by investing 30 minutes of your time; it's that simple! Thirty minutes is all it takes to set up HADR (High availability disaster recovery) feature available with DB2. The technology used in HADR has been around for more than a decade. We based it on Informix (another IBM database server) and it is very robust.

    The basic requirements for HADR are:

    • Two servers running DB2 (at least DB2 Express edition) using the same operating system, and same storage setup.
    • The DB2 fixpack levels may be different as well as the operating system maintenance levels
    • A network connection between the two servers.

    Now let me explain how it works with a few figures. HADR works at the database level. Figure 1 shows a client at the top, and two servers using HADR and in sync at the bottom.

    Figure 1 - How HADR works - Part 1

    In the figure, the Primary server (on the left) is the DB2 server that handles all your transactions; the Standby server (on the right) is the DB2 server ready to take over the workload in case the primary server goes down.

    In (1) the client performs transactions which are sent to the DB2 primary server. In (2) the DB2 primary server processes the transactions and stores the modified data on disk. The operations performed, for example an UPDATE statement, are also logged in files (log files), which are also stored on disk. In (3), the log files are sent to the Standby server which processes them in (4). This way the Standby is kept in sync with the Primary.

    Figure 2 illustrates what happens when for any reason the Primary server crashes as shown in (1).

    Figure 2 - How HADR works - Part 2

    In (2) Tivoli System Automation (TSA) which is included with the HADR feature detects that the primary server crashed, and thus, executes a "takeover" command. The takeover command switches the roles between primary and standby servers. Note in the figure, the server on the right is now identified as the primary. In (3) when client attempts to reach the server on the left fail, the "Client reroute" feature included with DB2 kicks in, which automatically reroutes the client's work to the server on the right. Work then continues as usual and in (4) transactions are processed and stored on disk. This whole process takes only 15 seconds!

    Figure 3 illustrates what happens when the server on the left is restarted or fixed. It shows the server on the left is now the Standby and the server on the right is now the Primary. The steps shown in Figure 3 are identical to Figure 1 just reversed. The Standby server on the left will first catch up by applying log files sent by Primary from the time the crash happened.

    Figure 3 - How HADR works - Part 3

    You can also use the standby server for read-only operations for example for reporting. This is an added benefit because it ensures the primary server is used mainly for transactions (OLTP) workloads, while the standby takes care of reporting (DSS/OLAP) workloads. If a takeover operation is required, readers are blocked from the standby.

    Another added benefit of HADR is that it allows you to perform rolling upgrades without disrupting your operations. This means you can suspend HADR to apply maintenance to one server first (say the standby) while operations are continuing on the primary. You can then start HADR again so the two servers are put in sync, and then switch the roles with a manual takeover command. Suspend HADR again, and then apply maintenance on the other server.

    This feature provides a lot of value to any company and can be easily set up in minutes from the DB2 Control Center or IBM Data Studio. It allows for high availability as described above, when both servers are sitting on the same location. If you want this feature to support Disaster Recovery, all you need is place the standby server in another location (another building, state, country or continent). This is why the feature is called HADR.

    There are many other options and scenarios with HADR. For example, you can set up HADR in the Cloud. I will also be talking about HADR next week at the developerWorks CC4D (Cloud Computing for developers) event. My session is titled "Database design for multi-tenancy and resiliency". HADR fits the "resiliency" part.

    Though HADR is not available with DB2 Express-C, it is available with DB2 Express which has also other benefits.

    For more details about HADR and other high availability and disaster recovery scenarios, watch the replay of this Chat with the labs event.

    Cheers, Raul.

    Wednesday, September 29, 2010

    Open beta for Visual Studio 2010 support in DB2

    Update: The beta is now at the DB2 V9.7 FP3a level. Check the forum link for the latest instructions.

    An open beta has come out of the IBM Data Server .NET provider for .NET Framework 4.0 as well as DB2 Add-ins for Visual Studio 2010. This beta level package requires a DB2 [9.7 FP3a] client install, and has the following features:
    • DB2 .NET provider for connectivity to DB2 LUW, IDS, DB2 for z/OS and DB2 for IBM i
    • DB2 Connect license required for z/OS and IBM i
    • Entity Framework provider
    • Entity Framework support for database first scenarios
    • Entity Framework canonical function support
    • Full filtering of Add Connection properties when use with Entity Framework Designer
    • Visual Studio 2010 Add-ins
    • Full Server Explorer filtering support
    • Windows, Web and WPF application development scenarios with full drag and drop
    • Designer support for SQL Procedures with syntax highlighting
    • Full end to end debugging for SQL procedures for VB and C# apps
    • Schema evolution support for common developer focused tasks
    • Create database, create / modify table, view and change data
    Please note that two important prerequisites for this beta:
    1. This beta only supports the [V9.7 FP3a] level of our client packages. It will not work with any earlier client package, and should there be a newer client package, this specific beta will not work with that client package.
    2. In addition, the ability to set breakpoints within a stored procedure debugging session requires a Visual Studio 2010 hotfix from Microsoft.
    Next steps


      Leons Petrazickis
      DB2 Community Team

        Monday, September 27, 2010

        DB2 High Availability chat on September 29

        There's an upcoming DB2 Chat with the Lab on Wednesday, September 29:
        DB2 High Availability
        Date: Wednesday September 29, 2010
        Time: 11:30-13:00 AM Eastern / 10:30 AM Central / 8:30 AM Pacific / 16:30hrs London / 17:30hrs Frankfurt, Paris / India 9 PM
        Speakers: Sal Vella - VP, Dale McInnis - Architect

        This webcast provides and in-depth overview of High Availability (HA) options for DB2 on Linux, UNIX and Windows. It covers various HA features and enhancements added to DB2 during the last few releases, including:
        • High Availability and Disaster Recovery (HA)
        • Integrated High Availability and Automated Failover
        • Read capability on Standby Servers
        The Chat will also touch on future directions.

        Leons Petrazickis
        DB2 Express-C Community Team

        Wednesday, September 22, 2010

        Things learned from hiring interns for IBM

        Our team recently hired two new co-op students. My colleague Antonio has written up his experience taking care of the details:
        A few months ago I blogged about the fact that IBM was looking for two interns to fill a long-term (paid) internship. The good news is that after an extensive selection process and a hearty dose of governmental bureaucracy (which is not unusual when relocating countries), two students have finally been able to join our DB2 team at the lab.

        In case you are curious about who the students are, they’re Marius Butuc from Romania, and Henrique Zambon from Brazil. They’re good guys, feel free to follow them on Twitter (even though Henrique’s stream may be more interesting to you if you speak Portuguese).

        The selection process

        I received about 100 resumes from students around the globe who wanted to apply for the internship. Of those, I invited the 50 most promising applicants to have an initial phone interview, as I wanted to give a fair chance to everyone (yet at the same time, I didn’t want get the hopes up of those who clearly didn’t have a shot, and thus the remaining applicants were informed that they hadn’t made the initial cut).

        Keep reading

        Leons Petrazickis
        DB2 Community Team

        Tuesday, September 21, 2010

        ibm_db2 PHP extension updated to 1.9.0

        Version 1.9.0 of the ibm_db2 extension for PHP has been released. Changes include:
        • Fix for BIGINT fix for i5.
        • Fix for autocommit issue (CLI setting is now handled).
        • Fix for db2_pconnect connection reset issue.
        • Fix for connection rollback in db2_pconnect at the end of request.
        On Windows, you should go to the DB2 Technology Explorer downloads and grab a build of the extension that matches your PHP 5.3 installation. Confusingly, PHP on Windows is available in four different official flavours:
        • Threadsafe PHP compiled with Microsoft Visual C++ 6
        • Non-thread-safe (nts) PHP compiled with Microsoft Visual C++ 6
        • Thread-safe PHP compiled with Microsoft Visual C++ 9
        • Non-thread-safe (nts) PHP compiled with Microsoft Visual C++ 9
        Be sure to get a build that matches your PHP flavour.

        On Linux, you should make sure you have pecl installed in your package manager and then run:

        pecl install ibm_db2

        You'll need gcc along with DB2 headers for this. If you do not have a local copy of DB2, you can install the IBM Data Server Driver for ODBC and CLI instead.


        Leons Petrazickis
        DB2 Community Team

        Tuesday, September 14, 2010

        DB2 blogs worldwide

        Some DB2 blogs aren't yet on PlanetDB2. For example, there are a few blogs started by ChannelDB2 members that aren't yet on PlanetDB2.

        There are also blogs in languages other than English. There's Гилёв Вячеслав (Russian), Berthou (French), and Fernando Martinez Diaz (Spanish).

        I'm one of the administrators of PlanetDB2. If you would like your blog posts to show up on PlanetDB2, email us at join @ planetdb2.com.


        Leons Petrazickis
        DB2 Express-C Community Team

        Tuesday, September 07, 2010

        DB2 Express-C packages for Ubuntu 10.04

        DB2 Express-C 9.7.2 packages for Ubuntu 10.04 LTS are now available in the Canonical Partner Repository. Andre has kindly provided the following installation instructions:
        1. Uncomment the Partner repository lines by editing the /etc/apt/sources.list file
        sudo nano /etc/apt/sources.list
        remove the "#" from the "deb http://archive.canonical.com/ubuntu lucid partner" line
        remove the "#" from the "deb-src http://archive.canonical.com/ubuntu lucid partner" line
        save the file and exit

        2. Update the packages list by executing the apt-get update command
        sudo apt-get update

        3. Install IBM DB2 Express-C 9.7 Fix Pack 2 by executing the apt-get install command
        sudo apt-get install db2exc
        Of course, you can always install the regular DB2 Express-C .tar.gz on any distribution of Linux:
        Administrative tools:
        Free books:


        Leons Petrazickis
        DB2 Express-C Community Team

        Monday, September 06, 2010

        tiếng Việt - Getting Started with DB2 Express-C 9.7

        The Vietnamese translation of the Getting Started with DB2 Express-C free e-book series is now available:
        Books in the Getting Started series have been downloaded over 100,000 times. The DB2 book is now available in English, Japanese, Bulgarian, Chinese, German, Italian, Polish, Portuguese, Spanish, Thai, and Vietnamese.

        Naturally, the DB2 Express-C database server is also available in many languages.


        Leons Petrazickis
        DB2 Express-C Community Team

        Monday, August 30, 2010

        pureScale chat on Tuesday August 31

        There's an upcoming chat with the lab tomorrow:
        DB2 pureScale - Always-on, Elastic Database Cluster

        Date: Tue, August 31, 2010
        Time: 11:30 AM - 1:00 PM Eastern (GMT-04:00)
        10:30 AM Central / 8:30 AM Pacific / 16:30hrs London / 17:30hrs Frankfurt, Paris / India 9 PM

        Last year IBM released DB2 pureScale, an integrated database cluster solution that provides continuous data availability, virtually unlimited capacity, elastic scalability, and all this with easy setup and management but without requiring any applications changes. IBM has recently updated DB2 pureScale and announced that it will now also be available to run on Intel-based commodity hardware and Linux. In this webcast we will cover various DB2 pureScale related topics including: architecture, benefits, demos, experiences, and getting started.

        To learn more and get your questions answered, join Sal Vella (VP, Development), and Drew Bradstock (Product Manager) on Tuesday August 31, 2010 at 11:30 AM Eastern.

        Leons Petrazickis
        DB2 Express-C Community Team

        ChannelDB2 surpasses 3000+ members

        The membership of ChannelDB2 now exceeds 3000 members, of whom over 60 joined in the past week. The site is designed to help DB2 professionals share fun and instructional videos, blogs, and discussions.

        The other great thing about ChannelDB2 is that you already know someone who's a member. I personally help out there with the moderation and the endless internet battle with spam bots.

        Leons Petrazickis
        DB2 Express-C Community Team

        Tuesday, August 10, 2010

        ChannelDB2, now with Finnish drinking songs

        ChannelDB2 is a free resource for the DB2 community. It has instructional videos, several blogs, groups with shared interests, and various social networking features to help DB2 professionals to connect.

        It's also the number one destination when you are looking for Finnish drinking songs that just happen to be compatible with IBM Business Conduct Guidelines:

        I might be speaking for myself, but I'd love to hear more of those.

        Leons Petrazickis
        DB2 Express-C Community Team

        Monday, August 09, 2010

        Tuning DB2 system performance chat on Aug 12

        Readers in Mainland China, Hong Kong, and Taiwan, there's an upcoming chat on August 12:
        Tuning and Monitoring DB2 System Performance 
        August 12 @ 10:00 AM China Standard Time (GMT+0800)
        August 11 @ 10:00 PM Toronto Time
        Speakers:    Sal Vella - VP, Guiyun Cao - one of the key IBM DB2 performance analysts
        Host:     Frank Ning

        In this chat, Guiyun Cao from the IBM Canada Lab will share some best practices about tuning and monitoring of DB2 system performance. He will talk about determining, addressing the system bottlenecks and some best practices for DB2 performance.

        Guiyun Cao has been with IBM more than 10 years specializing in DB2 performance, in particular with SAP and DB2 performance. He is one of the key performance analysts to serve IBM customers for their business success.

        Leons Petrazickis
        DB2 Express-C Community Team

        Wednesday, July 28, 2010

        DB2 Express-C database now 44% lighter

        The DB2 Express-C database server is downloaded worldwide, but broadband internet is not yet universal. Because of this, we are releasing a light version of DB2 Express-C 9.7.2 for Windows. It's an amazing 44% smaller than the full download.

        Unlike the lighter download, the DB2 Express-C (full) includes the Control Center, Full Text Search, Configuration Assistant, and the First Steps wizard. It also has support for non-English languages in its user interface. However, if you don't need these features, you can grab the DB2 Express-C (light) for a quicker download and a simpler installation.

        For example, if you are setting up a DB2 database on a Windows server that you plan to administer remotely with Data Studio, then the light version of DB2 Express-C is a great choice.

        Download it now:
        Administrative tools:
        Free books:

        Leons Petrazickis
        DB2 Express-C Community Team
        Google Analytics Alternative