报错
环境
- docker
- Database server = DB2/LINUXX8664 10.5.5
原因
数据库不存在
解决
进入镜像 并切换用户
(1)进入镜像
docker exec -it db2 /bin/bash
备注:
1.docker exec :在运行的容器中执行命令
2.-t :分配一个伪终端
3.db2 是容器的名称
(2)切换用户
su db2inst1
4、创建数据库
db2start
db2 create database AUDIT using codeset GBK territory cn
db2 connect to AUDIT
[root@f ~]# docker exec -it db2 /bin/bash
[root@dced5dfbb3f4 /]# su db2inst1
[db2inst1@dced5dfbb3f4 /]$ db2 connect to AUDIT
SQL1031N The database directory cannot be found on the indicated file system.
SQLSTATE=58031
[db2inst1@dced5dfbb3f4 /]$ db2start
SQL1026N The database manager is already active.
[db2inst1@dced5dfbb3f4 /]$ db2 create database AUDIT using codeset GBK territory cn
DB20000I The CREATE DATABASE command completed successfully.
[db2inst1@dced5dfbb3f4 /]$ db2 connect to AUDIT
Database Connection Information
Database server = DB2/LINUXX8664 10.5.5
SQL authorization ID = DB2INST1
Local database alias = AUDIT
[db2inst1@dced5dfbb3f4 /]$
成功连上