Home
Administration
Configure, manage, monitor, troubleshoot, and tune the performance of your system.
Monitoring Your System
Clearing MRR Cache
This section describes how to clear the MRR cache and close the open native handles of all MRR tables that have the Volatile flag set to false.

Welcome
What is Spectrum Spatial?
Getting Started
Learn about Spectrum Spatial.
Administration
Configure, manage, monitor, troubleshoot, and tune the performance of your system.
- Introduction
- Configure Your System
- Monitoring Your System
  - Viewing System Events
    View the system log when you experience trouble and are looking for information about possible causes.
  - Spatial Logging
  - Configuring a Mail Server
  - Selecting Items for Expiration Notification
    You can choose which items you want to be notified about so that you only receive notifications for those items that concern you.
  - Viewing Version Information
  - Viewing and Exporting License Information
  - Monitoring Performance with the Spectrum JMX Console
  - Monitoring File Handle Caching Statistics with the Spectrum JMX Console
  - Monitoring Memory Usage
  - Restarting Spectrum Spatial
    You can use the Spectrum Spatial Manager to restart Spectrum Spatial remote component to clear the cache or pick up new settings without restarting the Spectrum Technology Platform.
  - Clearing MRR Cache
    This section describes how to clear the MRR cache and close the open native handles of all MRR tables that have the Volatile flag set to false.
    - Clearing the MRR Cache in Spectrum Spatial Manager
    - Clearing the MRR Cache in Spectrum JMX Console
- Performance Tuning
- Manage a Cluster
- Using the Administration Utility
- Routing
- Troubleshooting Your System
Introduction to Security
Manage user roles and security for Spectrum Spatial and Spectrum Spatial Analyst.
Resources and Data
Learn how to work with spatial and routing data using named resources.
Managing Spatial
Manage the Spectrum Spatial repository and Spectrum Spatial Analyst deployments using Spectrum Spatial Manager.
Development
Learn how to incorporate spatial and routing functionality into your solutions.
Stages
Learn about the spatial and routing stages available for dataflows in Spectrum Enterprise Designer.
Services
Learn how to access spatial and routing services from your applications.
Utilities
Take advantage of the productivity tools that Spectrum Spatial has for working with spatial data.
Reference
Information about Spatial Java properties, MapInfo SQL language, and closest arc snapping when calculating routes.

Clearing MRR Cache

This section describes how to clear the MRR cache and close the open native handles of all MRR tables that have the Volatile flag set to false.

The MRR file is locked when its native handle is open in the cache to prevent update, delete, or replace operations on the file. A MRR Cache can be cleared in two ways, in the Spectrum JMX-Console and in Spectrum Spatial Manager.

The Volatile flag may be set to true or false:

When volatility is false, a file connection is held open by Spectrum Spatial for the MRR file. This is the default behavior, which prevents replacing MRR files when Spectrum Spatial is running on a Windows environment. On Linux, files can be replaced but older data is cached, which requires clearing the MRR cache.
When volatility is true, Spectrum Spatial opens and releases the MRR file for each request. When replacing a MRR file, the new data is immediately available for viewing. There may be a slight performance decrease re-opening the MRR on each request of about 100 ms (milliseconds).

See also MRR.