22.3 Examples
This example executes the adbls -d cltgrp command to display information on client groups and command groups.
Information on client groups and command groups is displayed in the following order:
-
Information on client groups and command groups
This information is output on as many lines as the number of times that the adbcltgrp operand in the server definition is specified.
-
Information on HADB clients and commands that do not belong to any groups
This information is displayed all in one row.
Explanation of the output items
The content of the output items varies depending on the type of information that is output to each row.
■ Information on client groups and command groups
- CLIENT_GROUP
-
For a client group, a client group name (the value specified in the -g option of the adbcltgrp operand in the server definition) is displayed.
For a command group, command is displayed.
- MAX_CON
-
Displays the maximum number of concurrent connections for the group (the value specified in the -m option of the adbcltgrp operand in the server definition)#.
- GUARANTEE_CON
-
Displays the guaranteed minimum number of concurrent connections for the group (the value specified in the -u option of the adbcltgrp operand in the server definition)#.
- CON
-
Displays the number of HADB clients and commands belonging to groups that are connected to the HADB server.
- MAX_RTHD
-
Displays the maximum number of processing real threads usable by a group (the value specified in the -r option of the adbcltgrp operand in the server definition)#.
- GUARANTEE_RTHD
-
Displays the guaranteed minimum number of processing real threads usable by a group (the value specified in the -e option of the adbcltgrp operand in the server definition)#.
- RTHD
-
Displays the number of processing real threads being used by HADB clients and commands that belong to a group.
- WRNMSG_CON:
-
Displays the output trigger of a warning message regarding the maximum number of concurrent connections (the value specified in the -w option of the adbcltgrp operand in the server definition) that is applied to this client group.
- RSTWRN_CON:
-
Displays the trigger to reset the warning message output status regarding the maximum number of concurrent connections (the value specified in the -w option of the adbcltgrp operand in the server definition)# that is applied to this client group.
- #
-
If the value specified for each option of the adbcltgrp operand in the server definition is different from the value that is actually applied, the value that is actually applied is displayed.
■ Information on HADB clients and commands that do not belong to any group
- CLIENT_GROUP
-
Displays -----.
- MAX_CON
-
Displays the freely usable number of concurrent connections#.
- GUARANTEE_CON
-
Displays the number of connections usable by HADB clients and commands that do not belong to any group#.
- CON
-
Displays the total number of connections to the HADB server being used by HADB clients and commands that do not belong to any group.
- MAX_RTHD
-
Displays the freely usable number of processing real threads#.
- GUARANTEE_RTHD
-
Displays the number of processing real threads usable by HADB clients and commands that do not belong to any group#.
- RTHD
-
Displays the total number of processing real threads being used by HADB clients and commands that do not belong to any group.
- WRNMSG_CON:
-
Displays the output trigger# of a warning message regarding the maximum number of concurrent connections that are applied to HADB clients and commands that do not belong to any group.
- RSTWRN_CON:
-
Displays the trigger to reset the warning message output status regarding the maximum number of concurrent connections that are applied to HADB clients and commands that do not belong to any group.
- #
-
For details about each item, see Points to consider when using the client-group facility in Preparing Resources in the HADB Setup and Operation Guide.