GET CONNECTION STATE command

The GET CONNECTION STATE command displays the connection state.

Possible states are:
  • Connectable and connected
  • Connectable and unconnected
  • Unconnectable and connected
  • Implicitly connectable (if implicit connect is available).
This command also returns information about:
  • The database connection mode (SHARE or EXCLUSIVE)
  • The alias and name of the database to which a connection exists (if one exists)
  • The host name and service name of the connection if the connection is using TCP/IP

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramGET CONNECTION STATE

Command parameters

None

Examples

The following example is sample output from GET CONNECTION STATE:

   Database Connection State

 Connection state       = Connectable and Connected
 Connection mode        = SHARE
 Local database alias   = SAMPLE
 Database name          = SAMPLE
 Hostname               = montero
 Service name           = 29384

Usage notes

This command does not apply to type 2 connections.