Accelerator Statistics Detail
Depending on the version of the Analytics Accelerator that you are using, the information about the activity of a specified Analytics Accelerator is different. The version number of the Analytics Accelerator is displayed in the Product ID field.
Accelerator Detail
If the product ID is lower than AQT04010, the Accelerator Detail panel is displayed. It might look like this:
________________ ZACSD VTM O2 V540./C DA31 03/25/13 16:58:59 2
> Help PF1 Back PF3 Up PF7 Down PF8
> R.N
===============================================================================
> Accelerator Detail
ACSD
+ Collection Interval: REALTIME Start: 03/25 16:49:04
+ Report Interval: 10 min End: 03/25 16:58:59
+
+ Name = VMNPS52
+ State = ONLINE
+ Product ID = AQT03010
+ Curr Active Requests = 0
+ Max Active Requests = 4
+ Avg Coord CPU = 30.00%
+ Avg Worker CPU = .00%
+ Total Num Processors = 8
+ Processing Capacity = 0
+ Act Worker Nodes = 2
+ Avg Queue Wait Time (MS) = 47
+ Max Queue Wait Time (MS) = 141
+ Query Queue Len 3 HR Avg = 0
+ Query Queue Len 24 HR Avg = 0
+ Max Query Queue Len = 0
+ Avail Disk (MB) = 195426
+ DB Disk Avail (MB) = 288
+ In-use Disk = .21%
+
+ TOTAL INTERVAL /SECOND
+ QUANTITY QUANTITY ( 594)
+ -------- -------- -------
+ Query Reqs Since Start 61 2 .00
+ Failed Reqs Since Start 1 0 .00
+ Failed Reqs Inv State 0 0 .00
+ Total Num Accel Connects 62 2 .00
+ Total Num Accel Requests 124 4 .00
+ Total Timed out Reqs 0 0 .00
+ Total Failed Reqs 0 0 .00
+ Num Bytes Sent 172758 6242 10.50
+ Num Bytes Received 33810260 3679800 6194.94
+ Num Msgs Sent 682 22 .03
+ Num Msgs Received 706 24 .04
+ Num Blocks Sent 0 0 .00
+ Num Blocks Received 62 2 .00
+ Num Rows Sent 0 0 .00
+ Num Rows Received 90854 10104 17.01
+
+
+ Time Data
+ TOTAL INTERVAL
+ QUANTITY QUANTITY
+---------------------------------------------------------------------------
+ TCP/IP Services Elapsed Time 0.000000 0.000000
+ CPU Time Executing SQL Stmts 0.000000 0.000000
+ CPU Time for Replication N/P N/P
+ CPU Time Load/Archive/Restore 0.000000 0.000000
+ Accel Elapsed Time 0.000000 0.000000
+ Accum Wait Time 0.000000 0.000000
+
===============================================================================
Navigation
For more information about
Fields
- Collection Interval
- The value REALTIME indicates that the collection interval and the report interval are the same.
- Start
- The start time of the report interval that is currently displayed.
- Report Interval
- The amount of time in the last cycle, for example, the time inbetween the Enter key was pressed twice.
- End
- The end time of the report interval that is currently displayed.
- Name (Q8STNAME)
- The name of the Accelerator.
- State (Q8STTATE)
- The current state of the Accelerator. The following list shows the values for the
state:
INITIALIZED INITING ONLINE PAUSED OFFLINE STOPPED MAINTENANCE - Product ID (Q8STPRID)
- The internal product ID. It includes the version of the Accelerator.
- Curr Active Requests
- The number of requests that are currently processed on the Accelerator.
- Max Active Requests
- The high water mark of concurrent active requests on the Accelerator.
- Avg Coord CPU
- The average percentage of the time that the CPU is busy for the Accelerator coordinator node.
- Avg Worker CPU
- The average percentage of the time that the CPU is busy for the Accelerator worker node.
- Total Num Processors
- The total number of processors for all the nodes in the Accelerator.
- Processing Capacity
- The total capacity of the processors in the Accelerator.
- Act Worker Nodes
- The number of worker nodes that are defined in the Accelerator.
- Avg Queue Wait Time (MS)
- The average time that a query is queued in the Accelerator.
- Max Queue Wait Time (MS)
- The maximum time that a query is queued in the Accelerator.
- Query Queue Len 3 HR Avg
- The average length of a queue during the past 3 hours.
- Query Queue Len 24 HR Avg
- The average length of a queue during the past 24 hours.
- Max Query Queue Len
- The maximum queue time a query is queued.
- Avail Disk (MB)
- The amount of disk space that is available on Accelerator.
- DB Disk In Use (MB)
- The amount of disk space that is used by database objects.
- In-use Disk
- The percentage of disk space that is used.
The following statistics are displayed for the fields below in tabular format:
- TOTAL QUANTITY
- The amount of activity since Db2 was started.
- INTERVAL QUANTITY
- The amount of activity during the last cycle.
- / SECOND (594)
- The rate per second during the last cycle. The value in parentheses indicates the number of seconds in the interval.
- Successful Requests
- The number of query requests sent by this Db2 that are successfully completed since the Accelerator is started.
- Failed Reqs Since Start
- The number of query requests that are sent by this Db2 since the Accelerator is started that failed for any reason.
- Failed Reqs Inv State
- The number of query requests that are sent by this Db2 since the Accelerator is started that failed because the Accelerator is in an invalid state. This value is a subset of the value in the field Failed Reqs Since Start.
- Total Num Accel Connects
- The number of connections that are started between this DB2 subsystem and the Accelerator.
- Total Num Accel Requests
- The number of requests that are sent to the Accelerator from this DB2 subsystem.
- Total Timed Out Reqs
- The number of requests that failed due to a timeout while waiting for the Accelerator.
- Total Failed Reqs
- The total number of failed Accelerator requests. This number includes any timeout errors.
- Num Bytes Sent
- The count of bytes of data that is sent to the Accelerator.
- Num Bytes Received
- The count of bytes of data that is received from the Accelerator.
- Num Messages Sent
- The count of messages that are sent to the Accelerator.
- Num Messages Received
- The count of messages that are received from the Accelerator.
- Num Blocks Sent
- The count of blocks that are sent to the Accelerator.
- Num Blocks Received
- The count of blocks that are received from the Accelerator.
- Num Rows Sent
- The count of data rows that are sent to the Accelerator.
- Num Rows Received
- The count of data rows that are received from the Accelerator.
The following statistics are displayed for the fields below in tabular format:
- Total Times
- The amount of time that is consumed since the Accelerator is activated.
- Interval Times
- The amount of time that is consumed in the current interval.
These are the fields for which the statistics above are displayed:
- In DB2 CPU Time
- The CPU time that is consumed within the Analytics Accelerator.
- TCP/IP Services Elapsed Time (Q8STTELA)
- The total elapsed time from the time Db2 started to process requests until the requests are complete
- Accel CPU Time (Q8STACPU)
- This is the CPU time consumed within the Accelerator device.
- Accel Elapsed Time (Q8STAELA)
- The total elapsed time that the thread is processed on the Accelerator. The Accelerator time is a subset of the In-DB2 time.
- Accum Wait Time (Q8STAWAT)
- The total wait time within the Accelerator.
Accelerator Detail Subsystem Perspective
If the product ID is greater than or equal to AQT04010, the Accelerator Detail
Subsystem Perspective panel is displayed. It shows information from the perspective of the
individual DB2 subsystem. It might look like
this:
________________ ZZID4 VTM O2 V540./C DB51 S 01/29/15 14:45:49
> Help PF1 Back PF3 Up PF7 Down PF8
>
> *-DB2 PERSPECTIVE B-ACCEL PERSPECTIVE
=============================================================================
> Version 4 Accelerator Detail Subsystem Perspective
ZID4
+
+ Collection Interval: REALTIME Start: 01/29/15 13:45:26.13
+ Report Interval: 23 sec End: 01/29/15 13:45:49.26
+
+
+ Name VMNPS52
+ State ONLINE
+ Product ID AQT04012
+ Server Start Time 01/19/15 02:48:10.63
+ Status Change Time 01/19/15 02:48:10.67
+ Curr Active Queries 0
+ Max Active Queries 0
+ Replication State STARTED
+ Replication Latency 0.000000
+ Replication Status Change 01/26/15 18:30:11.67
+ Replication Velocity 1.000549
+ Disk In Use This DB2 (MB) 204
+ Current Queue Len Db2 0
+ WAITFORDATA Success Db2 20
+ WAITFORDATA Expired Db2 32
+
+ TOTAL INTERVAL /SECOND
+ QUANTITY QUANTITY ( 23)
+------------------------------------------------------------------------
+ Successful Requests 0 0 0
+ Failed Requests 0 0 0
+ Total Num Accel Connects 0 0 0
+ Total Num Accel Requests 0 0 0
+ Total Timed Out Reqs 0 0 0
+ Total Failed Reqs 0 0 0
+ Number Bytes Sent 0 0 0
+ Number Bytes Received 0 0 0
+ Number Msgs Sent 0 0 0
+ Number Msgs Received 0 0 0
+ Number Blocks Sent 0 0 0
+ Number Blocks Recieved 0 0 0
+ Number Rows Sent 0 0 0
+ Number Rows Received 0 0 0
+
+ Replication Data
+ TOTAL INTERVAL /SECOND
+ QUANTITY QUANTITY ( 23)
+------------------------------------------------------------------------
+ Log Records Read 387086 0 0
+ Log Records Read Accel Tables 387086 0 0
+ Log Records Bytes Processed 25547808 0 0
+ Rows Inserted Accel Tables 0 0 0
+ Rows Updated Accel Tables 0 0 0
+ Rows Deleted Accel Tables 0 0 0
+
+ Time Data
+ TOTAL INTERVAL
+ QUANTITY QUANTITY
+------------------------------------------------------------------------
+ TCP/IP Services Elapsed Time 0.000000 0.000000
+ CPU Time Executing Queries 0.000000 0.000000
+ CPU Time for Replication 4.189145 N/P
+ CPU Time Load/Archive/Restore 0.050000 0.000000
+ Accel Elapsed Time 0.000000 0.000000
+ Accum Wait Time 0.000000 0.000000
+
+ Statements Sent to Accelerator
+ TOTAL INTERVAL /SECOND
+ QUANTITY QUANTITY ( 3)
+---------------------------------------------------------------------------
+ INSERT 0 0 0
+ UPDATE 0 0 0
+ DELETE 0 0 0
+ DROP 0 0 0
+ CREATE 0 0 0
+ COMMIT 0 0 0
+ ROLLBACK 0 0 0
+ OPEN 0 0 0
===============================================================================
Navigation
For more information about
- an aggregation of accelerator details of all DB2 subsystems that are connected to the Analytics Accelerator, select the option B-ACCELERATOR PERSPECTIVE.
- related topics, select one of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- Collection Interval
- The value REALTIME indicates that the collection interval and the report interval are the same.
- Start
- The start time of the report interval that is currently displayed.
- Report Interval
- The amount of time in the last cycle, for example, the time inbetween the Enter key was pressed twice.
- End
- The end time of the report interval that is currently displayed.
- Name (Q8STNAME)
- The name of the Accelerator.
- State (Q8STTATE)
- The current state of the Accelerator. The following list shows the values for the
state:
INITIALIZED INITING ONLINE PAUSED OFFLINE STOPPED MAINTENANCE - Product ID (Q8STPRID)
- The internal product ID. It includes the version of the Accelerator.
- Server Start Time (Q8STTART)
- The time the Accelerator server process is started.
- Status Change Time (Q8STTATC)
- The time the last status change is recorded.
- Curr Active Queries (Q8STNCQS)
- The number of queries that are processed currently on behalf of this DB2.
- Max Active Queries (Q8STMNQS)
- The maximum number of concurrent queries that are processed on behalf of this DB2.
- Replication State (Q8STCSS)
- The state of replication processing for this DB2.
- Replication Latency (Q8STCRL)
- The replication latency for this DB2.
- Replication Status Change (Q8STTLSC)
- The time the last replication status change is recorded.
- Replication Velocity (Q8STVLCS)
- Replication velocity of this Db2 subsystem. Replication velocity is measured in Db2 log seconds replicated per second to the Accelerator. The value in this field is in microseconds. For external use, convert the value to seconds. This value might be negative if replication for the Accelerator is stopped, or if replication information for the Accelerator is not yet available.
- Disk in Use This DB2 (Q8STDSKB)
- The amount of disk space that is used by database objects.
- Current Queue Len Db2 (Q8STCQLS)
- The current queue length at the accelerator back-end for this Db2 subsystem.
- WAITFORDATA Success Db2 (Q8STTDPS)
- Total number of successful query requests that were sent by this Db2 subsystem to the accelerator, and were run with the WAITFORDATA delay protocol.
- WAITFORDATA Expired Db2 (Q8STEDPS)
- Total number of query requests that were sent by this Db2 subsystem to the accelerator, were run with the WAITFORDATA delay protocol, and expired because the total wait time was greater than the specified WAITFORDATA value.
The following statistics are displayed for the fields below in tabular format:
- TOTAL QUANTITY
- The amount of activity since the Accelerator is activated.
- INTERVAL QUANTITY
- The amount of activity during the last cycle.
- /SECOND (1)
- The rate per second during the last cycle. The value in parentheses indicates the number of seconds in the interval.
These are the fields for which the statistics above are displayed:
- Successful Requests (Q8STSREQ)
- The number of query requests sent by this DB2 since the Accelerator is started that completed successfully.
- Failed Requests (Q8STFREQ)
- The number of query requests sent by this DB2 since the Accelerator is started that failed for any reason.
- Total Num Accel Connects (Q8STCONN)
- The number of connections that are started between this DB2 subsystem and the Accelerator.
- Total Num Accel Requests (Q8STREQ )
- The number of requests that are sent to the Accelerator from this DB2 subsystem.
- Total Timed Out Reqs (Q8STTOUT)
- The number of requests that failed due to a timeout waiting for the Accelerator.
- Total Failed Reqs (Q8STFAIL)
- The total number of failed Accelerator requests. This number includes any timeout errors.
- Number Bytes Sent
- The number of bytes of data that is sent to the Accelerator.
- Number Bytes Received (Q8STBYTR)
- The number of bytes that are received.
- Number Messages Sent (Q8STMSGS)
- The number of messages that are sent to the Accelerator.
- Number Messages Received (Q8STMSGR)
- The number of messages that are received from the Accelerator.
- Number Blocks Sent (Q8STBLKS)
- The number of blocks that are sent to the Accelerator.
- Number Blocks Received (Q8STBLKR)
- The number of blocks that are received by the Accelerator.
- Number Rows Sent (Q8STROWS)
- The number of data rows that are sent to the Accelerator.
- Number Rows Received (Q8STROWR)
- The number of data rows that are received by the Accelerator.
The following set of statistic fields is related to replication processing.
If replication is not configured for this Accelerator, these fields are not displayed.
- Log Records Read (Q8STNLRS)
- The total number of log records that is read by capture agents on this DB2.
- Log Records Read Accel Tables (Q8STNLTS)
- The number of log records that are read by capture agents on this DB2 for tables that reside in this Accelerator.
- Log Record Bytes Processed (Q8STNBS)
- The number of bytes that are processed by capture agents for this DB2.
- Rows Inserted Accel Tables (Q8STNIS)
- The number of inserted rows that are processed by capture agents on this DB2 for tables that reside in this Accelerator.
- Rows Updated Accel Tables (Q8STNUS)
- The number of updated rows that are processed by capture agents on this DB2 for tables that reside in this Accelerator.
- Rows Deleted Accel Tables (Q8STNDS)
- The number of inserted rows that are processed by capture agents on this DB2 for tables that reside in this Accelerator.
The following statistics are displayed for the fields below in tabular format:
- TOTAL QUANTITY
- The amount of time that is consumed since the Accelerator is activated.
- INTERVAL QUANTITY
- The amount of time that is consumed in the current interval.
- TCP/IP Services Elapsed Time (Q8STTELA)
- The total elapsed time from the time DB2 started to process a request until the time the request is completed.
- CPU Time Executing Queries (Q8STTCQS)
- The CPU time that is consumed by the Analytics Accelerator for processing queries.
- CPU Time for Replication (Q8STTCCS)
- The CPU time that is consumed by the Analytics Accelerator for replication.
- CPU Time for Load/Archive/Restore (Q8STTCMS)
- The CPU time that is consumed by the Analytics Accelerator for maintenance.
- Accel Elapsed Time (Q8STAELA)
- The total elapsed time that the thread is processed on the Analytics Accelerator. The Accelerator time is a subset of the In DB2 time.
- Accum Wait Time (Q8STAWAT)
- The total wait time within the Analytics Accelerator.
Statements sent to Accelerator
- Insert
- The number of Insert statements issued for IDT (Q8STINSC) objects from DB2 to the accelerator.
- Update
- The number of Update statements issued for IDT (Q8STUPDC) objects from DB2 to the accelerator.
- Delete
- This is the number of Delete statements issued for IDT (Q8STDELC) objects from DB2 to the accelerator.
- Drop
- The number of Drop statements issued for IDT (Q8STDRPC) objects from DB2 to the accelerator.
- Create
- The number of Create statements issued for IDT (Q8STCRTC) objects from DB2 to the accelerator.
- Commit
- The number of Commit statements issued for IDT (Q8STCMTC) objects from DB2 to the accelerator.
- Rollback
- This is the number of Rollback statements issued for (Q8STRBKC) IDT objects from DB2 to the accelerator.
- Open
- The number of Open statements issued for IDT (Q8STOPNC) objects from DB2 to the accelerator.
Accelerator Detail Accelerator Perspective
This panel displays detailed information that is aggregated across all DB2 subsystems that are
connected to the Analytics
Accelerator.
________________ ZZIDP VTM O2 V540./C DB51 S 01/29/15 14:48:15 2
> Help PF1 Back PF3 Up PF7 Down PF8
>
> A-DB2 PERSPECTIVE *-ACCEL PERSPECTIVE
================================================================================
> Version 4 Accelerator Detail Accelerator Perspective
ZIDP
+
+ Collection Interval: REALTIME Start: 01/29/15 13:48:09.50
+ Report Interval: 5 sec End: 01/29/15 13:48:15.11
+
+
+ Name VMNPS52
+ State ONLINE
+ Product ID AQT04012
+ Server Start Time 01/19/15 02:48:10.63
+ Status Change Time 01/19/15 02:48:10.67
+ Curr Active Queries 0
+ Max Active 6
+ Avg Coord CPU 3.99
+ Avg Worker CPU 0.00
+ Total Num Processors N/P
+ Act Worker Nodes N/P
+ Current Queue Length 0
+ Max Queue Length 0
+ Avg Queue Wait Time (MS) 0.003623
+ Max Queue Wait Time (MS) 0.011989
+ Disk Space for All DB2 (MB) N/P
+ Disk In Use All DB2 (MB) N/P
+ In-Use TEMP Data (MB) 0
+ In-Use LOG Data (MB) 976
+ Mem Avail User Data (MB) 1295
+ Mem Avail User Reqs (MB) 3258
+ Sort Overflows 0
+ Buffer Pool Hit Ratio 99.99
+ Transfer Rate In (KB/S) 1
+ Transfer Rate Out(KB/S) 1
+ WAITFORDATA Successful 20
+ WAITFORDATA Expired 32
+ Log Reader CPU Time 0.273891
+ Log Reader zIIP Time 27.440887
+ Log Reader zIIP Eligible Time 0.358064
+
+ TOTAL INTERVAL /SECOND
+ QUANTITY QUANTITY ( 5)
+------------------------------------------------------------------------
+ Successful Requests 98301 0 0
+ Failed Reqs Since Start 0 0 0
+
+ Replication Data
+ TOTAL INTERVAL /SECOND
+ QUANTITY QUANTITY ( 5)
+------------------------------------------------------------------------
+ Log Records Read 391902 391902 78380.40
+ Log Records Read Accel Tables 388444 388444 77688.80
+ Log Records Bytes Processed 25637304 25637304 5127.46K
+ Rows Inserted Accel Tables 0 0 0
+ Rows Updated Accel Tables 0 0 0
+ Rows Deleted Accel Tables 0 0 0
+
+ Time Data
+ TOTAL INTERVAL
+ QUANTITY QUANTITY
+------------------------------------------------------------------------
+ CPU Time Executing Queries 2:00:34.930000 0.000000
+ CPU Time for Replication 31.955084 31.955084
+ CPU Time Load/Archive/Restore 2:10.300000 0.000000
================================================================================Navigation
For more information about
- the activity in the specified Analytics Accelerator, select the option A-DB2 PERSPECTIVE.
- related topics, select one of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- Collection Interval
- The value REALTIME indicates that the collection interval and the report interval are the same.
- Start
- The start time of the report interval that is currently displayed.
- Report Interval
- The amount of time in the last cycle, for example, the time inbetween the Enter key was pressed twice.
- End
- The end time of the report interval that is currently displayed.
- Name (Q8STNAME)
- The name of the Accelerator.
- State (Q8STTATE)
- The current state of the Accelerator. The following list shows the values for the
state:
INITIALIZED INITING ONLINE PAUSED OFFLINE STOPPED MAINTENANCE - Product ID (Q8STPRID)
- The internal product ID. It includes the version of the Accelerator.
- Server Start Time (Q8STTART)
- The time the Accelerator server process is started.
- Status Change Time (Q8STTATC)
- The time the last status change is recorded.
- Curr Active Queries (Q8STNCQS)
- The number of queries that are processed currently on behalf of this DB2.
- Max Active Queries (Q8STMNQS)
- The maximum number of concurrent queries that are processed on behalf of this DB2.
- Avg Coord CPU (Q8STCCPU_64)
- The utilization of the CPU on the coordinator node.
- Avg Worker CPU (Q8STWCPU_64)
- The utilization of the CPU on worker nodes.
- Total Num Processors (Q8STCORS)
- The total number of CPU cores that are available for worker nodes.
- Act Worker Nodes (Q8STWNOD_64)
- The number of nodes that are active.
- Current Queue Length (Q8STCQL)
- The length of the waiting work queue.
- Max Queue Length
- The high watermark of the query queue length at the accelerator.
- Avg Queue Wait Time (MS) (Q8STQUEW)
- The average waiting time in a work queue.
- Max Queue Wait Time (MS)
- The maximum waiting time in a work queue.
- Disk Space for All DB2 (MB) (Q8STDSKA)
- The storage that is available on the disk.
- Disk In Use All DB2 (MB) (Q8STDSA)
- The total disk space that is used in all databases.
- In-Use TEMP Data (MB) (Q8STTSA)
- Amount of disk space, in megabytes, across all Db2 subsystems, for temporary data.
- In-Use LOG Data (MB) (Q8STLSA)
- Amount of disk space, in megabytes, across all Db2 subsystems, for log data.
- Mem Avail User Data (MB) (Q8STTMUD)
- Total amount of memory that is configured for buffer pools, across all worker nodes, in megabytes. This value is the amount of memory that is available for user data.
- Mem Avail User Reqs (MB) (Q8STTMPS)
- Total amount of memory that is available for processing SQL queries or data manipulation language statements in the Accelerator, in megabytes.
- Sort Overflows (Q8STOFLW)
- The number of sort overflows at the Accelerator back-end. A sort overflow occurs when an SQL statement can not be processed entirely in memory.
- Buffer Pool Hit Ratio (Q8STABHR)
- The accelerator buffer pool hit ratio. This value is the buffer pool hit ratio for all work that the Accelerator performs on behalf of currently paired Db2 subsystems.
- Transfer Rate In (KB/S) (Q8STANUI)
- Current inbound transfer rate for data transmitted through a network interface between the Accelerator and Db2, in kilobytes per second.
- Transfer Rate Out (KB/S) (Q8STANUO)
- Current outbound transfer rate for data transmitted through a network interface between the Accelerator and Db2, in kilobytes per second.
- WAITFORDATA Successful (Q8STTDPA)
- Total number of successful query requests that were sent by all Db2 subsystems to the Accelerator, and were run with the WAITFORDATA delay protocol.
- WAITFORDATA Expired (Q8STEDPA)
- Total number of query requests that were sent by all Db2 subsystems to the accelerator, were run with the WAITFORDATA delay protocol, and expired because the total wait time was greater than the specified WAITFORDATA value.
- Log Reader CPU Time (Q8STLRCP)
- CPU time used by Integrated Synchronization asynchronous log reader task on behalf of this accelerator. (Db2 V12 and later)
- Log Reader zIIP Time (Q8STLRZI)
- zIIP time used by Integrated Synchronization asynchronous log reader task on behalf of this accelerator. (Db2 V12 and later)
- Log Reader zIIP Eligible Time (Q8STLRZE)
- zIIP eligible time for Integrated Synchronization asynchronous log reader task on behalf of this accelerator. (Db2 V12 and later)
The following statistics are displayed for the fields below in tabular format:
- TOTAL QUANTITY
- The amount of activity since Db2 was started.
- INTERVAL QUANTITY
- The amount of activity during the last cycle.
- / SECOND (594)
- The rate per second during the last cycle. The value in parentheses indicates the number of seconds in the interval.
- Successful Requests
- The number of query requests sent by this Db2 that are successfully completed since the Accelerator is started.
- Failed Reqs Since Start
- The number of query requests that are sent by this Db2 since the Accelerator is started that failed for any reason.
The following set of statistic fields is related to replication processing.
If replication is not configured for this Accelerator, these fields are not displayed.
- Log Records Read (Q8STNLRS)
- The total number of log records that is read by capture agents on this DB2.
- Log Records Read Accel Tables (Q8STNLTS)
- The number of log records that are read by capture agents on this DB2 for tables that reside in this Accelerator.
- Log Record Bytes Processed (Q8STNBS)
- The number of bytes that are processed by capture agents for this DB2.
- Rows Inserted Accel Tables (Q8STNIS)
- The number of inserted rows that are processed by capture agents on this DB2 for tables that reside in this Accelerator.
- Rows Updated Accel Tables (Q8STNUS)
- The number of updated rows that are processed by capture agents on this DB2 for tables that reside in this Accelerator.
- Rows Deleted Accel Tables (Q8STNDS)
- The number of inserted rows that are processed by capture agents on this DB2 for tables that reside in this Accelerator.
The following statistics are displayed
for the fields below in tabular format:
- TOTAL QUANTITY
- The amount of time that is consumed since the Accelerator is activated.
- INTERVAL QUANTITY
- The amount of time that is consumed in the current interval.
- CPU Time Executing Queries (Q8STTCQS)
- The CPU time that is consumed by the Analytics Accelerator for processing queries.
- CPU Time for Replication (Q8STTCCS)
- The CPU time that is consumed by the Analytics Accelerator for replication.
- CPU Time for Load/Archive/Restore (Q8STTCMS)
- The CPU time that is consumed by the Analytics Accelerator for maintenance.