Jump to

• Request
• Response

Retrieve an existing In Flight Transaction Information

get

/services/{version}/mpoints/{item}/currentInflightTransactions

Request

Path Parameters

• item: string
  Minimum Length: 1

  Maximum Length: 32
• version: string

  Oracle GoldenGate Service API version.

  Allowed Values: [ "v2" ]

Back to Top

Response

Supported Media Types

• application/json

200 Response

Body ()

Root Schema : Oracle GoldenGate Current In-Flight Transactions

Type: object

Title: Oracle GoldenGate Current In-Flight Transactions

Show Source

• $schema(optional):
  Allowed Values: [ "mpoints:currentInflightTransactions" ]
• currentInflightTransactions(optional): array currentInflightTransactions
  Minimum Number of Items: 0

  Maximum Number of Items: 2147483647

{
    "title":"Oracle GoldenGate Current In-Flight Transactions",
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "mpoints:currentInflightTransactions"
            ]
        },
        "currentInflightTransactions":{
            "type":"array",
            "minItems":0,
            "maxItems":2147483647,
            "items":{
                "type":"object",
                "properties":{
                    "commitScn":{
                        "description":"SCN Number",
                        "x-oneOf":[
                            {
                                "description":"System Change Number(Normal Format) for Oracle Database.",
                                "type":"integer",
                                "minimum":0,
                                "maximum":9.223372036854776E18,
                                "example":"6488359"
                            },
                            {
                                "description":"System Change Number(Alternate Format) for Oracle Database.",
                                "type":"string",
                                "pattern":"[0-9]+[.][0-9]+",
                                "minLength":3,
                                "maxLength":64,
                                "example":"6488359.3456712"
                            }
                        ]
                    },
                    "scn":{
                        "description":"SCN Number",
                        "x-oneOf":[
                            {
                                "description":"System Change Number(Normal Format) for Oracle Database.",
                                "type":"integer",
                                "minimum":0,
                                "maximum":9.223372036854776E18,
                                "example":"6488359"
                            },
                            {
                                "description":"System Change Number(Alternate Format) for Oracle Database.",
                                "type":"string",
                                "pattern":"[0-9]+[.][0-9]+",
                                "minLength":3,
                                "maxLength":64,
                                "example":"6488359.3456712"
                            }
                        ]
                    },
                    "zosLsn":{
                        "description":"DB2 z/OS LSN",
                        "type":"string",
                        "minLength":1,
                        "maxLength":20
                    },
                    "flags":{
                        "description":"Transaction flags",
                        "type":"string",
                        "minLength":1,
                        "maxLength":100
                    },
                    "coUid":{
                        "description":"CO UID",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "xid":{
                        "description":"Transaction ID",
                        "type":"string",
                        "minLength":1,
                        "maxLength":16
                    },
                    "startTime":{
                        "description":"Transaction start time",
                        "type":"string",
                        "pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
                        "minLength":20,
                        "maxLength":32
                    },
                    "extract":{
                        "description":"Extract Name",
                        "type":"string",
                        "minLength":1,
                        "maxLength":16
                    },
                    "status":{
                        "description":"Transaction status",
                        "type":"string",
                        "minLength":1,
                        "maxLength":100
                    },
                    "redoRba":{
                        "description":"Redo RBA",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    },
                    "redoSeq":{
                        "description":"Redo Sequence Number",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    },
                    "logStreamId":{
                        "description":"Log Stream Id for DB2LUW",
                        "type":"integer",
                        "minimum":0,
                        "maximum":1.8446744073709552E19
                    },
                    "size":{
                        "description":"Number of items in transaction",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    },
                    "redoThread":{
                        "description":"Redo Thread ID",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    }
                },
                "additionalProperties":false
            }
        }
    },
    "additionalProperties":false
}

Nested Schema : currentInflightTransactions

Type: array

Minimum Number of Items: 0

Maximum Number of Items: 2147483647

Show Source

• Array of: object items

