Connect CDC console - Connect_CDC - connect_cdc_mimix_share

Connect CDC Console is a command line version of the monitoring and control tool, providing those features when you do not have access to a machine with GUI capability or do not want to use a GUI. For example, use Connect CDC Console for scripting.

Commands are not case sensitive. Options in the commands are also not case sensitive. However, specific parameters, for example, host name, server name, request name or model name, are case sensitive.

Depending on the machine type, run startconsole.bat or startc.sh from the command line from the same directory that contains the Connect CDC executable jar file (omni.jar).

Since Connect CDC Console is specific to a model, the first step is to load the model. You are prompted:

To load a model, type

"LOAD XXX"

where XXX is the model name.

If the model name contains spaces or any special characters, you must embed it in quotes. For example, if the name is DE model, enter:

load "DE model"

If no user and password are associated with the model, it loads. If a user and password are associated, you must enter them, similar to the process for logging in to Connect CDC MonCon. You are then ready to issue commands.

Note: The command HELP lists all available commands and their descriptions. If further description of a functionality is needed, see its explanation in the Connect CDC MonCon section.

Control Command	Description
ContinueRequest requestname	This command is available only for Synchronization requests. It skips the copy phase of the specified request and continues to replicate. If the request is started for the first time, then it ignores the continue command and proceeds to copy first and then replicate.
CROPLOG servername processname	Deletes the entries more than 24 hours old in a log of a process.
DisableCapture requestname	Stops change capture on all source tables participating in the given request.
DisableTableCapture requestname serverLabel fullyQualifiedTableName	Stops change capture specified tables on the given server for specified request for this server.
EnableCapture requestname	Starts change capture all source tables on this host participating in the given request.
EnableTableCapture requestName serverLabel fully QualifiedTableNames	Starts change capture on specified tables on the given server for specified request for this host.
QueueDel request [server]	Deletes queues for the request. request–requestname server–servername
RefreshModel/ModelUpdate	Updates the model on all hosts.
SelectiveStart requestname -s servername -t tablename	This command is available only for Copy and Synchronization requests. It selectively copies/synchronizes specified tables in a given request. requestname–Name of the request -s serverlabel–Server label -t tablename–table name Note: Table names require the system separator (/) for IBMi. For example, `selectivestart Copy1 -s LTIAS03 -t QAUSER1/T1` Remember: Table names that use "." separator will not be found in the Console.
Shutdown K [hosts]	Defaults to shut down kernel on all hosts. Optionally, specify the host name to shut down the kernel on selected hosts.
Start [hosts]	Defaults to start the kernel on all the hosts. Options: hosts - Start the kernel on the specified hosts. Note: This is a space-separated list.
StartChangeSelector [-ws=1\|0 [-recv **** -seq xxxx]] [-h hostname [-s servername [-p processname]]]	Starts one or more change selectors. For all options, use -ws=0 to do cold start; use -ws=1 to do warm start. -ws=1\|0 - Starts a Change Selector on all hosts. [-ws=1\|0] hostname - Starts a Change Selector on the specified host. The value of warm start can be 0 or 1. [-ws=1\|0] hostname servername - Starts Change Selector on the specified host and server. The value of warm start can be 0 or 1. These parameters are applicable for the IBM i only. specify receiver, sequence number, servername and processname. `-recv **** -seq xxxx` -recv is the receiver library name. The predefined values for this parameter are CURRENT or CURCHAIN. If the value for this parameter is not defined, then it is CURRENT by default. - seq is the sequence no. The predefined values for this parameter are FIRST or LAST. If the value for this parameter is not defined, then it is LAST by default.
StartRequest requestname	Starts the given request on all the source hosts. Use “*” to start all the requests in the current model.
StopChangeSelector [hostname [servername]]	Defaults to stop the Change Selector on all the hosts. Options: hostname - Stops the Change Selector on the specified host. hostname servername - Stops the Change Selector on the specified host and server.
StopRequest requestname	Stops all requests on all source hosts. To stop all requests in the current model, use “*”.

