Mismatch Between Object Count in the Navigator/Manage and the Database Table

You may encounter a situation where the total number of objects (e.g., queues) listed in the database table (such as localqs) differs from the count displayed in the Navigator/Manage. For example :

• The database table shows: 98 queues

• Navigator/Manage shows: 100 queues

This mismatch occurs because the database is not updated in real-time—instead, data is written at scheduled intervals (default: once per hour). Meanwhile, the Navigator/Manage reflects the current, live state of the system. 

Why Does This Happen?

The Workgroup Server (WGS) manages object synchronization between the database and Navigator/Manage. Key factors influencing this behavior include:

1. Database Write Interval

   • By default, the WGS updates the database every 60 minutes (this is configurable).

   • Changes made in Navigator/Manage (e.g., queue creation/deletion) may not immediately reflect in the database. 

2. Caching & Real-Time Monitoring

   • Navigator/Manage retrieves live data directly from the messaging system (e.g., IBM MQ).

   • The database (localqs) only stores a periodic snapshot.

3. Configuration Settings

   • The "Database Write Interval" in WGS properties controls how frequently updates are pushed to the database. 

WGS Properties Configuration :