1. REST API for GoldenGate Veridata
  2. Tasks
  3. Monitor

Retrieve Repair Statistics

get

http://{host}:{port}/veridata/v1/services/monitoring/repair/jobs

Required Role: Administrator, SuperUser, DetailMonitoringOperator, MonitoringOperator, CommandLineOperator

This API is used to monitor Repair Jobs. Pass the runId as input to fetch Group and Compare Pair details.

Request

Query Parameters
  • Defines the start date range (inclusive) to filter out the Repair Job response. Supported format yyyy-MM-dd'T'HH:mm:ss'Z'. Example: 2024-03-13T18:30:00Z
  • Fetch Repair job stats of last x units. Supported units D(Days) or H(hours) or M(minutes). Example: 1D
  • The Repair Job's Run ID. Example: runId=1024,0,0. Group and Compare Pair details will be returned in response only when this parameter is passed.
  • Defines Repair Job Status. To fetch Jobs of different status, pass comma separated values.
  • Defines the end date range (not inclusive) to filter out the Repair Job response. Supported format yyyy-MM-dd'T'HH:mm:ss'Z'. Example: 2024-03-13T18:30:00Z

There's no request body for this operation.

Back to Top

Response

Supported Media Types

200 Response

Returns a collection of Repair Jobs.
Body ()
Root Schema : schema
Type: array
Show Source
Example:
[ { "runId":{ "asString":"19970/0/0", "comparePairNum":0, "groupNum":0, "runID":19970 }, "startTime":"2024-02-03T10:15:30Z", "endTime":"2024-02-03T10:15:30Z", "name":"repairTestJob", "comparePairsProcessed":5, "comparePairsRepaired":5, "comparePairsWithWarnings":0, "comparePairsCancelled":0, "repairStatus":"OOS", "groups":[ { "runId":"19970/1/0", "startTime":"2024-02-03T10:15:30Z", "endTime":"2024-02-03T10:15:30Z", "grpId":1019, "name":"baseGroups", "numOfComparePairs":1, "comparePairs":[ { "runId":{ "asString":"19970/1/1", "comparePairNum":1, "groupNum":1, "runID":19970 }, "startTime":"2024-02-03T10:15:30Z", "endTime":"2024-02-03T10:15:30Z", "id":1022, "name":"SRC3=TRG3", "status":"OOS", "errorMessage":"", "rowsRepaired":5, "inserts":2, "updates":2, "deletes":1, "insertsWithWarnings":0, "deletesWithWarnings":0, "updatesWithWarnings":0, "rowComparisonsTotal":9, "totalBytesWithWarnings":0, "totalBytesRepaired":40, "comparePair":{ "columnsSystemMapped":true, "deltaProcessingEnabled":false, "enabled":"trye", "keyColumnsSystemMapped":true, "srcTable":{ "name":"SRC3", "schema":"SYSTEM", "catalog":"ORACLPDB1", "isView":false, "tablePartition":{ "name":"SRC_PART_3" } }, "tgtTable":{ "name":"TRG3", "schema":"SYSTEM", "catalog":"ORACLPDB1", "isView":false, "tablePartition":{ "name":"TRG_PART_3" } } } } ] } ] } ]
Nested Schema : RepairJobStats
Match All
Show Source
Nested Schema : BaseStats
Type: object
Show Source
Nested Schema : RepairJobStats-allOf[1]
Type: object
Show Source
Nested Schema : RunID
Type: object
Run ID.
Show Source
Nested Schema : groups
Type: array
Show Source
Nested Schema : RepairGroupStats
Match All
Show Source
Nested Schema : RepairGroupStats-allOf[1]
Type: object
Show Source
Nested Schema : comparePairs
Type: array
Show Source
Nested Schema : RepairPairStats
Match All
Show Source
Nested Schema : RepairPairStats-allOf[1]
Type: object
Show Source
Nested Schema : comparePair
Match All
Show Source
Nested Schema : comparePair-allOf[0]
Type: object
Nested Schema : ComparePairViewStats
Type: object
Show Source
Nested Schema : srcTable
Represents a table in compare pair with table and row partitions info, if any.
Match All
Represents a table in compare pair with table and row partitions info, if any.
Represents a table in compare pair with table and row partitions info, if any.
Show Source
Nested Schema : tgtTable
Represents a table in compare pair with table and row partitions info, if any.
Match All
Represents a table in compare pair with table and row partitions info, if any.
Represents a table in compare pair with table and row partitions info, if any.
Show Source
Nested Schema : Table
Type: object
Defines a table.
Show Source
Nested Schema : srcTable-allOf[1]
Type: object
Nested Schema : tablePartition
Type: object
Match All
Show Source
Nested Schema : TablePartition
Type: object
Show Source
Nested Schema : tgtTable-allOf[1]
Type: object

400 Response

Bad Request.
Body ()
Root Schema : Error
Type: object
Show Source
Example:
{ "errCode":"OGGV-00001", "errMsg":"Error message" }

401 Response

"Unauthorized."
Body ()
Root Schema : Error
Type: object
Show Source
Example:
{ "errCode":"OGGV-00001", "errMsg":"Error message" }

404 Response

"Not found."
Body ()
Root Schema : Error
Type: object
Show Source
Example:
{ "errCode":"OGGV-00001", "errMsg":"Error message" }

500 Response

"Server error."
Body ()
Root Schema : Error
Type: object
Show Source
Example:
{ "errCode":"OGGV-00001", "errMsg":"Error message" }
Back to Top