作者a3470194·2013-07-01 16:13

系统管理员·北京瑞银信管理顾问有限公司

DB2 SQL Error: SQLCODE=-30082, SQLSTATE=08001, SQLERRMC=42

字数 2640阅读 9413评论 0赞 0

<p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>问题</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>：使用客户端登陆时，报以下错误：</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>An error occurred while establishing the connection:</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>   Type: com.ibm.db2.jcc.am.ho   Error Code: -30082   SQL State: 08001</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>Message:</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>   DB2 SQL Error: SQLCODE=-30082, SQLSTATE=08001, SQLERRMC=42;ROOT CAPABILITY REQUIRED;, DRIVER=3.57.82</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>解决方法：</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>/home/db2inst1/sqllib/security目录下，db2chpw、db2ckpw两个文件的所属用户修改为root。权限修改为：4511。</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>步骤：</span><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/#cd /home</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home#cd db2inst1</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home/db2inst1#cd sqllib</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home/db2inst1/sqllib#cd security</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home/db2inst1/sqllib/security#ls -l</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>total 8064</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>drwxr-xr-x    2 db2inst1 db2iadm1        256 Feb 25 17:44 auditdata</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>-r-s--x--x    1 db2inst1 db2iadm1      34966 Feb 25 17:44 db2aud</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>-rw-r--r--    1 db2inst1 db2iadm1       4096 Feb 25 17:44 db2audit.cfg</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>lrwxrwxrwx    1 root     system           37 Feb 25 17:44 db2chkau -> /opt/IBM/db2/V9.7/security64/db2chkau</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>-r-s--x--x    1 db2inst1 db2iadm1      23872 Feb 25 17:44 db2chpw</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>-r-s--x--x    1 db2inst1 db2iadm1    4015551 Feb 25 17:44 db2ckpw</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>-r-x--s--x    1 db2inst1 db2iadm1      43592 Feb 25 17:44 db2flacc</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home/db2inst1/sqllib/security#chown root db2chpw</span><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home/db2inst1/sqllib/security#chown root db2ckpw</span><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home/db2inst1/sqllib/security#chmod 4511 db2chpw</span><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home/db2inst1/sqllib/security#chmod 4511 db2ckpw</span><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>root:/home/db2inst1/sqllib/security#su - db2inst1</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>$ pwd</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>/home/db2inst1</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>$ db2stop</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>03/18/2013 16:25:20     0   0   SQL1064N  DB2STOP processing was successful.</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>SQL1064N  DB2STOP processing was successful.</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>$ </span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>$ db2start</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>03/18/2013 16:25:29     0   0   SQL1063N  DB2START processing was successful.</span><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p><p style="margin-top: 0pt; margin-bottom: 0pt;" class="p0"><span style='font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'>SQL1063N  DB2START processing was successful.</span><span style='color: rgb(255, 0, 0); font-family: "新宋体"; font-size: 11pt; mso-spacerun: "yes";'></span></p>

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

作者其他文章

AIX上解压缩.tar.Z, .tar.gz, .zip及.tgz
评论 1 · 赞 1

AIX安装SSH
评论 1 · 赞 0

aix mount "vmount: operation not permitted" Error From Linux NFS 转载
评论 0 · 赞 0

Aix系统维护常用命令
评论 0 · 赞 0

aix_6.1_安装中文字符集
评论 0 · 赞 0

关于TWT 使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们
© 2024talkwithtrend — talk with trend,talk with technologist 京ICP备09031017号-30

X社区推广