BroadSQLOn this page
SHOW INACTIVE CONNECTIONS
Core command
SH INACT CO
SHINACO
Lists the inactive database connections of the CDF.
Syntax
SHOW INACTIVE CONNECTIONS [<type>]Arguments
| Argument | Required | Values | Default |
|---|---|---|---|
<type> | No | A database type, matched exactly, ignoring case | Every type |
Examples
SHOW INACTIVE CONNECTIONS;
SHOW INACTIVE CONNECTIONS H2;Details
One row per inactive connection: ID, type, name, user, Database Group and Environment, sorted by ID, followed by the number found, in the same table layout as SHOW ALL CONNECTIONS. It is the command line equivalent of the "View inactive connections" option of the CONFIG window.
An inactive connection is invisible to every other command (CONNECT, SHOW ALL CONNECTIONS, SHOW CONNECTION...). This command is how to find its ID before REACTIVATE CONNECTION or a permanent deletion (HARDDEL).
The database type filter matches the type exactly, ignoring case, as in SHOW ALL CONNECTIONS.
Related
Last modified in release 5.5.0.
Found something wrong or unclear on this page? Tell us, with the page address.