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