IBM DB2 Extension for Yii 2 (yii2-ibm-db2)

This extension adds IBM DB2 database engine extension for the Yii framework 2.0.

This branch use the last developer version of Yii2 (dev-master)

Requirements

• IBM DB2 Client SDK installed
• PHP module pdo_ibm or pdo_odbc
• IBM DB2 Database Server 10.1 or greater

Installation

The preferred way to install this extension is through composer.

Either run

php composer.phar require --prefer-dist "edgardmessias/yii2-ibm-db2:*"

or add

"edgardmessias/yii2-ibm-db2": "*"

to the require section of your composer.json.

Configuration

To use this extension, simply add the following code in your application configuration:

Using IBM DB2:

return [
    //....
    'components' => [
        'db' => [
            'class'         => 'edgardmessias\db\ibm\db2\Connection',
            'dsn'           => 'ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=test;HOSTNAME=127.0.0.1;PORT=50000;PROTOCOL=TCPIP',
            'username'      => 'username',
            'password'      => 'password',
            'defaultSchema' => '',
            'isISeries'     => false
        ],
    ],
];

Using ODBC IBM iAccess driver:

return [
    //....
    'components' => [
        'db' => [
            'class'         => 'edgardmessias\db\ibm\db2\Connection',
            'dsn'           => 'odbc:DRIVER={IBM i Access ODBC Driver 64-bit};SYSTEM=127.0.0.1;PROTOCOL=TCPIP',
            'username'      => 'username',
            'password'      => 'password',
            'defaultSchema' => '',
            'isISeries'     => false
        ],
    ],
];

If working on iSeries set isISeries parameter to true and fill defaultSchema.

Donations

• Donation is as per your goodwill to support my development.
• If you are interested in my future developments, i would really appreciate a small donation to support this project.

  My Monero Wallet Address (XMR)
  429VTmDsAw4aKgibxkk4PzZbxzj8txYtq5XrKHc28pXsUtMDWniL749WbwaVe4vUMveKAzAiA4j8xgUi29TpKXpm41bmrwQ

  My Bitcoin Wallet Address (BTC)
  38hcARGVzgYrcdYPkXxBXKTqScdixvFhZ4

  My Ethereum Wallet Address (ETH)
  0xdb77aa3d0e496c73a0dac816ac33ea389cf54681

  Another Cryptocurrency: https://freewallet.org/id/edgardmessias