Root Schema : Oracle GoldenGate Receiver Server Info
Type: object
Title: Oracle GoldenGate Receiver Server Info
Show Source
{
"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":9.223372036854776E18,
"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":1.8446744073709552E19,
"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":9.223372036854776E18,
"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":1.8446744073709552E19,
"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
}
Nested Schema : trails
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 8192
Show Source
{
"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":9.223372036854776E18,
"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":1.8446744073709552E19,
"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":9.223372036854776E18,
"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":1.8446744073709552E19,
"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
}
Nested Schema : items
Type: object
Trail File Details
Show Source
{
"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":9.223372036854776E18,
"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":1.8446744073709552E19,
"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":9.223372036854776E18,
"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":1.8446744073709552E19,
"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
}
Nested Schema : bsn
Type: object
LogBSN information
Show Source
{
"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":9.223372036854776E18,
"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":1.8446744073709552E19,
"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
}
Nested Schema : pos
Type: object
Pos information
Show Source
{
"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":9.223372036854776E18,
"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":1.8446744073709552E19,
"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
}
Nested Schema : at
Match One
Show Source
{
"x-oneOf":[
{
"x-anyOf":[
{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18,
"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":1.8446744073709552E19,
"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
}
]
}
Nested Schema : at-x-oneOf[0]
Match Any
Show Source
-
at-x-oneOf[0]-x-anyOf[0]
-
at-x-oneOf[0]-x-anyOf[1]
-
string
Minimum Length: 3
Maximum Length: 41
Pattern: ^([0-9]{1,20}[.][0-9]{1,20})$
Log Record Identifer(LRI) pattern for DB2LUW Database.
Example: 65423.12345
-
string
Minimum Length: 3
Maximum Length: 22
Pattern: ^([0][Xx][a-fA-F0-9]{1,20})$
Log Sequence Number (LSN) pattern for DB2ZOS Database.
Example: 0xa123bcde
-
at-x-oneOf[0]-x-anyOf[4]
-
string
Minimum Length: 15
Maximum Length: 56
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}))$
Commit Sequence Number pattern for MSSQL Database.
Example: 0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445
-
string
Minimum Length: 3
Maximum Length: 17
Pattern: ^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$
Commit Sequence Number pattern for PostgreSQL Database.
Example: 9acd12/231bcf
-
string
Minimum Length: 7
Maximum Length: 33
Pattern: ^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$
Commit Sequence Number pattern for Sybase Database.
Example: 00000.0026487383.0000533650.00034
-
null
Commit Sequence Number for Teradata (Not Supported)
-
string
Minimum Length: 1
Maximum Length: 100
Pattern: ^([A-Za-z0-9_]{1,100})$
Commit Sequence Number pattern for Generic Database.
Example: 9acd12231bcf
{
"x-anyOf":[
{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18,
"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":1.8446744073709552E19,
"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"
}
]
}
Nested Schema : at-x-oneOf[0]-x-anyOf[0]
Match One
Show Source
-
integer
Minimum Value: 0
Maximum Value: 9.223372036854776E18
System Change Number(Normal Format) for Oracle Database.
Example: 6488359
-
string
Minimum Length: 3
Maximum Length: 64
Pattern: [0-9]+[.][0-9]+
System Change Number(Alternate Format) for Oracle Database.
Example: 6488359.3456712
{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18,
"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"
}
]
}
Nested Schema : at-x-oneOf[0]-x-anyOf[1]
Match One
Show Source
-
string
Minimum Length: 3
Maximum Length: 37
Pattern: ^([0-9]+[:][0-9]+)$
Commit Sequence Number pattern(Legacy) for MySQL Database.
Example: 6488359:564781
-
string
Minimum Length: 77
Maximum Length: 77
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}$
CSN pattern(GTID format) for MySQL Database.
Example: 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"
}
]
}
Nested Schema : at-x-oneOf[0]-x-anyOf[4]
Match One
Show Source
-
integer
Minimum Value: 1
Maximum Value: 1.8446744073709552E19
Commit Sequence Number pattern (Legacy) for DB2400 Database.
Example: 78654321
-
string
Minimum Length: 32
Maximum Length: 32
Pattern: ^([a-fA-F0-9]{32})$
Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.
Example: F0B4993FD22315E5F0B4993FD22315E5
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":1,
"maximum":1.8446744073709552E19,
"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"
}
]
}
Nested Schema : at
Match One
Show Source
{
"x-oneOf":[
{
"x-anyOf":[
{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18,
"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":1.8446744073709552E19,
"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
}
]
}
Nested Schema : at-x-oneOf[0]
Match Any
Show Source
-
at-x-oneOf[0]-x-anyOf[0]
-
at-x-oneOf[0]-x-anyOf[1]
-
string
Minimum Length: 3
Maximum Length: 41
Pattern: ^([0-9]{1,20}[.][0-9]{1,20})$
Log Record Identifer(LRI) pattern for DB2LUW Database.
Example: 65423.12345
-
string
Minimum Length: 3
Maximum Length: 22
Pattern: ^([0][Xx][a-fA-F0-9]{1,20})$
Log Sequence Number (LSN) pattern for DB2ZOS Database.
Example: 0xa123bcde
-
at-x-oneOf[0]-x-anyOf[4]
-
string
Minimum Length: 15
Maximum Length: 56
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}))$
Commit Sequence Number pattern for MSSQL Database.
Example: 0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445
-
string
Minimum Length: 3
Maximum Length: 17
Pattern: ^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$
Commit Sequence Number pattern for PostgreSQL Database.
Example: 9acd12/231bcf
-
string
Minimum Length: 7
Maximum Length: 33
Pattern: ^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$
Commit Sequence Number pattern for Sybase Database.
Example: 00000.0026487383.0000533650.00034
-
null
Commit Sequence Number for Teradata (Not Supported)
-
string
Minimum Length: 1
Maximum Length: 100
Pattern: ^([A-Za-z0-9_]{1,100})$
Commit Sequence Number pattern for Generic Database.
Example: 9acd12231bcf
{
"x-anyOf":[
{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18,
"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":1.8446744073709552E19,
"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"
}
]
}
Nested Schema : at-x-oneOf[0]-x-anyOf[0]
Match One
Show Source
-
integer
Minimum Value: 0
Maximum Value: 9.223372036854776E18
System Change Number(Normal Format) for Oracle Database.
Example: 6488359
-
string
Minimum Length: 3
Maximum Length: 64
Pattern: [0-9]+[.][0-9]+
System Change Number(Alternate Format) for Oracle Database.
Example: 6488359.3456712
{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18,
"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"
}
]
}
Nested Schema : at-x-oneOf[0]-x-anyOf[1]
Match One
Show Source
-
string
Minimum Length: 3
Maximum Length: 37
Pattern: ^([0-9]+[:][0-9]+)$
Commit Sequence Number pattern(Legacy) for MySQL Database.
Example: 6488359:564781
-
string
Minimum Length: 77
Maximum Length: 77
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}$
CSN pattern(GTID format) for MySQL Database.
Example: 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"
}
]
}
Nested Schema : at-x-oneOf[0]-x-anyOf[4]
Match One
Show Source
-
integer
Minimum Value: 1
Maximum Value: 1.8446744073709552E19
Commit Sequence Number pattern (Legacy) for DB2400 Database.
Example: 78654321
-
string
Minimum Length: 32
Maximum Length: 32
Pattern: ^([a-fA-F0-9]{32})$
Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.
Example: F0B4993FD22315E5F0B4993FD22315E5
{
"x-oneOf":[
{
"description":"Commit Sequence Number pattern (Legacy) for DB2400 Database.",
"type":"integer",
"minimum":1,
"maximum":1.8446744073709552E19,
"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"
}
]
}