database 未发出启动数据库管理器命令。SQLSTATE=57019

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/31740042/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-08 07:57:49  来源:igfitidea点击:

No start database manager command was issued. SQLSTATE=57019

databasedb2database-administration

提问by Sathish Kumar

I am new to DB2 and I have installed DB2 9.7.

我是 DB2 的新手,并且已经安装了 DB2 9.7。

I created an instance which is shown below

我创建了一个实例,如下所示

[sathish@oc3855733574 ~]$ db2ilist
sathish

Settings of /etc/services is shown below

/etc/services 的设置如下所示

DB2_sathish     60000/tcp
DB2_sathish_1   60001/tcp
DB2_sathish_2   60002/tcp
DB2_sathish_END 60003/tcp
DB2_TMINST      50000/tcp

But, when I start using 'db2start' it throws the following error

但是,当我开始使用“db2start”时,它会引发以下错误

07/31/2015 10:26:20     0   0   SQL1042C  An unexpected system error occurred.
SQL1032N  No start database manager command was issued.  SQLSTATE=57019

I installed DB2 using 'root' and starting 'DB2' from 'instance' (sathish in this case)

我使用“root”安装 DB2 并从“实例”启动“DB2”(在本例中为 sathish)

Any help or URL link will be of great use

任何帮助或 URL 链接都非常有用

Thanks Sathish Kumar

感谢 Sathish Kumar

回答by Sathish Kumar

I had a look into db2diag.log file and I got a unusual hack from one of the website

我查看了 db2diag.log 文件,并从其中一个网站获得了一个不寻常的黑客攻击

I followed the steps mentioned below and it worked

我按照下面提到的步骤操作,它奏效了

a)   db2trc on -f db2trace.out
b)   db2start
c)   db2trc off

回答by ashishshan97

This problem generally occurs if you have recently changed the password of the account which is the owner of that db2 instance what you need to do is go to services-> properties of the db2 instance -> and then from log on part select local system account

如果您最近更改了该 db2 实例所有者帐户的密码,通常会出现此问题,您需要做的是转到服务-> db2 实例的属性-> 然后从登录部分选择本地系统帐户

回答by data_henrik

This looks like something is wrong with the installation. There should be some hints on what DB2 ran into in the db2diag.log file (look under ~/sqllib/db2dump/db2diag.log).

这看起来像是安装有问题。db2diag.log 文件中应该有一些关于 DB2 遇到的问题的提示(查看 ~/sqllib/db2dump/db2diag.log)。

What you could do if the db2diag.log does not provide a clue is to verify your installation is correct. DB2 includes a tool for that named "db2val". Here is the link to the documentation of db2val for version 9.7. Just run "db2val" as the instance owner and check the output.

如果 db2diag.log 没有提供线索,您可以做的是验证您的安装是否正确。DB2 包含一个名为“db2val”的工具。这是9.7 版 db2val 文档链接。只需以实例所有者身份运行“db2val”并检查输出。