The CakePHP team has included the ibm_db2 driver that I submitted in the latest 1.2 development branch.
I’ve sent out a call for alpha testers to put it through its paces.
You can get up and running quickly by:
- Extracting the sample application (thanks Nate) which provides a skeleton for working with CRUD operations and table associations (hasOne, hasMany, belongsTo, hasAndBelongsToMany) to your “app” directory.
- Creating a database.
db2 => CREATE DATABASE CAKE USING CODESET UTF-8 TERRITORY US
- Creating the database tables from the DDL.
[firstname.lastname@example.org]$ db2 connect to cake
[email@example.com]$ db2 -tf db_test_db2.sql
- Updating your database.php configuration.
var $default = array(
‘driver’ => ‘db2′,
‘connect’ => ‘db2_connect’,
‘host’ => ‘localhost’,
‘login’ => ‘db2inst1′,
‘password’ => ‘password’,
‘database’ => ‘cake’,
‘prefix’ => ”,
‘encoding’ => ‘UTF-8′
- Retarting your Web server.
Please try it out and submit your bug reports to Trac with “DB2″ in the title. Information on the particular database product, platform and version you are using would be helpful as well.