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/
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
Start the Db2 Command Line Window and execute the command
db2 list db directoryIn Db2 Command Line Processor you can issue 'connect to sample' to connect to this 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.
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.
We have the experience of installing Db2 on Ubuntu 10.6, and we want to share this experience with you.
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
cd /opt/db2/instance ./db2icrt -p 50000 -u db2fenc1 db2inst1 ./db2dascrt -u dasuser1
DB2_TMINST 50000/tcp
db2 update dbm cfg using svcename 50000 db2set DB2COMM=tcpip
db2start
ln -s /opt/teamviewer/teamviewer/6/bin/teamviewer /etc/init.d/TeamViewer update-rc.d noip defaults
binaries/noip2-i686 -C ln -s /opt/noip-2.1.9-1/debian.noip2.sh /opt/init.d/noip update-rc.d noip defaults