Docker - Install and deploy through container DB2 Database tutorial

I've written a document about how to use  DB2  The official installation procedure  DB2  Database installation （ Click to see ）. This article introduces another way ： adopt  Docker  To quickly build  DB2  Database environment , Using this method can save a lot of trouble in installation and configuration , Convenient and quick .

1, Pull the mirror image

（1） First, execute the following command to download the image to the local ：

（2） Because the image is bigger （2.69G）, Execute the following command to delete all  dangling  Data volume （ It's useless  Volume）, Avoid the lack of space ：

2, Start the container  

（1） Execute the following command to instantiate  DB2  service ： Parameter description ：

• -d: Means to start the container in the background ;
• -p 50000:50000: Inside the container  50000  Port mapping host  50000  port ;
• --name db2： Name the container  db2
• --privileged=true： Make the inside of the container  root  Have real  root  jurisdiction .
• -e DB2INST1_PASSWORD=marco-1234： Set the built-in instance user  db2inst1  The password for  marco-1234
• -e DBNAME=testdb： A container named  testdb  The database of , If this parameter is not specified, the database will not be created
• -e LICENSE=accept： Acceptance of agreement
• -v /usr/local/db2:/database： Mount Directory , among  /usr/local/db2  It's the host Directory

（2） perform  docker ps  Command to confirm that the container started successfully .

3, Carry out orders

（1） First execute the following command to enter  DB2  Instance in the command environment ：

（2） Execute the following command to switch to the instance user  db2inst1：

Be careful ： Be sure to write the middle bar （-）.

（3） Execute the following command to view the running status ：

（4） Execute the following command to view the database and patch version ：

（5） Execute the following command to view the created database , It can be found that according to the configuration parameters at startup , Currently create one  testdb  database ：

（6） Execute the following command to connect  testdb  database ：

（7） Then execute the following command to create a file named  TEST  Table of ：

Be careful ：db2  After the order sql Statements need to be enclosed in quotation marks , No, it will be reported  -bash: syntax error near unexpected token `('  error .

（8） Execute the following command to view all user tables , You can find  TEST  Table created successfully ：

（9） We can also execute the following command to create another  SAMPLE  database （ Sample database ）

（10） Then execute again  db2 list dbdirectory  The command can see that the database is created successfully ：

（11） Finally, execute  exit  You can exit the container , Return to the host .

4, Carry out orders

DB2 Database common command learning