ALTER AGENT Statement

Modifies connection information for the SAP Sybase IQ agent.

Quick Links:

Syntax

ALTER AGENT FOR MULTIPLEX SERVER server-name   

alter-options 
   {PORT portnum  
   | USER username IDENTIFIED BY PASSWORD agentpwd, ... } 
   }

alter-options – refers to port, user, and password for an SCC SAP Sybase IQ agent.

Multiplex only.

Example 1 – alters the agent for server mpxdemo_svr2 by changing the password and port number for user smit:
```
ALTER AGENT FOR MULTIPLEX SERVER mpxdemo_svr2 USER smith IDENTIFIED BY smith_pwd PORT 1112
```

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

Requires the MANAGE MULTIPLEX system privilege.