Update Statistics Handling

Note: Only one Update Statistics call can run at any one time on the server.

If necessary, the settings for Update Settings may be modified to deviate from the default interval and to control when maintenance calls happen. You can add specific “Update” settings in the Configuration database SystemProperties table. The following script examples may be used as a guide:

 

 

When the database statistics are updated, the Queue Manager Log file contains an entry similar to:

"Statistics update completed in NNms on database XYZ"

 

The values are set to either False (off) or True (on) for the following “Update” settings:

 

The Queue Manager Log file now contains additional information about when a database is put on the list of databases to be updated, along with when the earliest the update will run. For example:

2017-04-06 13:32:48,715 [20] INFO  QueueManager.QMMaintenance - Queued database DG_F_eCapFI_Client00002 for statistics update at or after 1:47 PM

 

The Log file now displays information about when a database is put into the Update Statistics queue. For example:

2017-04-06 13:35:09,514 [56] INFO  QueueManager.QMMaintenance - Queued database DG_F_eCapFI_Client00002 for statistics update [interval]

2017-04-06 13:35:09,514 [56] INFO  QueueManager.QMMaintenance - Queued database DG_F_eCapFI_Client00002 for statistics update [job completion]

 

Related Topics

Client Management Tree View and Status and Summary Panel