PSPMAGENT_VW

index back

Agent Definitions View

Performance monitor agent definitions that are domain monitoring agents and of type application server.
SELECT PM_AGENTID , PM_AGENT_TYPE , PM_DOMAIN_NAME , PM_DOMAIN_TYPE , PM_DOMAIN_DIR , PM_DOMAIN_MONITOR , PM_HOST_PORT , PM_INSTANCE , PM_SYSTEMID FROM PSPMAGENT WHERE PM_DOMAIN_MONITOR = 'Y' AND PM_DOMAIN_TYPE = '01' AND PM_AGENT_INACTIVE <> 'Y'

PeopleSoft Field NameField TypeColumn TypeDescription
PM_AGENTIDNumber(10,0)DECIMAL(10) NOT NULLPerformance Monitor Agent Identifier.
PM_AGENT_TYPECharacter(32)VARCHAR2(32) NOT NULLPerformance Monitor Agent Name.
PM_DOMAIN_NAMECharacter(32)VARCHAR2(32) NOT NULLPerformance Monitor Agent Name.
PM_DOMAIN_TYPECharacter(2)VARCHAR2(2) NOT NULLPerformance Monitor Domain Type.
01=Application Server
02=Web Server
03=Database
04=Process Scheduler
05=Integration Broker
06=Performance Monitor
99=Unknown
PM_DOMAIN_DIRCharacter(254)VARCHAR2(254) NOT NULLPerformance Monitor Domain Directory.
PM_DOMAIN_MONITORCharacter(1)VARCHAR2(1) NOT NULLPerformance Monitor, monitor indicator flag. If set to 'Y', the agent is a special domain monitor agent.
N=No
Y=Yes

Y/N Table Edit

Default: N

PM_HOST_PORTCharacter(64)VARCHAR2(64) NOT NULLPerformance Monitor host name.
PM_INSTANCECharacter(32)VARCHAR2(32) NOT NULLServer Instance
PM_SYSTEMIDNumber(5,0)INTEGER NOT NULLPerformance Monitor System Identifier.

Prompt Table: PSPMSYSDEFN

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19