Using the event viewer for incremental updates

The event viewer shows system messages that are related to incremental update processes. It is equipped with various filtering options to facilitate the search for particular messages.

• To open the event viewer:
  1. Connect to the Db2 subsystem that is associated with the replication-enabled accelerator.
     This must be an accelerator that is included in the incremental update process. That is, incremental updates must be configured for the Db2® subsystem to which the accelerator is attached.

     IBM Db2 Analytics Accelerator Studio	Double-click the database-connection-profile icon for that subsystem.
     IBM Data Server Manager	From the drop-down list on the top banner, select the corresponding database connection.

  2. Open the list of accelerators:

     IBM Db2 Analytics Accelerator Studio	In the Administration Explorer, go to the Accelerators folder.
     IBM Data Server Manager	Click in the upper left. Select ADMINISTER > Accelerators.

  3. Select the replication-enabled accelerator:

     IBM Db2 Analytics Accelerator Studio	In the Object List Editor, double-click the accelerator name.
     IBM Data Server Manager	Select the accelerator (row) in the list.

  4. Open the event viewer:

     IBM Db2 Analytics Accelerator Studio	Click the Show events link in the header of the Accelerator view.
     IBM Data Server Manager	Next to the Replication Latency value in the Accelerator view, click Show Events.

     Note: The current replication status of the accelerator (Started, Stopped, or Error) is irrelevant.
• Selecting a message in the Replication Events window has the following effect:

  IBM Db2 Analytics Accelerator Studio	The main column values are displayed in the Event Details section on the lower left, and the full message text is displayed in the Message window on the lower right.
  IBM Data Server Manager	The full message text is displayed at the bottom of the window.

• Using the View drop-down list on the upper right, you can hide all messages of an event type that is different from the selected type. To apply this type of filter, click the Run button after selecting an event type from the drop-down list.
  For example, if you select Error and Run, only error messages and messages with a severity higher than error are displayed.
  The underlying mechanism is the same as for the classification of trace information. The lower the severity of the selected information type, the more verbose is the information that is displayed. While the Error type provides information about errors and even severer events only, the Warning type provides information about warnings, errors, and severer events. That is, each information type with a lower severity includes the information of the types with a higher severity.
• Using the Show drop-down list, you can select a time frame for the messages to be displayed. To apply this type of filter, click the Run button after selecting a time frame from the drop-down list.
  For example, if you select Last 24 hours and Run, the event viewer shows all events that happened during the last 24 hours.
  In IBM Db2 Analytics Accelerator Studio, you can even define a custom time frame:
  1. Select Custom interval from the Show drop-down list to open the Define Custom Interval window.
     • To use a predefined time frame (same as using the Show drop-down list in the Replication Events window), leave the Show events within radio button as is, and select a suitable time frame from the adjacent drop-down list.
     • To define a custom time frame, select Show events and:
       1. In the line starting with From, select the start of your time frame by using the date picker and the time spin buttons on the right.
       2. In the line starting with To, select the end of your time frame by using the date picker and the time spin buttons on the right.
  2. Click OK to return to the Replication Events window.
• IBM Db2 Analytics Accelerator Studio only: Typing a search term in the search field on the top of the table reduces the messages being displayed to those messages that contain the search term.
  For example, if you know the error code belonging to a particular message, you can type in this error code to show just the messages for one particular type of error.
• To close the Replication Events viewer:

  IBM Db2 Analytics Accelerator Studio	Click the cross-shaped icon on the window tab.
  IBM Data Server Manager	Click Close.