DSNX830I csect-name

Explanation

This message displays output from the DISPLAY ACCEL command.

csect-name

The name of the control section that issued the message.

The output provides the following information about the accelerator server or servers:

ACCELERATOR                      MEMB  STATUS  REQUESTS ACTV QUED MAXQ
-------------------------------- ---- -------- -------- ---- ---- ----
text                             text text          num  num  num  num

For data sharing, the list of accelerator servers are grouped by member. The list for each member, other than the first list, begins with a DSN9035I message.

ACCELERATOR

The name of the accelerator server.

MEMB

The name of the Db2 data-sharing member.

STATUS

The status of the accelerator server. The status can be any of the following values:

STARTED

The accelerator server is able to accept requests.

STARTEXP

The accelerator server was started with the EXPLAINONLY option and is available only for EXPLAIN requests.

STARTMNT

The accelerator server was started with the ACCESS(MAINT) option and is available only to installation SYSADM and installation SYSOPR.

STOPPEND

The accelerator server is no longer accepting new requests. Active accelerator threads are allowed to complete normally, and queued accelerator threads are terminated. The accelerator server was placed in this status by the STOP ACCEL MODE(QUIESCE) command.

STOPPED

The accelerator server is not active. New requests for the accelerator are rejected. The accelerator server was placed in this status by the STOP ACCEL command.

STOPERR

The accelerator server is not active. The accelerator server was placed in this status by an error condition. New requests for the accelerator are rejected.

REQUESTS

The number of query requests that have been processed successfully for this Db2 system.

ACTV

The current number of active, accelerated requests for this Db2 system.

QUED

The current number of queued requests.

MAXQ

The highest number of queued requests that have been reached since the accelerator was started.

Detailed output

If the DISPLAY ACCEL command is issued with the DETAIL option, the following additional information is provided about the accelerator server. With multiple accelerators, Db2 issues a separate DSNX830I message for each accelerator, and each message ends with either DISPLAY ACCEL REPORT CONTINUED, or DISPLAY ACCEL REPORT COMPLETE for the last accelerator.

LOCATION=text heartbeat-status
DETAIL STATISTICS
  LEVEL  = text
  STATUS = text
  FAILED REQUESTS                                          =      num
  AVERAGE QUEUE WAIT                                       =      num MS 
  MAXIMUM QUEUE WAIT                                       =      num MS  
  TOTAL NUMBER OF ACTIVE PROCESSORS                        =      num
  AVERAGE CPU UTILIZATION ON COORDINATOR NODES             =      num %
  AVERAGE CPU UTILIZATION ON WORKER NODES                  =      num %
  AVERAGE DISK IO UTILIZATION                              =      num %
  NUMBER OF ACTIVE WORKER NODES                            =      num
  TOTAL DISK STORAGE                                       =      num MB
  DISK STORAGE IN USE FOR THIS DB2 SYSTEM                  =      num MB
  DISK STORAGE IN USE FOR ALL DB2 SYSTEMS                  =      num MB
  TOTAL CPU FOR REQUESTS FOR THIS DB2 SYSTEM               =      num MS
  TOTAL CPU FOR DATA MAINTENANCE FOR THIS DB2 SYSTEM       =      num MS
  TOTAL CPU FOR REPLICATION FOR THIS DB2 SYSTEM            =      num MS
  TOTAL MEMORY AVAILABLE FOR USER DATA                     =      num MB
  TOTAL MEMORY AVAILABLE FOR SQL PROCESSING                =      num MB
  INBOUND NETWORK UTILIZATION OF THE ACCELERATOR           =      num KB
                                                              PER SECOND
  OUTBOUND NETWORK UTILIZATION OF THE ACCELERATOR          =      num KB
                                                              PER SECOND
  CURRENT REPLICATION LATENCY FOR THIS DB2 SYSTEM          =      num MS
  NUMBER OF SUCCESSFUL QUERY REQUESTS WITH DELAY PROTOCOL      
       FOR ALL DB2 SUBSYSTEMS                              =      num
  NUMBER OF EXPIRED QUERY REQUESTS WITH DELAY PROTOCOL      
       FOR ALL DB2 SUBSYSTEMS                              =      num
  REPLICATION VELOCITY                                     =      num

LOCATION

The location name of the accelerator server as specified in table SYSACCEL.SYSACCELERATORS.

heartbeat-status

The health status of the accelerator server. The status can be any of the following values:

HEALTHY

The accelerator server is accepting and processing requests.

BUSY

The accelerator server is processing requests, but it is not accepting new requests.

FLATLINE

The accelerator server is not responding.

AUTHFAIL

Db2 and the accelerator server could not establish the credentials that are required to communicate with each other. The accelerator server did not accept the value of the ACCELERATORAUTHTOKEN column in the SYSACCELERATORS table for this accelerator.

