Compress the Database

Some of the data obtained by RICOH Streamline NX is stored on Microsoft SQL Server. However, data related to @Remote, device job log, device access log, and temporary data are also stored in the internal database (Derby Database).

After deleting the data, compress the database to reserve a free capacity on the hard disk.

For a detailed procedure for compressing the Microsoft SQL Server database, refer to Microsoft information at https://msdn.microsoft.com/library/ms189035(v=sql.110).aspx

Use the database compression tool for tables associated with the Derby Database. Using the database compression tool, you can free up space on the hard drive by deleting device job logs and device access logs.

The conditions for using the database compression tool are as follows:

  • The server is installed with Java.

  • Polling, configuration, and other RICOH Streamline NX tasks must be stopped.

  • You must have Windows Administrator privileges.

  • Ensure that there is sufficient disk space for compression. If an error message is displayed indicating that the drive is full when the database compression tool is used, safeguard the other files temporarily.

When you use the database compression tool, the RICOH Streamline NX service stops. Therefore, you cannot use RICOH Streamline NX while using the database compression tool.

  1. Extract (install-path)\Tools\SLNX_ShrinkInternalDB.zip to a folder.

  2. Move the extracted SLNX_ShrinkInternalDB folder to the install folder of RICOH Streamline NX.

The default path of the install folder is C:\Program Files\Ricoh\Streamline NX.

  1. Run "shrink.bat" in the SLNX_ShrinkInternalDB folder.

    The following message is displayed on the command prompt screen when the process is completed.

    Message

    Description

    Compress derby database end. Starting service.

    Service has started successfully.

    The process ended successfully.

    Disk has insufficient space. compress derby database failed.

    The process ended abnormally.

    Ensure that there is sufficient disk space, and then run the database compression tool again.

    Database (path) not found. compress derby database failed.

    The process ended abnormally.

    Move the SLNX_ShrinkInternalDB folder to the install folder of RICOH Streamline NX, and then run the database compression tool again.

    Access denied.

    compress derby database failed.

    The process ended abnormally.

    Log in with Administrator privileges, and then run the database compression tool again.