CREATE AGENT Statement

Associates an SAP Sybase IQ agent for SAP Control Center with the named server to support high availability.

Quick Links:

Go to Examples

Go to Usage

Go to Permissions

Syntax

CREATE AGENT FOR MULTIPLEX SERVER server-name 
   USER username IDENTIFIED BY agentpwd PORT portnum 

Applies to

Multiplex only.

Examples

(back to top)

Usage

(back to top)

The SYS.ISYSIQMPXSERVERAGENT system table stores the agent connection definitions for the server.

Side Effects
  • Automatic commit

Permissions

(back to top)

Requires the MANAGE MULTIPLEX system privilege.