Step 1: Create control tables for the Monitor program

The first step in setting up monitoring for the Capture and Apply programs is to create control tables for the Replication Alert Monitor program.

1. Expand the Monitoring and Alerts folder.
2. Right-click the Monitor Control Servers folder and select Create Monitor Control Tables.
3. In the Select a Server window, select the COPYDB database. This database will be your Monitor control server.
4. In the Create Monitor Control Tables window, select the IBMSNAP_CONTACTS control table and fill in the information for the RELPMONTS1 table space properties. Click the browse button next to the container name to customize the location for this table space. You can also specify other information for the table space. For example, set the buffer pool to IBMDEFAULTBP. By default, all of the Monitor control tables except IBMSNAP_ALERTS and IBMSNAP_MONTRACE share the same table space as the IBMSNAP_CONTACTS table. The Create Monitor Control Tables window should look similar to the window shown in Figure 1.
   Figure 1. The Create Monitor Control Tables window

   
5. In the Create Monitor Control Tables window, select the IBMSNAP_ALERTS control table and fill in the information for the RELPMONTS2 table space properties.
6. In the Create Monitor Control Tables window, select the IBMSNAP_MONTRACE control table and fill in the information for the RELPMONTS3 table space properties.
7. Click OK on the Create Monitor Control Tables window to accept the default values for the other control table information, including index names.
8. Click Close on the Messages and SQL Scripts window. This window shows the results of generating the SQL script to create the Monitor control tables. If there are any errors, they are displayed in this window.
9. Click OK on the Run Now or Save SQL window to process the SQL script immediately.
10. You should see a message in the DB2® Message window stating that the script ran successfully. Click Close.
11. Expand the Monitor Control Servers folder. The COPYDB database should be displayed under the folder.