SQLSTATE=57019

解决DB2数据库启动问题

最新推荐文章于 2020-05-15 07:56:34 发布

guoyanxi

最新推荐文章于 2020-05-15 07:56:34 发布

阅读量554

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/guoyanxi/article/details/83761329

db2 专栏收录该内容

33 篇文章

订阅专栏

本文记录了在尝试启动DB2数据库时遇到的问题及其解决过程。初始尝试未能成功启动数据库，返回了SQLSTATE=57019错误，通过进一步的操作最终成功启动了数据库并建立了连接。

SQLSTATE=57019

issue db2start:


db2 => connect to SAMPLE
SQL1032N  No start database manager command was issued.  SQLSTATE=57019
db2 => quit
DB20000I  The QUIT command completed successfully.

[db2inst1@server1 ~]$ db2 ? 57019

SQLSTATE 57019: The statement was not successful, because of a problem with a
resource.

[db2inst1@server1 ~]$ db2start
SQL1063N  DB2START processing was successful.
[db2inst1@server1 ~]$ db2 connect to sample

   Database Connection Information

 Database server        = DB2/LINUX 9.5.2
 SQL authorization ID   = DB2INST1
 Local database alias   = SAMPLE