DROP CONNECTION

Use the DROP CONNECTION command to drop a connection. This removes the corresponding connection record from the system table.

For more information about configuring Netezza Performance Server host access for clients, see the IBM® Netezza® System Administrator’s Guide.

Syntax

Syntax for dropping a connection:
DROP CONNECTION <connection_id>

Input

The DROP CONNECTION command takes the following input:
Table 1. DROP CONNECTION input
Input Description
<connection_id> The ID of the connection to be dropped. To obtain the connection ID, issue the SHOW CONNECTION command.

Outputs

The DROP CONNECTION command has the following outputs:

Table 2. DROP CONNECTION outputs
Output Description
DROP CONNECTION The command was successful.
ERROR: permission denied You do not have the privilege needed to issue this command.

Privileges

You must be the admin user or have the Manage System privilege.