PHPackages                             geiger-it/db2-laravelumen - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. geiger-it/db2-laravelumen

ActiveLibrary[Database & ORM](/categories/database)

geiger-it/db2-laravelumen
=========================

db2-laravelumen is a simple DB2 service provider for Laravel or Lumen v5.2. It provides a DB2 Connection by extending the Illuminate Database component working with both query builder and eloquent.

2.3.2(10y ago)050MITPHPPHP >=5.4.0

Since Apr 22Pushed 9y ago1 watchersCompare

[ Source](https://github.com/geiger-it/db2-laravelumen)[ Packagist](https://packagist.org/packages/geiger-it/db2-laravelumen)[ RSS](/packages/geiger-it-db2-laravelumen/feed)WikiDiscussions master Synced yesterday

READMEChangelogDependencies (2)Versions (11)Used By (0)

db2-laravelumen
===============

[](#db2-laravelumen)

db2-laravelumen is a fork of Cooperl22/laravel-db2 in order to support Laravel and Lumen v5.2. It provides a DB2 Connection by extending the Illuminate Database component working with both Fluent (query builder) and Eloquent.

---

- [Installation](#installation)
- [Registering the Package](#registering-the-package)
- [Configuration](#configuration)
- [Usage](#usage)

Installation
------------

[](#installation)

Ensure you have the proper drivers installed. For our AS400 system, I installed iSeriesAccess-7.1.0-1.0.x86\_64.rpm from [ibm](http://www-01.ibm.com/support/docview.wss?uid=swg21585490) using alien for our debian distribution and configuring the /etc/odbc.ini and /etc/odbcinst.ini.

Add db2-laravelumen to your composer.json file:

```
"require": {
    "geiger-it/db2-laravelumen": "~3.0"
}

```

Use [composer](http://getcomposer.org) to install this package.

```
$ composer update

```

### Registering the Package

[](#registering-the-package)

Add the db2-laravelumen Service Provider to your `bootstrap/app.php`:

```
$app->register(geiger-it\Database\DB2\DB2ServiceProvider::class);
```

### Configuration

[](#configuration)

Put your DB2 connection and credential information into your `config/database.php` file. You'll notice Lumen does not have a config directory, but will read from it when you create it.

```
    'ibmi' => [
        'driver'               => 'odbc' / 'ibm',
        'driverName'           => '{IBM i Access ODBC Driver}' / '{iSeries Access ODBC Driver}',
         // General settings
        'host'                 => 'server',
        'username'             => '',
        'password'             => '',
        //Server settings
        'database'             => 'WRKRDBDIRE entry',
        'prefix'               => '',
        'schema'               => 'default schema',
        'signon'               => 3,
        'ssl'                  => 0,
        'commitMode'           => 2,
        'connectionType'       => 0,
        'defaultLibraries'     => '',
        'naming'               => 0,
        'unicodeSql'           => 0,
        // Format settings
        'dateFormat'           => 5,
        'dateSeperator'        => 0,
        'decimal'              => 0,
        'timeFormat'           => 0,
        'timeSeparator'        => 0,
        // Performances settings
        'blockFetch'           => 1,
        'blockSizeKB'          => 32,
        'allowDataCompression' => 1,
        'concurrency'          => 0,
        'lazyClose'            => 0,
        'maxFieldLength'       => 15360,
        'prefetch'             => 0,
        'queryTimeout'         => 1,
        // Modules settings
        'defaultPkgLibrary'    => 'QGPL',
        'defaultPackage'       => 'A/DEFAULT(IBM),2,0,1,0',
        'extendedDynamic'      => 1,
        // Diagnostic settings
        'QAQQINILibrary'       => '',
        'sqDiagCode'           => '',
        // Sort settings
        'languageId'           => 'ENU',
        'sortTable'            => '',
        'sortSequence'         => 0,
        'sortWeight'           => 0,
        'jobSort'              => 0,
        // Conversion settings
        'allowUnsupportedChar' => 0,
        'ccsid'                => 1208,
        'graphic'              => 0,
        'forceTranslation'     => 0,
        // Other settings
        'allowProcCalls'       => 0,
        'DB2SqlStates'         => 0,
        'debug'                => 0,
        'trueAutoCommit'       => 0,
        'catalogOptions'       => 3,
        'libraryView'          => 0,
        'ODBCRemarks'          => 0,
        'searchPattern'        => 1,
        'translationDLL'       => '',
        'translationOption'    => 0,
        'maxTraceSize'         => 0,
        'multipleTraceFiles'   => 1,
        'trace'                => 0,
        'traceFilename'        => '',
        'extendedColInfo'      => 0,
        'options'  => [
            PDO::ATTR_CASE => PDO::CASE_LOWER,
            PDO::ATTR_EMULATE_PREPARES => false,
            PDO::ATTR_PERSISTENT => false
        ]
    ],
```

driver setting is either 'odbc' for ODBC connection or 'ibm' for pdo\_ibm connection Then if driver is 'odbc', database must be set to ODBC connection name. if driver is 'ibm', database must be set to IBMi database name (WRKRDBDIRE).

Usage
-----

[](#usage)

Consult the [Laravel framework documentation](http://laravel.com/docs).

###  Health Score

28

—

LowBetter than 52% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity64

Established project with proven stability

 Bus Factor1

Top contributor holds 50% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~42 days

Recently: every ~71 days

Total

10

Last Release

3703d ago

Major Versions

1.0 → 2.02015-05-06

### Community

Maintainers

![](https://www.gravatar.com/avatar/bfafa562c182d021cd39fea2a3b736c52f92acd63c4d8756c94301e5b5b36c0c?d=identicon)[esmith.geiger](/maintainers/esmith.geiger)

---

Top Contributors

[![cooperl22](https://avatars.githubusercontent.com/u/12048268?v=4)](https://github.com/cooperl22 "cooperl22 (4 commits)")[![esmithgeiger](https://avatars.githubusercontent.com/u/127890154?v=4)](https://github.com/esmithgeiger "esmithgeiger (4 commits)")

---

Tags

laraveldatabasepdodb2odbc

### Embed Badge

![Health badge](/badges/geiger-it-db2-laravelumen/health.svg)

```
[![Health](https://phpackages.com/badges/geiger-it-db2-laravelumen/health.svg)](https://phpackages.com/packages/geiger-it-db2-laravelumen)
```

###  Alternatives

[psalm/plugin-laravel

Psalm plugin for Laravel

3345.1M337](/packages/psalm-plugin-laravel)[cooperl/laravel-db2

laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.

58123.4k1](/packages/cooperl-laravel-db2)[ntanduy/cloudflare-d1-database

Cloudflare D1 database driver for Laravel — full Eloquent & Query Builder support.

266.8k](/packages/ntanduy-cloudflare-d1-database)[itpathsolutions/dbstan

Database Standardization and Analysis Tool for Laravel

442.1k](/packages/itpathsolutions-dbstan)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)