SpendMap User Guide (v14.8)

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Printable Version
Send Mail Feedback
Save Permalink URL

Navigation: Purchasing (Main Module) > Setup System

Database, Maintenance and System Performance Settings

PURCHASING > Setup system > Database, maintenance and system performance

These settings either enable and/or configure various features related to how SpendMap stores data in its database. Some of these settings influence system performance.

Some of the settings only apply to certain database types.

Related utilities

Various utilities are available to perform Database Maintenance.

DB Performance Settings Screen

Fields

Field

Description

Enable transaction rollback?

•Check this box to enable the Rollback Feature that will reverse the updates to the database in the event that a transaction cannot be completed in its entirety. A “transaction” is a process that updates multiple tables, such as processing a PO that updates the open PO table, the item history, budgets, etc.

•Possible causes of transaction failure are power failures, network problems, incorrect user actions (e.g.re‑booting), operating system errors, etc.

•While Rollback provides an increased level of data security, the use of Rollback will impact system performance.

Enable priority/rush maintenance?

•Check this box to enable the Priority Maintenance Feature that will allow management users to suspend other users' work while certain maintenance functions take place.

•You can specify which users are permitted to use the Priority Maintenance feature in the User Master File.

Use network rights checking?

•Do not change this setting unless advised by Technical Support.

Delete SPOOL files older than (months)

•SPOOL files are those that you access with Saved Reports and Files.

•Use this setting to conserve disk space by automatically deleting SPOOL files that are older than a certain number of months. Old files will be deleted as part of the full reindex procedure.

•A recommended value for most systems is 3-6 months. Enter ZERO (0) to disable (i.e. keep files forever unless manually deleted).

Path used for document attachments.

•You can specify an alternate path to use for document attachments (instead of the default /ATTACH folder).

Why can’t I change this setting (the field is not accessible)?

This value can only be changed under the following conditions:

1) There are no files/attachments currently in the target folder. If you need to change the folder after the system has been in use, you will need to move the files in the existing folder to the new location. This must only be done when no other users are in the system.

2) All users (including the Mobile Web App server, if applicable) must exit the system. There can only be a single user logged into the system (i.e., the user changing this setting).

Blank records available on history card when beginning a transaction (SQL version only)

•Do not change this setting unless advised by SpendMap Technical Support.

SQL database server CPU speed limit when printing reports
(SQL version only)

•Do not change this setting unless advised by SpendMap Technical Support.