Database Housekeeping

RunMyJobs makes heavy use of its database. Consequently, you must closely monitor the file system space used by your database, and pay attention to fragmentation of database files, tablespaces, and other means of file system space allocation used by database objects.

By default, the Monitor Tree monitors some database-related statistics, such as the number of records and the delta number of records. The monitoring section of the documentation also contains an example of how to monitor Oracle database processes. You can build on that to create your database flavor-specific monitoring module.

Cleaning Ghost Records up on MS SQL Server and SAP/Sybase ASE Databases

Customers using a great number of processes with many parameters and short keep clauses can experience the build-up of ghost records in the indexes on JCS_JOBPARAMETER0. This can slow-down the system and use up a tremendous amount of space. If you cannot reduce the number of parameters, you will have to rebuild the indexes regularly on that table; the frequency depends on the volume of parameters.

SQL Server

You can schedule a rebuild of the indexes at regular intervals. For example:

ALTER INDEX PK__JCS_JOBP__D9CE5306737017C0 ON JCS_JOBPARAMETER0 REBUILD
ALTER INDEX JCS_JOBPARAMETER00 ON JCS_JOBPARAMETER0 REBUILD
ALTER INDEX JCS_JOBPARAMETER01 ON JCS_JOBPARAMETER0 REBUILD

SAP/Sybase ASE

On Sybase, you can use the following syntax:

reorg rebuild JCS_JOBPARAMETER0 PK__JCS_JOBP__D9CE5306737017C0

Note: Be sure to check the names of the indexes in your database.