在linux里安装了docker之后，使用DB的指南

1. install docker(linux) & docker command

#install docker
$ sudo apt-get install docker.io 

#check if docker is running

$ service docker status

#add your username into docker group

$ sudo usermod -aG docker username(your username)

#search software image from docker software market

$ docker search db2(software name)

2. install db2 indocker & db2 command

#install db2express-c

$ docker pull ibmcom/db2express-c(software name)

#start a container

$ docker run -it -p 50000:50000 -e DB2INST1_PASSWORD=db2inst1-pwd -e LICENSE=accept ibmcom/db2express-c:latest bash

#switch user

$ su – db2inst1

# start/stop db2 service

$ db2start/db2stop

# enter db2

$ db2 

3.Db2Sql Command //db2set DB2COMM=tcpip

# create database

db2=> create db databasename

# connect database

db2=> create to databasename

# create schema (AES - schema name)

db2=> create schema AES

#create table(PR99_ERR_MSG – table name)

db2=> create table AES.PR99_ERR_MSG(PF_ERR_MSG varchar(255), PX_ERR_MSG_TXT varchar(255))

#insert table into values

db2=> insert into AES.PR99_ERR_MSG values('t5h','hello world')

#select table

db2=> select * from AES.PR99_ERR_MSG r where r.PF_ERR_MSG='t5h'