ジャンプ先

• リクエスト
• レスポンス

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

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":{
                    "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
                    },
                    "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":16
                    },
                    "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":4.294967295E9
                    },
                    "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":{
            "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
            },
            "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":16
            },
            "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":4.294967295E9
            },
            "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

ソースの表示

• extract(optional): string
  最小長: 1

  最大長: 16

  Extract名
• logStreamId(optional): integer
  最小値: 0

  最大値: 4.294967295E9

  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

  最大長: 16

  トランザクションのステータス
• xid(optional): string
  最小長: 1

  最大長: 16

  トランザクションID
• zosLsn(optional): string
  最小長: 1

  最大長: 20

  DB2 z/OS LSN

{
    "type":"object",
    "properties":{
        "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
        },
        "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":16
        },
        "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":4.294967295E9
        },
        "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
}

ネストされたスキーマ: 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":[
    ]
}

先頭に戻る