Monitor Replication Pipelines
Replication pipelines used in a replication project can copy, synchronize, and replicate your data from source to a target stream. This screen allows the user to monitor details of a selected replication pipeline and perform certain actions based on the component. When you click the selected replication pipeline, additional details such as health of the pipeline, the current phase of the pipeline, required actions, and the statuses of the processes are displayed. For example, if the overall health status is Stopped ( ) that indicates all processes and replication pipelines for the project are stopped. This includes kernel processes on all runtime engines and replication processes for all replication pipelines. Capture can still be enabled. Staged but not active projects will appear stopped. You can also perform actions on the components. For example, by clicking (
) next to replication pipeline, you can select an item from the context menu.
View Replication Pipeline Details
-
To open a replication pipeline, click
from the top of the navigation to view all details about the replication pipeline.
- Click Refresh to see the latest statistics, details, and statuses.
- Click Close.
Start Replication Pipeline
- If the pipeline is started for the first time:
- any log readers are started
- tables are enabled for capture
- for replication, data is replicated to the target
- for sync, the initial copy/load is done and then captured data is replicated to the target
- If this a copy, no log readers are started, tables do not get enabled for capture (because this is just for copy) the data is copied to the target. Once the copy is completed the copy pipeline stops.
- If the pipeline is started after being stopped and at least one table is enabled for capture
- replication pipeline starts replicating data to the target
- sync continues with replication or to recopy the data. Default to continue replication and NOT copy.
To start replication pipeline
-
To open a replication project, click
from the top of the navigation menu and select Start . The Start Replication Pipeline page opens.
-
For synchronize data flows, to copy the full set of data to the target
again, select Copy data before starting replication in synchronize data
flows.
Note: This is required the first time you start a synchronize replication pipeline.
-
Do one of the following:
- Click Start to start the replication pipeline. One of the
following occurs:
- If there are no errors, the window closes. Statuses for source server, replication, and the overall replication pipeline status show as Started. When the replication pipeline are restarted, the values are refreshed with the latest statistics.
- If there are problems starting the replication pipeline(s), an error message displays alerting you to the problems.
- Click Cancel to close the window without starting the replication pipeline.
- Click Start to start the replication pipeline. One of the
following occurs:
Stop Replication Pipeline
-
To open a replication project, click
from the top of the navigation menu and select Stop.
-
The Stop Replication Pipeline page opens showing the name and type of each
selected replication pipeline. If any selected replication pipeline are
already stopped, their names display but are ignored during the stop
process
Note: If the replication project is currently deploying or is set to Ignored, the Stop button is unavailable
-
Do one of the following:
- Click Stop to stop the replication pipeline.
- Click Cancel to close the window without stopping the replication pipeline.
Clear Backlog
-
To open a replication project, click
from the top of the navigation menu and select Clear Backlog.
The Clear Backlog dialog opens. -
Select the Confirm clearing the backlog option to clear the backlog rows.
Note: This option is displayed if the number of backlogs rows is more than 100,000.
-
Do one of the following:
- Click Clear Backlog to close the dialog. When the backlog finishes clearing, the value in the Backlog Rows column displays 0 (zero). If a problem is encountered and the backlog cannot be cleared, an error message displays.
- Click Cancel to close the dialog without clearing the backlog.
Metabases
Create a Metabase for Oracle for JDBC data connection
-
To open a replication project, click
from the top of the action menu and select Metabase.
The Metabase page opens. -
If a metabase is not present, click
to add a new metabase.
The New Metabase page opens. -
Enter the required information:
Option Description Data connection Oracle JDBC data connections. Note: If there is only one Oracle JDBC data connection it is selected by default.Database server The address of the database server the metabase will be created on. This value is populated when the data connection is selected.
Oracle administration user ID Oracle system admin user ID for source server. The value is SYS.
Password Password for the oracle admin credentials, used to create the metabase. Password is not stored.
Replication user ID A user will be created. For Oracle, this user must be unique to the metabase or project.Note: The user cannot be reused across projects.Password Password for the user ID.
Metabase name Name of the metabase. The value is the same as the Replication user ID.
Tablespace for metabase Specify the name of the tablespace to create for the metabase.
Data file Specifies the file on the database server that is used to store the tablespace for the metabase
Size Specifies the size of the file that contains the new tablespace you are creating, in Megabytes. The default value is 200.
Temporary tablespace for metabase Specify the name of the tablespace in which to create the temporary metabase space.
Temporary data file Specifies the file that is to store the temporary tablespace for the metabase.
Size Specifies the size of the file that contains the new temporary tablespace you are creating, in Megabytes. The default value is 200.
- Click Create.
Create a Metabase for Db2 for IBM i source data connection
-
To open a replication project, click
from the top of the action menu and select Metabase.
The Metabase page opens. -
If a metabase is not present, click
to add a new metabase.
The New Metabase page opens. -
Enter the required information:
Option Description Data connection Db2 for IBM i JDBC data connections.
Note: If there is only one Db2 for IBM I, JDBC data connection it is selected by default.Database server The address of the database server the metabase will be created on. This value is populated when the data connection is selected.
Replication user ID A user chosen during the Change Selector (Log Reader) software installation on IBM i. For example, OMNIENT.
Password Password for the user ID.
Metabase library Installing the metabase will create the metabase library with this name. The metabase library must be unique for this project/source combination and must not used by any other replication project.
- Click Create.
Create a Metabase for Db2 for Linux, Unix, or Windows type data connection
-
To open a replication project, click
from the top of the action menu and select Metabase.
The Metabase page opens. -
If a metabase is not present, click
to add a new metabase.
The New Metabase page opens. -
Enter the required information:
Option Description Data connection Db2 for Linux, Unix, Windows JDBC data connections.
Note: If there is only one Db2 for Linux, Unix, Windows, JDBC data connection it is selected by default.Database server The address of the database server the metabase will be created on. This value is populated when the data connection is selected.
Db2 administrator user ID: Specifies the Db2 admin user ID. Password Password for the Linux, Unix, Windows server admin credentials, used to create the metabase. Password is not stored.
Replication user ID A user ID to associate with the metabase.
Password Password for the user ID.
Metabase name Name of the metabase. The default value: RPUSER.
- Click Create.