DCMT DISPLAY DBGROUP Command

The DCMT DISPLAY DBGROUP command displays statistics about the role of the currently-executing central version in dynamic database session routing. You can display information for all groups to which the current CV can route requests or for a specific group. Dynamic database session routing can occur only in a Sysplex environment.
idmscu19
The DCMT DISPLAY DBGROUP command displays statistics about the role of the currently-executing central version in dynamic database session routing. You can display information for all groups to which the current CV can route requests or for a specific group. Dynamic database session routing can occur only in a Sysplex environment.
This article describes the following information:
Syntax
►►── DCMT ─┬───────────────────┬─────────────────────────────────────────────► └─
broadcast-parms
─┘ ►─── Display DBGroup ─┬──────────────┬──────────────────────────────────────►◄ ├─ * ◄─────────┤ └─
group-name
─┘
Parameters
  • broadcast-parms
    Indicates to execute the DCMT command on all or a list of data sharing group members.
    For more information about broadcasting and
    broadcast-parms
    syntax, see the section How to Broadcast System Tasks.
  • DBGroup *
    Displays information about all groups to which the currently executing CV can route requests. This is the default parameter.
  • group-name
    Specifies the name of the group to display.
Usage
Display for Every DBGroup
The DCMT DISPLAY DBGROUP command displays this information about each DBGROUP:
Field
Value
DBGroup
Name of the DBGROUP.
Number of backends
Number of active CVs that are able to process DBGroup requests
Backend Status
Status of the currently executing CV which acts as a back-end CV. Possible values are:
ACTIVE -- The current CV can process requests submitted to the corresponding DBGroup
INACTIVE -- The current CV cannot process requests submitted to the corresponding DBGroup
Backend Requests
Number of DBGroup requests that have been processed by the current CV.
Frontend Status
Status of the currently executing CV which acts as a front-end CV. Possible values are:
ACTIVE -- The current CV can submit requests to the corresponding DBGroup
INACTIVE -- The current CV cannot submit requests to the corresponding DBGroup
Frontend Requests
Number of DBGroup requests that have been submitted by the current CV.
Display for a Specified DBGroup
When
group-name
is specified on the DCMT DISPLAY DBGROUP command, CA IDMS displays the same information that is listed in the table above for all DBGROUPS, plus the actual distribution of all the front-end requests processed by the different back-end CVs. For each back-end CV that processed front-end requests, CA IDMS displays the node name of the back-end CV and the number of requests processed.
Example
DCMT DISPLAY DBGROUP *
This example shows that there are two groups to which the currently executing CV can route requests, DBDCGR and IDMSGR. Dynamic database session routing is active on the currently executing front-end CV and both groups are active as indicated by the ACTIVE status in the STATUS column under FRONTEND. The BACKEND STATUS of INACTIVE indicates that the currently executing CV is not available as a back-end CV.
DCMT DISPLAY DBG * *** Display DBGroup request *** DBGroup * Number of * Backend * Frontend * backends * Status ; Requests * Status ; Requests ****************************************************************** DBDCGR * 002 * Inactive N/A * Active ; 0000000001 IDMSGR * 002 * Inactive N/A * Active ; 0000001020
DCMT DISPLAY DBGROUP group-name
This example displays information about the IDMSGR group. It shows that it is comprised of two back-ends, IDMS073 and IDMS072, and the number of times each has replied to a request for services from the currently executing CV. IDMS073 has responded to 492 requests and IDMS072 has responded to 528. Additionally, statistics about the currently executing CV as both a back-end and a front-end CV are displayed. The total number of requests processed by this front-end CV is 1020.
DCMT DISPLAY DBGROUP IDMSGR *** Display DBGroup request *** DBGroup IDMSGR has 002 backends Backend status: Inactive; Number of requests processed: N/A Frontend status: Active; Number of requests processed: 0000001020 Replies on frontend requests distribution: IDMS073 : 0000000492 IDMS072 : 0000000528
More Information
  • For more information about dynamic database session routing, see the "System Reference" section.
  • For more information about defining DBGROUPS, see the section "Administrating CA IDMS Database" in the CA IDMS documentation.