Monday, June 28, 2010

IBM_DB2 1.8.4 extension for PHP released

Version 1.8.4 of the ibm_db2 extension for PHP has been released. Changes include:
  • Adding support for query time out.
  • Fixing problem with DATE/TIME datatype.
  • i5/OS Add new attribute DB2_I5_JOB_SORT_ON/OFF (php.ini ibm_db2.i5_job_sort).
  • i5/OS Fix BIGINT string type to help with larger values.
  • i5/OS Fix "early" terminate fetch loops due to CLOB/BLOB zero length.
  • i5/OS Fix db2_pclose() to allow reset persistent connections.

On Windows, you should go to the DB2 Technology Explorer download site and grab a build of the extension that matches your PHP 5.3 installation. Unfortunately, PHP on Windows is available in four different official flavours, so you need a build of the extension that matches your flavour in terms of VC6 versus VC9 and threadsafe versus non-threadsafe (nts).

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 intead.


Leons Petrazickis
DB2 Express-C Community Team

Tuesday, June 22, 2010

Moving from Sybase ASE to DB2 chat on June 23

There's a lab chat this Wednesday, June 23rd:
Moving easily from Sybase ASE to DB2

Wednesday June 23, 2010
11:30 AM Eastern / 10:30 AM Central / 8:30 AM Pacific / 16:30 hrs London / 17:30 hrs Frankfurt, Paris / India 9PM

On June 28 2010, IBM will GA a new DB2 feature that makes it easy to move applications written for Sybase ASE to DB2 for Linux, Unix, and Windows, often with few or no code changes to either the application or stored procedure code. Like the Oracle database compatibility feature before it, the new DB2 feature for Sybase ASE will help customers quickly consolidate and reduce their database costs. In this chat, learn about the new DB2 feature, it's architecture, performance, beta results, technical value, and business value.

Leons Petrazickis
DB2 Express-C Community Team

Monday, June 21, 2010

Silly video about the village of Orrible in the land of Databasia

Natasha Tolub and some other folks put together this silly video about the town of DB2 and the village of Orrible.


Leons Petrazickis
DB2 Express-C Community Team

Tuesday, June 15, 2010

Get started with WebSphere and DB2

Getting Started with WebSphere Application Server Community Edition (WASCE) is the fourth free e-book in the Getting Started series.

After reading the book, you'll be able to:
  • Learn how to develop Java EE applications with WebSphere Application Server Community Edition
  • Understand how WAS CE interacts with databases such as DB2
  • Learn everyday WAS CE administration tasks
  • Tune and troubleshoot WAS CE servers
  • Practice with hands-on exercises
Get the books now:
Leons Petrazickis
DB2 Express-C Community Team

Tuesday, June 08, 2010

Get started with Adobe Flex (and DB2)

Getting Started with Adobe Flex is the latest free e-book in the On Campus series. After reading it, you should be able to:
  • Understand how to build rich Internet applications using Flex
  • Learn how to work with Flex Builder to create, run and debug Flex applications
  • Understand how Flex works with Web services and databases like DB2®
  • Learn about the Flex programming basics using MXML® and ActionScript™
  • Get up to speed with powerful features like data binding, view states, and charting
  • Practice with hands-on exercises
It's available for free download:
Leons Petrazickis
DB2 Express-C Community Team

Wednesday, June 02, 2010

Going from Oracle to DB2 9.7 chat on June 3

There's a chat on Thursday, June 3rd about easily enabling Oracle applications for DB2:
Enabling from Oracle to DB2 9.7 the Easy Way
Serge Rielau, DB2 SQL Architect
Thursday, June 3
11:00 AM - 12:00 PM Eastern

DB2 9.7 brought the biggest infusion of SQL features since DB2 V2.1. In this presentation, learn about features that lead to a ten-fold reduction in enablement costs when Oracle-based applications are enabled for DB2. The virtual tech briefing covers the following:
  • Business drivers to move Oracle applications to DB2
  • SQL enhancements in DB2 9.7
  • Tooling support to enable applications from Oracle to DB2
  • PL/SQL support in DB2 9.7
  • Library extensions in DB2 9.7
Register now


Leons Petrazickis
DB2 Community Team

Tuesday, June 01, 2010

DB2 Express-C 9.7.2 refreshed

DB2 Express-C 9.7.2 is now available for download. It is a full refresh of the free edition of DB2 with lots of new features and fixes including:
  • Default parameter values in user defined functions (UDFs)
  • Named arguments when calling user defined functions
  • Ability to copy table spaces and SQL schemas between active databases using RESTORE with TRANSPORT option
  • Auditing improvements with full replay of past database activities
  • Improved performance and ease of development for .NET applications
You can get it now:
Free book:
Related downloads:

Leons Petrazickis
DB2 Express-C Community Team