{"id":41,"date":"2009-03-03T22:03:49","date_gmt":"2009-03-03T16:03:49","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=41"},"modified":"2016-01-07T11:31:14","modified_gmt":"2016-01-07T05:31:14","slug":"resetting-db2-file-permissions","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=41","title":{"rendered":"Resetting DB2 file permissions"},"content":{"rendered":"<p>Today something interesting happened at work. My windows system admin seems to have installed a patch on the OS without shutting down DB2. This seems to have screwed up the file permissions on the DB2 install directory. When we tried to start Db2 after the server restart, DB2 started giving SQL1042C.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0A little bit of research confirmed that the install directory had lost its permission and db2instance userid was not able to read the files.<\/p>\n<p>I executed the following command from the SQLLIB\/BIN (windows) directory and it reset the permissions :<\/p>\n<h3 id=\"r0011802\">Set permissions for DB2 objects<span> Command\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 :<\/span><\/h3>\n<h3>db2secv82\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 &#8211; &gt; <span>for DB2 V8.x<\/span><\/h3>\n<h3><span>db2extsec\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 -&gt; for DB2 V9.x<\/span><\/h3>\n<p>This also works on UNIX systems.\u00c2\u00a0 Read up about the command on DB2 manuals before you execute it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today something interesting happened at work. My windows system admin seems to have installed a patch on the OS without shutting down DB2. This seems to have screwed up the file permissions on the DB2 install directory. When we tried to start Db2 after the server restart, DB2 started giving SQL1042C.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0A little bit of research [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[3],"tags":[943,17,16],"class_list":["post-41","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2","tag-file","tag-permissions"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/41","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=41"}],"version-history":[{"count":3,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":101,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions\/101"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}