{"id":311,"date":"2016-02-06T15:23:02","date_gmt":"2016-02-06T09:53:02","guid":{"rendered":"http:\/\/www.middlewareprimer.com\/blog\/?p=311"},"modified":"2016-02-06T15:23:02","modified_gmt":"2016-02-06T09:53:02","slug":"sql10007n-message-1390-not-retrieved-reason-code-3","status":"publish","type":"post","link":"http:\/\/www.middlewareprimer.com\/blog\/2016\/02\/06\/sql10007n-message-1390-not-retrieved-reason-code-3\/","title":{"rendered":"SQL10007N Message “-1390” could not be retrieved. Reason code: “3”"},"content":{"rendered":"

SQL10007N Message “-1390” could not be retrieved.\u00a0 Reason code: “3”, message pops up while starting the Database. Below is the message,<\/p>\n

[root@<hostname> adm]# .\/db2start
\nSQL10007N Message “-1390” could not be retrieved.\u00a0 Reason code: “3”.<\/p>\n

This error message came up after fixing the hostname issue reported in my previous blog entry<\/span><\/a>.<\/p>\n

Resolution<\/strong><\/span><\/p>\n

1. DB2INSTANCE Environment variable is declared.<\/p>\n

On root user, just issue the command, env<\/strong> ,make sure that DB2INSTANCE variable is declared and is visible in the output. If not please assign the variable with the instance name.<\/p>\n

ex:<\/p>\n

export DB2INSTANCE=<instancename><\/p>\n

export DB2INSTANCE=db2inst1 (my instance name is db2inst1 here)<\/p>\n

After export, issue the same command, env and check for the value.<\/p>\n

2. Verify db2profile file for all the entries.<\/p>\n

Make sure that db2profile file contains all proper entries for the current DB2 instance. db2profile file will be under <instancename>\/sqllib\/ directory.<\/p>\n

3. Make sure that proper access is available to start\/stop\/query the database. The user with which we are executing the commands should have proper rights with at least 644 privileges.<\/p>\n

Please refer to IBM DB2 Support portal technote,<\/p>\n

https:\/\/www-304.ibm.com\/support\/docview.wss?uid=swg21474604<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

SQL10007N Message “-1390” could not be retrieved.\u00a0 Reason code: “3”, message pops up while starting the Database. Below is the message, [root@<hostname> adm]# .\/db2start SQL10007N Message “-1390” could not be retrieved.\u00a0 Reason code: “3”. This error message came up after fixing the hostname issue reported in my previous blog entry. Resolution 1. DB2INSTANCE Environment variable […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[80],"tags":[83,82,84,81],"class_list":["post-311","post","type-post","status-publish","format-standard","hentry","category-ibm-db2","tag-83","tag-db2-v9-7","tag-reason-code-3","tag-sql10007n"],"_links":{"self":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/comments?post=311"}],"version-history":[{"count":2,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/311\/revisions"}],"predecessor-version":[{"id":316,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/311\/revisions\/316"}],"wp:attachment":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/media?parent=311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/categories?post=311"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/tags?post=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}