-DISPLAY ACCEL command (Db2)
The -DISPLAY ACCEL command displays information about accelerator servers.
Abbreviation: -DIS ACCEL
Environment for -DISPLAY ACCEL
This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (Db2 COMMANDS), an IMS or CICS® terminal, or a program that uses the instrumentation facility interface (IFI).
Data sharing scope: Group or member
Authorization for -DISPLAY ACCEL
To execute
this command, you must use a privilege set of the process that includes
one of the following privileges or authorities:
- DISPLAY privilege
- System DBADM authority
- SYSOPR authority
- SYSCTRL authority
- SYSADM authority
Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization by using primary and secondary authorization IDs.
Syntax for -DISPLAY ACCEL
Option descriptions for -DISPLAY ACCEL
- (accelerator-name)
- The accelerator server name. This option limits the display to the specified accelerator servers.
- (*)
- Requests a list of all accelerator servers, whether the servers are currently in use or not. Specifying an asterisk (*) as the accelerator name indicates that the display must include all accelerator servers.
- DETAIL
- Displays additional information for one or more of the accelerator servers. If DETAIL is not specified, a basic summary report is produced.
- LIST
- Produces a list of accelerator servers that are currently in use or that have been started. Valid values are:
- ( ACTIVE )
- Restricts the list of accelerator servers to those that are currently in use.
- (*)
- Requests a list of all accelerator servers, whether they are currently in use or not. An accelerator that has just been created appears in the list only if it has been started by using the START ACCEL command.
- SCOPE
- Specifies the scope of the command. In a non-data-sharing environment, the option is ignored. Valid values are:
- ( LOCAL )
- Displays information only for the accelerator servers for the current data sharing member.
- (GROUP)
- Displays information for accelerator servers for all members of the data sharing group.
- MEMBER
- Restricts the display for the identified accelerator server to specific members of the data sharing group. The default behavior is to display accelerator servers on the local member in a data sharing environment. This option is not supported in non-data sharing environments.
Usage notes for -DISPLAY ACCEL
- Trace information for commands issued with group scope
- If this command is issued with options that specify group scope in a Db2 data sharing member, it also runs on all other active members. IFICID 090 trace records for other group members can show that the same command was issued by the SYSOPR authorization ID from the 016.TLPKN5F correlation ID, in addition to the trace records from the member where the original command was issued. See Command scope in Db2 data sharing.
Output for -DISPLAY ACCEL
Message DSNX830I indicates the beginning of the output of the command.
If the DETAIL keyword is specified, the output includes a separate DSNX830I message for each accelerator server. Otherwise, a single DSNX830I message is issued for all accelerator servers.
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 numFor 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.
DETAIL output for -DISPLAY ACCEL
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.
Examples for -DISPLAY ACCEL
- Example 1: Displaying information about all accelerator servers for a data sharing group
- The following command displays information about all of the accelerator servers for all members in a data sharing group:
-DIS ACCEL(*) SCOPE(GROUP) LIST(*)The output is similar to the following example:
DSNX810I -DB1A DSNX8CMD DISPLAY ACCEL FOLLOWS - DSNX830I -DB1A DSNX8CDA ACCELERATOR MEMB STATUS REQUESTS ACTV QUED MAXQ -------------------------------- ---- -------- -------- ---- ---- ---- ACCEL1 DB1A STARTED 32769 2 5 23 ACCEL2 DB1A STOPPED 37235 1 7 17 ACCEL3 DB1A STARTED 3256 5 23 41 DISPLAY ACCEL REPORT COMPLETE DSN9035I -DB1A BEGIN OF DISPLAY FOR MEMBER: DB1B --------------------------------------------- DSNX830I -DB1B DSNX8CDA ACCELERATOR MEMB STATUS REQUESTS ACTV QUED MAXQ -------------------------------- ---- -------- -------- ---- ---- ---- ACCEL1 DB1B STARTED 23456 1 0 2 ACCEL2 DB1B STOPPED 47 0 0 0 ACCEL3 DB1B STOPPED 92 0 0 2 DISPLAY ACCEL REPORT COMPLETE --------END OF DISPLAY FOR MEMBER: DB1B -------- DSN9035I -DB1A BEGIN OF DISPLAY FOR MEMBER: DB1C --------------------------------------------- DSNX830I -DB1C DSNX8CDA ACCELERATOR MEMB STATUS REQUESTS ACTV QUED MAXQ -------------------------------- ---- -------- -------- ---- ---- ---- ACCEL1 DB1C STARTED 734 0 0 4 ACCEL2 DB1C STARTED 2 0 0 0 ACCEL3 DB1C STARTED 87 0 0 7 DISPLAY ACCEL REPORT COMPLETE --------END OF DISPLAY FOR MEMBER: DB1C -------- DSN9035I -DB1A BEGIN OF DISPLAY FOR MEMBER: DB1D --------------------------------------------- DSNX830I -DB1D DSNX8CDA ACCELERATOR MEMB STATUS REQUESTS ACTV QUED MAXQ -------------------------------- ---- -------- -------- ---- ---- ---- ACCEL1 DB1D STARTED 9210 0 0 1 ACCEL2 DB1D STOPPED 0 0 0 0 ACCEL3 DB1D STOPPED 21 0 11 11 DISPLAY ACCEL REPORT COMPLETE --------END OF DISPLAY FOR MEMBER: DB1D -------- DSN9022I -DB1A DSNX8CMD '-DISPLAY ACCEL' NORMAL COMPLETION - Example 2: Displaying detailed information about specific accelerator servers
- The following command displays detailed information about active accelerator servers ACCEL1 and ACCEL2 for data sharing member DB1D:
-DIS ACCEL(ACCEL1,ACCEL2) DETAIL LIST(ACTIVE) SCOPE(LOCAL) MEMBER(DB1D)The output that is displayed depends on the accelerator versions that you are using. For example, if you are using IBM Db2 Analytics Accelerator for z/OS V6 or later, output similar to the following example is displayed. A value of N/A in any field indicates that the field does not apply to your installation or is reserved for future use.ACCELERATOR MEMB STATUS REQUESTS ACTV QUED MAXQ -------------------------------- ---- -------- -------- ---- ---- ---- ACCEL1 DB1D STARTED 9210 7 0 N/A LOCATION=ACCELERATOR1 HEALTHY DETAIL STATISTICS LEVEL = AQT07010 STATUS = ONLINE FAILED REQUESTS = 0 AVERAGE QUEUE WAIT = 0 MS TOTAL NUMBER OF ACTIVE PROCESSORS = 4 AVERAGE CPU UTILIZATION ON COORDINATOR NODES = .00% AVERAGE CPU UTILIZATION ON WORKER NODES = .13% AVERAGE CPU UTILIZATION ON WORKER NODES = .01% NUMBER OF ACTIVE WORKER NODES = 1 TOTAL DISK STORAGE = 195114 MB DISK STORAGE IN USE FOR THIS DB2 SYSTEM = 0 MB DISK STORAGE IN USE FOR ALL DB2 SYSTEMS = 106 MB TOTAL CPU FOR REQUESTS FOR THIS DB2 SYSTEM = 0 MS TOTAL CPU FOR DATA MAINTENANCE FOR THIS DB2 SYSTEM = 0 MS TOTAL CPU FOR REPLICATION FOR THIS DB2 SYSTEM = 0 MS TOTAL MEMORY AVAILABLE FOR USER DATA = 4803 MB TOTAL MEMORY AVAILABLE FOR SQL PROCESSING = 4547 MB INBOUND NETWORK UTILIZATION OF THE ACCELERATOR = 3 KB PER SECOND OUTBOUND NETWORK UTILIZATION OF THE ACCELERATOR = 2 KB PER SECOND DISPLAY ACCEL REPORT COMPLETE DSN9022I ) DSNX8CMD '-DISPLAY ACCEL' NORMAL COMPLETION However, the following output is displayed for IBM Db2 Analytics Accelerator for z/OS V5 and earlier:ACCELERATOR MEMB STATUS REQUESTS ACTV QUED MAXQ -------------------------------- ---- -------- -------- ---- ---- ---- ACCEL1 DB1D STARTED 9210 7 5 9 LOCATION=ACCELERATOR1 HEALTHY DETAIL STATISTICS LEVEL = AQT05015 STATUS = ONLINE FAILED REQUESTS = 3 AVERAGE QUEUE WAIT = 99 MAXIMUM QUEUE WAIT = 400 TOTAL NUMBER OF ACTIVE PROCESSORS = 4 AVERAGE CPU UTILIZATION ON COORDINATOR NODES = 45.00% AVERAGE CPU UTILIZATION ON WORKER NODES = 40.00% AVERAGE DISK IO UTILIZATION = 10.00% NUMBER OF ACTIVE WORKER NODES = 2 TOTAL DISK STORAGE = 93000 MB DISK STORAGE IN USE FOR THIS DB2 SYSTEM = 27 MB DISK STORAGE IN USE FOR ALL DB2 SYSTEMS = 27 MB TOTAL CPU FOR REQUESTS FOR THIS DB2 SYSTEM = 30 MS TOTAL CPU FOR DATA MAINTENANCE FOR THIS DB2 SYSTEM = 110 MS TOTAL CPU FOR REPLICATION FOR THIS DB2 SYSTEM = 0 MS DISPLAY ACCEL REPORT COMPLETE DSN9022I ) DSNX8CMD '-DISPLAY ACCEL' NORMAL COMPLETION - Example 3: DISPLAY GROUP DETAIL output for multiple accelerators
- The following examples shows how Db2 issues a separate DSNX830I message for each accelerator when the DISPLAY GROUP command is issued for multiple accelerators. The message for each accelerator ends with either DISPLAY ACCEL REPORT CONTINUED, or DISPLAY ACCEL REPORT COMPLETE for the last accelerator.
DSNX830I -DB2A DSNX8CDA 927 ACCELERATOR MEMB STATUS REQUESTS ACTV QUED MAXQ -------------------------------- ---- -------- -------- ---- ---- ---- ACCEL1 DB2A STARTED 0 0 0 N/A LOCATION=ZP7 HEALTHY DETAIL STATISTICS LEVEL = AQT0705B STATUS = ONLINE FAILED REQUESTS = 0 AVERAGE QUEUE WAIT = N/A TOTAL NUMBER OF ACTIVE PROCESSORS = 8 AVERAGE CPU UTILIZATION ON COORDINATOR NODES = 4.33% AVERAGE CPU UTILIZATION ON WORKER NODES = 4.33% AVERAGE DISK IO UTILIZATION = 22.50% NUMBER OF ACTIVE WORKER NODES = 1 TOTAL DISK STORAGE = 85783966 MB DISK STORAGE IN USE FOR THIS DB2 SYSTEM = N/A DISK STORAGE IN USE FOR ALL DB2 SYSTEMS = N/A TOTAL CPU FOR REQUESTS FOR THIS DB2 SYSTEM = 0 MS TOTAL CPU FOR DATA MAINTENANCE FOR THIS DB2 SYSTEM = 0 MS TOTAL CPU FOR REPLICATION FOR THIS DB2 SYSTEM = N/A TOTAL MEMORY AVAILABLE FOR USER DATA = 4918 MB TOTAL MEMORY AVAILABLE FOR SQL PROCESSING = 4687 MB INBOUND NETWORK UTILIZATION OF THE ACCELERATOR = 1024 KB PER SECOND OUTBOUND NETWORK UTILIZATION OF THE ACCELERATOR = 2048 KB PER SECOND CURRENT REPLICATION LATENCY FOR THIS DB2 SYSTEM = N/A NUMBER OF SUCCESSFUL QUERY REQUESTS WITH DELAY PROTOCOL FOR ALL DB2 SYSTEMS = 0 NUMBER OF EXPIRED QUERY REQUESTS WITH DELAY PROTOCOL FOR ALL DB2 SYSTEMS = 0 REPLICATION VELOCITY = N/A DISPLAY ACCEL REPORT CONTINUED DSNX830I -DB2A DSNX8CDA 928 ACCELERATOR MEMB STATUS REQUESTS ACTV QUED MAXQ -------------------------------- ---- -------- -------- ---- ---- ---- ACCEL DB2A STARTED 0 0 0 N/A LOCATION=ZP8 HEALTHY DETAIL STATISTICS LEVEL = AQT0705B STATUS = ONLINE FAILED REQUESTS = 0 AVERAGE QUEUE WAIT = N/A TOTAL NUMBER OF ACTIVE PROCESSORS = 8 AVERAGE CPU UTILIZATION ON COORDINATOR NODES = 2.00% AVERAGE CPU UTILIZATION ON WORKER NODES = 2.00% AVERAGE DISK IO UTILIZATION = 22.50% NUMBER OF ACTIVE WORKER NODES = 1 TOTAL DISK STORAGE = 85783966 MB DISK STORAGE IN USE FOR THIS DB2 SYSTEM = N/A DISK STORAGE IN USE FOR ALL DB2 SYSTEMS = N/A TOTAL CPU FOR REQUESTS FOR THIS DB2 SYSTEM = 0 MS TOTAL CPU FOR DATA MAINTENANCE FOR THIS DB2 SYSTEM = 0 MS TOTAL CPU FOR REPLICATION FOR THIS DB2 SYSTEM = N/A TOTAL MEMORY AVAILABLE FOR USER DATA = 4918 MB TOTAL MEMORY AVAILABLE FOR SQL PROCESSING = 4687 MB INBOUND NETWORK UTILIZATION OF THE ACCELERATOR = 1024 KB PER SECOND OUTBOUND NETWORK UTILIZATION OF THE ACCELERATOR = 2048 KB PER SECOND CURRENT REPLICATION LATENCY FOR THIS DB2 SYSTEM = N/A NUMBER OF SUCCESSFUL QUERY REQUESTS WITH DELAY PROTOCOL FOR ALL DB2 SYSTEMS = 0 NUMBER OF EXPIRED QUERY REQUESTS WITH DELAY PROTOCOL FOR ALL DB2 SYSTEMS = 17 REPLICATION VELOCITY = N/A DISPLAY ACCEL REPORT COMPLETE DSN9022I -DB2A DSNX8CMD '-DISPLAY ACCEL' NORMAL COMPLETION