DB2 Express-C Team Blog

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.

Cheers,

Leons Petrazickis
DB2 Express-C Community Team

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.

• Register to attend
• Get the charts

Cheers,

Leons Petrazickis
DB2 Express-C Community Team

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

• View video on ChannelDB2
• Find more videos on ChannelDB2
  

Cheers,

Leons Petrazickis
DB2 Express-C Community Team

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:

• Getting Started with WAS CE
• Getting Started with DB2 Express-C
• Getting Started with Data Studio for DB2
• Getting Started with Adobe Flex

Cheers,
Leons Petrazickis
DB2 Express-C Community Team

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:

• Getting Started with Adobe Flex
• Getting Started with DB2 Express-C
• Getting Started with Data Studio for DB2

Cheers,
Leons Petrazickis
DB2 Express-C Community Team

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

Cheers,

Leons Petrazickis
DB2 Community Team

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:

• DB2 Express-C for Windows
• DB2 Express-C for Windows x64
• DB2 Express-C for Linux
• DB2 Express-C for Linux x86-64
• DB2 Express-C for Linux on POWER
• DB2 Express-C for Solaris x86-64

Free book:

• Getting Started with DB2 Express-C

Related downloads:

• Data Studio Standalone
• Data Studio IDE

Cheers,

Leons Petrazickis
DB2 Express-C Community Team