缘来路过 发表于 2016-11-18 08:35:56

【DB2问题解决】SQL1042C SQL1032N SQLSTATE=57019

  作者:gnuhpc   
出处:http://www.cnblogs.com/gnuhpc/
  It can be due to incorrect ownership or permissions on db2sysc executable.   
Check the file permission in <instance_home>/sqllib/adm - It should be &quot;-r-sr-s---&quot; and owned by root:db2grp1 (in your case)   
Log in as root and update the instance (db2iupdt).   
Check the permission of db2sysc executable in <instance_home>/sqllib/adm directory - it should be &quot;-r-sr-s---&quot;.   
If its different,   
- login as root   
- change directory to /usr/opt/db2_08_01/instance   
- Update the instance - ./db2iupdt db2inst1   
Before the instance update ensure all DB2 interprocess communications are cleared for the instance to be updated. As the instance owner, run: <instance_home>/sqllib/bin/ipclean.
  作者:gnuhpc   
出处:http://www.cnblogs.com/gnuhpc/
页: [1]
查看完整版本: 【DB2问题解决】SQL1042C SQL1032N SQLSTATE=57019