Root Schema : Oracle GoldenGate Distribution Path Statistics
Type: object
Title: Oracle GoldenGate Distribution Path Statistics
Show Source
{
"title":"Oracle GoldenGate Distribution Path Statistics",
"required":[
"lcrReceived",
"lcrSent"
],
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"ddlSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathStats"
]
},
"procedure":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableStatsDaily":{
"type":"array",
"items":{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableStatsHourly":{
"type":"array",
"items":{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableStats":{
"type":"array",
"items":{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"chunkStats":{
"type":"array",
"items":{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"ddl":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathChunkStats"
]
},
"procedure":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"chunkId":{
"type":"integer",
"minimum":"1",
"maximum":"4294967295"
}
},
"required":[
"chunkId",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"ddlReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"netStats":{
"type":"object",
"properties":{
"totalMsgsReceived":{
"description":"Total Messages received",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"totalMsgsSent":{
"description":"Total Messages sent",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"remoteAddress":{
"type":"object",
"properties":{
"host":{
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"x-oneOf":[
{
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
{
"type":"integer",
"minimum":"0",
"maximum":"0"
}
]
}
}
},
"localAddress":{
"type":"object",
"properties":{
"host":{
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"x-oneOf":[
{
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
{
"type":"integer",
"minimum":"0",
"maximum":"0"
}
]
}
}
},
"$schema":{
"enum":[
"ogg:netStats"
]
},
"streaming":{
"type":"boolean"
},
"totalBytesReceived":{
"description":"Total bytes received",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"recvWaitTime":{
"description":"Total recv wait time",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"sendWaitTime":{
"description":"Total send wait time",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"totalBytesSent":{
"description":"Total bytes sent",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"additionalProperties":false
},
"fileIoStats":{
"description":"Oracle GoldenGate Distribution Path file I/O Stats",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailStats"
]
},
"currentFile":{
"description":"Current Trail file",
"type":"object",
"properties":{
"spaceUsed":{
"description":"Bytes consumed by all trail sequences",
"type":"integer",
"minimum":"0",
"maximum":"18446744073709552000"
},
"sizeMB":{
"description":"The maximum size, in megabytes, of a file in the trail.",
"type":"integer",
"default":"500",
"minimum":"1",
"maximum":"2000"
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":"0",
"maximum":"2147483647"
},
"sequenceMaxInUse":{
"description":"Maximum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"trailName":{
"description":"The optional 'user-friendly' name for the trail",
"type":"string",
"pattern":"^[a-zA-Z0-9_#$/-]*$",
"minLength":"3",
"maxLength":"512"
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
"remote":{
"description":"Indicates if trail is local or remote",
"type":"boolean",
"default":false
},
"sequenceLastArchived":{
"description":"Last sequence number archived (Managed Trails only)",
"type":"array",
"items":{
"type":"object",
"properties":{
"taskName":{
"description":"The name of the task which archived trail sequences",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_-]*$",
"minLength":"1",
"maxLength":"64"
},
"archiveTarget":{
"description":"The location where the trail sequences were archived",
"x-oneOf":[
{
"description":"Filesystem directory where trail sequences are stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
{
"description":"OCI Object Storage Bucket",
"type":"object",
"properties":{
"nameSpace":{
"description":"The OCI Object Storage namespace",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the Object Storage bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
]
}
},
"required":[
"nameSpace",
"bucketName",
"authentication"
],
"additionalProperties":false
},
{
"description":"S3-compatible object storage bucket",
"type":"object",
"properties":{
"region":{
"description":"The optional region for the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
]
}
},
"required":[
"bucketName"
],
"additionalProperties":false
}
]
},
"sequence":{
"description":"Last sequence number archived by the associated task",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"archiveTarget",
"sequence"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"128"
},
"name":{
"description":"The two-character name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]$",
"minLength":"2",
"maxLength":"2"
},
"sequence":{
"description":"Trail beginning sequence number",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"$schema":{
"enum":[
"ogg:trail"
]
},
"sequenceMinInUse":{
"description":"Minimum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLength":{
"description":"Number of digits in sequence file name",
"enum":[
"6",
"9"
],
"default":"9"
},
"sequenceMin":{
"description":"Minimum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLengthFlip":{
"description":"Indicates sequence number length will change",
"type":"boolean",
"default":false
},
"processRef":{
"description":"List of all processes associated with this trail",
"type":"array",
"items":{
"description":"A reference to an OGG process associated with this managed trail",
"type":"object",
"properties":{
"processType":{
"enum":[
"extract",
"replicat",
"distpath",
"recvpath"
]
},
"processName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
},
{
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9-_.]*$",
"minLength":"1",
"maxLength":"32"
}
]
}
},
"required":[
"processType",
"processName"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"5000"
},
"sequenceMax":{
"description":"Maximum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"description":{
"description":"Description for the trail",
"type":"string",
"minLength":"1",
"maxLength":"4095"
}
},
"additionalProperties":false
},
"totalBytesWrittentoFile":{
"description":"Total Bytes written to the current trail file",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"totalBytesRead":{
"description":"Total Bytes read from the current file",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"totalIdleTime":{
"description":"Idle time(in seconds) includes the time when no data records are received from pump/Distsrvr",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"encryption":{
"description":"endpoint trail encryption",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:distPathEncryption"
]
},
"algorithm":{
"enum":[
"NONE",
"AES128",
"AES192",
"AES256"
],
"default":"NONE"
},
"keyname":{
"description":"encryption key logical name",
"type":"string",
"minLength":"1",
"maxLength":"128"
}
},
"required":[
"algorithm"
],
"additionalProperties":false
}
},
"additionalProperties":false
},
"stats":{
"type":"array",
"items":{
"x-anyOf":[
{
"properties":{
"ddl":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"mapped",
"unmapped",
"default",
"excluded"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"ddl",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"ddlevent":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"enum":[
"events",
"invalidations"
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"ddlevent",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"sourceTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"targetTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"sqlexecOperations":{
"type":"array",
"items":{
"properties":{
"name":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"attempts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"successful":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"name",
"attempts",
"successful"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"cdrConflict",
"cdrSuccess",
"cdrFailure",
"cdrConflictInsertExists",
"cdrConflictUpdateExists",
"cdrConflictUpdateMissing",
"cdrConflictDeleteExists",
"cdrConflictDeleteMissing"
]
},
{
"enum":[
"fetchAttempt",
"fetchFailed",
"fetchDup",
"fetchSnapshotByRowid",
"fetchSnapshotByKey",
"fetchByRowid",
"fetchByKey",
"fetchMissingSnapshotByRowid",
"fetchMissingSnapshotByKey",
"fetchMissingByRowid",
"fetchMissingByKey",
"fetchSnapshotInconsistent",
"fetchInconsistent",
"nofetch"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"sourceTable",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"feature":{
"description":"Procedure feature name",
"type":"string",
"minLength":"1",
"maxLength":"384"
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"execution"
]
},
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"17"
}
},
"required":[
"feature",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"integratedReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"redirected",
"replicatedProcedures",
"ddlOperations",
"storedProcedures",
"datatypeFunctionality",
"optypeFunctionality",
"eventActions",
"databaseCompatibility",
"directTransactionRatio"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"integratedReplicat",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"coordinatedReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"averageCoordinationTime":{
"type":"string",
"minLength":"0",
"maxLength":"16"
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"ddlOperations",
"primaryKeyUpdates",
"emiTransactions",
"userDefinedBarriers",
"metadataBarriers",
"lagGap"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"coordinatedReplicat",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"parallelReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"invalidIndexOperations",
"splitTransactions",
"splitAvgChunks",
"splitAvgRows",
"serializeTransactions",
"largeTransactions",
"largeAvgRows",
"largeAvgChunks",
"missingDepColumns",
"nonNativeSupport",
"maxSchedulingConstraints",
"metadataBarriers",
"ddlOperations",
"sequenceOperations",
"replicatedProcedures",
"eventActions",
"storedProcedures",
"synchronous",
"errorFallback"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
},
"workloadDependencyStats":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"foreignKeyParentRowDeletes",
"tableLevelDependencies",
"virtualColumnDependencies"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"3"
},
"tableDependencyStats":{
"type":"array",
"items":{
"properties":{
"parentTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"childTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"childTable",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"tableWatermarkDependencyCounts":{
"type":"array",
"items":{
"properties":{
"parentTable":{
"description":"Table with dependency constraint",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"constraintType":{
"description":"Type of dependency constraint",
"enum":[
"VIRTUAL",
"OBJECT",
"BITMAP",
"COLUMN",
"WATERMARK"
]
},
"count":{
"description":"Times the dependency constraint has been hit",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"constraintType",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
},
"required":[
"parallelReplicat",
"since",
"operations"
],
"additionalProperties":false
}
]
},
"minItems":"1",
"maxItems":"7"
}
},
"additionalProperties":false
}
Nested Schema : chunkStats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
{
"type":"array",
"items":{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"ddl":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathChunkStats"
]
},
"procedure":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"chunkId":{
"type":"integer",
"minimum":"1",
"maximum":"4294967295"
}
},
"required":[
"chunkId",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
Nested Schema : fileIoStats
Type: object
Oracle GoldenGate Distribution Path file I/O Stats
Show Source
{
"description":"Oracle GoldenGate Distribution Path file I/O Stats",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailStats"
]
},
"currentFile":{
"description":"Current Trail file",
"type":"object",
"properties":{
"spaceUsed":{
"description":"Bytes consumed by all trail sequences",
"type":"integer",
"minimum":"0",
"maximum":"18446744073709552000"
},
"sizeMB":{
"description":"The maximum size, in megabytes, of a file in the trail.",
"type":"integer",
"default":"500",
"minimum":"1",
"maximum":"2000"
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":"0",
"maximum":"2147483647"
},
"sequenceMaxInUse":{
"description":"Maximum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"trailName":{
"description":"The optional 'user-friendly' name for the trail",
"type":"string",
"pattern":"^[a-zA-Z0-9_#$/-]*$",
"minLength":"3",
"maxLength":"512"
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
"remote":{
"description":"Indicates if trail is local or remote",
"type":"boolean",
"default":false
},
"sequenceLastArchived":{
"description":"Last sequence number archived (Managed Trails only)",
"type":"array",
"items":{
"type":"object",
"properties":{
"taskName":{
"description":"The name of the task which archived trail sequences",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_-]*$",
"minLength":"1",
"maxLength":"64"
},
"archiveTarget":{
"description":"The location where the trail sequences were archived",
"x-oneOf":[
{
"description":"Filesystem directory where trail sequences are stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
{
"description":"OCI Object Storage Bucket",
"type":"object",
"properties":{
"nameSpace":{
"description":"The OCI Object Storage namespace",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the Object Storage bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
]
}
},
"required":[
"nameSpace",
"bucketName",
"authentication"
],
"additionalProperties":false
},
{
"description":"S3-compatible object storage bucket",
"type":"object",
"properties":{
"region":{
"description":"The optional region for the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
]
}
},
"required":[
"bucketName"
],
"additionalProperties":false
}
]
},
"sequence":{
"description":"Last sequence number archived by the associated task",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"archiveTarget",
"sequence"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"128"
},
"name":{
"description":"The two-character name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]$",
"minLength":"2",
"maxLength":"2"
},
"sequence":{
"description":"Trail beginning sequence number",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"$schema":{
"enum":[
"ogg:trail"
]
},
"sequenceMinInUse":{
"description":"Minimum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLength":{
"description":"Number of digits in sequence file name",
"enum":[
"6",
"9"
],
"default":"9"
},
"sequenceMin":{
"description":"Minimum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLengthFlip":{
"description":"Indicates sequence number length will change",
"type":"boolean",
"default":false
},
"processRef":{
"description":"List of all processes associated with this trail",
"type":"array",
"items":{
"description":"A reference to an OGG process associated with this managed trail",
"type":"object",
"properties":{
"processType":{
"enum":[
"extract",
"replicat",
"distpath",
"recvpath"
]
},
"processName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
},
{
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9-_.]*$",
"minLength":"1",
"maxLength":"32"
}
]
}
},
"required":[
"processType",
"processName"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"5000"
},
"sequenceMax":{
"description":"Maximum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"description":{
"description":"Description for the trail",
"type":"string",
"minLength":"1",
"maxLength":"4095"
}
},
"additionalProperties":false
},
"totalBytesWrittentoFile":{
"description":"Total Bytes written to the current trail file",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"totalBytesRead":{
"description":"Total Bytes read from the current file",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"totalIdleTime":{
"description":"Idle time(in seconds) includes the time when no data records are received from pump/Distsrvr",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"encryption":{
"description":"endpoint trail encryption",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:distPathEncryption"
]
},
"algorithm":{
"enum":[
"NONE",
"AES128",
"AES192",
"AES256"
],
"default":"NONE"
},
"keyname":{
"description":"encryption key logical name",
"type":"string",
"minLength":"1",
"maxLength":"128"
}
},
"required":[
"algorithm"
],
"additionalProperties":false
}
},
"additionalProperties":false
}
Nested Schema : netStats
Type: object
Show Source
{
"type":"object",
"properties":{
"totalMsgsReceived":{
"description":"Total Messages received",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"totalMsgsSent":{
"description":"Total Messages sent",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"remoteAddress":{
"type":"object",
"properties":{
"host":{
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"x-oneOf":[
{
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
{
"type":"integer",
"minimum":"0",
"maximum":"0"
}
]
}
}
},
"localAddress":{
"type":"object",
"properties":{
"host":{
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"x-oneOf":[
{
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
{
"type":"integer",
"minimum":"0",
"maximum":"0"
}
]
}
}
},
"$schema":{
"enum":[
"ogg:netStats"
]
},
"streaming":{
"type":"boolean"
},
"totalBytesReceived":{
"description":"Total bytes received",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"recvWaitTime":{
"description":"Total recv wait time",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"sendWaitTime":{
"description":"Total send wait time",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"totalBytesSent":{
"description":"Total bytes sent",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"additionalProperties":false
}
Nested Schema : stats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 7
Show Source
{
"type":"array",
"items":{
"x-anyOf":[
{
"properties":{
"ddl":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"mapped",
"unmapped",
"default",
"excluded"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"ddl",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"ddlevent":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"enum":[
"events",
"invalidations"
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"ddlevent",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"sourceTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"targetTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"sqlexecOperations":{
"type":"array",
"items":{
"properties":{
"name":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"attempts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"successful":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"name",
"attempts",
"successful"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"cdrConflict",
"cdrSuccess",
"cdrFailure",
"cdrConflictInsertExists",
"cdrConflictUpdateExists",
"cdrConflictUpdateMissing",
"cdrConflictDeleteExists",
"cdrConflictDeleteMissing"
]
},
{
"enum":[
"fetchAttempt",
"fetchFailed",
"fetchDup",
"fetchSnapshotByRowid",
"fetchSnapshotByKey",
"fetchByRowid",
"fetchByKey",
"fetchMissingSnapshotByRowid",
"fetchMissingSnapshotByKey",
"fetchMissingByRowid",
"fetchMissingByKey",
"fetchSnapshotInconsistent",
"fetchInconsistent",
"nofetch"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"sourceTable",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"feature":{
"description":"Procedure feature name",
"type":"string",
"minLength":"1",
"maxLength":"384"
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"execution"
]
},
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"17"
}
},
"required":[
"feature",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"integratedReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"redirected",
"replicatedProcedures",
"ddlOperations",
"storedProcedures",
"datatypeFunctionality",
"optypeFunctionality",
"eventActions",
"databaseCompatibility",
"directTransactionRatio"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"integratedReplicat",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"coordinatedReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"averageCoordinationTime":{
"type":"string",
"minLength":"0",
"maxLength":"16"
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"ddlOperations",
"primaryKeyUpdates",
"emiTransactions",
"userDefinedBarriers",
"metadataBarriers",
"lagGap"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"coordinatedReplicat",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"parallelReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"invalidIndexOperations",
"splitTransactions",
"splitAvgChunks",
"splitAvgRows",
"serializeTransactions",
"largeTransactions",
"largeAvgRows",
"largeAvgChunks",
"missingDepColumns",
"nonNativeSupport",
"maxSchedulingConstraints",
"metadataBarriers",
"ddlOperations",
"sequenceOperations",
"replicatedProcedures",
"eventActions",
"storedProcedures",
"synchronous",
"errorFallback"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
},
"workloadDependencyStats":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"foreignKeyParentRowDeletes",
"tableLevelDependencies",
"virtualColumnDependencies"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"3"
},
"tableDependencyStats":{
"type":"array",
"items":{
"properties":{
"parentTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"childTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"childTable",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"tableWatermarkDependencyCounts":{
"type":"array",
"items":{
"properties":{
"parentTable":{
"description":"Table with dependency constraint",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"constraintType":{
"description":"Type of dependency constraint",
"enum":[
"VIRTUAL",
"OBJECT",
"BITMAP",
"COLUMN",
"WATERMARK"
]
},
"count":{
"description":"Times the dependency constraint has been hit",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"constraintType",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
},
"required":[
"parallelReplicat",
"since",
"operations"
],
"additionalProperties":false
}
]
},
"minItems":"1",
"maxItems":"7"
}
Nested Schema : tableStats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
{
"type":"array",
"items":{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
Nested Schema : tableStatsDaily
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
{
"type":"array",
"items":{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
Nested Schema : tableStatsHourly
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
{
"type":"array",
"items":{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
Nested Schema : items
Type: object
Show Source
{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"ddl":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathChunkStats"
]
},
"procedure":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"chunkId":{
"type":"integer",
"minimum":"1",
"maximum":"4294967295"
}
},
"required":[
"chunkId",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
}
Nested Schema : currentFile
Type: object
Current Trail file
Show Source
-
$schema:
Allowed Values: [
"ogg:trail"
]
-
description:
string
Minimum Length: 1
Maximum Length: 4095
Description for the trail
-
name:
string
Minimum Length: 2
Maximum Length: 2
Pattern: ^[A-Za-z][A-Za-z0-9]$
The two-character name of the trail
-
offset:
integer
Minimum Value: 0
Maximum Value: 2147483647
Offset in trail sequence file
-
path:
string
Minimum Length: 1
Maximum Length: 4096
The path where trail data is stored
-
processRef:
array processRef
Minimum Number of Items: 1
Maximum Number of Items: 5000
List of all processes associated with this trail
-
remote:
boolean
Default Value: false
Indicates if trail is local or remote
-
sequence:
integer
Minimum Value: 0
Maximum Value: 999999999
Default Value: 0
Trail beginning sequence number
-
sequenceLastArchived:
array sequenceLastArchived
Minimum Number of Items: 1
Maximum Number of Items: 128
Last sequence number archived (Managed Trails only)
-
sequenceLength:
Default Value: 9
Allowed Values: [
"6",
"9"
]
Number of digits in sequence file name
-
sequenceLengthFlip:
boolean
Default Value: false
Indicates sequence number length will change
-
sequenceMax:
integer
Minimum Value: 0
Maximum Value: 999999999
Default Value: 0
Maximum trail sequence number that exists in the deployment
-
sequenceMaxInUse:
integer
Minimum Value: 0
Maximum Value: 999999999
Default Value: 0
Maximum trail sequence number in use
-
sequenceMin:
integer
Minimum Value: 0
Maximum Value: 999999999
Default Value: 0
Minimum trail sequence number that exists in the deployment
-
sequenceMinInUse:
integer
Minimum Value: 0
Maximum Value: 999999999
Default Value: 0
Minimum trail sequence number in use
-
sizeMB:
integer
Minimum Value: 1
Maximum Value: 2000
Default Value: 500
The maximum size, in megabytes, of a file in the trail.
-
spaceUsed:
integer
Minimum Value: 0
Maximum Value: 18446744073709552000
Bytes consumed by all trail sequences
-
trailName:
string
Minimum Length: 3
Maximum Length: 512
Pattern: ^[a-zA-Z0-9_#$/-]*$
The optional 'user-friendly' name for the trail
{
"description":"Current Trail file",
"type":"object",
"properties":{
"spaceUsed":{
"description":"Bytes consumed by all trail sequences",
"type":"integer",
"minimum":"0",
"maximum":"18446744073709552000"
},
"sizeMB":{
"description":"The maximum size, in megabytes, of a file in the trail.",
"type":"integer",
"default":"500",
"minimum":"1",
"maximum":"2000"
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":"0",
"maximum":"2147483647"
},
"sequenceMaxInUse":{
"description":"Maximum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"trailName":{
"description":"The optional 'user-friendly' name for the trail",
"type":"string",
"pattern":"^[a-zA-Z0-9_#$/-]*$",
"minLength":"3",
"maxLength":"512"
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
"remote":{
"description":"Indicates if trail is local or remote",
"type":"boolean",
"default":false
},
"sequenceLastArchived":{
"description":"Last sequence number archived (Managed Trails only)",
"type":"array",
"items":{
"type":"object",
"properties":{
"taskName":{
"description":"The name of the task which archived trail sequences",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_-]*$",
"minLength":"1",
"maxLength":"64"
},
"archiveTarget":{
"description":"The location where the trail sequences were archived",
"x-oneOf":[
{
"description":"Filesystem directory where trail sequences are stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
{
"description":"OCI Object Storage Bucket",
"type":"object",
"properties":{
"nameSpace":{
"description":"The OCI Object Storage namespace",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the Object Storage bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
]
}
},
"required":[
"nameSpace",
"bucketName",
"authentication"
],
"additionalProperties":false
},
{
"description":"S3-compatible object storage bucket",
"type":"object",
"properties":{
"region":{
"description":"The optional region for the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
]
}
},
"required":[
"bucketName"
],
"additionalProperties":false
}
]
},
"sequence":{
"description":"Last sequence number archived by the associated task",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"archiveTarget",
"sequence"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"128"
},
"name":{
"description":"The two-character name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]$",
"minLength":"2",
"maxLength":"2"
},
"sequence":{
"description":"Trail beginning sequence number",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"$schema":{
"enum":[
"ogg:trail"
]
},
"sequenceMinInUse":{
"description":"Minimum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLength":{
"description":"Number of digits in sequence file name",
"enum":[
"6",
"9"
],
"default":"9"
},
"sequenceMin":{
"description":"Minimum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLengthFlip":{
"description":"Indicates sequence number length will change",
"type":"boolean",
"default":false
},
"processRef":{
"description":"List of all processes associated with this trail",
"type":"array",
"items":{
"description":"A reference to an OGG process associated with this managed trail",
"type":"object",
"properties":{
"processType":{
"enum":[
"extract",
"replicat",
"distpath",
"recvpath"
]
},
"processName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
},
{
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9-_.]*$",
"minLength":"1",
"maxLength":"32"
}
]
}
},
"required":[
"processType",
"processName"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"5000"
},
"sequenceMax":{
"description":"Maximum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"description":{
"description":"Description for the trail",
"type":"string",
"minLength":"1",
"maxLength":"4095"
}
},
"additionalProperties":false
}
Nested Schema : encryption
Type: object
endpoint trail encryption
Show Source
-
$schema:
Allowed Values: [
"ogg:distPathEncryption"
]
-
algorithm(required):
Default Value: NONE
Allowed Values: [
"NONE",
"AES128",
"AES192",
"AES256"
]
-
keyname:
string
Minimum Length: 1
Maximum Length: 128
encryption key logical name
{
"description":"endpoint trail encryption",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:distPathEncryption"
]
},
"algorithm":{
"enum":[
"NONE",
"AES128",
"AES192",
"AES256"
],
"default":"NONE"
},
"keyname":{
"description":"encryption key logical name",
"type":"string",
"minLength":"1",
"maxLength":"128"
}
},
"required":[
"algorithm"
],
"additionalProperties":false
}
Nested Schema : processRef
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 5000
List of all processes associated with this trail
Show Source
{
"description":"List of all processes associated with this trail",
"type":"array",
"items":{
"description":"A reference to an OGG process associated with this managed trail",
"type":"object",
"properties":{
"processType":{
"enum":[
"extract",
"replicat",
"distpath",
"recvpath"
]
},
"processName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
},
{
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9-_.]*$",
"minLength":"1",
"maxLength":"32"
}
]
}
},
"required":[
"processType",
"processName"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"5000"
}
Nested Schema : sequenceLastArchived
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 128
Last sequence number archived (Managed Trails only)
Show Source
{
"description":"Last sequence number archived (Managed Trails only)",
"type":"array",
"items":{
"type":"object",
"properties":{
"taskName":{
"description":"The name of the task which archived trail sequences",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_-]*$",
"minLength":"1",
"maxLength":"64"
},
"archiveTarget":{
"description":"The location where the trail sequences were archived",
"x-oneOf":[
{
"description":"Filesystem directory where trail sequences are stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
{
"description":"OCI Object Storage Bucket",
"type":"object",
"properties":{
"nameSpace":{
"description":"The OCI Object Storage namespace",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the Object Storage bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
]
}
},
"required":[
"nameSpace",
"bucketName",
"authentication"
],
"additionalProperties":false
},
{
"description":"S3-compatible object storage bucket",
"type":"object",
"properties":{
"region":{
"description":"The optional region for the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
]
}
},
"required":[
"bucketName"
],
"additionalProperties":false
}
]
},
"sequence":{
"description":"Last sequence number archived by the associated task",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"archiveTarget",
"sequence"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"128"
}
Nested Schema : items
Type: object
A reference to an OGG process associated with this managed trail
Show Source
{
"description":"A reference to an OGG process associated with this managed trail",
"type":"object",
"properties":{
"processType":{
"enum":[
"extract",
"replicat",
"distpath",
"recvpath"
]
},
"processName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
},
{
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9-_.]*$",
"minLength":"1",
"maxLength":"32"
}
]
}
},
"required":[
"processType",
"processName"
],
"additionalProperties":false
}
Nested Schema : processName
Match Any
Show Source
-
string
Minimum Length: 1
Maximum Length: 8
Pattern: ^[A-Z_$][A-Z0-9_$]*$
-
string
Minimum Length: 1
Maximum Length: 32
Pattern: ^[A-Za-z][A-Za-z0-9-_.]*$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
},
{
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9-_.]*$",
"minLength":"1",
"maxLength":"32"
}
]
}
Nested Schema : items
Type: object
Show Source
{
"type":"object",
"properties":{
"taskName":{
"description":"The name of the task which archived trail sequences",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_-]*$",
"minLength":"1",
"maxLength":"64"
},
"archiveTarget":{
"description":"The location where the trail sequences were archived",
"x-oneOf":[
{
"description":"Filesystem directory where trail sequences are stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
{
"description":"OCI Object Storage Bucket",
"type":"object",
"properties":{
"nameSpace":{
"description":"The OCI Object Storage namespace",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the Object Storage bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
]
}
},
"required":[
"nameSpace",
"bucketName",
"authentication"
],
"additionalProperties":false
},
{
"description":"S3-compatible object storage bucket",
"type":"object",
"properties":{
"region":{
"description":"The optional region for the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
]
}
},
"required":[
"bucketName"
],
"additionalProperties":false
}
]
},
"sequence":{
"description":"Last sequence number archived by the associated task",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"archiveTarget",
"sequence"
],
"additionalProperties":false
}
Nested Schema : archiveTarget
The location where the trail sequences were archived
Match One
Show Source
{
"description":"The location where the trail sequences were archived",
"x-oneOf":[
{
"description":"Filesystem directory where trail sequences are stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
{
"description":"OCI Object Storage Bucket",
"type":"object",
"properties":{
"nameSpace":{
"description":"The OCI Object Storage namespace",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the Object Storage bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
]
}
},
"required":[
"nameSpace",
"bucketName",
"authentication"
],
"additionalProperties":false
},
{
"description":"S3-compatible object storage bucket",
"type":"object",
"properties":{
"region":{
"description":"The optional region for the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
]
}
},
"required":[
"bucketName"
],
"additionalProperties":false
}
]
}
Nested Schema : archiveTarget-x-oneOf[1]
Type: object
OCI Object Storage Bucket
Show Source
{
"description":"OCI Object Storage Bucket",
"type":"object",
"properties":{
"nameSpace":{
"description":"The OCI Object Storage namespace",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the Object Storage bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
]
}
},
"required":[
"nameSpace",
"bucketName",
"authentication"
],
"additionalProperties":false
}
Nested Schema : archiveTarget-x-oneOf[2]
Type: object
S3-compatible object storage bucket
Show Source
{
"description":"S3-compatible object storage bucket",
"type":"object",
"properties":{
"region":{
"description":"The optional region for the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"bucketName":{
"description":"The name of the S3-compatible bucket",
"type":"string",
"minLength":"1",
"maxLength":"1024"
},
"authentication":{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
]
}
},
"required":[
"bucketName"
],
"additionalProperties":false
}
Nested Schema : authentication
Match One
Show Source
{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
},
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
]
}
Nested Schema : authentication-x-oneOf[0]
Type: object
Authentication using a named profile from the default profile configuration file
Show Source
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
}
Nested Schema : authentication-x-oneOf[1]
Type: object
Authentication for OCI using an instance principal
Show Source
{
"description":"Authentication for OCI using an instance principal",
"type":"object",
"properties":{
"instancePrincipal":{
"description":"Indicates the instance principal should be used for authentication",
"enum":[
true
]
}
},
"required":[
"instancePrincipal"
],
"additionalProperties":false
}
Nested Schema : authentication-x-oneOf[2]
Type: object
Authentication for OCI using an API signing key for a user
Show Source
{
"description":"Authentication for OCI using an API signing key for a user",
"type":"object",
"properties":{
"tenancyId":{
"description":"OCI tenancy OCID",
"type":"string",
"pattern":"^ocid1[.]tenancy[.].*",
"minLength":"1",
"maxLength":"256"
},
"userId":{
"description":"OCI user OCID",
"type":"string",
"pattern":"^ocid1[.]user[.].*",
"minLength":"1",
"maxLength":"256"
},
"apiSigningKey":{
"description":"Unencrypted API signing key",
"type":"string",
"pattern":"^-----BEGIN RSA PRIVATE KEY-----\n([A-Za-z0-9+/=\n])+\n-----END RSA PRIVATE KEY-----",
"minLength":"1",
"maxLength":"10240"
},
"apiSigningKeyFingerprint":{
"description":"Fingerprint of the API signing key",
"type":"string",
"pattern":"^[0-9a-fA-F]{2}(:[0-9a-fA-F]){15}$",
"minLength":"47",
"maxLength":"47"
}
},
"required":[
"tenancyId",
"userId",
"apiSigningKey",
"apiSigningKeyFingerprint"
],
"additionalProperties":false
}
Nested Schema : authentication
Match One
Show Source
{
"x-oneOf":[
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
},
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
]
}
Nested Schema : authentication-x-oneOf[0]
Type: object
Authentication using a named profile from the default profile configuration file
Show Source
{
"description":"Authentication using a named profile from the default profile configuration file",
"type":"object",
"properties":{
"profile":{
"description":"Name of the profile to use",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"profile"
],
"additionalProperties":false
}
Nested Schema : authentication-x-oneOf[1]
Type: object
S3 Authentication using secrets
Show Source
{
"description":"S3 Authentication using secrets",
"type":"object",
"properties":{
"accessKeyId":{
"description":"S3 access key",
"type":"string",
"minLength":"1",
"maxLength":"256"
},
"secretKey":{
"description":"S3 secret key",
"type":"string",
"minLength":"1",
"maxLength":"256"
}
},
"required":[
"accessKeyId",
"secretKey"
],
"additionalProperties":false
}
Nested Schema : localAddress
Type: object
Show Source
{
"type":"object",
"properties":{
"host":{
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"x-oneOf":[
{
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
{
"type":"integer",
"minimum":"0",
"maximum":"0"
}
]
}
}
}
Nested Schema : remoteAddress
Type: object
Show Source
{
"type":"object",
"properties":{
"host":{
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"x-oneOf":[
{
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
{
"type":"integer",
"minimum":"0",
"maximum":"0"
}
]
}
}
}
Nested Schema : host
Match One
Show Source
-
string
Minimum Length: 1
Maximum Length: 4095
Pattern: ^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$
Network host name
-
host-x-oneOf[1]
{
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
}
Nested Schema : port
Match One
Show Source
-
integer
Minimum Value: 1
Maximum Value: 65535
-
integer
Minimum Value: 0
Maximum Value: 0
{
"x-oneOf":[
{
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
{
"type":"integer",
"minimum":"0",
"maximum":"0"
}
]
}
Nested Schema : host-x-oneOf[1]
Network IP address
Match One
Show Source
-
string
Minimum Length: 7
Maximum Length: 15
Pattern: ^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
Network IPv4 address
-
string
Minimum Length: 1
Maximum Length: 256
Pattern: ^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$
Network IPv6 address
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
Nested Schema : host
Match One
Show Source
-
string
Minimum Length: 1
Maximum Length: 4095
Pattern: ^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$
Network host name
-
host-x-oneOf[1]
{
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
}
Nested Schema : port
Match One
Show Source
-
integer
Minimum Value: 1
Maximum Value: 65535
-
integer
Minimum Value: 0
Maximum Value: 0
{
"x-oneOf":[
{
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
{
"type":"integer",
"minimum":"0",
"maximum":"0"
}
]
}
Nested Schema : host-x-oneOf[1]
Network IP address
Match One
Show Source
-
string
Minimum Length: 7
Maximum Length: 15
Pattern: ^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
Network IPv4 address
-
string
Minimum Length: 1
Maximum Length: 256
Pattern: ^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$
Network IPv6 address
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
Nested Schema : items
Match Any
Show Source
{
"x-anyOf":[
{
"properties":{
"ddl":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"mapped",
"unmapped",
"default",
"excluded"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"ddl",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"ddlevent":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"enum":[
"events",
"invalidations"
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"ddlevent",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"sourceTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"targetTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"sqlexecOperations":{
"type":"array",
"items":{
"properties":{
"name":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"attempts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"successful":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"name",
"attempts",
"successful"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"cdrConflict",
"cdrSuccess",
"cdrFailure",
"cdrConflictInsertExists",
"cdrConflictUpdateExists",
"cdrConflictUpdateMissing",
"cdrConflictDeleteExists",
"cdrConflictDeleteMissing"
]
},
{
"enum":[
"fetchAttempt",
"fetchFailed",
"fetchDup",
"fetchSnapshotByRowid",
"fetchSnapshotByKey",
"fetchByRowid",
"fetchByKey",
"fetchMissingSnapshotByRowid",
"fetchMissingSnapshotByKey",
"fetchMissingByRowid",
"fetchMissingByKey",
"fetchSnapshotInconsistent",
"fetchInconsistent",
"nofetch"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"sourceTable",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"feature":{
"description":"Procedure feature name",
"type":"string",
"minLength":"1",
"maxLength":"384"
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"execution"
]
},
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"17"
}
},
"required":[
"feature",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"integratedReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"redirected",
"replicatedProcedures",
"ddlOperations",
"storedProcedures",
"datatypeFunctionality",
"optypeFunctionality",
"eventActions",
"databaseCompatibility",
"directTransactionRatio"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"integratedReplicat",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"coordinatedReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"averageCoordinationTime":{
"type":"string",
"minLength":"0",
"maxLength":"16"
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"ddlOperations",
"primaryKeyUpdates",
"emiTransactions",
"userDefinedBarriers",
"metadataBarriers",
"lagGap"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"coordinatedReplicat",
"since",
"operations"
],
"additionalProperties":false
},
{
"properties":{
"parallelReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"invalidIndexOperations",
"splitTransactions",
"splitAvgChunks",
"splitAvgRows",
"serializeTransactions",
"largeTransactions",
"largeAvgRows",
"largeAvgChunks",
"missingDepColumns",
"nonNativeSupport",
"maxSchedulingConstraints",
"metadataBarriers",
"ddlOperations",
"sequenceOperations",
"replicatedProcedures",
"eventActions",
"storedProcedures",
"synchronous",
"errorFallback"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
},
"workloadDependencyStats":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"foreignKeyParentRowDeletes",
"tableLevelDependencies",
"virtualColumnDependencies"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"3"
},
"tableDependencyStats":{
"type":"array",
"items":{
"properties":{
"parentTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"childTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"childTable",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"tableWatermarkDependencyCounts":{
"type":"array",
"items":{
"properties":{
"parentTable":{
"description":"Table with dependency constraint",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"constraintType":{
"description":"Type of dependency constraint",
"enum":[
"VIRTUAL",
"OBJECT",
"BITMAP",
"COLUMN",
"WATERMARK"
]
},
"count":{
"description":"Times the dependency constraint has been hit",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"constraintType",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
},
"required":[
"parallelReplicat",
"since",
"operations"
],
"additionalProperties":false
}
]
}
Nested Schema : items-x-anyOf[0]
Type: object
Show Source
{
"properties":{
"ddl":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"mapped",
"unmapped",
"default",
"excluded"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"ddl",
"since",
"operations"
],
"additionalProperties":false
}
Nested Schema : items-x-anyOf[1]
Type: object
Show Source
{
"properties":{
"ddlevent":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"enum":[
"events",
"invalidations"
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"ddlevent",
"since",
"operations"
],
"additionalProperties":false
}
Nested Schema : items-x-anyOf[2]
Type: object
Show Source
{
"properties":{
"sourceTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"targetTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"sqlexecOperations":{
"type":"array",
"items":{
"properties":{
"name":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"attempts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"successful":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"name",
"attempts",
"successful"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"cdrConflict",
"cdrSuccess",
"cdrFailure",
"cdrConflictInsertExists",
"cdrConflictUpdateExists",
"cdrConflictUpdateMissing",
"cdrConflictDeleteExists",
"cdrConflictDeleteMissing"
]
},
{
"enum":[
"fetchAttempt",
"fetchFailed",
"fetchDup",
"fetchSnapshotByRowid",
"fetchSnapshotByKey",
"fetchByRowid",
"fetchByKey",
"fetchMissingSnapshotByRowid",
"fetchMissingSnapshotByKey",
"fetchMissingByRowid",
"fetchMissingByKey",
"fetchSnapshotInconsistent",
"fetchInconsistent",
"nofetch"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"sourceTable",
"since",
"operations"
],
"additionalProperties":false
}
Nested Schema : items-x-anyOf[3]
Type: object
Show Source
{
"properties":{
"feature":{
"description":"Procedure feature name",
"type":"string",
"minLength":"1",
"maxLength":"384"
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"execution"
]
},
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"17"
}
},
"required":[
"feature",
"since",
"operations"
],
"additionalProperties":false
}
Nested Schema : items-x-anyOf[4]
Type: object
Show Source
{
"properties":{
"integratedReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"redirected",
"replicatedProcedures",
"ddlOperations",
"storedProcedures",
"datatypeFunctionality",
"optypeFunctionality",
"eventActions",
"databaseCompatibility",
"directTransactionRatio"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"integratedReplicat",
"since",
"operations"
],
"additionalProperties":false
}
Nested Schema : items-x-anyOf[5]
Type: object
Show Source
{
"properties":{
"coordinatedReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"averageCoordinationTime":{
"type":"string",
"minLength":"0",
"maxLength":"16"
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"ddlOperations",
"primaryKeyUpdates",
"emiTransactions",
"userDefinedBarriers",
"metadataBarriers",
"lagGap"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
},
"required":[
"coordinatedReplicat",
"since",
"operations"
],
"additionalProperties":false
}
Nested Schema : items-x-anyOf[6]
Type: object
Show Source
{
"properties":{
"parallelReplicat":{
"enum":[
true
]
},
"since":{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
},
"operations":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"invalidIndexOperations",
"splitTransactions",
"splitAvgChunks",
"splitAvgRows",
"serializeTransactions",
"largeTransactions",
"largeAvgRows",
"largeAvgChunks",
"missingDepColumns",
"nonNativeSupport",
"maxSchedulingConstraints",
"metadataBarriers",
"ddlOperations",
"sequenceOperations",
"replicatedProcedures",
"eventActions",
"storedProcedures",
"synchronous",
"errorFallback"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
},
"workloadDependencyStats":{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"foreignKeyParentRowDeletes",
"tableLevelDependencies",
"virtualColumnDependencies"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"3"
},
"tableDependencyStats":{
"type":"array",
"items":{
"properties":{
"parentTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"childTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"childTable",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
},
"tableWatermarkDependencyCounts":{
"type":"array",
"items":{
"properties":{
"parentTable":{
"description":"Table with dependency constraint",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"constraintType":{
"description":"Type of dependency constraint",
"enum":[
"VIRTUAL",
"OBJECT",
"BITMAP",
"COLUMN",
"WATERMARK"
]
},
"count":{
"description":"Times the dependency constraint has been hit",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"constraintType",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
},
"required":[
"parallelReplicat",
"since",
"operations"
],
"additionalProperties":false
}
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"mapped",
"unmapped",
"default",
"excluded"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
Nested Schema : since
Match One
Show Source
-
string
Minimum Length: 20
Maximum Length: 32
Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
Allowed Values: [
"startup"
]
{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"mapped",
"unmapped",
"default",
"excluded"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
}
Nested Schema : operation
Match One
Show Source
-
Allowed Values: [
"mapped",
"unmapped",
"default",
"excluded"
]
{
"x-oneOf":[
{
"enum":[
"mapped",
"unmapped",
"default",
"excluded"
]
}
]
}
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
{
"type":"array",
"items":{
"properties":{
"operation":{
"enum":[
"events",
"invalidations"
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
Nested Schema : since
Match One
Show Source
-
string
Minimum Length: 20
Maximum Length: 32
Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
Allowed Values: [
"startup"
]
{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"operation":{
"enum":[
"events",
"invalidations"
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
}
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"cdrConflict",
"cdrSuccess",
"cdrFailure",
"cdrConflictInsertExists",
"cdrConflictUpdateExists",
"cdrConflictUpdateMissing",
"cdrConflictDeleteExists",
"cdrConflictDeleteMissing"
]
},
{
"enum":[
"fetchAttempt",
"fetchFailed",
"fetchDup",
"fetchSnapshotByRowid",
"fetchSnapshotByKey",
"fetchByRowid",
"fetchByKey",
"fetchMissingSnapshotByRowid",
"fetchMissingSnapshotByKey",
"fetchMissingByRowid",
"fetchMissingByKey",
"fetchSnapshotInconsistent",
"fetchInconsistent",
"nofetch"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
Nested Schema : since
Match One
Show Source
-
string
Minimum Length: 20
Maximum Length: 32
Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
Allowed Values: [
"startup"
]
{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
}
Nested Schema : sourceTable
Match Any
Show Source
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : sqlexecOperations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
{
"type":"array",
"items":{
"properties":{
"name":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"attempts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"successful":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"name",
"attempts",
"successful"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
Nested Schema : targetTable
Match Any
Show Source
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"cdrConflict",
"cdrSuccess",
"cdrFailure",
"cdrConflictInsertExists",
"cdrConflictUpdateExists",
"cdrConflictUpdateMissing",
"cdrConflictDeleteExists",
"cdrConflictDeleteMissing"
]
},
{
"enum":[
"fetchAttempt",
"fetchFailed",
"fetchDup",
"fetchSnapshotByRowid",
"fetchSnapshotByKey",
"fetchByRowid",
"fetchByKey",
"fetchMissingSnapshotByRowid",
"fetchMissingSnapshotByKey",
"fetchMissingByRowid",
"fetchMissingByKey",
"fetchSnapshotInconsistent",
"fetchInconsistent",
"nofetch"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
}
Nested Schema : operation
Match Any
Show Source
-
Allowed Values: [
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
-
Allowed Values: [
"cdrConflict",
"cdrSuccess",
"cdrFailure",
"cdrConflictInsertExists",
"cdrConflictUpdateExists",
"cdrConflictUpdateMissing",
"cdrConflictDeleteExists",
"cdrConflictDeleteMissing"
]
-
Allowed Values: [
"fetchAttempt",
"fetchFailed",
"fetchDup",
"fetchSnapshotByRowid",
"fetchSnapshotByKey",
"fetchByRowid",
"fetchByKey",
"fetchMissingSnapshotByRowid",
"fetchMissingSnapshotByKey",
"fetchMissingByRowid",
"fetchMissingByKey",
"fetchSnapshotInconsistent",
"fetchInconsistent",
"nofetch"
]
-
Allowed Values: [
"conversionFailure",
"truncationFailure"
]
{
"x-anyOf":[
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"cdrConflict",
"cdrSuccess",
"cdrFailure",
"cdrConflictInsertExists",
"cdrConflictUpdateExists",
"cdrConflictUpdateMissing",
"cdrConflictDeleteExists",
"cdrConflictDeleteMissing"
]
},
{
"enum":[
"fetchAttempt",
"fetchFailed",
"fetchDup",
"fetchSnapshotByRowid",
"fetchSnapshotByKey",
"fetchByRowid",
"fetchByKey",
"fetchMissingSnapshotByRowid",
"fetchMissingSnapshotByKey",
"fetchMissingByRowid",
"fetchMissingByKey",
"fetchSnapshotInconsistent",
"fetchInconsistent",
"nofetch"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
}
Nested Schema : sourceTable-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"name":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"attempts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"successful":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"name",
"attempts",
"successful"
],
"additionalProperties":false
}
Nested Schema : name
Match Any
Show Source
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : name-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
Nested Schema : targetTable-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 17
Show Source
{
"type":"array",
"items":{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"execution"
]
},
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"17"
}
Nested Schema : since
Match One
Show Source
-
string
Minimum Length: 20
Maximum Length: 32
Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
Allowed Values: [
"startup"
]
{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"operation":{
"x-anyOf":[
{
"enum":[
"execution"
]
},
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
}
Nested Schema : operation
Match Any
Show Source
-
Allowed Values: [
"execution"
]
-
Allowed Values: [
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
-
Allowed Values: [
"conversionFailure",
"truncationFailure"
]
{
"x-anyOf":[
{
"enum":[
"execution"
]
},
{
"enum":[
"insert",
"update",
"before",
"alterBefore",
"delete",
"upsert",
"unsupported",
"drop",
"truncate",
"discard",
"ignore",
"marker",
"operations",
"insertCollision",
"updateCollision",
"deleteCollision",
"metadataRecords"
]
},
{
"enum":[
"conversionFailure",
"truncationFailure"
]
}
]
}
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"redirected",
"replicatedProcedures",
"ddlOperations",
"storedProcedures",
"datatypeFunctionality",
"optypeFunctionality",
"eventActions",
"databaseCompatibility",
"directTransactionRatio"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
Nested Schema : since
Match One
Show Source
-
string
Minimum Length: 20
Maximum Length: 32
Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
Allowed Values: [
"startup"
]
{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"redirected",
"replicatedProcedures",
"ddlOperations",
"storedProcedures",
"datatypeFunctionality",
"optypeFunctionality",
"eventActions",
"databaseCompatibility",
"directTransactionRatio"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
}
Nested Schema : operation
Match One
Show Source
-
Allowed Values: [
"transactions",
"redirected",
"replicatedProcedures",
"ddlOperations",
"storedProcedures",
"datatypeFunctionality",
"optypeFunctionality",
"eventActions",
"databaseCompatibility",
"directTransactionRatio"
]
{
"x-oneOf":[
{
"enum":[
"transactions",
"redirected",
"replicatedProcedures",
"ddlOperations",
"storedProcedures",
"datatypeFunctionality",
"optypeFunctionality",
"eventActions",
"databaseCompatibility",
"directTransactionRatio"
]
}
]
}
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"ddlOperations",
"primaryKeyUpdates",
"emiTransactions",
"userDefinedBarriers",
"metadataBarriers",
"lagGap"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
Nested Schema : since
Match One
Show Source
-
string
Minimum Length: 20
Maximum Length: 32
Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
Allowed Values: [
"startup"
]
{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"ddlOperations",
"primaryKeyUpdates",
"emiTransactions",
"userDefinedBarriers",
"metadataBarriers",
"lagGap"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
}
Nested Schema : operation
Match One
Show Source
-
Allowed Values: [
"ddlOperations",
"primaryKeyUpdates",
"emiTransactions",
"userDefinedBarriers",
"metadataBarriers",
"lagGap"
]
{
"x-oneOf":[
{
"enum":[
"ddlOperations",
"primaryKeyUpdates",
"emiTransactions",
"userDefinedBarriers",
"metadataBarriers",
"lagGap"
]
}
]
}
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"invalidIndexOperations",
"splitTransactions",
"splitAvgChunks",
"splitAvgRows",
"serializeTransactions",
"largeTransactions",
"largeAvgRows",
"largeAvgChunks",
"missingDepColumns",
"nonNativeSupport",
"maxSchedulingConstraints",
"metadataBarriers",
"ddlOperations",
"sequenceOperations",
"replicatedProcedures",
"eventActions",
"storedProcedures",
"synchronous",
"errorFallback"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"16"
}
Nested Schema : since
Match One
Show Source
-
string
Minimum Length: 20
Maximum Length: 32
Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
-
Allowed Values: [
"startup"
]
{
"x-oneOf":[
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":"20",
"maxLength":"32"
},
{
"enum":[
"startup"
]
}
]
}
Nested Schema : tableDependencyStats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
{
"type":"array",
"items":{
"properties":{
"parentTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"childTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"childTable",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
Nested Schema : tableWatermarkDependencyCounts
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
{
"type":"array",
"items":{
"properties":{
"parentTable":{
"description":"Table with dependency constraint",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"constraintType":{
"description":"Type of dependency constraint",
"enum":[
"VIRTUAL",
"OBJECT",
"BITMAP",
"COLUMN",
"WATERMARK"
]
},
"count":{
"description":"Times the dependency constraint has been hit",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"constraintType",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"2147483647"
}
Nested Schema : workloadDependencyStats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 3
Show Source
{
"type":"array",
"items":{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"foreignKeyParentRowDeletes",
"tableLevelDependencies",
"virtualColumnDependencies"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
},
"minItems":"1",
"maxItems":"3"
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"transactions",
"invalidIndexOperations",
"splitTransactions",
"splitAvgChunks",
"splitAvgRows",
"serializeTransactions",
"largeTransactions",
"largeAvgRows",
"largeAvgChunks",
"missingDepColumns",
"nonNativeSupport",
"maxSchedulingConstraints",
"metadataBarriers",
"ddlOperations",
"sequenceOperations",
"replicatedProcedures",
"eventActions",
"storedProcedures",
"synchronous",
"errorFallback"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
}
Nested Schema : operation
Match One
Show Source
-
Allowed Values: [
"transactions",
"invalidIndexOperations",
"splitTransactions",
"splitAvgChunks",
"splitAvgRows",
"serializeTransactions",
"largeTransactions",
"largeAvgRows",
"largeAvgChunks",
"missingDepColumns",
"nonNativeSupport",
"maxSchedulingConstraints",
"metadataBarriers",
"ddlOperations",
"sequenceOperations",
"replicatedProcedures",
"eventActions",
"storedProcedures",
"synchronous",
"errorFallback"
]
{
"x-oneOf":[
{
"enum":[
"transactions",
"invalidIndexOperations",
"splitTransactions",
"splitAvgChunks",
"splitAvgRows",
"serializeTransactions",
"largeTransactions",
"largeAvgRows",
"largeAvgChunks",
"missingDepColumns",
"nonNativeSupport",
"maxSchedulingConstraints",
"metadataBarriers",
"ddlOperations",
"sequenceOperations",
"replicatedProcedures",
"eventActions",
"storedProcedures",
"synchronous",
"errorFallback"
]
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"parentTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"childTable":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"childTable",
"count"
],
"additionalProperties":false
}
Nested Schema : childTable
Match Any
Show Source
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : parentTable
Match Any
Show Source
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : childTable-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
Nested Schema : parentTable-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"parentTable":{
"description":"Table with dependency constraint",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"constraintType":{
"description":"Type of dependency constraint",
"enum":[
"VIRTUAL",
"OBJECT",
"BITMAP",
"COLUMN",
"WATERMARK"
]
},
"count":{
"description":"Times the dependency constraint has been hit",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"parentTable",
"constraintType",
"count"
],
"additionalProperties":false
}
Nested Schema : parentTable
Table with dependency constraint
Match Any
Show Source
{
"description":"Table with dependency constraint",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : parentTable-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
Nested Schema : items
Type: object
Show Source
{
"properties":{
"operation":{
"x-oneOf":[
{
"enum":[
"foreignKeyParentRowDeletes",
"tableLevelDependencies",
"virtualColumnDependencies"
]
}
]
},
"count":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"operation",
"count"
],
"additionalProperties":false
}
Nested Schema : operation
Match One
Show Source
-
Allowed Values: [
"foreignKeyParentRowDeletes",
"tableLevelDependencies",
"virtualColumnDependencies"
]
{
"x-oneOf":[
{
"enum":[
"foreignKeyParentRowDeletes",
"tableLevelDependencies",
"virtualColumnDependencies"
]
}
]
}
Nested Schema : items
Type: object
Show Source
{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
}
Nested Schema : tableName
Match Any
Show Source
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : tableName-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
Nested Schema : items
Type: object
Show Source
{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
}
Nested Schema : tableName
Match Any
Show Source
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : tableName-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
Nested Schema : items
Type: object
Show Source
{
"type":"object",
"properties":{
"upserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"truncates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"tableName":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
},
"updates":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"inserts":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"$schema":{
"enum":[
"ogg:distPathTableStats"
]
},
"deletes":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrReceived":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"lcrSent":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
},
"other":{
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000"
}
},
"required":[
"tableName",
"lcrReceived",
"lcrSent"
],
"additionalProperties":false
}
Nested Schema : tableName
Match Any
Show Source
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}
]
}
Nested Schema : tableName-x-anyOf[1]
Match Any
Show Source
-
string
Minimum Length: 3
Maximum Length: 261
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
-
string
Minimum Length: 5
Maximum Length: 392
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"3",
"maxLength":"261"
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"5",
"maxLength":"392"
}
]
}