Discussion:
SQL10007N Message "-1390" could not be retrieved. Reason code: "3"
(too old to reply)
c***@tsctech.com
2007-08-06 16:58:47 UTC
Permalink
hello,
i have recently installed db2 8.1 on debian, but i
SQL10007N Message "-1390" could not be retrieved.
Reason code: "3"
no matter what db2 command i execute, i always get
the above error. i have tried issuing commands as
root and as db2inst1. i have been googling for a day
now, but without success. there are solutions for
reason code 1,2,4,5,6,... but no 3.
does anyone know what this reason code 3 means, and
can help me along?
i would be very thankfull!
Had same on my Linux installation while running as root.
su <db2instanceuser>
viola!
t***@rediffmail.com
2007-08-28 23:50:40 UTC
Permalink
The reason for this is db2 user profile has been created while installing as ROOT. you need to change .profile and .login files of the user which you created while installing the DB2 to the respective user:group.
Ex:
chown wcsdb:db2fadm /home/wcsdb/.profile

Then login using the DB2 user which will set the required profile and will run your db2 commands.
Continue reading on narkive:
Search results for 'SQL10007N Message "-1390" could not be retrieved. Reason code: "3"' (Questions and Answers)
4
replies
What is basic difference between java n html?
started 2006-10-04 22:39:43 UTC
software
Loading...