{"id":41,"date":"2009-12-17T11:22:00","date_gmt":"2009-12-17T11:22:00","guid":{"rendered":"https:\/\/www.srivittal.com\/wp\/?p=41"},"modified":"2021-08-31T10:13:06","modified_gmt":"2021-08-31T09:13:06","slug":"sql1092n-does-not-have-the-authority-to-perform-the-requested-command","status":"publish","type":"post","link":"https:\/\/www.srivittal.com\/wp\/?p=41","title":{"rendered":"SQL1092N  does not have the authority to perform the requested command"},"content":{"rendered":"<p>When I installed DB2 express 9.5 on my Windows XP pro, it automatically created a default DB2 instance, a user named db2admin with the password I specified and then a DB2ADMNS group. The DB2 install added the db2admin user to the DB2ADMNS group. Everything went well and the install finished.<\/p>\n<p>But unfortunately, I was logged in using my corporate domain id and when launching DB2 Control Center, I could not see the default instance or the databases. I could not perform any database create operations as wel.This id was also a part of the local administrators group.<\/p>\n<p>After digging around Google for a while, I came across several steps that must be performed in order to get this working successfully. <\/p>\n<ul>\n<li>Go to the Services panel and change the DB2 services running under .db2admin id to run under the domain id. Stop and restart these services. Some of the services include<\/li>\n<ul>\n<li>DB2 &#8211; DB2COPY1 &#8211; DB2<\/li>\n<li>DB2 Remote command server (DB2COPY1)<\/li>\n<li>DB2DAS &#8211; DB2DAS00<\/li>\n<\/ul>\n<li>Add the domain id to the local DB2ADMNS group<\/li>\n<li>Open up the DB2 command line processor window and type quit to come out of CLP.<\/li>\n<li>The type the following command in<\/li>\n<\/ul>\n<blockquote><p>db2set DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL<\/p><\/blockquote>\n<blockquote><p>UPDATE DBM CFG USING SYSADM_GROUP DB2ADMNS<br \/>UPDATE DBM CFG USING SYSCTRL_GROUP DB2ADMNS<\/p><\/blockquote>\n<ul>\n<li>&nbsp;Stop and restart the DB2 services again.<\/li>\n<li>If necessary stop and restart windows.<\/li>\n<\/ul>\n<p>Try to open DB2 control center to see if you can see everything and create databases.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When I installed DB2 express 9.5 on my Windows XP pro, it automatically created a default DB2 instance, a user named db2admin with the password I specified and then a DB2ADMNS group. The DB2 install added the db2admin user to the DB2ADMNS group. Everything went well and the install finished. But unfortunately, I was logged &hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry entry-center"],"_links":{"self":[{"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/41","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=41"}],"version-history":[{"count":1,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":202,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions\/202"}],"wp:attachment":[{"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.srivittal.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}