Striim 3.9.6 documentation

Using the MON command

The monitor command's syntax is:

mon[itor]
  [ <node>
  | <namespace>.<application name> [ <node> ]
  | <namespace>.<component name> [ <node> ]
  | <namespace>.<target name> ]
[-follow [ seconds ] ]
[-start '<time>']
[-end '<time>']

Node names begin with S or A to indicate server or Forwarding Agent, followed by the node's IP address with hyphens instead of periods. For example, a server with the IP address 192.168.1.12 would be named S192-168-1-12. Use the command LIST SERVERS; to return a list of nodes in the current cluster.

If you include the -follow option, the display will be refreshed every five seconds. You may specify a different refresh period in seconds, such as -follow 30.

Use the -start and/or -end options when specifying a node, application, or component to return the most recent data within the specified range. Time may be specified as HH:mm (current day), yyyy/MM/dd-HH:mmyyyy/MM/dd-HH:mm:ss, or yyyy/MM/dd-HH:mm:ss:SSS.

The <target name> option is supported only for AzureBlobWriter and DatabaseWriter.

mon;

Returns a summary of the applications and nodes in the cluster. For example:

Screen_Shot_2016-07-13_at_12.24.30_PM.png
mon <node>;

Returns details for every component in every namespace in the specified node. For example:

Screen_Shot_2016-07-13_at_12.26.35_PM.png
mon <namespace>.<application name>;

Returns details for every component in the specified application. For example:

Screen_Shot_2016-07-13_at_12.27.50_PM.png
mon <namespace>.<application name> <node>;

Returns a summary, including the application start time, for the specified application on the specified node.

mon <namespace>.<component name> [ <node> ]

Returns details for only the specified component. For example:

Screen_Shot_2016-07-13_at_12.28.44_PM.png

For a DatabaseWriter source with an input stream that is the output stream of a DatabaseReader or CDC reader source, output will include Commit Lag, which is the number of milliseconds between the timestamp of the last known operation of the database source and the current Striim system time. Note that if the database and Striim systems are in different time zones this number will be quite large.

For an OracleReader source, output will include the following:

╒═════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╕
│                                                      admin.oracSource                                                       │
├───────────────────────────────────┬─────────────────────────────────────────────────────────────────────────────────────────┤
│ Property                          │ Value                                                                                   │
├───────────────────────────────────┼─────────────────────────────────────────────────────────────────────────────────────────┤
│ Catalog evolution duration        │ Not Ready                                                                               │
│ Schema Evolution Status           │ NotApplicable                                                                           │
│ CDC Operation                     │ {                                                                                       │
│                                   │   "No of Inserts" : 0,                                                                  │
│                                   │   "No of Updates" : 0,                                                                  │
│                                   │   "No of Deletes" : 0,                                                                  │
│                                   │   "No of DDLs" : 0                                                                      │
│                                   │ }                                                                                       │
│ Number of events seen per monitor │ 0                                                                                       │
│ snapshot interval                 │                                                                                         │
│ Input                             │ 0                                                                                       │
│ Input Rate                        │ 0                                                                                       │
│ Last Checkpoint Position          │                                                                                         │
│ Latest Activity                   │ 2019/04/12-17:28:09                                                                     │
│ Logminer Start Duration           │ 7ms                                                                                     │
│ Oldest Open Transactions          │ [{"2.17.6315":{"# of Ops":2,"StartSCN":"6707358","TimeStamp":"2019-04-12T17:29:05.000-0 │
│                                   │ 7:00"}},{"3.13.6250":{"# of Ops":2,"StartSCN":"6707359","TimeStamp":"2019-04-12T17:29:0 │
│                                   │ 8.000-07:00"}},{"8.27.6144":{"# of Ops":2,"StartSCN":"6707359","TimeStamp":"2019-04-12T │
│                                   │ 17:29:08.000-07:00"}}]                                                                  │
│ Total No of Transactions in the   │ 3                                                                                       │
│ Cache                             │                                                                                         │
│ Nodes                             │ 1                                                                                       │
│ Oracle Reader Last SCN            │ 6707402                                                                                 │
│ Oracle Reader Last Timestamp      │ 2019/04/13-06:00:13                                                                     │
│ Rate                              │ 0                                                                                       │
│ Read Lag                          │ 0                                                                                       │
│ Recovery Status                   │ Not Applicable                                                                          │
│ Source Input                      │ 0                                                                                       │
│ Source Rate                       │ 0                                                                                       │
│ StartSCN                          │ 6707326                                                                                 │
│ Timestamp                         │ 2019/04/12-17:30:14                                                                     │
│ Top Open Transactions (# of Ops)  │ [{"2.17.6315":{"# of Ops":2,"StartSCN":"6707358","TimeStamp":"2019-04-12T17:29:05.000-0 │
│                                   │ 7:00"}},{"3.13.6250":{"# of Ops":2,"StartSCN":"6707359","TimeStamp":"2019-04-12T17:29:0 │
│                                   │ 8.000-07:00"}},{"8.27.6144":{"# of Ops":2,"StartSCN":"6707359","TimeStamp":"2019-04-12T │
│                                   │ 17:29:08.000-07:00"}}]                                                                  │
│ Total No of operations in the     │ 6                                                                                       │
│ Cache                             │                                                                                         │
└───────────────────────────────────┴─────────────────────────────────────────────────────────────────────────────────────────┘

Known issue DEV-12638: The "Oracle Reader Last Timestamp" always uses the time zone of the Striim server, even when the Oracle server is in a different time zone.

mon <namespace>.<application or component name> [ <node> ] -format "summaryreport"

Returns a summary for the specified application or component.

mon <namespace>.<component name> [-start "HH:MM"] [-end "HH:MM"] -format "timeseriesreport";

Returns a comma-delimited, highly verbose report for the specified component, which you may parse using your own tools. The first line is a header row.