{
    "type":"array",
    "minItems":0,
    "maxItems":2147483647,
    "items":{
        "type":"object",
        "properties":{
            "commitScn":{
                "description":"SCN Number",
                "x-oneOf":[
                    {
                        "description":"System Change Number(Normal Format) for Oracle Database.",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18,
                        "example":"6488359"
                    },
                    {
                        "description":"System Change Number(Alternate Format) for Oracle Database.",
                        "type":"string",
                        "pattern":"[0-9]+[.][0-9]+",
                        "minLength":3,
                        "maxLength":64,
                        "example":"6488359.3456712"
                    }
                ]
            },
            "scn":{
                "description":"SCN Number",
                "x-oneOf":[
                    {
                        "description":"System Change Number(Normal Format) for Oracle Database.",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18,
                        "example":"6488359"
                    },
                    {
                        "description":"System Change Number(Alternate Format) for Oracle Database.",
                        "type":"string",
                        "pattern":"[0-9]+[.][0-9]+",
                        "minLength":3,
                        "maxLength":64,
                        "example":"6488359.3456712"
                    }
                ]
            },
            "zosLsn":{
                "description":"DB2 z/OS LSN",
                "type":"string",
                "minLength":1,
                "maxLength":20
            },
            "flags":{
                "description":"Transaction flags",
                "type":"string",
                "minLength":1,
                "maxLength":100
            },
            "coUid":{
                "description":"CO UID",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "xid":{
                "description":"Transaction ID",
                "type":"string",
                "minLength":1,
                "maxLength":16
            },
            "startTime":{
                "description":"Transaction start time",
                "type":"string",
                "pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
                "minLength":20,
                "maxLength":32
            },
            "extract":{
                "description":"Extract Name",
                "type":"string",
                "minLength":1,
                "maxLength":16
            },
            "status":{
                "description":"Transaction status",
                "type":"string",
                "minLength":1,
                "maxLength":100
            },
            "redoRba":{
                "description":"Redo RBA",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            },
            "redoSeq":{
                "description":"Redo Sequence Number",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            },
            "logStreamId":{
                "description":"Log Stream Id for DB2LUW",
                "type":"integer",
                "minimum":0,
                "maximum":1.8446744073709552E19
            },
            "size":{
                "description":"Number of items in transaction",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            },
            "redoThread":{
                "description":"Redo Thread ID",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            }
        },
        "additionalProperties":false
    }
}

Nested Schema : items

Type: object

Show Source

• commitScn(optional): commitScn
  SCN Number
• coUid(optional): integer
  Minimum Value: 0

  Maximum Value: 9.223372036854776E18

  CO UID
• extract(optional): string
  Minimum Length: 1

  Maximum Length: 16

  Extract Name
• flags(optional): string
  Minimum Length: 1

  Maximum Length: 100

  Transaction flags
• logStreamId(optional): integer
  Minimum Value: 0

  Maximum Value: 1.8446744073709552E19

  Log Stream Id for DB2LUW
• redoRba(optional): integer
  Minimum Value: 0

  Maximum Value: 4.294967295E9

  Redo RBA
• redoSeq(optional): integer
  Minimum Value: 0

  Maximum Value: 4.294967295E9

  Redo Sequence Number
• redoThread(optional): integer
  Minimum Value: 0

  Maximum Value: 4.294967295E9

  Redo Thread ID
• scn(optional): scn
  SCN Number
• size(optional): integer
  Minimum Value: 0

  Maximum Value: 4.294967295E9

  Number of items in transaction
• startTime(optional): string
  Minimum Length: 20

  Maximum Length: 32

  Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$

  Transaction start time
• status(optional): string
  Minimum Length: 1

  Maximum Length: 100

  Transaction status
• xid(optional): string
  Minimum Length: 1

  Maximum Length: 16

  Transaction ID
• zosLsn(optional): string
  Minimum Length: 1

  Maximum Length: 20

  DB2 z/OS LSN

{
    "type":"object",
    "properties":{
        "commitScn":{
            "description":"SCN Number",
            "x-oneOf":[
                {
                    "description":"System Change Number(Normal Format) for Oracle Database.",
                    "type":"integer",
                    "minimum":0,
                    "maximum":9.223372036854776E18,
                    "example":"6488359"
                },
                {
                    "description":"System Change Number(Alternate Format) for Oracle Database.",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":3,
                    "maxLength":64,
                    "example":"6488359.3456712"
                }
            ]
        },
        "scn":{
            "description":"SCN Number",
            "x-oneOf":[
                {
                    "description":"System Change Number(Normal Format) for Oracle Database.",
                    "type":"integer",
                    "minimum":0,
                    "maximum":9.223372036854776E18,
                    "example":"6488359"
                },
                {
                    "description":"System Change Number(Alternate Format) for Oracle Database.",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":3,
                    "maxLength":64,
                    "example":"6488359.3456712"
                }
            ]
        },
        "zosLsn":{
            "description":"DB2 z/OS LSN",
            "type":"string",
            "minLength":1,
            "maxLength":20
        },
        "flags":{
            "description":"Transaction flags",
            "type":"string",
            "minLength":1,
            "maxLength":100
        },
        "coUid":{
            "description":"CO UID",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "xid":{
            "description":"Transaction ID",
            "type":"string",
            "minLength":1,
            "maxLength":16
        },
        "startTime":{
            "description":"Transaction start time",
            "type":"string",
            "pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
            "minLength":20,
            "maxLength":32
        },
        "extract":{
            "description":"Extract Name",
            "type":"string",
            "minLength":1,
            "maxLength":16
        },
        "status":{
            "description":"Transaction status",
            "type":"string",
            "minLength":1,
            "maxLength":100
        },
        "redoRba":{
            "description":"Redo RBA",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "redoSeq":{
            "description":"Redo Sequence Number",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "logStreamId":{
            "description":"Log Stream Id for DB2LUW",
            "type":"integer",
            "minimum":0,
            "maximum":1.8446744073709552E19
        },
        "size":{
            "description":"Number of items in transaction",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "redoThread":{
            "description":"Redo Thread ID",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        }
    },
    "additionalProperties":false
}

Nested Schema : commitScn

SCN Number

Match One

Show Source

• integer
  Minimum Value: 0

  Maximum Value: 9.223372036854776E18

  System Change Number(Normal Format) for Oracle Database.

  Example: 6488359
• string
  Minimum Length: 3

  Maximum Length: 64

  Pattern: [0-9]+[.][0-9]+

  System Change Number(Alternate Format) for Oracle Database.

  Example: 6488359.3456712

{
    "description":"SCN Number",
    "x-oneOf":[
        {
            "description":"System Change Number(Normal Format) for Oracle Database.",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18,
            "example":"6488359"
        },
        {
            "description":"System Change Number(Alternate Format) for Oracle Database.",
            "type":"string",
            "pattern":"[0-9]+[.][0-9]+",
            "minLength":3,
            "maxLength":64,
            "example":"6488359.3456712"
        }
    ]
}

Nested Schema : scn

SCN Number

Match One

Show Source

• integer
  Minimum Value: 0

  Maximum Value: 9.223372036854776E18

  System Change Number(Normal Format) for Oracle Database.

  Example: 6488359
• string
  Minimum Length: 3

  Maximum Length: 64

  Pattern: [0-9]+[.][0-9]+

  System Change Number(Alternate Format) for Oracle Database.

  Example: 6488359.3456712

{
    "description":"SCN Number",
    "x-oneOf":[
        {
            "description":"System Change Number(Normal Format) for Oracle Database.",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18,
            "example":"6488359"
        },
        {
            "description":"System Change Number(Alternate Format) for Oracle Database.",
            "type":"string",
            "pattern":"[0-9]+[.][0-9]+",
            "minLength":3,
            "maxLength":64,
            "example":"6488359.3456712"
        }
    ]
}

Example Response (application/json)

{
    "$schema":"api:standardResponse",
    "response":{
        "$schema":"mpoints:currentInflightTransactions",
        "currentInflightTransactions":[
            {
                "scn":"0.4080896",
                "xid":"1.6.1358",
                "startTime":"2015-06-11T11:21:31.011Z",
                "extract":"EORADB1",
                "status":"Running",
                "redoRba":11829476,
                "redoSeq":202,
                "size":3,
                "redoThread":1
            },
            {
                "scn":"0.4080898",
                "xid":"2.16.1835",
                "startTime":"2015-06-11T11:21:31.564Z",
                "extract":"EORADB1",
                "status":"Running",
                "redoRba":11830800,
                "redoSeq":202,
                "size":7,
                "redoThread":1
            }
        ]
    },
    "messages":[
    ],
    "links":[
    ]
}

Back to Top