db2inst1@hostdb2[/home/db2inst1]$ db2 "select * from staff"
SQL1024N A database connection does not exist. SQLSTATE=08003
在刚创建的db2数据库下执行了:
6) 断开所有应用程序与数据库的连接
force application all
这条命令,导致正常的数据库连接和查询都无法进行了
db2inst1@hostdb2[/home/db2inst1]$ db2 "select * from staff"
SQL1024N A database connection does not exist. SQLSTATE=08003
db2inst1@hostdb2[/home/db2inst1]$
需要在该用户下执行一下如下的命令就行了:
db2inst1@hostdb2[/home/db2inst1]$db2 connect to sample user db2inst1 using db2inst1
Database Connection Information
Database server = DB2/LINUXX8664 11.1.4.4
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
db2inst1@hostdb2[/home/db2inst1]$
sample是数据库名,我这边是建库的时候创建的示例数据库sample。
user db2inst1是实例安装的操作系统用户
using db2inst1是上面操作系统用户对应的密码。