epadmin-connection

< Previous		Next >

epadmin-connection

epadmin connection target — Displays or closes client and JDBC connections to an EventFlow fragment.

SYNOPSIS

epadmin [globalparameters] command connection [commandparameters]

DESCRIPTION

Use the connection target to retrieve information about client connections or JDBC connections, and to optionally close one or more connections.

The connection target has two commands:

The designation [sn|ad] in syntax examples is a reminder that this command requires either the global parameter ‑‑servicename or the ‑‑adminport and ‑‑hostname combination to identify the node or cluster of interest.

epadmin display connection

Displays information about client and JDBC connections to the specified nodes. This command reports the same information as the legacy sbadmin listConnections and sbadmin manageJdbcConnections commands.

epadmin [sn|ad] display connection
epadmin [sn|ad] display connection name=2A8DA8330F92A3A8566FF620AF39408B
epadmin [sn|ad] display connection --engine=enginename
epadmin [sn|ad] display connection --type=jdbc
epadmin [sn|ad] display connection --type=jdbc --name="MySQL5lab"

Command Parameter	Description	Required
`engine`	Engine name filter.	No. The default is to display all connections on all engines.
`name`	For client connections, `name` is a connection ID as reported by this command, which is a 32 character GUID assigned by the StreamBase server. For example, if you run this command with a cluster service name that has many client connections, use `name=` in subsequent commands to narrow the results to a single connection. For JDBC connections, `name` is a JDBC Data Source property assigned to a JDBC Table data construct in the EventFlow module.	No. The default value is all connections.
`type`	Connection type filter, one of `client` or `jdbc`.	No. The default value is `client`.

epadmin close connection

Closes a specified client or JDBC connection, or closes all connections by engine name or type. This command performs the same tasks as the legacy sbadmin killConnection connectionID, sbadmin killConnections, and sbadmin manageJdbcConnections close commands.

epadmin [sn|ad] close connection
epadmin [sn|ad] close connection name=2A8DA8330F92A3A8566FF620AF39408B
epadmin [sn|ad] close connection --engine=an-engine-name
epadmin [sn|ad] close connection --type=jdbc
epadmin [sn|ad] close connection --type=jdbc --name="MySQL5lab"

Command Parameter	Description	Required
`engine`	Engine name filter.	No. The default is to close all connections on all engines.
`name`	Connection ID or Data Source name as described above for the display command.	No. The default value is all connections.
`type`	Connection type filter, one of `client` or `jdbc`.	No. The default value is `client`.