ルート・スキーマ: Oracle GoldenGate Receiver Server Info
型: object
タイトル: Oracle GoldenGate Receiver Server Info
ソースの表示
{
"title":"Oracle GoldenGate Receiver Server Info",
"required":[
"trails"
],
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:targetPathProgress"
]
},
"trails":{
"type":"array",
"items":{
"description":"Trail File Details",
"type":"object",
"properties":{
"name":{
"description":"Trail Name",
"type":"string",
"minLength":"1",
"maxLength":"255"
},
"source":{
"description":"Source DB Name",
"type":"string",
"minLength":"1",
"maxLength":"255"
},
"extract":{
"description":"Source Extract Name",
"type":"string",
"minLength":"1",
"maxLength":"8"
},
"pos":{
"description":"Pos information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atCSN"
]
},
"at":{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
},
"required":[
"at"
],
"additionalProperties":false
},
"bsn":{
"description":"LogBSN information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atCSN"
]
},
"at":{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
},
"required":[
"at"
],
"additionalProperties":false
},
"xid":{
"description":"XID information",
"type":"string",
"minLength":"1",
"maxLength":"16"
}
},
"required":[
"name"
],
"additionalProperties":false
},
"minItems":"0",
"maxItems":"8192"
}
},
"additionalProperties":false
}
ネストされたスキーマ: trails
型: array
最小アイテム数: 0
最大アイテム数: 8192
ソースの表示
{
"type":"array",
"items":{
"description":"Trail File Details",
"type":"object",
"properties":{
"name":{
"description":"Trail Name",
"type":"string",
"minLength":"1",
"maxLength":"255"
},
"source":{
"description":"Source DB Name",
"type":"string",
"minLength":"1",
"maxLength":"255"
},
"extract":{
"description":"Source Extract Name",
"type":"string",
"minLength":"1",
"maxLength":"8"
},
"pos":{
"description":"Pos information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atCSN"
]
},
"at":{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
},
"required":[
"at"
],
"additionalProperties":false
},
"bsn":{
"description":"LogBSN information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atCSN"
]
},
"at":{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
},
"required":[
"at"
],
"additionalProperties":false
},
"xid":{
"description":"XID information",
"type":"string",
"minLength":"1",
"maxLength":"16"
}
},
"required":[
"name"
],
"additionalProperties":false
},
"minItems":"0",
"maxItems":"8192"
}
ネストされたスキーマ: items
型: object
トレイル・ファイルの詳細
ソースの表示
{
"description":"Trail File Details",
"type":"object",
"properties":{
"name":{
"description":"Trail Name",
"type":"string",
"minLength":"1",
"maxLength":"255"
},
"source":{
"description":"Source DB Name",
"type":"string",
"minLength":"1",
"maxLength":"255"
},
"extract":{
"description":"Source Extract Name",
"type":"string",
"minLength":"1",
"maxLength":"8"
},
"pos":{
"description":"Pos information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atCSN"
]
},
"at":{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
},
"required":[
"at"
],
"additionalProperties":false
},
"bsn":{
"description":"LogBSN information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atCSN"
]
},
"at":{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
},
"required":[
"at"
],
"additionalProperties":false
},
"xid":{
"description":"XID information",
"type":"string",
"minLength":"1",
"maxLength":"16"
}
},
"required":[
"name"
],
"additionalProperties":false
}
ネストされたスキーマ: bsn
型: object
LogBSNの情報
ソースの表示
{
"description":"LogBSN information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atCSN"
]
},
"at":{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
},
"required":[
"at"
],
"additionalProperties":false
}
ネストされたスキーマ: pos
型: object
Posの情報
ソースの表示
{
"description":"Pos information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atCSN"
]
},
"at":{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
},
"required":[
"at"
],
"additionalProperties":false
}
ネストされたスキーマ: at
1つに一致
ソースの表示
{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
ネストされたスキーマ: at-x-oneOf[0]
いずれかに一致
ソースの表示
- at-x-oneOf[0]-x-anyOf[0]
- at-x-oneOf[0]-x-anyOf[1]
- string
最小長: 3
最大長: 41
パターン: ^([0-9]{1,20}[.][0-9]{1,20})$
DB2LUWデータベースの場合のログ・レコード識別子(LRI)パターン。
例: 65423.12345
- string
最小長: 3
最大長: 22
パターン: ^([0][Xx][a-fA-F0-9]{1,20})$
DB2ZOSデータベースの場合のログ順序番号(LSN)パターン。
例: 0xa123bcde
- at-x-oneOf[0]-x-anyOf[4]
- string
最小長: 15
最大長: 56
パターン: ^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$
MSSQLデータベースの場合のコミット順序番号パターン。
例: 0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445
- string
最小長: 3
最大長: 17
パターン: ^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$
PostgreSQLデータベースの場合のコミット順序番号パターン。
例: 9acd12/231bcf
- string
最小長: 7
最大長: 33
パターン: ^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$
Sybaseデータベースの場合のコミット順序番号パターン。
例: 00000.0026487383.0000533650.00034
- null
Teradataの場合のコミット順序番号(サポート対象外)
- string
最小長: 1
最大長: 100
パターン: ^([A-Za-z0-9_]{1,100})$
汎用データベースの場合のコミット順序番号パターン。
例: 9acd12231bcf
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
}
ネストされたスキーマ: at-x-oneOf[0]-x-anyOf[0]
1つに一致
ソースの表示
- integer
最小値: 0
最大値: 9223372036854776000
Oracle Databaseの場合のシステム変更番号(標準形式)。
例: 6488359
- string
最小長: 3
最大長: 64
パターン: [0-9]+[.][0-9]+
Oracle Databaseの場合のシステム変更番号(代替形式)。
例: 6488359.3456712
{
"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"
}
]
}
ネストされたスキーマ: at-x-oneOf[0]-x-anyOf[1]
1つに一致
ソースの表示
- string
最小長: 3
最大長: 37
パターン: ^([0-9]+[:][0-9]+)$
MySQLデータベースの場合のコミット順序番号パターン(レガシー)。
例: 6488359:564781
- string
最小長: 77
最大長: 77
パターン: ^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$
MySQLデータベースの場合のCSNパターン(GTID形式)。
例: 00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
}
ネストされたスキーマ: at-x-oneOf[0]-x-anyOf[4]
1つに一致
ソースの表示
- integer
最小値: 1
最大値: 18446744073709552000
DB2400データベースの場合のコミット順序番号パターン(レガシー)。
例: 78654321
- string
最小長: 32
最大長: 32
パターン: ^([a-fA-F0-9]{32})$
DB2400データベースの場合のコミット順序番号パターン(受信側のタイムスタンプおよび順序番号)。
例: F0B4993FD22315E5F0B4993FD22315E5
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
}
ネストされたスキーマ: at
1つに一致
ソースの表示
{
"x-oneOf":[
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
},
{
"type":"string",
"pattern":"[0-9]+",
"minLength":"1",
"maxLength":"255"
}
]
}
ネストされたスキーマ: at-x-oneOf[0]
いずれかに一致
ソースの表示
- at-x-oneOf[0]-x-anyOf[0]
- at-x-oneOf[0]-x-anyOf[1]
- string
最小長: 3
最大長: 41
パターン: ^([0-9]{1,20}[.][0-9]{1,20})$
DB2LUWデータベースの場合のログ・レコード識別子(LRI)パターン。
例: 65423.12345
- string
最小長: 3
最大長: 22
パターン: ^([0][Xx][a-fA-F0-9]{1,20})$
DB2ZOSデータベースの場合のログ順序番号(LSN)パターン。
例: 0xa123bcde
- at-x-oneOf[0]-x-anyOf[4]
- string
最小長: 15
最大長: 56
パターン: ^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$
MSSQLデータベースの場合のコミット順序番号パターン。
例: 0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445
- string
最小長: 3
最大長: 17
パターン: ^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$
PostgreSQLデータベースの場合のコミット順序番号パターン。
例: 9acd12/231bcf
- string
最小長: 7
最大長: 33
パターン: ^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$
Sybaseデータベースの場合のコミット順序番号パターン。
例: 00000.0026487383.0000533650.00034
- null
Teradataの場合のコミット順序番号(サポート対象外)
- string
最小長: 1
最大長: 100
パターン: ^([A-Za-z0-9_]{1,100})$
汎用データベースの場合のコミット順序番号パターン。
例: 9acd12231bcf
{
"x-anyOf":[
{
"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"
}
]
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
},
{
"description":"Log Record Identifer(LRI) pattern for DB2LUW Database.",
"type":"string",
"pattern":"^([0-9]{1,20}[.][0-9]{1,20})$",
"minLength":"3",
"maxLength":"41",
"example":"65423.12345"
},
{
"description":"Log Sequence Number (LSN) pattern for DB2ZOS Database.",
"type":"string",
"pattern":"^([0][Xx][a-fA-F0-9]{1,20})$",
"minLength":"3",
"maxLength":"22",
"example":"0xa123bcde"
},
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
},
{
"description":"Commit Sequence Number pattern for MSSQL Database.",
"type":"string",
"pattern":"^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$",
"minLength":"15",
"maxLength":"56",
"example":"0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445"
},
{
"description":"Commit Sequence Number pattern for PostgreSQL Database.",
"type":"string",
"pattern":"^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$",
"minLength":"3",
"maxLength":"17",
"example":"9acd12/231bcf"
},
{
"description":"Commit Sequence Number pattern for Sybase Database.",
"type":"string",
"pattern":"^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$",
"minLength":"7",
"maxLength":"33",
"example":"00000.0026487383.0000533650.00034"
},
{
"description":"Commit Sequence Number for Teradata (Not Supported)",
"type":"null"
},
{
"description":"Commit Sequence Number pattern for Generic Database.",
"type":"string",
"pattern":"^([A-Za-z0-9_]{1,100})$",
"minLength":"1",
"maxLength":"100",
"example":"9acd12231bcf"
}
]
}
ネストされたスキーマ: at-x-oneOf[0]-x-anyOf[0]
1つに一致
ソースの表示
- integer
最小値: 0
最大値: 9223372036854776000
Oracle Databaseの場合のシステム変更番号(標準形式)。
例: 6488359
- string
最小長: 3
最大長: 64
パターン: [0-9]+[.][0-9]+
Oracle Databaseの場合のシステム変更番号(代替形式)。
例: 6488359.3456712
{
"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"
}
]
}
ネストされたスキーマ: at-x-oneOf[0]-x-anyOf[1]
1つに一致
ソースの表示
- string
最小長: 3
最大長: 37
パターン: ^([0-9]+[:][0-9]+)$
MySQLデータベースの場合のコミット順序番号パターン(レガシー)。
例: 6488359:564781
- string
最小長: 77
最大長: 77
パターン: ^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$
MySQLデータベースの場合のCSNパターン(GTID形式)。
例: 00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern(Legacy) for MySQL Database.",
"type":"string",
"pattern":"^([0-9]+[:][0-9]+)$",
"minLength":"3",
"maxLength":"37",
"example":"6488359:564781"
},
{
"description":"CSN pattern(GTID format) for MySQL Database.",
"type":"string",
"pattern":"^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$",
"minLength":"77",
"maxLength":"77",
"example":"00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654"
}
]
}
ネストされたスキーマ: at-x-oneOf[0]-x-anyOf[4]
1つに一致
ソースの表示
- integer
最小値: 1
最大値: 18446744073709552000
DB2400データベースの場合のコミット順序番号パターン(レガシー)。
例: 78654321
- string
最小長: 32
最大長: 32
パターン: ^([a-fA-F0-9]{32})$
DB2400データベースの場合のコミット順序番号パターン(受信側のタイムスタンプおよび順序番号)。
例: F0B4993FD22315E5F0B4993FD22315E5
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":"1",
"maximum":"18446744073709552000",
"example":"78654321"
},
{
"description":"Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.",
"type":"string",
"pattern":"^([a-fA-F0-9]{32})$",
"minLength":"32",
"maxLength":"32",
"example":"F0B4993FD22315E5F0B4993FD22315E5"
}
]
}