Monitoring Command	Description
ModelVersion	Lists the version of the current model at all hosts.
RefreshStatus	Refreshes the status of all the requests in the current model.
StartAlertCollect hostname	Starts email collection at the specified host.
STATISTICS requestname	Retrieves statistics for a specific request.
STATUS requestname	Queries status of a specific request.
StatusChangeSelector [hostname [servername]]	Defaults to query the status of the Change Selector on all hosts. hostname–Queries status of the Change Selector on the specified host. hostname servername–Queries status of the Change Selector on the specified host and server.
StopAlertCollect [hostname]	Stops email collection at the specified host or the host specified in the most recent StartAlertCollect command if run without a hostname parameter.

Miscellaneous Command	Description
CREATEBROKER hostname portnumber [brokername] [-ssle]	Creates a broker to load models from remote machines. host name–name of host to contact to load a model port number–port number of the remote Connect CDC Listener broker name–optional parameter to specify a name for the broker -ssle–optional parameter to specify encryption and authentication Note: The broker.directory file is created in the kernel directory on the system from where the console is run. This file contains information for brokers created on that system.
Help	Syntax of all commands supported by Connect CDC Console.
List -brokers -h -h requestname -m requestname -r -s -s hostname -t servername -cs	Defaults to list all the requests for a model. Brokers Defaults to list all the hosts for a model All hosts for the specified request All target table mappings for the specified request All requests in a model Defaults to list all servers for a model All servers for the specified host All tables for the specified server All the Change Selectors.
Load [modelname] [brokername]	Loads the specified model. The “LOCAL” broker is the host from which the console is running. The console picks up the model from its location specified in the omnireplicator.directory. brokername–name of a specific broker to be used to load a model
LOG servername processname	Displays the log of a process (Change Selector).
Login “loginID” “password”	Logs in with the specified userid and password.
Logout	Logs out current user.
Quit/Exit	While Connect CDC Console is running, exits Connect CDC Console.
SetLogLevel [SQLDEBUG\|NOSQLDEBUG] [DEBUG\|INFO\|WARN] [host] [host]...	Sets the level of verbosity for logging. If a host is unspecified or “*”, level will be set for all hosts in the model. A setting of DEBUG includes all levels below it. See Debugging .
Unload	Unloads the model.

Miscellaneous Command	Description
QueueStat requestname [servername]	Displays the queue statistics for the request name. If the server name is specified, then the combination of the server label and request name will be used to get the queue statistics.
QueueDel requestname [servername]	Deletes the queues for the request name. If the server label is specified, then the combination of server label and request name will be used to delete data from the queues.
commandname	Displays the syntax of the specified command name. If the argument has a space or any special characters then it must be embedded in quotes. For example, `STARTREQUEST "Copy Employee_SRC"` The request name has a space. `STARTREQUEST "Replicate \"AS400\" to \"OS390\""` The request name has quotes embedded in it. `STARTREQUEST REPREQUEST` This request does not have any special characters.

Miscellaneous Command

Description

QueueStat requestname [servername]

Displays the queue statistics for the request name. If the server name is specified, then the combination of the server label and request name will be used to get the queue statistics.

QueueDel requestname [servername]

Deletes the queues for the request name. If the server label is specified, then the combination of server label and request name will be used to delete data from the queues.

commandname

Displays the syntax of the specified command name.

If the argument has a space or any special characters then it must be embedded in quotes. For example,

STARTREQUEST "Copy Employee_SRC"

The request name has a space.

STARTREQUEST "Replicate \"AS400\" to \"OS390\""

The request name has quotes embedded in it.

STARTREQUEST REPREQUEST

This request does not have any special characters.

Connect CDC console - Connect_CDC - connect_cdc_mimix_share - Latest

Connect CDC Advanced User Guide