Connect CDC console - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

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.