Sidebar

How do I shrink the h2 database file after removing thousands of errors?

0 votes
2.9K views
asked Feb 19, 2015 by gary-h-3646 (180 points)
A customer's h2 database file is 15 GB.  They had CCDA validation errors a few months ago and now they only have a few hundred messages.  Other than renaming the .h2 file and importing a recent configuration like we do when they lose the admin password, is there any way to free up the extra disk space?

They only have the two meaningful use channels.

1 Answer

0 votes

The errors can be purged by right clicking on the channel and choosing properties. Then choosing the option to Purge Messages and then choosing to purge the Error Retention After x number of day's. This will purge the error messages.

Additionaly from the Channel Properties page you can choose to override the error retention policy and set it to 90 days or an appropirate number of days for the organization.

 

  

answered Feb 19, 2015 by gary-t-8719 (14,860 points)
...