PSPMAGENT(SQL Table) |
Index Back |
---|---|
Agent DefinitionsPerformance 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 |