PMN_SRVRLIST

index back

Process Monitor Server List

This view is used to list server definitions in the Process Monitor.
SELECT A.SERVERNAME , A.BEGINDTTM , A.LASTUPDDTTM , A.SERVERSTATUS , A.SRVRHOSTNAME , X.XLATLONGNAME , B.DESCR , S.DESCR , B.DISTNODENAME , B.MAXAPIAWARE , B.SLEEPTIME , B.HEARTBEAT , B.DAEMONENABLED , B.DAEMONGROUP , B.DAEMONSLEEPTIME ,A.PRCSTHRESHOLD ,A.PRCSDISKSPACE ,B.SRVRLOADBALOPTN ,B.MAXCPU , B.MINMEM ,B.OPSYS FROM PSSERVERSTAT A , PS_SERVERDEFN B , PS_PRCSSRVROPSYS S , PSXLATITEM X WHERE A.SERVERNAME = B.SERVERNAME AND A.SERVERSTATUS = X.FIELDVALUE AND S.OPSYS = B.OPSYS AND X.FIELDNAME = 'SERVERSTATUS'

  • Related language record: PMN_SRVRLSTLANG
  • PeopleSoft Field Name Field Type Column Type Description
    SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
    BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    SERVERSTATUS Character(2) VARCHAR2(2) NOT NULL Server Status
    0=Error
    1=Down
    2=Suspended
    3=Running
    4=Purging
    5=Running With No Report Node
    6=Suspended - Disk Low
    7=Suspended - Offline
    8=Running - Report Rep. Full
    9=Overloaded
    SRVRHOSTNAME Character(80) VARCHAR2(80) NOT NULL Server Hostname
    SERVERSTATUSDESCR Character(30) VARCHAR2(30) NOT NULL Server Status
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    DISTNODENAME Character(15) VARCHAR2(15) NOT NULL Report Distribution Node Name
    MAXAPIAWARE Number(3,0) SMALLINT NOT NULL Max API Aware Tasks
    SLEEPTIME Number(4,0) SMALLINT NOT NULL Sleep Time
    HEARTBEAT Number(4,0) SMALLINT NOT NULL Heartbeat
    DAEMONENABLED Character(1) VARCHAR2(1) NOT NULL Daemon Enabled
    DAEMONGROUP Character(8) VARCHAR2(8) NOT NULL Daemon Procedure Group
    DAEMONSLEEPTIME Number(4,0) SMALLINT NOT NULL Daemon Sleep Time
    PRCSTHRESHOLD Number(8,0) INTEGER NOT NULL Disk Space Threshold
    PRCSDISKSPACE Number(8,0) INTEGER NOT NULL Disk Space Available
    SRVRLOADBALOPTN Character(2) VARCHAR2(2) NOT NULL Server Load Balancing Option
    0=Do Not Use for Load Balancing
    1=Use for Load Balancing
    MAXCPU Number(3,0) SMALLINT NOT NULL Max. CPU Usage required
    MINMEM Number(3,0) SMALLINT NOT NULL Min. Memory Required
    OPSYS Character(1) VARCHAR2(1) NOT NULL Operating System
    0=DOS
    1=NT/Win95 Client
    2=Windows
    3=OS/2
    4=UNIX
    5=VMS
    6=MPE/XL
    7=OS390
    8=NT
    9=OS/400
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19