Modify the default parameters as specified in the <CAPTURESERVERSCHEMA>.IBMSNAP_CAPPARMS
table. After deploying the replication artifacts, you can determine the number
of Capture servers that the data movement services component has created by
running the following query against the Runtime database. CONNECT
TO RUNTIME DATABASE
SELECT DISTINCT OM_NAME, SERVICE_NAME, SRC_RM_CAP_SVR_NAME
FROM WBIRMADM.RMMETADATA
ORDER BY 1,2,3
You see a
table like the following:
Table 1. RMMETADATA exampleOM_NAME |
SERVICE_NAME |
SRC_RM_CAP_SVR_NAME |
SubDoctor3 |
Runtime to Historical |
CAPTURE_18 |
SubDoctor3 |
State to Runtime |
CAPTURE_1 |
SubDoctor3 |
State to Runtime |
CAPTURE_115 |
SubDoctor3 |
State to Runtime |
CAPTURE_156 |
SubDoctor3 |
State to Runtime |
CAPTURE_194 |
SubDoctor3 |
State to Runtime |
CAPTURE_212 |
SubDoctor3 |
State to Runtime |
CAPTURE_250 |
SubDoctor3 |
State to Runtime |
CAPTURE_41 |
SubDoctor3 |
State to Runtime |
CAPTURE_59 |
SubDoctor3 |
State to Runtime |
CAPTURE_97 |
The OM_NAME is the name of the
WebSphere® Business
Modeler project.
The SERVICE_NAME indicates the data movement service, and the SRC_RM_CAP_SVR_NAME
is the identifier (CAPTURE SCHEMA) for the Capture server that is being used
as part of the data movement service. In the above table, there is one capture
server for the Runtime to Historical data movement service and nine for the
State to Runtime data movement service.
Note: The number of servers and the
names of the servers vary, based on the model being used and the policy parameters
specified during artifact generation.
The database services component
supports all the options for lag_limit and startmode parameters,
but you should be aware that there are serious performance problems if the
number of cold starts (the start of the Capture servers after failure) increases.
If there are frequent cold starts, the ETL component of the data movement
service processes all existing records instead of simply recording the changes.
Once all of the Capture servers that need to be modified are identified, you
can modify the default parameters in the database. Once the default parameters
are modified for each Capture server, you can start the Capture servers.