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.

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;

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

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

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.

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 Java on Ubuntu using
    • In packadge manager enable third party software
    • sudo apt-get update
    • sudo apt-get install sun-java6-jdk
  • See snippets.dzone.com/posts/show/3682
  • sudo apt-get libstdc++5
  • sudo apt-get libaio1
  • Download db2 software. Unpack and execute as root './db2_install'. Install in a different location: /opt/db2
  • Create three users as follow, with a home directory ( -m ) and with a group for them ( -U ). Change their password and be sure this users have a .profile file inside:
    useradd -m -U -s /bin/bash db2inst1
    useradd -m -U -s /bin/bash db2fenc1
    useradd -m -U -s /bin/bash dasusr1
    passwd db2inst1
    passwd db2fenc1
    passwd dasusr1
          
  • Create an instance and an administration server:
    cd /opt/db2/instance
    ./db2icrt -p 50000 -u db2fenc1 db2inst1
    ./db2dascrt -u dasuser1
          
  • Add the following lines to /etc/services:
    DB2_TMINST 50000/tcp
          
  • Login as db2inst1 and execute
    db2 update dbm cfg using svcename 50000
    db2set DB2COMM=tcpip
          
  • Start the database
    db2start
          

Install Ubuntu utilities

  • Download TeamViewer debian packadge, execute:
    ln -s /opt/teamviewer/teamviewer/6/bin/teamviewer /etc/init.d/TeamViewer
    update-rc.d noip defaults
      
  • Download noip, execute:
    binaries/noip2-i686 -C
    ln -s /opt/noip-2.1.9-1/debian.noip2.sh /opt/init.d/noip
    update-rc.d noip defaults