chuk-shirley
11/9/2015 - 4:22 AM

ZF2 DB2 configuration

ZF2 DB2 configuration

<?php
// config/autoload/global.php
return [
  'db' => [
      'driver' => 'IbmDb2',
      'platform' => 'IbmDb2',
      'platform_options' => [
          'quote_identifiers' => true,
      ],
      'persistent' => true,
      'database' => 'S1234567',  // Look up value with WRKRDBDIRE
      'driver_options' => [
          'i5_naming' => DB2_I5_NAMING_ON,
      ]
  ],
];
<?php
// config/autoload/db.production.php
return [
    'db' => [
        'username' => 'WEBUSER',
        'password' => 'WEBUSER',
        'driver_options' => [
            'i5_libl' => 'PRODLIB1 PRODLIB2'
        ]
    ]
];
<?php
// config/autoload/db.development.php
ini_set('error_log', '/usr/local/zendsvr6/var/log/php-dev.log');
ini_set('error_reporting', E_ALL);
return [
    'db' => [
        'username' => 'WEBTEST',
        'password' => 'WEBTEST',
        'driver_options' => [
            'db2_attr_case' => DB2_CASE_UPPER,
            'i5_libl' => 'TESTLIB1 TESTLIB2'
        ]
    ]
];
<?php

$env = getenv('APPLICATION_ENV');
return [
    // modules, module listener options, etc.
    'config_glob_paths' => [
        __DIR__.'/autoload/{,*.}{global,'.$env.',local}.php',
    ]
]l