loopback-connector-db2

IBM® DB2® is the database of choice for robust, enterprise-wide solutions handling high-volume workloads.It is optimized to deliver industry-leading performance while lowering costs. The module is the LoopBack connector for DB2.

The LoopBack DB2 connector supports:

• All .
• Queries with fields, limit, order, skip and where filters.
• All supported DB2 LUW versions.

Enter the following in the top-level directory of your LoopBack application:

Use the to add the DB2 data source to your application.The entry in the application’s server/datasources.json will look something like this:

"mydb": {
  "name": "mydb",
  "connector": "db2"
}

Edit server/datasources.json to add other supported properties as required:

"mydb": {
  "name": "mydb",
  "username": <username>,
  "database": <database name>,
  "hostname": <db2 server hostname>,
  "port":     <port number>
}

The following table describes the connector properties.

If you have a local or remote DB2 instance and would like to use that to run the test suite, use the following command:

• Linux

DB2_HOSTNAME=<HOST> DB2_PORTNUM=<PORT> DB2_USERNAME=<USER> DB2_PASSWORD=<PASSWORD> DB2_DATABASE=<DATABASE> DB2_SCHEMA=<SCHEMA> CI=true npm test

• Windows

SET DB2_HOSTNAME=<HOST>
SET DB2_PORTNUM=<PORT>
SET DB2_USERNAME=<USER>
SET DB2_PASSWORD=<PASSWORD>
SET DB2_DATABASE=<DATABASE>
SET DB2_SCHEMA=<SCHEMA>
SET CI=true

How to get a local DB2 instance:

• Go to page.
• Register for an account.
• Download either IBM DB2 or IBM DB2 Express-C.
• For documentation or more information about the installation or setup, see http://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.kc.doc/welcome.html

IBM DB2 Express-C scenario on Windows:

• Run the setup file.
• Set user information for the DB2 Administration server.
• Write down the user information and the password that you create. User name is db2admin by default but it could be modified.
• Configure DB2 instance and write down the port number. It is 50000 by default.
• Once setup is done, Start the default DB2 and Database Client Interface Selection Wizard, and proceed with the configuration.
• Ensure that the DB2 Data server runtime client is started. The default name is DB2COPY1.
• Let’s assume your database name is sample, and schema name is STRONGLOOP.
• In Windows, start the DB2 Command window-Administrator (In Mac or Linux, use terminal with proper privileges).
• Make sure that you are in this path …\IBM\SQLLIB\BIN (In mac, it should be /Users//sqllib\bin), and type the following commands:

Docker

If you do not have a local DB2 instance, you can also run the test suite with very minimal requirements.

• Assuming you have installed, run the following script which would spawn a DB2 instance on your local:

source setup.sh <HOST> <PORT> <PASSWORD> <DATABASE>

where <HOST>, <PORT>, <PASSWORD> and <DATABASE> are optional parameters. By default, the user is .

• Run the test: