Oracle GoldenGate REST API 21c (21.1.0)

既存の処理中トランザクション情報の取得

get

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

リクエスト

パス・パラメータ

item: string

最小長: 1

最大長: 32
version: string

Oracle GoldenGateサービスのAPIバージョン。

指定できる値: [ "v2" ]

先頭に戻る

レスポンス

サポートされるメディア・タイプ

application/json

200レスポンス

ルート・スキーマ: Oracle GoldenGate Current In-Flight Transactions

型: object

タイトル: Oracle GoldenGate Current In-Flight Transactions

ソースの表示

$schema(optional):

指定できる値: [ "mpoints:currentInflightTransactions" ]
currentInflightTransactions(optional): array currentInflightTransactions

最小アイテム数: 0

最大アイテム数: 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":"Normal format",
                                "type":"integer",
                                "minimum":0,
                                "maximum":9.223372036854776E18
                            },
                            {
                                "description":"Alternate format",
                                "type":"string",
                                "pattern":"[0-9]+[.][0-9]+",
                                "minLength":3,
                                "maxLength":64
                            }
                        ]
                    },
                    "scn":{
                        "description":"SCN Number",
                        "x-oneOf":[
                            {
                                "description":"Normal format",
                                "type":"integer",
                                "minimum":0,
                                "maximum":9.223372036854776E18
                            },
                            {
                                "description":"Alternate format",
                                "type":"string",
                                "pattern":"[0-9]+[.][0-9]+",
                                "minLength":3,
                                "maxLength":64
                            }
                        ]
                    },
                    "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
}

ネストされたスキーマ: currentInflightTransactions

型: array

最小アイテム数: 0

最大アイテム数: 2147483647

ソースの表示

配列: object items

{
    "type":"array",
    "minItems":0,
    "maxItems":2147483647,
    "items":{
        "type":"object",
        "properties":{
            "commitScn":{
                "description":"SCN Number",
                "x-oneOf":[
                    {
                        "description":"Normal format",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    {
                        "description":"Alternate format",
                        "type":"string",
                        "pattern":"[0-9]+[.][0-9]+",
                        "minLength":3,
                        "maxLength":64
                    }
                ]
            },
            "scn":{
                "description":"SCN Number",
                "x-oneOf":[
                    {
                        "description":"Normal format",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    {
                        "description":"Alternate format",
                        "type":"string",
                        "pattern":"[0-9]+[.][0-9]+",
                        "minLength":3,
                        "maxLength":64
                    }
                ]
            },
            "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
    }
}

ネストされたスキーマ: items

型: object

ソースの表示

commitScn(optional): commitScn

SCN番号
coUid(optional): integer

最小値: 0

最大値: 9.223372036854776E18

CO UID
extract(optional): string

最小長: 1

最大長: 16

Extract名
flags(optional): string

最小長: 1

最大長: 100

取引フラグ
logStreamId(optional): integer

最小値: 0

最大値: 1.8446744073709552E19

DB2LUWのログ・ストリームID
redoRba(optional): integer

最小値: 0

最大値: 4.294967295E9

REDO RBA
redoSeq(optional): integer

最小値: 0

最大値: 4.294967295E9

REDO順序番号
redoThread(optional): integer

最小値: 0

最大値: 4.294967295E9

REDOスレッドID
scn(optional): scn

SCN番号
size(optional): integer

最小値: 0

最大値: 4.294967295E9

トランザクションのアイテム数
startTime(optional): string

最小長: 20

最大長: 32

パターン: ^[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])$

トランザクション開始時間
status(optional): string

最小長: 1

最大長: 100

トランザクションのステータス
xid(optional): string

最小長: 1

最大長: 16

トランザクションID
zosLsn(optional): string

最小長: 1

最大長: 20

DB2 z/OS LSN

{
    "type":"object",
    "properties":{
        "commitScn":{
            "description":"SCN Number",
            "x-oneOf":[
                {
                    "description":"Normal format",
                    "type":"integer",
                    "minimum":0,
                    "maximum":9.223372036854776E18
                },
                {
                    "description":"Alternate format",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":3,
                    "maxLength":64
                }
            ]
        },
        "scn":{
            "description":"SCN Number",
            "x-oneOf":[
                {
                    "description":"Normal format",
                    "type":"integer",
                    "minimum":0,
                    "maximum":9.223372036854776E18
                },
                {
                    "description":"Alternate format",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":3,
                    "maxLength":64
                }
            ]
        },
        "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
}

ネストされたスキーマ: commitScn

SCN番号

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9.223372036854776E18

標準の形式
string

最小長: 3

最大長: 64

パターン: [0-9]+[.][0-9]+

代替の形式

{
    "description":"SCN Number",
    "x-oneOf":[
        {
            "description":"Normal format",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        {
            "description":"Alternate format",
            "type":"string",
            "pattern":"[0-9]+[.][0-9]+",
            "minLength":3,
            "maxLength":64
        }
    ]
}

ネストされたスキーマ: scn

SCN番号

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9.223372036854776E18

標準の形式
string

最小長: 3

最大長: 64

パターン: [0-9]+[.][0-9]+

代替の形式

{
    "description":"SCN Number",
    "x-oneOf":[
        {
            "description":"Normal format",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        {
            "description":"Alternate format",
            "type":"string",
            "pattern":"[0-9]+[.][0-9]+",
            "minLength":3,
            "maxLength":64
        }
    ]
}

レスポンスの例(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":[
    ]
}

先頭に戻る