dmshowevents - Display CDC Replication events

Use this command to display CDC Replication events to standard output. You can use this command as an alternative to showing CDC Replication events in the Event Log view in Management Console.

The output of this command shows events in chronological order with the most recent event shown first in the list.

Syntax

dmshowevents [-I <name>] -a|-s <subscription ...>|-t <source ID> ...|-s 
<subscription ...> -t <source ID> ... [-h] [-c <max_msg>] [-L <locale>]

dmshowevents -I <name> -a|-s <subscription ...>|-t <source ID> ... [-h] 
[-c <max_msg>] [-L <locale>]

Parameters

[-I <name>]

Specifies the name of the CDC Replication instance. Alternatively, you can specify the TSINSTANCE environment variable in place of this value.

-a

Specifies that CDC Replication shows events for all subscriptions.

-s <subscription ...>

Specifies the name of the subscription for which CDC Replication displays source events.

To specify multiple subscriptions, list the subscriptions separated by a space.

-t <source ID> ...

Specifies the source ID of the subscription for which CDC Replication displays target events. List the source IDs if you specify more than one.

Source IDs are automatically generated based on truncating the subscription name to 8 characters during subscription creation. Source IDs must be unique.

[-h]

Specifies that CDC Replication displays a header before the list of events.

This option helps you identify each item of information that is displayed for each event.

[-c <max_msg>]

Specifies the maximum number of events that CDC Replication displays.

If you omit this parameter or you specify a value greater than the total number of events, CDC Replication displays all events for the specified subscriptions and source IDs.

Minimum Setting: 0. No events are shown.
Maximum Setting: 2147483647

[-L <locale>]

The name of the locale used for the CDC Replication instance. The default is your machine's locale.

Result

This command returns a value of 0 if the operation was successful. If it fails, this command returns a non-zero value.

Examples

dmshowevents
-I NEWINSTANCE -s FINANCE

Displays all events for the Finance subscription for the specified instance.

dmshowevents -I
MYINSTANCE –a –h

Displays all events for all subscriptions. A header is displayed before the list of events for the specified instance.

dmshowevents -I NEWINSTANCE –s
FINANCE MARKETING –t ATLANTA –h –c 20

Displays the most recent 20 events for the Finance and Marketing subscriptions and for the Atlanta source ID. A header is displayed before the list of events for the specified instance.

Sample output

TIME|AGENTTYPE|SUBSCRIPTION|EVENTID|SEVERITY|EVENTPROGRAM|EVENTTEXT

2006-04-21 17:23:08.817|T|ATLANTA|95|Information|class com.datamirror.ts.target.
publication.c|IBM InfoSphere Change Data Capture Communications ending.

2006-04-21 17:23:08.614|T|ATLANTA|1538|Information|class com.datamirror.ts.target.
publication.c|---IBM InfoSphere Change Data Capture for ATLANTA terminating 
normally.

2006-04-21 17:23:08.333|T|ATLANTA|1537|Information|class com.datamirror.ts.target.
publication.c|Describe conversation with ATLANTA completed successfully.

2006-04-21 17:23:07.911|T|ATLANTA|1536|Information|class com.datamirror.ts.target.
publication.c|Describe conversation started by ATLANTA.

2006-04-21 17:23:07.333|T|ATLANTA|1531|Information|class com.datamirror.ts.target.
publication.c|Communication with ATLANTA successfully started on Data channel.

2006-04-21 17:23:06.973|T|ATLANTA|1534|Information|class com.datamirror.ts.engine.a
|Code page conversation from the source database's code page 1252 to the target 
database's code page Cp1252 for ATLANTA will be performed by the Remote system

Fields in each record are separated by vertical bars ( | ). These fields are identified in the first line of the output. In the AGENTTYPE field, S indicates source and T indicates target.