-DISPLAY ACCEL command (Db2)
The DISPLAY ACCEL command displays information about accelerator servers.
Abbreviation: -DIS ACCEL
Environment
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
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
Option descriptions
- (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.
Output
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.
Usage notes
- 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.
Examples
- 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