PSPMAGENT

(SQL Table)
Index Back

Agent Definitions

Performance monitor agent definitions.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
2 PM_JMX_RMI_PORT Number(6,0) INTEGER NOT NULL RMI Port for JMX Connection

Default Value: 0

3 PM_AGENT_TYPE Character(32) VARCHAR2(32) NOT NULL Performance Monitor Agent Name.
4 PM_DOMAIN_NAME Character(32) VARCHAR2(32) NOT NULL Performance Monitor Agent Name.
5 PM_DOMAIN_TYPE Character(2) VARCHAR2(2) NOT NULL Performance Monitor Domain Type.
01=Application Server
02=Web Server
03=Database
04=Process Scheduler
05=Integration Broker
06=Performance Monitor
99=Unknown
6 PM_DOMAIN_DIR Character(254) VARCHAR2(254) NOT NULL Performance Monitor Domain Directory.
7 PM_DOMAIN_MONITOR Character(1) VARCHAR2(1) NOT NULL Performance Monitor, monitor indicator flag. If set to 'Y', the agent is a special domain monitor agent.
N=No
Y=Yes

Default Value: N

8 PM_HOST_PORT Character(64) VARCHAR2(64) NOT NULL Performance Monitor host name.
9 PM_INSTANCE Character(32) VARCHAR2(32) NOT NULL Server Instance
10 PM_SYSTEMID Number(5,0) INTEGER NOT NULL Performance Monitor System Identifier.

Prompt Table: PSPMSYSDEFN

11 PM_AGENT_INACTIVE Character(1) VARCHAR2(1) NOT NULL Inactive Agent

Y/N Table Edit

Default Value: N