VERIFIED SOLUTION i
X

Can we reduce the database size to avoid Spectrum upgrade issues?

UPDATED: September 9, 2018


No, there is not much we can do to reduce the database size.
Refer Neo4j Knowledge base article Understanding Database Growth for more details.
User-added image

As a precaution, you need to run purge and auto archive and database size should not go up.
Refer Knowledge base article topic "Maintaining database size to avoid Spectrum v12.2 upgrade issues" for some ways to control the database size.

However, if there is still need to reduce the file size under graph db folder, you can use the open source tool and follow the below steps:
Refer the Stackoverflow online community discussion for more details.

1. Open a web browser and go to http://server:port/jmx-console
Where: server is the IP address or hostname of your Spectrum™ Technology Platform server and port is the HTTP port used by Spectrum™ Technology Platform. The default is 8080.

2. Run purge
User-added image

3. Once the purge completes, stop the Spectrum server from Services
4. Please be sure than no any neo4j instances running
5. Backup database from <Spectrum Install>/repository/data/databases/graph.db
6.  Unzip storeutil.zip into <Spectrum Install>/server/bin
7.  Check neo4j.properties specifically property:
source_db_dir=../../repository/data/databases/graph.db
target_db_dir=../../repository/data/databases/graph.new

8.    If on windows run as admin: 
java -jar store-util-3.2.6.jar

9.    Once completed new database will be in: 
../../repository/data/databases/graph.new
10. Delete old graph.db replace with /graph.new


 

Environment Details

Product Affected: Spectrum Technology Platform
Product Feature: Installation / Upgrade
Operating System: Windows
 

Downloads

  • No Downloads