-DISPLAY ACCEL (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 local, depending on the SCOPE option.
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
.-(--*--)----------------------------. | .-,----------------. | | V | | >>-DISPLAY ACCEL--+-(--------accelerator-name-+------)-+--------> >--+--------+--+--------------------+--+--------------------+---> '-DETAIL-' | .-ACTIVE-. | | .-LOCAL-. | '-LIST(-+-*------+-)-' '-SCOPE(-+-GROUP-+-)-' >--+---------------------+------------------------------------->< '-MEMBER(member-name)-'
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 for the local member. In a non-data-sharing environment, this option is ignored.
Output
Message DSNX830I indicates the beginning of the output of the command.
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 accelerators that you are using.
For example, 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