Managing Polling Notifications

About this task

You must schedule a notification and then enable it before you can use the notification. Use Integration Server Administrator along with the following procedures to do so.

Note: You must have Integration Server Administrator privileges to access Adapter for JDBC's administrative screens. For information about setting user privileges, see the IBM webMethods Integration Server Administrator’s Guide for your release.

To manage polling notifications

Procedure

  1. Start Integration Server Administrator.
  2. From the Adapters menu in the navigation area of Integration Server Administrator, select Adapter for JDBC.
  3. From the navigation area, select Polling Notifications.
  4. From the Adapter for JDBCPolling Notifications table, use the fields in the following table to manage each adapter notification:
    Note: For AS/400 DB2 V4R5 using a jt400.jar file, the table name for the notification cannot exceed 10 characters. If the table name exceeds 10 characters, an exception will be generated when you try to enable the notification.
    Note: If you use an XA-Transaction connection, you cannot enable a notification.
    Field Description/Action
    Notification Name The name of the notification.
    Package Name The name of the package for the notification.

    State

    		After you schedule a polling notification, you can use this option's dropdown list to set the polling notification's state:
    Note: You must schedule a polling notification before you can enable it. To schedule a polling notification, use the icon described in these procedures.
    • Enabled: The polling notification performs as scheduled.
    • Suspended: The polling notification is removed from the scheduler but the database trigger and buffer table are not dropped.
    • Disabled: The polling notification is removed from the scheduler and the database trigger and buffer table are dropped.
    The Suspend all enabled and Enable all suspended links help you change states quickly for multiple polling notifications. Enabling, suspending, and disabling a notification affects how its trigger and buffer tables are created and dropped. For details, see Polling Notifications and States. If there is no polling notification scheduled for a given adapter notification, control for this field is disabled. Use the icon to schedule a polling notification.
    Edit Schedule Click the icon to create or modify polling notification parameters.
    Note: You must disable a polling notification before you can edit it.
    View Schedule Click on the View Schedule icon to review the parameters for the selected polling notification. Click Return toAdapter for JDBCNotifications to go back to the main polling notification page.
    Run As User Click to assign a user to a polling notification. By default, Run As User is set to Administrator. You can now configure the Run as User in the Integration Server Administrator to assign a user to a polling notification.
  5. To create or modify schedule parameters for the selected adapter notification, click on the icon and use the following fields:
    Field Description/Action
    Interval (seconds) Type the polling interval time in seconds.
    Overlap
    Note: Do not use this option; otherwise, when you enable this notification, it may lock up tables and cause Integration Server to fail.
    Immediate Enable this option to start polling immediately.
  6. Click Save Schedule.
  7. After you create a polling notification, you can enable it. Use the State field to enable a polling notification.