TERMINATE USER

The TERMINATE USER statement terminates one or more DBE sessions associated with your user name or another user name.

Scope

ISQL or Application Programs

SQL Syntax

  TERMINATE USER {DBEUserID 
                  SessionID 
                  CID ConnectionID}

Parameters

DBEUserID: identifies the user to terminate all sessions for. Users currently on the system appear in the system view SYSTEM.USER.
SessionID: identifies a specific session to be terminated. Session identifiers can be found in the system view SYSTEM.USER. One user may have several session IDs active at the same time.
CID ConnectionID: identifies the specific connection to terminate.

Description

Any transactions in progress in the session(s) are terminated and any changes are backed out. Any locks still held are released, and any cursor still open is closed.

Authorization

You can terminate a session if it is your own session, or if you have DBA authority.

Example

   User1 starts a DBE session SessionID1
 
   CONNECT TO '../sampledb/PartsDBE'
 
   User1 starts a DBE session SessionID2
 
   CONNECT TO '../sampledb/PartsDBE'
 
   User2 starts a DBE session SessionID3
 
   CONNECT TO '../sampledb/PartsDBE'
 
   User2 starts a DBE session SessionID4
 
   CONNECT TO '../sampledb/PartsDBE'

Both of User1's DBE sessions terminate. Either User1 or a DBA can enter this statement.

TERMINATE USER User1

One of User2's DBE sessions terminates. Either User2 or a DBA can enter this statement.

TERMINATE USER SessionID3