1. Oracle GoldenGate Microservices REST API
  2. Tasks
  3. Performance Metrics Server
  4. Extract Metrics

Retrieve an existing In Flight Transaction Information

get

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

Required Role: User

Retrieve an existing In Flight Transaction Information

Request

Path Parameters
Back to Top

Response

Supported Media Types

200 Response

Body ()
Root Schema : Oracle GoldenGate Current In-Flight Transactions
Type: object
Title: Oracle GoldenGate Current In-Flight Transactions
Show Source
Nested Schema : currentInflightTransactions
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 2147483647
Show Source
Nested Schema : items
Type: object
Show Source
  • commitScn
    SCN Number
  • Minimum Value: 0
    Maximum Value: 9223372036854776000
    CO UID
  • Minimum Length: 1
    Maximum Length: 16
    Extract Name
  • Minimum Length: 1
    Maximum Length: 100
    Transaction flags
  • Minimum Value: 0
    Maximum Value: 18446744073709552000
    Log Stream Id for DB2LUW
  • Minimum Value: 0
    Maximum Value: 4294967295
    Redo RBA
  • Minimum Value: 0
    Maximum Value: 4294967295
    Redo Sequence Number
  • Minimum Value: 0
    Maximum Value: 4294967295
    Redo Thread ID
  • scn
    SCN Number
  • Minimum Value: 0
    Maximum Value: 4294967295
    Number of items in transaction
  • 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
  • Minimum Length: 1
    Maximum Length: 100
    Transaction status
  • Minimum Length: 1
    Maximum Length: 16
    Transaction ID
  • Minimum Length: 1
    Maximum Length: 20
    DB2 z/OS LSN
Nested Schema : commitScn
SCN Number
Match One
Show Source
  • Minimum Value: 0
    Maximum Value: 9223372036854776000
    System Change Number(Normal Format) for Oracle Database.
    Example: 6488359
  • Minimum Length: 3
    Maximum Length: 64
    Pattern: [0-9]+[.][0-9]+
    System Change Number(Alternate Format) for Oracle Database.
    Example: 6488359.3456712
Nested Schema : scn
SCN Number
Match One
Show Source
  • Minimum Value: 0
    Maximum Value: 9223372036854776000
    System Change Number(Normal Format) for Oracle Database.
    Example: 6488359
  • Minimum Length: 3
    Maximum Length: 64
    Pattern: [0-9]+[.][0-9]+
    System Change Number(Alternate Format) for Oracle Database.
    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