Oracle GoldenGate Microservices REST API

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

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:

指定できる値: [ "mpoints:currentInflightTransactions" ]
currentInflightTransactions: 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":"System Change Number(Normal Format) for Oracle Database.",
                                "type":"integer",
                                "minimum":"0",
                                "maximum":"9223372036854776000",
                                "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":"9223372036854776000",
                                "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":"9223372036854776000"
                    },
                    "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":"4294967295"
                    },
                    "redoSeq":{
                        "description":"Redo Sequence Number",
                        "type":"integer",
                        "minimum":"0",
                        "maximum":"4294967295"
                    },
                    "logStreamId":{
                        "description":"Log Stream Id for DB2LUW",
                        "type":"integer",
                        "minimum":"0",
                        "maximum":"18446744073709552000"
                    },
                    "size":{
                        "description":"Number of items in transaction",
                        "type":"integer",
                        "minimum":"0",
                        "maximum":"4294967295"
                    },
                    "redoThread":{
                        "description":"Redo Thread ID",
                        "type":"integer",
                        "minimum":"0",
                        "maximum":"4294967295"
                    }
                },
                "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":"System Change Number(Normal Format) for Oracle Database.",
                        "type":"integer",
                        "minimum":"0",
                        "maximum":"9223372036854776000",
                        "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":"9223372036854776000",
                        "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":"9223372036854776000"
            },
            "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":"4294967295"
            },
            "redoSeq":{
                "description":"Redo Sequence Number",
                "type":"integer",
                "minimum":"0",
                "maximum":"4294967295"
            },
            "logStreamId":{
                "description":"Log Stream Id for DB2LUW",
                "type":"integer",
                "minimum":"0",
                "maximum":"18446744073709552000"
            },
            "size":{
                "description":"Number of items in transaction",
                "type":"integer",
                "minimum":"0",
                "maximum":"4294967295"
            },
            "redoThread":{
                "description":"Redo Thread ID",
                "type":"integer",
                "minimum":"0",
                "maximum":"4294967295"
            }
        },
        "additionalProperties":false
    }
}

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

型: object

ソースの表示

commitScn: commitScn

SCN番号
coUid: integer

最小値: 0

最大値: 9223372036854776000

CO UID
extract: string

最小長: 1

最大長: 16

Extract名
flags: string

最小長: 1

最大長: 100

取引フラグ
logStreamId: integer

最小値: 0

最大値: 18446744073709552000

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

最小値: 0

最大値: 4294967295

REDO RBA
redoSeq: integer

最小値: 0

最大値: 4294967295

REDO順序番号
redoThread: integer

最小値: 0

最大値: 4294967295

REDOスレッドID
scn: scn

SCN番号
size: integer

最小値: 0

最大値: 4294967295

トランザクションのアイテム数
startTime: 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: string

最小長: 1

最大長: 100

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

最小長: 1

最大長: 16

トランザクションID
zosLsn: string

最小長: 1

最大長: 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":"9223372036854776000",
                    "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":"9223372036854776000",
                    "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":"9223372036854776000"
        },
        "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":"4294967295"
        },
        "redoSeq":{
            "description":"Redo Sequence Number",
            "type":"integer",
            "minimum":"0",
            "maximum":"4294967295"
        },
        "logStreamId":{
            "description":"Log Stream Id for DB2LUW",
            "type":"integer",
            "minimum":"0",
            "maximum":"18446744073709552000"
        },
        "size":{
            "description":"Number of items in transaction",
            "type":"integer",
            "minimum":"0",
            "maximum":"4294967295"
        },
        "redoThread":{
            "description":"Redo Thread ID",
            "type":"integer",
            "minimum":"0",
            "maximum":"4294967295"
        }
    },
    "additionalProperties":false
}

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

SCN番号

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9223372036854776000

Oracle Databaseの場合のシステム変更番号(標準形式)。

例: 6488359
string

最小長: 3

最大長: 64

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

Oracle Databaseの場合のシステム変更番号(代替形式)。

例: 6488359.3456712

{
    "description":"SCN Number",
    "x-oneOf":[
        {
            "description":"System Change Number(Normal Format) for Oracle Database.",
            "type":"integer",
            "minimum":"0",
            "maximum":"9223372036854776000",
            "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

SCN番号

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9223372036854776000

Oracle Databaseの場合のシステム変更番号(標準形式)。

例: 6488359
string

最小長: 3

最大長: 64

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

Oracle Databaseの場合のシステム変更番号(代替形式)。

例: 6488359.3456712

{
    "description":"SCN Number",
    "x-oneOf":[
        {
            "description":"System Change Number(Normal Format) for Oracle Database.",
            "type":"integer",
            "minimum":"0",
            "maximum":"9223372036854776000",
            "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"
        }
    ]
}

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

先頭に戻る