Installation and Configuration Supplement

Enabling Multisite Updates Using the Control Center

As of Version 6, you can use the Control Center to provide multisite update. The procedure is very simple, and is outlined below. For more information about the multisite update configuration process, including how to configure your system manually, refer to the on-line Connectivity Supplement.

Starting the Multisite Update Smartguide

From the Control Center, click on the [+] sign to expand the tree view. With the right mouse button, select the instance that you wish to configure. A popup menu opens. Select Multisite Update->Configure from this menu.

Smartguide Steps

The Smartguide provides a notebook-type interface. Each page of the notebook will prompt you for certain information about your configuration. The pages are shown below in the order in which you will encounter them.

step  1.
Specify a Transaction Processor (TP) monitor.
This field will show the defaults for the TP Monitor you have enabled. If you do not wish to use a TP monitor, select Do Not Use a TP Monitor.
step  2.
Specify the communications protocols you will use.
step  3.
Specify a Transaction Manager database.
This panel defaults to the first database you connect to (1ST_CONN). You can leave this default or select another catalogued database.
step  4.
Specify the types of database servers involved in the update, and also whether or not TCP/IP is to be used exclusively.
step  5.
Specify the Syncpoint Manager settings.
This page will only appear if the settings on the previous page indicate that you need to use DB2's Syncpoint Manager in a multisite update scenario.

Testing the Multisite Update Feature

step  1.
Select the instance with the right mouse button and choose the Multisite Update->Test menu option from the pop-up menu. The Test Multi-Site Update window opens.
step  2.
Select the databases you wish to test from the available databases in the left sub-window. You can use the arrow buttons in the middle to move selections to and from the Selected Databases sub-window.
step  3.
When you have finished your selection, press the Test... button at the bottom of the window. The Multi-Site Update Test Result window opens.
step  4.
The Multi-Site Update Test Result window shows which of the databases you selected succeeded or failed the update test. The window will show sql codes and error messages for those that failed.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]

step 1.	Specify a Transaction Processor (TP) monitor. This field will show the defaults for the TP Monitor you have enabled. If you do not wish to use a TP monitor, select Do Not Use a TP Monitor.
step 2.	Specify the communications protocols you will use.
step 3.	Specify a Transaction Manager database. This panel defaults to the first database you connect to (1ST_CONN). You can leave this default or select another catalogued database.
step 4.	Specify the types of database servers involved in the update, and also whether or not TCP/IP is to be used exclusively.
step 5.	Specify the Syncpoint Manager settings. This page will only appear if the settings on the previous page indicate that you need to use DB2's Syncpoint Manager in a multisite update scenario.

step 1.	Select the instance with the right mouse button and choose the Multisite Update->Test menu option from the pop-up menu. The Test Multi-Site Update window opens.
step 2.	Select the databases you wish to test from the available databases in the left sub-window. You can use the arrow buttons in the middle to move selections to and from the Selected Databases sub-window.
step 3.	When you have finished your selection, press the Test... button at the bottom of the window. The Multi-Site Update Test Result window opens.
step 4.	The Multi-Site Update Test Result window shows which of the databases you selected succeeded or failed the update test. The window will show sql codes and error messages for those that failed.