<div dir="ltr">Hi Guys,<div><br></div><div>I am using Guvnor 5.5. For moving packages between environments, I am doing an export, and then import in the new package. I have a lof of assets in each package. I am using the DB storage for the jcr repository.</div>
<div><br></div><div style>After some months, the DB has grown a LOT! (like 3.5GB).</div><div style><br></div><div style>Is there a way regularly clean the JCR history, or maybe disable JCR history as we are not using it at all?</div>
<div style><br></div><div style>These are the steps I did to remove the history and seems to work fine. Does is seem safe? Is there a better way?</div><div style><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
1.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Export the entire repository via guvor.<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
<u></u>2.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Delete all the packages.<u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
<u></u>3.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Stop tomact<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u>4.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>“truncate” the following guvnor tables:<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>a.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Pm_ws_default_binval<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>b.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Pm_ws_default_bundel<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>c.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Versioning_pm_binval<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:74.7pt"><u></u>d.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Versioning_pm_bundle<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u>5.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Restated tomcat</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
6.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u>Import what I exported on step #1</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><br></p>
<p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">Thanks!</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><br></p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt">
Demian</p><p style="font-family:arial,sans-serif;font-size:13.333333969116211px;margin-left:38.7pt"><u></u></p><div><br></div></div></div>