CREATE AGENT Statement

Associates an SAP IQ agent for SAP IQ Cockpit 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>

Applies to

Multiplex only.

Examples

Example 1
create an agent for the SAP 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
```

Usage

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

Side Effects

Permissions

Requires the MANAGE MULTIPLEX system privilege.