How to Connect to Db2 on iSeries / AS400

First read How to Connect to Database to understand the Connection Dialog.

DbSchema includes Db2 drivers. The driver requires two files, db2jcc.jar and db2jcc_license_cu.jar.

There is an open source JDBC driver available for AS400 / iSeries called jtopen. See http://jt400.sourceforge.net/

Tip Firewalls & anti-viruses may block database connections. Read How to enable Firewall connections.

Run Db2 in Docker Container

There is a Db2 docker container available at https://hub.docker.com/r/ibmcom/db2.

Create the container using:

docker run -itd --name db2 --privileged=true -p 50000:50000 -e LICENSE=accept -e DB2INST1_PASSWORD=DbSchema12 -e DBNAME=test ibmcom/db2
From DbSchema you can connect using

Install Db2 Express Edition

Db2 Express can be downloaded from https://www.ibm.com/developerworks/downloads/im/db2express/ After install you can connect using the user db2admin and the set password

Start the Db2 Command Line Window and execute the command

db2 list db directory
In Db2 Command Line Processor you can issue 'connect to sample' to connect to this database.

Show instances

Create New Database

From the Command Line Processor create a database using the command 'Create database test;

Db2 14

Db2 15

Connect from DbSchema using the user db2admin with password you defined during installation, and database test.

Db2d

Short Tutorial on Installing Db2 On Windows

Download Db2 Express from www.ibm.com/software/data/db2/express/

During the installation you have to enter the password for the database user db2admin

Db2 9

Choose the DB2 instance. This means you can run the DB2 software more than one time on a single computer. This parameter is not required in DbSchema.

Db2 10

Short Tutorial on Installing Db2 On Linux Ubuntu

We have the experience of installing Db2 on Ubuntu 10.6, and we want to share this experience with you.

Install Ubuntu utilities