【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 "-r-sr-s---" 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 "-r-sr-s---".
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/

原文地址:https://www.cnblogs.com/gnuhpc/p/2828292.html