Hitachi

Hitachi Advanced Database Command Reference


22.3 Examples

This example executes the adbls -d cltgrp command to display information on client groups and command groups.

[Figure]

Information on client groups and command groups is displayed in the following order:

  1. 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.

  2. 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.