{"id":67,"date":"2016-06-17T17:42:29","date_gmt":"2016-06-17T14:42:29","guid":{"rendered":"https:\/\/amsd.go.ro\/wordpress\/?p=67"},"modified":"2021-09-07T11:25:26","modified_gmt":"2021-09-07T08:25:26","slug":"manually-running-proactivenet-sybase-db-rebuild","status":"publish","type":"post","link":"https:\/\/amsd.go.ro\/wordpress\/?p=67","title":{"rendered":"Manually running ProactiveNet Sybase DB Rebuild"},"content":{"rendered":"<p>This is an workaround that could be used when standard rebuild procedure fails because of &#8220;memory e<span id=\"page:j_id366:j_id367:title\">xhausted&#8221;: <em>pw database rebuild fails with error Dynamic Memory Exhausted<\/em><\/span><\/p>\n<pre>Manually running the steps and using a larger cache size resolved the issue<br \/><br \/>1) dbunload -c \"LINKS=tcpip;eng=storm_&lt;hostname&gt;;uid=dba;pwd=pronet\" -r \"D:\\ProactiveNet\\pw\\dbrebuild\\reload.sql\" -u \"D:\\ProactiveNet\\pw\\dbrebuild\\unload\"<br \/>2) dbinit -p 4096 -z UTF8 -j \"D:\\ProactiveNet\\pw\\dbrebuild\\pronto.db\"<br \/>3) dbeng9 -qi -d -ch 2000M \"D:\\ProactiveNet\\pw\\dbrebuild\\pronto.db\"<br \/>4) dbisqlc -c \"LINKS=tcpip;eng=pronto;uid=dba;pwd=sql\" -q <br \/>    \"D:\\ProactiveNet\\pw\\dbrebuild\\reload.sql\"<\/pre>\n<p>If it still fails try a larger -ch number<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is an workaround that could be used when standard rebuild procedure fails because of &#8220;memory exhausted&#8221;: pw database rebuild fails with error Dynamic Memory Exhausted Manually running the steps and using a larger cache size resolved the issue1) dbunload [&hellip;]<\/p>\n<div class=\"link-more\"><a href=\"https:\/\/amsd.go.ro\/wordpress\/?p=67#more-67\" class=\"more-link\">Continue reading &#10142; <span class=\"screen-reader-text\">Manually running ProactiveNet Sybase DB Rebuild<\/span><\/a><\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[16,13,17,10,18,12],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-technology","tag-ps_56","tag-ps_40","tag-ps_33","tag-ps_32","tag-ps_39","tag-ps_17"],"_links":{"self":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=67"}],"version-history":[{"count":1,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":177,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions\/177"}],"wp:attachment":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}