“Expired Query-Ex Data” in the Lotus Notes Driver



By: pnuffer

September 26, 2007 5:18 am

Reads: 168

Comments:0

Rating:0

Problem

Question: In the Notes driver trace file, I see messages similar to the following:

TRACE:  NotesDriver: Check subscriber channel query processor for expired query-ex data.
TRACE:  NotesDriver: Performing clean-up check for expired query-ex data.
TRACE:  NotesDriver: cleanQueryExTable: no expired query-ex data found.
TRACE:  NotesDriver: Check publisher channel query processor for expired query-ex data.
TRACE:  NotesDriver: Performing clean-up check for expired query-ex data.
TRACE:  NotesDriver: cleanQueryExTable: no expired query-ex data found.

What is “expired query-ex data”? And what do these trace messages signify?

Solution

Answer: These messages are displayed by the janitorial services of the NotesDriverShim. To support the feature of query-ex, the NotesDriverShim runs a process every 30 minutes (by default) to remove any orphaned query-ex data that is currently being maintained (but not utilized) by the NotesDriverShim.

Query-ex is an Identity Manager feature implemented by the IDM engine – and many IDM drivers – that allows query data to be returned to the requestor in blocks or chunks. Thus, query-ex can be used to request all the Person documents within Notes, but only return them in blocks of 50 person documents at a time, so that JVM memory limitations are not exceeded. When using this type of paged result query protocol, it is possible for the requestor to abandon the query sequence before getting all the blocks of data possible. Thus, every 30 minutes this janitorial process will run and search for orphaned query-ex data that has not been accessed by the paged result protocol in the last specified interval (30-minute default). If detected, this orphaned query-ex data is removed from memory.

Example

To alter the default interval at which the Notes driver’s janitorial service runs, you can use (or insert) a parameter definition similar to the one below. The NotesDriverShim startup parameter shown below should be inserted within the ‘driver-options’ section of the driver configuration.

<definition display-name="Janitor Cleanup Interval (in minutes)" name="janitor-cleanup-interval" type="integer">
  <description>Janitor cleanup checks for and releases resources that might have been orphaned by unfinished query-ex sequences. 
This interval determines how often to perform this janitorial service.</description>
  <value<30</value>
</definition>

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

Tags: , ,
Categories: Identity Manager, Technical Solutions

Disclaimer: As with everything else at NetIQ Cool Solutions, this content is definitely not supported by NetIQ, so Customer Support will not be able to help you if it has any adverse effect on your environment.  It just worked for at least one person, and perhaps it will be useful for you too.  Be sure to test in a non-production environment.

Comment