Advanced Database Administration

Modified on Sat, 25 Jul at 11:28 PM

Overview

This section is intended primarily for IT administrators. It controls the QQube database engine, database location, synchronization role, and service settings.

Use care when changing these settings

Most installations should retain the default values. Change support-only options only when directed by a CLEARIFY engineer.

QQube advanced database administration settings

Database settings

SettingGuidance
1. QQube Engine NameDefaults to the computer name. Leave this value unchanged.
2. Database PathControls the location of the QQube database file. The default path is suitable for most installations.
3. Synchronizer Computer or SessionIdentifies the one computer or session permitted to perform synchronization.
4. Disable Shared MemoryUse only when directed by CLEARIFY Support.
5. Advanced Server OptionsControls advanced database-engine behavior, including memory limits. Use only when directed by CLEARIFY Support.
6. Database Service ControlsControls the QQube database service. The service is configured automatically during installation and should normally remain enabled.

Database path

The default database path is:

C:\Users\Public\Documents\CLEARIFY\QQube Tool\QQube.db

In a QQube Multi-User installation, the database may be moved to another local drive when additional storage or a different disk location is required.

Database location requirement

The database must remain on a drive physically attached to the same computer. Do not place it on a network share or another computer.

Database file options

Right-click inside the Database Path area to display the available database actions.

QQube database path right-click options

OptionAction
ACreate a new, empty QQube database.
BRename the current QQube database.
CMove the database to another location on the same physical computer.
DCreate a compressed copy of the database on the desktop for support or archival purposes.

Synchronizer computer or session

A QQube network can have only one synchronization computer or session. In a Multi-User environment, this setting is established during the server installation and cannot be changed without reinstalling QQube.

Support-only options

Disable Shared Memory

Use this option only when directed by a CLEARIFY engineer.

Advanced Server Options

These options control advanced database-engine behavior, including memory usage. The example shown in the Configuration Tool limits the database engine to 50% of available memory.

Do not change these values unless directed by a CLEARIFY engineer.

Database service controls

The QQube database operates most effectively as a Windows service. The installer configures this automatically to support network access and faster communication with reporting applications.

Important distinction

The QQube database service does not communicate with QuickBooks. The Intuit SDK does not permit QuickBooks communication from an elevated Windows service.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article