Functions of the Delta Queue Monitor

Restricting the Displayed Information

There are different ways of restricting the information:

Preselection in the Monitor

In the upper area of the monitor screen, you can restrict the data displayed in the queue using various criteria. This improves the performance of the monitor.

Provider-Based Restriction
If you select a specific provider, for example BW DataSource, only the queues belonging to this provider are displayed in the monitor. Subscribers that have not subscribed to any of the queues of this provider are not displayed.

If you do not select a provider, all the queues from all providers are displayed in the monitor.
Queue-Based Restriction
If you specify a particular queue, for example, a DataSource, then only this specific queue is displayed in the monitor. When specifying the queue, you can use the wildcard * (for example, 0FI*) to restrict the monitor display to several queues.

If you do not specify a queue, the monitor display is not restricted.
Subscriber Type Restriction
If you select a specific subscriber type, for example SAP BusinessObjects Data Services, only the queues that have been subscribed to by a subscriber of this type are displayed in the monitor.

If you do not select a subscriber type, all the queues of all subscriber types are displayed in the monitor.
Subscriber-Based Restriction
If you specify a particular subscriber, for example, a data services system, then only this specific subscriber is displayed in the monitor. When specifying the subscriber, you can use the wildcard * (for example, SAP*) to restrict the monitor display to several subscribers.

If you do not specify a subscriber, the monitor display is not restricted.

These settings are applied when you change between monitor views.

Filter Settings in the List

You can set further restrictions for the displayed data, by using the filter function in the list. Filter settings in the list and changes to the list display only apply to the current monitor view. When you change to a different monitor view, these settings and changes are not applied.

Example Example

You can restrict the request overview to unconfirmed requests (in other words, requests that have not been transferred by the subscriber).

End of the example.

Calculating and Displaying the Data Volume of Queues

When you calculate the data volume (extended view) in the upper screen area of the monitor, the data volume and related key figures are calculated and displayed.

Note Note

This calculation can take a long time if a lot of units are saved in the delta queues. Therefore the calculation is not performed automatically when the monitor is called. You need to select the relevant checkbox to perform this calculation. When you change to a different monitor view, the calculation setting is applied to the new view.

End of the note.

The following calculations are performed in the monitor view:

Queues:
For each queue, the system counts the number of units, totals the rows and data volume (before and after compression) and finds the compression rate as well as the smallest and largest sequential transaction number (TSN).
Subscriptions:
For each subscription, the system counts the number of changed units per queue that are saved (in a retrievable state) in the delta queue. The system totals the changed rows (data changes) and the volume of saved, non-retrieved data (before and after compression), and also finds the compression rate.
Requests:
For each request, the system counts the number of units per queue, totals the rows and data volume (before and after compression) and finds the compression rate.
Units:
For a unit, the system totals the rows and the volume of saved, non-retrieved data (before and after compression), and also finds the compression rate. Note that the system always performs the calculation at the units level.

Displaying All Requests

If you choose Take requests w/o subscription into account in the upper screen area of the monitor, one-off transfers of data snapshots (full) are also included in the display.

Obtaining this data is very time consuming. Therefore, only requests with a subscription (delta requests) are displayed when the Delta Queue Monitor is called. When you change to a different monitor view, the setting for displaying requests without a subscription is applied to the new view.

Changing Between Monitor Views

You can switch between monitor views using the pushbuttons queues, subscriptions, requests and units. You can also double-click on a row to change views:

Switch from the queue overview to the subscription overview
Double-click on a row in the queue overview. The provider and the queue from the selected row are added to the preselection (in the subscription overview). The subscription overview only displays the subscriptions of the selected queue.
Switch from the subscription overview to the request overview
Double-click on a row in the subscription overview. The provider, the queue, the subscriber type and the subscriber from the selected row are added to the preselection (in the request overview). The request overview only displays the requests of a specific subscriber in a specific queue.
Switch to Unit Overview
From all of the other views, you can double-click on the Units or Units (Changed) column of an entry to switch to the unit overview. Depending on the view you switch from, the provider, the queue, the subscriber type and the subscriber from the selected row in the unit overview are added to the preselection. The unit overview then only displays units for this preselection.

Additional Functions

Additional Monitor Functions

The following additional functions are available in the monitor:

(Refresh Monitor)
This function reads the displayed data from the database again.
(Technical Name On/Off)
This function enables you to choose between the technical names and the queue descriptions in the system language.
Goto Reorganize Delta Queues
Use this function to set retention periods for the data in the delta queues and schedule a background job to delete data from the delta queues (after the retention periods have expired).

List Functions

The following list functions are available in the monitor:

(Sort Descending) or (Sort Ascending)
Use this function (in the queue overview) to find out, for example, which queues contain a lot of data. Once you have calculated the data volume, sort the data records in descending order by the compressed size in bytes.
(Change Layout)
Use this function to show or hide columns in a view. You can save these settings, including the sort sequence and filters, as a user-specific layout for a view.

Application Log

In the application log (transaction SLG1), you can find logs for extraction requests and aministration tasks, such as terminating subscriptions or the reorganization run. To do this, enter ODQ and the Object and Extraction or Administration as the Subobject.