[DB2 Problem Solving] sql1_2c sql1032n sqlstate = 57019

Author: gnuhpc
Source: 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 shoshocould 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 shoshould 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 updatupdated. As the instance owner, run: <instinstance_home>/sqllib/bin/ipclean.

 

Author: gnuhpc
Source: http://www.cnblogs.com/gnuhpc/