Report Process

The command is used to report the details on the tables' data changes (DML, DDL and Initial load operations) for a given process. The command is valid for both Capture and Apply Processes. 

CLI Syntax:

The input parameters are:

• process – Process type. The possible values are capture or apply.
• id – The identifier of the Process
• from lsn and until lsn are the parameters to specify range of the transactions to be included into the report using LSN/SCN, while from time and until time are to specify range using transactions' time.

Note - For the running process the command can be involved without providing time or LSN parameters. This is used to show all the changes handled by a Process since it has been started. 

REST API:

• Endpoint: https://repstance_url/report/process
• Method: POST
• Header:
  • Content-Type: application/json
  • X-Token: token
• Body:
  {
    "command": "report",
      "process":"capture|apply",
      "id":"processID",
      "start_lsn":"FROM_LSN",
      "end_lsn":"UNTIL_LSN",
      "start_time":"Start Time",
      "end_time":"End Time"
  }

Server response:

• HTTP Status – Status of the command, possible codes are:
  • 200 – if no error occurs
  • 422 – if error occurs
• Body:
  {
    "Status":"{Failed|Completed}",
    "Message":"The command execution details",
    "Stats": TableStatistics,
    "FirstLSN": LSN of the first available transaction in the report,
    "LastLSN": LSN of the last available transaction in the report,
    "FirstTime": Timestamp of the first available transaction in the report,
    "LastTime": Timestamp of the last available transaction in the report
  }

Examples

The following example demonstrates how to run the “report” command to view the details of the Capture Process id=4:

The command output:

The following example demonstrates how to run the command to get data for the given time range:

The following example demonstrates how to view changes of the transaction with LSN=0x0000012C0000041C0003: