Batch SQL Statistics

Name	Value
Documentation	Retrieve an existing Integrated Replicat Batch SQL Statistics
Process Type(s)	Replicat
Endpoint	/services/v2/mpoints/{item}/batchSqlStatistics
JSON Schema	mpoints:batchSqlStatistics
Base Name	batch-sql-stats
Internal Name	MPL_BATCHSQL_STATS

Tag	Description
deploymentName	The name of the OGG Microservices deployment
deploymentId	The unique identity of the OGG Microservices deployment
processType	The type of process
processName	The name of the process

Metric	Data Type	Description
total-batch-operations	integer	Total Batch Operations
total-batches	integer	Total Batches
total-batch-executions	integer	Total Batch Executions
sql-queues	integer	SQL Queues
total-batches-in-error	integer	Total Batches in Error
total-normal-mode-operations	integer	Total Normal Mode Operations
total-primary-key-collisions	integer	Total Primary Key Collisions
total-foreign-key-collisions	integer	Total Foreign Key Collisions
total-unique-key-collisions	integer	Total Unique Key Collisions
total-operation-flushes	integer	Total Operation Flushes
total-plu-flushes	integer	Total PLU Flushes
number-of-batch-thread-groups	integer	Number of Batch Thread Groups
total-commits integer Total Commits	integer	Total Commits
total-flushes	integer	Total Flushes
total-rollbacks	integer	Total Rollbacks
last-timestamp	integer	Last Operation Timestamp
total-elapsed-time	integer	Total Elapsed Batch Time
total-insert-time	integer	Total Insert Time
total-update-time	integer	Total Update Time
total-delete-time	integer	Total Delete Time