Show TOC

ALTER AGENT StatementLocate this document in the navigation structure

Modifies connection information for the SAP IQ agent.

Quick Links:

Go to Parameters

Go to Examples

Go to Usage

Go to Permissions

Syntax
ALTER AGENT FOR MULTIPLEX SERVER <server-name>   

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

(back to top)

  • alter-options refers to port, user, and password for an SAP IQ Cockpit SAP IQ agent.
Applies to
Multiplex only.
Examples

(back to top)

  • 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
Usage

(back to top)

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

Permissions

(back to top)

Requires the MANAGE MULTIPLEX system privilege.