Back to Sequelize

DB2 for LUW

docs/databases/db2.mdx

latest1.6 KB
Original Source

Sequelize for DB2 for Linux, Unix, and Windows

:::info Version Compatibility

See Releases to see which versions of DB2 for LUW are supported.

:::

To use Sequelize with DB2 for LUW, you need to install the @sequelize/db2 dialect package:

bash
npm i @sequelize/db2

Then use the Db2Dialect class as the dialect option in the Sequelize constructor:

ts
import { Sequelize } from '@sequelize/core';
import { Db2Dialect } from '@sequelize/db2';

const sequelize = new Sequelize({
  dialect: Db2Dialect,
  database: 'mydb',
  user: 'myuser',
  password: 'mypass',
  hostname: 'localhost',
  port: 50000,
  ssl: true,
});

Connection Options

import ConnectionOptions from './_connection-options.md';

<ConnectionOptions />

The following options are accepted by the DB2 for LUW dialect:

OptionDescription
databaseODBC "DATABASE" parameter
usernameODBC "UID" parameter
passwordODBC "PWD" parameter
hostnameODBC "HOSTNAME" parameter
portODBC "PORT" parameter
sslSets ODBC "Security" parameter to SSL when true
sslServerCertificateODBC "SSLServerCertificate" parameter
odbcOptionsAdditional ODBC parameters.