Displaying Subscriptions

This panel displays the configured and clients subscriptions for the Staging Agent for the selected database and is automatically updated every 15 seconds.

To view internal subscriptions created automatically when communicating with a DB2 for Linux, UNIX and Windows source system, select Include Internal Subscriptions.

To sort the display in ascending or descending order based on a particular field, click on the field name until the arrow adjacent to the field name is displayed in the desired direction.

For each subscription, the following values are displayed:

The information in the Transactions and Oldest Transaction columns can help you determine whether the client is retrieving change data from the Capture Agent.  If you review the status after a period of time and the value for the Oldest Transaction is different, the SQDR client is retrieving changes from the Capture Agent. If the value for Oldest Transaction does not change, check that the SQDR service on the client computer is running and that the incremental group has not been paused. If the Capture Agent has changes pending for subscriptions that have been orphaned, you may need to delete the resources as described in “Deleting Orphaned Subscriptions”.

Rows Waiting indicates the number of rows that are available for the SQDR client to fetch.

Rows Pending is a count of the rows for a transaction in progress, and not yet available for the SQDR client. This field indicates in-flight activity when the agent is processing a large number of rows for a transaction.

 

Metadata

Selecting the checkbox next to one or more subscriptions and selecting View Metadata from the Resource menu will display column information for the source table and which ones the agent uses as "key columns".  It will also display journal information for subscriptions from DB2 for i sources.

Filtering

If you have a large number of subscriptions, you can filter the display by selecting a group from the Groups drop-down menu, or entering a schema or table name, at the top of the display. When entering a schema or table name, standard SQL wildcard operators apply - for instance, % character means match anything, and _ is a substitute for exactly one character. There is an implicit % at the end, and the display is updated immediately.  For example, if you have tables ATAB, TAB1, TAB2, and TAB100, entering T in the Table field will immediately filter out ATAB and display only TAB1, TAB2, and TAB100.  Entering TAB1 will display TAB1 and TAB100 (because of the implicit %).  To eliminate the implicit % and terminate the string, enter a period. For example, entering TAB1. will display only TAB1 and not TAB100.

Deleting Orphaned Subscriptions

The Capture Agent automatically prunes the change data control tables and journal receivers that are no longer needed. However, incremental replication subscriptions can become “orphaned” if the subscriptions are not cleaned up correctly from the SQDR Replicator Manager on the Windows client computer. This can occur if the SQDR Replicator Manager is re-configured to use a different local control database, ceases to run the defined incremental replication subscriptions, or the client software is uninstalled prior to deleting the defined subscriptions.

To delete a subscription, select the checkbox next to the subscription, or select all subscriptions with the checkbox on the heading bar, and then select Delete Subscription from the Resource menu or select the X button at the top of the window.

You can also delete all subscriptions in a group and the group itself by selecting the group in the Filter options and selecting Delete Group from the Resource menu.