Migrate db2 developer edition to new server
Here is a guide I wrote for my work, I just post it here so that I can refer to it even after I leave.
Install the same DB2 version as in DEV environment (v220.127.116.11)
IBM does not support old version of DB2 developer edition, and when new version is released, old version support is dropped and you’re not able to install them any more.
As a workaround, we need to migrate the existing DB2, which runs as a container, to new server to get the same version.
Here is the steps to migrate the container:
on existing DB2 server:
docker export db2server -o db2server.tar ## run this command to export db2server container docker inspect db2server |jq '.|.HostConfig.Binds' ## run this command to check what folder is mounted on container
then, copy db2server.tar and the folder from 2nd command (usually /home/centos/.config/ibm-db2-hkex/DB2/db2fs or /home/centos/.config/ibm-db2-developerc/DB2/db2fs) to new server
on new server, run these commands:
sudo yum install -y docker ## to install docker sudo systemctl enable docker ## config docker to start at boot sudo groupadd docker ## create docker group, to grant current user permission to run docker sudo usermod -aG docker $USER ## add current user to docker group
logout and log back in, try ‘docker info’ to make sure your account has permission to start docker containers
docker import db2server.tar ## import container docker images ## list docker images. copy the image ID for use with below command docker tag IMAGE_ID db2server:18.104.22.168 ## give this docker image a tag, will be referenced later.
create a file called ‘.env_list’, with the following content:
LICENSE=accept DB2INSTANCE=db2inst1 DB2INST1_PASSWORD=myadmin BLU=false ENABLE_ORACLE_COMPATIBILITY=false UPDATEAVAIL=NO TO_CREATE_SAMPLEDB=false REPODB=false IS_OSXFS=true PERSISTENT_HOME=true STORAGE_DIR=/database SETUPDIR=/var/db2_setup HADR_SHARED_DIR=/hadr LICENSE_NAME=db2dec.lic DBPORT=50000 TSPORT=55000 HADR_ENABLED=false ETCD_ENDPOINT= ETCD_USERNAME= ETCD_PASSWORD=
create a file called run_db2_container.sh, with the following content:
Note the argument to ‘-v’, make sure the folder is where you put the content copied from the old server.
docker run \ --name db2server --restart=always \ --detach \ --privileged=true \ -p 50000:50000 -p 55000:55000 \ --env-file .env_list \ -v /home/centos/.config/ibm-db2-hkex/DB2/db2fs:/db2fs \ db2server:22.214.171.124 \ /var/db2_setup/lib/entrypoint.sh
then, run below command to start the container:
then, run below command to make sure container started:
update db2nodes.cfg file with new container hostname, with below commands:
docker exec -it db2server bash ## login to container hostname ## run this within container, to get its hostname
edit file /home/db2inst1/sqllib/db2nodes.cfg, replace old hostname string with new one.
exit ## logout from container
restart container and verify DB2 is working:
docker stop db2server ## run this from host machine, to stop the container docker start db2server ## start container docker exec -it db2server bash ## login to container su - db2inst1 ## switch to db2 admin account db2 connect to sample ## try connect to a sample database, to verify db2 is working exit;exit ## exit twice to logout from container