DDFFAIL

A DDF problem occurred during connection to the accelerator server. Messages on the z/OS® console that begin with DSNL provide information for resolving the problem.

LEVEL

The product level of the accelerator.

STATUS

The status of the accelerator server. For IBM IBM® Db2 Analytics Accelerator for z/OS, Version 4 and later, the status can be any of the following values:

INITIALIZING

The system is still initializing. The accelerator server is not ready for use.

ONLINE

The accelerator server is operational and ready for use.

OFFLINE

The accelerator server is offline and not operational.

MAINTENANCE

The accelerator server is in maintenance mode and is not operational.

UNKNOWN

The accelerator server is in an error state and is not operational.

For IBM Db2 Analytics Accelerator for z/OS, Version 3 and earlier, the status can be any of the following values:

• INITIALIZED
• ONLINE
• PAUSED
• OFFLINE
• STOPPED
• MAINTENANCE
• DOWN
• UNKNOWN

FAILED REQUESTS

The number of failed requests for the accelerator.

AVERAGE QUEUE WAIT

The length of the average queue wait time within the accelerator, measured in milliseconds.

MAXIMUM QUEUE WAIT

The length of the maximum queue wait time within the accelerator, measured in milliseconds.

TOTAL NUMBER OF ACTIVE PROCESSORS

The number of active processors within the accelerator. For a multi-core processor, each core is counted as a separate processor.

AVERAGE CPU UTILIZATION ON COORDINATOR NODES

Average processor utilization for coordinator node in this accelerator server. This value is a number in the range 0.00-100.00, where 0.00 indicates that all processors are idle, and 100.00 means that all processors are fully used.

This value does not represent the current state of processor utilization, but rather the average utilization within the last 60 seconds. The returned value is the average, calculated over all coordinator nodes within the accelerator since startup.

AVERAGE CPU UTILIZATION ON WORKER NODES

The average processor utilization for worker nodes in this accelerator server. This value is a number in the range 0.00-100.00, where 0.00 indicates that all processors are idle, and 100.00 means that all processors are fully used.

This value does not represent the current state of processor utilization, but rather the average utilization within the last 60 seconds. The returned value is the average, calculated over all worker nodes within the accelerator since startup.

AVERAGE DISK IO UTILIZATION

The average I/O disk utilization of the worker nodes in this accelerator server. This value is the percentage of the available I/O channels and resources that are being used.

NUMBER OF ACTIVE WORKER NODES

The number of active worker nodes in the accelerator.

TOTAL DISK STORAGE

The total amount of disk storage that is available in the accelerator, measured in megabytes (MB).

DISK STORAGE IN USE FOR THIS Db2 SYSTEM

The amount of disk storage that is being used by this Db2 subsystem within the accelerator, measured in megabytes (MB).

DISK STORAGE IN USE FOR ALL Db2 SYSTEMS

The amount of disk storage that is being used by all of the connected Db2 subsystems within the accelerator, measured in megabytes (MB).

TOTAL CPU FOR REQUESTS FOR THIS Db2 SYSTEM

The total processor time that is associated with running requests in the accelerator for this Db2 system.

TOTAL CPU FOR DATA MAINTENANCE FOR THIS Db2 SYSTEM

The total processor time for data maintenance operations in the accelerator for this Db2 system.

TOTAL CPU FOR REPLICATION FOR THIS Db2 SYSTEM

The total processor time that is associated with the replication apply process in the accelerator for this Db2 system.

TOTAL MEMORY AVAILABLE FOR USER DATA

The amount of memory, in MBs, that is configured for buffer pools across all worker nodes, as opposed to the physical memory of the accelerator.

TOTAL MEMORY AVAILABLE FOR SQL PROCESSING

The amount of memory, in MBs, that is available for processing SQL statements in the accelerator.

INBOUND NETWORK UTILIZATION OF THE ACCELERATOR

The amount of network usage, in KB per second, that is being consumed to service inbound requests to the accelerator.

OUTBOUND NETWORK UTILIZATION OF THE ACCELERATOR

The amount of network usage, in KB per second, that is consumed to return query results from the accelerator.

CURRENT REPLICATION LATENCY FOR THIS DB2 SYSTEM

The current replication latency, in MS, for the Db2 subsystem.

NUMBER OF SUCCESSFUL QUERY REQUESTS WITH DELAY PROTOCOL FOR ALL DB2 SYSTEMS

The number of successful query requests with delay protocol for all Db2 subsystems.

NUMBER OF EXPIRED QUERY REQUESTS WITH DELAY PROTOCOL FOR ALL DB2 SYSTEMS

The number of expired query requests with delay protocol for all Db2 subsystems.

REPLICATION VELOCITY

The number of Db2 for z/OS log seconds replicated per second to the accelerator.

The output terminates with message DSNX859I.