How to install IBM DB2 in Docker
时间：2022-10-02 07:00:01
- install
docker run --detach \ --restart always \ --publish 50000:50000 \ --name db2 \ --privileged=true \ --volume /data/docker/db2:/database \ --env LICENSE=accept \ --env DB2INST1_PASSWORD=Gah6kuP7ohfio4 \ ibmcom/db2:11.5.7.0 - view
lwk@qwfys:~$ docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES b7a031e63731 ibmcom/db2:11.5.7.0 "/var/db2_setup/lib/…" 17 seconds ago Up 14 seconds 22/tcp, 55000/tcp, 60006-60007/tcp, 0.0.0.0:50000->50000/tcp, :::50000->50000/tcp db2 lwk@qwfys:~$ - into the db2
lwk@qwfys:~$ docker exec -it db2 /bin/bash [root@eae784bfb067 /]# ll total 2188 lrwxrwxrwx 1 root root 7 Dec 2 07:04 bin -> usr/bin dr-xr-xr-x 2 root root 4096 Dec 14 2017 boot drwxr-xr-x 4 root root 4096 Jan 19 16:37 database drwxr-xr-x 15 root root 4480 Jan 19 16:36 dev drwxr-xr-x 1 root root 4096 Jan 19 16:37 etc -rw-r--r-- 1 root root 2159352 Dec 16 16:43 get-pip.py drwxr-xr-x 2 root root 4096 Dec 16 16:44 hadr drwxr-xr-x 2 root root 4096 Dec 2 07:06 home lrwxrwxrwx 1 root root 7 Dec 2 07:04 lib -> usr/lib lrwxrwxrwx 1 root root 9 Dec 2 07:04 lib64 -> usr/lib64 drwxr-xr-x 1 root root 4096 Dec 16 16:58 licenses drwxr-xr-x 2 root root 4096 Dec 14 2017 media drwxr-xr-x 2 root root 4096 Dec 14 2017 mnt drwxr-xr-x 1 root root 4096 Dec 16 16:56 opt dr-xr-xr-x 685 root root 0 Jan 19 16:36 proc dr-xr-x--- 1 root root 4096 Dec 16 16:57 root drwxr-xr-x 1 root root 4096 Jan 19 16:37 run lrwxrwxrwx 1 root root 8 Dec 2 07:04 sbin -> usr/sbin drwxr-xr-x 2 root root 4096 Dec 14 2017 srv dr-xr-xr-x 13 root root 0 Jan 19 16:36 sys drwxrwxrwt 1 root root 4096 Jan 19 16:37 tmp drwxr-xr-x 1 root root 4096 Dec 2 07:04 usr drwxr-xr-x 1 root root 4096 Dec 16 16:56 var [root@eae784bfb067 /]# pwd / [root@eae784bfb067 /]# ll /home/ total 0 [root@eae784bfb067 /]# ll /database/ total 8 drwxr-xr-x 6 root root 4096 Jan 19 16:37 config drwxr-xr-x 2 db2inst1 db2iadm1 4096 Jan 19 16:37 data [root@eae784bfb067 /]# ll /database/data/ total 0 [root@eae784bfb067 /]# su - db2inst1 Last login: Wed Jan 19 16:39:11 UTC 2022 [db2inst1@eae784bfb067 ~]$ db2 list database directory SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 [db2inst1@eae784bfb067 ~]$ db2sampl Creating database "SAMPLE"... Connecting to database "SAMPLE"... Creating tables and data in schema "DB2INST1"... Creating tables with XML columns and XML data in schema "DB2INST1"... 'db2sampl' processing complete. [db2inst1@eae784bfb067 ~]$ db2 list database directory System Database Directory Number of entries in the directory = 1 Database 1 entry: Database alias = SAMPLE Database name = SAMPLE Local database directory = /database/data Database release level = 15.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = [db2inst1@eae784bfb067 ~]$ db2 list database directory System Database Directory Number of entries in the directory = 1 Database 1 entry: Database alias = SAMPLE Database name = SAMPLE Local database directory = /database/data Database release level = 15.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = [db2inst1@eae784bfb067 ~]$ - view logs
lwk@qwfys:~$ docker logs -f db2
(*) Previous setup has not been detected. Creating the users...
(*) Creating users ...
(*) Creating instance ...
DB2 installation is being initialized.
Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)
Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end
Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end
Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end
Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/db2icrt.log.71".
DBI1446I The db2icrt command is running.
DBI1070I Program db2icrt completed successfully.
(*) Fixing /etc/services file for DB2 ...
01/19/2022 16:37:00 0 0 SQL1032N No start database manager command was issued.
SQL1032N No start database manager command was issued. SQLSTATE=57019
(*) Cataloging existing databases
ls: cannot access /database/data/db2inst1/NODE0000: No such file or directory
(*) Applying Db2 license ...
LIC1402I License added successfully.
LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V11.5/license/en_US.iso88591"
(*) Saving the checksum of the current nodelock file ...
(*) Updating DBM CFG parameters ...
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
No Cgroup memory limit detected, instance memory will follow automatic tuning
(*) Remounting /database with suid...
DB2 State : Operable
DB2 has not been started
Starting DB2...
01/19/2022 16:37:07 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
ssh-keygen: generating new host keys: RSA1 RSA DSA ECDSA ED25519
(*) All databases are now active.
(*) Setup has completed.
false
2022-01-19-16.37.07.792499+000 I30273E393 LEVEL: Warning
PID : 12888 TID : 140696121096064 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: eae784bfb067
FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:16187
MESSAGE : Released lock on the file:
DATA #1 : String, 50 bytes
/database/config/db2inst1/sqllib/ctrl/db2strst.lck
2022-01-19-16.40.47.526231+000 I30667E572 LEVEL: Info
PID : 12986 TID : 140284901975808 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
APPHDL : 0-8 APPID: *LOCAL.db2inst1.220119164048
AUTHID : DB2INST1 HOSTNAME: eae784bfb067
EDUID : 23 EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, data protection services, sqlpCreateDatabaseFiles, probe:1657
DATA #1 : 
