CREATE AGENT Statement

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

Quick Links:

Syntax

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

Multiplex only.

Example 1 – create an agent for the SAP Sybase IQ server named mpx_writer1. The user login is “sqltester” and the port number is 1138.
```
CREATE AGENT FOR MULTIPLEX SERVER mpx_writer1 USER sqltester IDENTIFIED BY '8U3dkA' PORT 1138
```

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

Side Effects

Requires the MANAGE MULTIPLEX system privilege.